| 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 | RPLAN | Reorganization Plan | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FAGL_R_PLAN | Allow NULL? |
| 3 | KOART | Account Type | char | 1 | 0 | CHAR | (N' ') | No | | KOART | Allow NULL? |
| 4 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 5 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 6 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 7 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BUZEI | Allow NULL? |
| 8 | SPL_NO | Sequence Number of Splitting Information | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | FAGL_INDEX | Allow NULL? |
| 9 | BUZEI_APAR | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 10 | OBJ_TYPE_SUP | Object Type of the Higher-Level Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FAGL_R_OBJ_TYPE_SUP | Allow NULL? |
| 11 | VAL1_SUP | Value of the First Key Field for the Higher-Level Object | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | FAGL_R_OBJ_VAL1_SUP | Allow NULL? |
| 12 | VAL2_SUP | Value of the Second Key Field for the Higher-Level Object | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | FAGL_R_OBJ_VAL2_SUP | Allow NULL? |
| 13 | VAL3_SUP | Value of the Third Key Field for the Higher-Level Object | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | FAGL_R_OBJ_VAL3_SUP | Allow NULL? |
| 14 | SEQNR | Sequence Number | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | FAGL_R_SEQNR_APAR | Allow NULL? |
| 15 | XSKV | Cash Discount Clearing Item | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XSKV | Allow NULL? |
| 16 | XDEL | Entry Was Deleted | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XDELETED | Allow NULL? |
| 17 | STATUS | Object Status | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FAGL_R_OBJ_STATUS | Allow NULL? |