| 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 | BELNR | Document Number of a Closing Document for Cumulation | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CKCUM_BELNR | Allow NULL? |
| 3 | KJAHR | Year in Which Closing Document for Cumulation Was Saved | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CKCUM_KJAHR | Allow NULL? |
| 4 | POSNR | Accounting Document Line Item Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | POSNR_ACC | Allow NULL? |
| 5 | URZEILE | Original item in material or invoice document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | CK_URZEILE | Allow NULL? |
| 6 | KALN1 | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | CK_KALNR | Allow NULL? |
| 7 | BUSTW | Posting string for values | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BUSTW | Allow NULL? |
| 8 | VORSL | Transaction/event key for account determination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VORSL | Allow NULL? |
| 9 | FELDN | Name of field | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | FELDN | Allow NULL? |
| 10 | KOMOK | Account Modification | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KOMOK | Allow NULL? |
| 11 | LOGVO | Logical Transaction | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | LOGVO | Allow NULL? |
| 12 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 13 | BWKEY | Valuation Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001K | BWKEY | Allow NULL? |
| 14 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BWTAR_D | Allow NULL? |
| 15 | MAT_KDAUF | Sales Order Number of Valuated Sales Order Stock | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MAT_KDAUF | Allow NULL? |
| 16 | MAT_KDPOS | Sales Order Item of Valuated Sales Order Stock | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | MAT_KDPOS | Allow NULL? |
| 17 | MAT_PSPNR | Valuated Sales Order Stock WBS Element | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | MAT_PSPNR | Allow NULL? |
| 18 | KZBWS | Valuation of Special Stock | char | 1 | 0 | CHAR | (N' ') | Yes | | KZBWS | Allow NULL? |
| 19 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | T148 | SOBKZ | Allow NULL? |
| 20 | BKLAS | Valuation Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T025 | BKLAS | Allow NULL? |
| 21 | BSCHL | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TBSL | BSCHL | Allow NULL? |
| 22 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PPRCTR | Allow NULL? |
| 23 | HRKFT | Origin Group as Subdivision of Cost Element | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HRKFT | Allow NULL? |
| 24 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 25 | MONAT | Fiscal Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MONAT | Allow NULL? |
| 26 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 27 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 28 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | BLART | Allow NULL? |
| 29 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 30 | VORGN | Transaction Type for General Ledger | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORGN | Allow NULL? |
| 31 | BEKNZ | Debit/credit indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | BEKNZ | Allow NULL? |
| 32 | BWMOD | Valuation Grouping Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BWMOD | Allow NULL? |
| 33 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 34 | KTOPL | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KTOPL | Allow NULL? |
| 35 | KTOSL | Transaction Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KTOSL | Allow NULL? |
| 36 | KOART | Account Type | char | 1 | 0 | CHAR | (N' ') | Yes | | KOART | Allow NULL? |
| 37 | KSCHL | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KSCHL | Allow NULL? |
| 38 | SAKNR | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | SAKNR | Allow NULL? |
| 39 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 40 | HKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT | Allow NULL? |
| 41 | STATUS | Delta Posting Status from AVR | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | STATUS_AVR_DELTA_POST | Allow NULL? |
| 42 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 43 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 44 | LSTAR | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 45 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 46 | KSTRG | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KSTRG | Allow NULL? |
| 47 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | CO_AUFPL | Allow NULL? |
| 48 | APLZL | Internal counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CIM_COUNT | Allow NULL? |
| 49 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | NPLNR | Allow NULL? |
| 50 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 51 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR_VA | Allow NULL? |
| 52 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KDAUF | Allow NULL? |
| 53 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 54 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEOBJNR | Allow NULL? |
| 55 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 56 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 57 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 58 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 59 | PRZNR | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CO_PRZNR | Allow NULL? |
| 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | IMKEY | Allow NULL? |
| 61 | DABRZ | Reference Date for Settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DABRBEZ | Allow NULL? |
| 62 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 63 | AWREF_REV | Reversal: Reverse Document Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF_REV | Allow NULL? |
| 64 | AWORG_REV | Reversal: Reverse Document Reference Organization | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWORG_REV | Allow NULL? |
| 65 | STATUS_IT | Status of Cumulation Closing Document | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CKMLAVRDOC_STATUS | Allow NULL? |
| 66 | BELNR_POST | Document Number of a Closing Document for Cumulation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CKCUM_BELNR | Allow NULL? |
| 67 | KJAHR_POST | Year in Which Closing Document for Cumulation Was Saved | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CKCUM_KJAHR | Allow NULL? |
| 68 | BELNR_REV | Document Number of a Closing Document for Cumulation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CKCUM_BELNR | Allow NULL? |
| 69 | KJAHR_REV | Year in Which Closing Document for Cumulation Was Saved | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CKCUM_KJAHR | Allow NULL? |
| 70 | REVERSAL_ITEM | Reversal Item | char | 1 | 0 | CHAR | (N' ') | Yes | | CKMLAVRDOC_REVERSAL_ITEM | Allow NULL? |
