| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | LOGSYS | Logical system of source document | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | AWSYS | Allow NULL? |
| 3 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | No | * | AWTYP | Allow NULL? |
| 4 | AWKEY | Reference Key | nvarchar | 20 | 0 | CHAR | (N' ') | No | | AWKEY | Allow NULL? |
| 5 | STOKZ | Indicator: Data Record Canceled | char | 1 | 0 | CHAR | (N' ') | No | | HR_STOKZ | Allow NULL? |
| 6 | CUSTFLD | Customer-Specific Field | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | HR_USRFLD | Allow NULL? |
| 7 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 8 | BEGDA | Validity Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | HR_DATE | Allow NULL? |
| 9 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | SPRPS | Allow NULL? |
| 10 | UNAME1 | User who wrote record to interface | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME1 | Allow NULL? |
| 11 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM1 | Allow NULL? |
| 12 | UZEIT1 | Time at which record was written to interface | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT1 | Allow NULL? |
| 13 | PGMID1 | Write Record to Interface Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID1 | Allow NULL? |
| 14 | UNAME2 | Name of user who initially accessed record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME2 | Allow NULL? |
| 15 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM2 | Allow NULL? |
| 16 | UZEIT2 | Time at which record was initially accessed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT2 | Allow NULL? |
| 17 | PGMID2 | Report used to access record initially | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID2 | Allow NULL? |
| 18 | STATU2 | Log status when record was first accessed | char | 1 | 0 | CHAR | (N' ') | Yes | | PW_STATU2 | Allow NULL? |
| 19 | UNAME3 | Last user to access record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME3 | Allow NULL? |
| 20 | DATUM3 | Date on which record was last accessed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM3 | Allow NULL? |
| 21 | UZEIT3 | Time at which record was last accessed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT3 | Allow NULL? |
| 22 | PGMID3 | Last Used to Access Record Program | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID3 | Allow NULL? |
| 23 | STATU3 | Log status when record was last accessed | char | 1 | 0 | CHAR | (N' ') | Yes | | PW_STATU3 | Allow NULL? |
| 24 | UNAME4 | User who first retrieved the record successfully | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME4 | Allow NULL? |
| 25 | DATUM4 | Date on which record was first retrieved successfully | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM4 | Allow NULL? |
| 26 | UZEIT4 | Time at which record was first retrieved successfully | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT4 | Allow NULL? |
| 27 | PGMID4 | Report first used to retrieve record successfully | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID4 | Allow NULL? |
| 28 | LGART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGART | Allow NULL? |
| 29 | STDAZ | No.of hours for remuneration info. | decimal | 7 | 2 | DEC | ((0)) | Yes | | ENSTD | |
| 30 | ANZHL | Number | decimal | 7 | 2 | DEC | ((0)) | Yes | | ANZHL | |
| 31 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T538A | PT_ZEINH | Allow NULL? |
| 32 | BETRG | Wage Type Amount for Payments | decimal | 13 | 2 | CURR | ((0)) | Yes | | PAD_AMT7S | |
| 33 | VERSL | Overtime Compensation Type | char | 1 | 0 | CHAR | (N' ') | Yes | T555R | VRSCH | Allow NULL? |
| 34 | EXBEL | External Document Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | EXBEL | Allow NULL? |
| 35 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | TRFGR | Allow NULL? |
| 36 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TRFST | Allow NULL? |
| 37 | PRAKN | Premium Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T510P | PRAKN | Allow NULL? |
| 38 | PRAKZ | Premium Indicator | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PRAKZ | Allow NULL? |
| 39 | OTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778O | OTYPE | Allow NULL? |
| 40 | PLANS | Position | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | T528B | PLANS | Allow NULL? |
| 41 | AUFKZ | Extra Pay Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AUFKN | Allow NULL? |
| 42 | BWGRL | Valuation Basis for Different Payment | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTM_VBAS7S | |
| 43 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 44 | WTART | Work tax area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UTB | WTART | Allow NULL? |
| 45 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 46 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 47 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 48 | LTLST | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 49 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 50 | KSTRG | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KSTRG | Allow NULL? |
| 51 | PS_POSID | Work Breakdown Structure Element (WBS Element) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | PS_POSID | Allow NULL? |
| 52 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | NPLNR | Allow NULL? |
| 53 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORNR | Allow NULL? |
| 54 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KDAUF | Allow NULL? |
| 55 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 56 | PRZNR | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CO_PRZNR | Allow NULL? |
| 57 | FISTL | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FISTL | Allow NULL? |
| 58 | FIPOS | Commitment Item | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | FIPOS | Allow NULL? |
| 59 | GEBER | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BP_GEBER | Allow NULL? |
| 60 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EBELN | Allow NULL? |
| 61 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | EBELP | Allow NULL? |
| 62 | LSTNR | Activity Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | ASNUM | Allow NULL? |
| 63 | STELL | Job | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | STELL | Allow NULL? |
| 64 | SBUKR | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 65 | SGSBR | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 66 | SKOST | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 67 | LSTAR | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 68 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 69 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5D7C | DART | Allow NULL? |
| 70 | UDART | Service Category (Public Service Germany) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5D7E | UDART | Allow NULL? |
| 71 | FKBER | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FKBER | Allow NULL? |
| 72 | GRANT_NBR | Grant | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | GM_GRANT_NBR | Allow NULL? |
| 73 | SGEBER | Sender fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_SFONDS | Allow NULL? |
| 74 | SFKBER | Sending Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | SFKTBER | Allow NULL? |
| 75 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | GM_GRANT_SENDER | Allow NULL? |
| 76 | FIPEX | Commitment Item | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | * | FM_FIPEX | Allow NULL? |
| 77 | BUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_BUDGET_PERIOD | Allow NULL? |
| 78 | SBUDGET_PD | FM: Sender Budget Period | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_SBUDGET_PERIOD | Allow NULL? |
