| 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 | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 9 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 10 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | SPRPS | Allow NULL? |
| 11 | UNAME1 | User who wrote record to interface | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME1 | Allow NULL? |
| 12 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM1 | Allow NULL? |
| 13 | UZEIT1 | Time at which record was written to interface | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT1 | Allow NULL? |
| 14 | PGMID1 | Write Record to Interface Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID1 | Allow NULL? |
| 15 | UNAME2 | Name of user who initially accessed record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME2 | Allow NULL? |
| 16 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM2 | Allow NULL? |
| 17 | UZEIT2 | Time at which record was initially accessed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT2 | Allow NULL? |
| 18 | PGMID2 | Report used to access record initially | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID2 | Allow NULL? |
| 19 | STATU2 | Log status when record was first accessed | char | 1 | 0 | CHAR | (N' ') | Yes | | PW_STATU2 | Allow NULL? |
| 20 | UNAME3 | Last user to access record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME3 | Allow NULL? |
| 21 | DATUM3 | Date on which record was last accessed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM3 | Allow NULL? |
| 22 | UZEIT3 | Time at which record was last accessed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT3 | Allow NULL? |
| 23 | PGMID3 | Last Used to Access Record Program | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID3 | Allow NULL? |
| 24 | STATU3 | Log status when record was last accessed | char | 1 | 0 | CHAR | (N' ') | Yes | | PW_STATU3 | Allow NULL? |
| 25 | UNAME4 | User who first retrieved the record successfully | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME4 | Allow NULL? |
| 26 | DATUM4 | Date on which record was first retrieved successfully | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM4 | Allow NULL? |
| 27 | UZEIT4 | Time at which record was first retrieved successfully | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT4 | Allow NULL? |
| 28 | PGMID4 | Report first used to retrieve record successfully | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID4 | Allow NULL? |
| 29 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | AWART | Allow NULL? |
| 30 | BEGUZ | Start Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BEGUZ | Allow NULL? |
| 31 | ENDUZ | End Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ENDUZ | Allow NULL? |
| 32 | STDAZ | Absence hours | decimal | 7 | 2 | DEC | ((0)) | Yes | | ABSTD | |
| 33 | VTKEN | Previous Day Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VTKEN | Allow NULL? |
| 34 | ALLDF | Record is for Full Day | char | 1 | 0 | CHAR | (N' ') | Yes | | ALLDF | Allow NULL? |
| 35 | VERSL | Overtime Compensation Type | char | 1 | 0 | CHAR | (N' ') | Yes | * | VRSCH | Allow NULL? |
| 36 | TRFGR | Pay Scale Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | TRFGR | Allow NULL? |
| 37 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TRFST | Allow NULL? |
| 38 | PRAKN | Premium Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T510P | PRAKN | Allow NULL? |
| 39 | PRAKZ | Premium Indicator | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PRAKZ | Allow NULL? |
| 40 | OTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778O | OTYPE | Allow NULL? |
| 41 | PLANS | Position | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | T528B | PLANS | Allow NULL? |
| 42 | AUFKZ | Extra Pay Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AUFKN | Allow NULL? |
| 43 | BWGRL | Valuation Basis for Different Payment | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTM_VBAS7S | |
| 44 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 45 | WTART | Work tax area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UTB | WTART | Allow NULL? |
| 46 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 47 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 48 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 49 | LTLST | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 50 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 51 | KSTRG | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KSTRG | Allow NULL? |
| 52 | PS_POSID | Work Breakdown Structure Element (WBS Element) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | PS_POSID | Allow NULL? |
| 53 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | NPLNR | Allow NULL? |
| 54 | VORNR | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORNR | Allow NULL? |
| 55 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KDAUF | Allow NULL? |
| 56 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 57 | PRZNR | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CO_PRZNR | Allow NULL? |
| 58 | FISTL | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FISTL | Allow NULL? |
| 59 | FIPOS | Commitment Item | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | FIPOS | Allow NULL? |
| 60 | GEBER | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BP_GEBER | Allow NULL? |
| 61 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EBELN | Allow NULL? |
| 62 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | EBELP | Allow NULL? |
| 63 | LSTNR | Activity Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | ASNUM | Allow NULL? |
| 64 | STELL | Job | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | STELL | Allow NULL? |
| 65 | SBUKR | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 66 | SGSBR | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 67 | SKOST | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 68 | LSTAR | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 69 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 70 | DART | Service Type (Public Service Germany) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5D7C | DART | Allow NULL? |
| 71 | UDART | Service Category (Public Service Germany) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5D7E | UDART | Allow NULL? |
| 72 | FKBER | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FKBER | Allow NULL? |
| 73 | GRANT_NBR | Grant | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | GM_GRANT_NBR | Allow NULL? |
| 74 | SGEBER | Sender fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_SFONDS | Allow NULL? |
| 75 | SFKBER | Sending Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | SFKTBER | Allow NULL? |
| 76 | SGRANT_NBR | Sender Grant | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | GM_GRANT_SENDER | Allow NULL? |
| 77 | FIPEX | Commitment Item | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | * | FM_FIPEX | Allow NULL? |
| 78 | BUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_BUDGET_PERIOD | Allow NULL? |
| 79 | SBUDGET_PD | FM: Sender Budget Period | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_SBUDGET_PERIOD | Allow NULL? |
