| 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 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PERNR_D | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | REINR | Allow NULL? |
| 4 | PERIO | Trip Period Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PTRV_PEROD | Allow NULL? |
| 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PTRV_PDVRS | Allow NULL? |
| 6 | LINE_NR | Account assignment number of reference document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | TR_RFKNT | Allow NULL? |
| 7 | OBJ_TYPE | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 8 | OBJ_KEY | Reference Key | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AWKEY | Allow NULL? |
| 9 | OBJ_SYS | Logical system of source document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AWSYS | Allow NULL? |
| 10 | OBJ_POS | Reference line item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWPOS | Allow NULL? |
| 11 | OBJ_ID | Reference document: Current identification | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWID | Allow NULL? |
| 12 | PSTNG_DATE | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 13 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 14 | GL_ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 15 | NETWORK | Network Number for Account Assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | NPLNR | Allow NULL? |
| 16 | ORDERID | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 17 | WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | PS_POSID | Allow NULL? |
| 18 | COSTCENTER | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 19 | SEG_TEXT | Segment text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | CO_SGTXT | Allow NULL? |
| 20 | DELETE_IND | Commitments deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | DELOI | Allow NULL? |
| 21 | CMMT_ITEM | Commitment Item | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | FIPOS | Allow NULL? |
| 22 | FUND | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BP_GEBER | Allow NULL? |
| 23 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FISTL | Allow NULL? |
| 24 | APPROVED | Travel Request or Trip Approved (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | ANTRG | Allow NULL? |
| 25 | CMMT_ITEM_LONG | Commitment Item | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | * | FM_FIPEX | Allow NULL? |
| 26 | GRANT_NBR | Grant | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | GM_GRANT_NBR | Allow NULL? |
| 27 | FUNC_AREA_LONG | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FKBER | Allow NULL? |
| 28 | FM_TRANS_DATE | FM Transaction Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FM_TRANSACTION_DATE | Allow NULL? |
| 29 | FUND_LONG | Obsolete | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | FM_GEBER_LONG | Allow NULL? |
| 30 | BUDGET_PERIOD | FM: Budget Period | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_BUDGET_PERIOD | Allow NULL? |
| 31 | ACTIVITY_NR | Operation/Activity Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORNR | Allow NULL? |
