| 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 | ITEM | Consolidation item | nvarchar | 10 | 0 | CHAR | (N' ') | No | | RITEM | Allow NULL? |
| 3 | SPLIN | Indicator: partial breakdown | char | 1 | 0 | CHAR | (N' ') | No | | KZSPLIN | Allow NULL? |
| 4 | FIXIN | Indicator: Selected FS item | char | 1 | 0 | CHAR | (N' ') | No | | KZFIXIN | Allow NULL? |
| 5 | CONIN | Ind.: Item used only during consolidation | char | 1 | 0 | CHAR | (N' ') | No | | KZCONIN | Allow NULL? |
| 6 | AMOIN | Indicator: quantity | char | 1 | 0 | CHAR | (N' ') | No | | KZMENGE | Allow NULL? |
| 7 | ITSUM | Indicator: totals item | char | 1 | 0 | CHAR | (N' ') | No | | KZITSUM | Allow NULL? |
| 8 | SIGN | Debit/credit sign for consolidation item | char | 1 | 0 | CHAR | (N' ') | No | | SHKZVZ | Allow NULL? |
| 9 | ITTYP | Asset/Liability/IncSt/Other | char | 1 | 0 | CHAR | (N' ') | No | | ITTYP | Allow NULL? |
| 10 | CHAIN | Indicator: contra item | char | 1 | 0 | CHAR | (N' ') | No | | KZCHAIN | Allow NULL? |
| 11 | TTYIN | Indicator: breakdown by transaction types | char | 1 | 0 | CHAR | (N' ') | No | | KZTTYIN | Allow NULL? |
| 12 | YOAIN | Indicator: breakdown by years of acquisition | char | 1 | 0 | CHAR | (N' ') | No | | KZYOAIN | Allow NULL? |
| 13 | ASCIN | Indicator: Breakdown by trading partners (affiliates) | char | 1 | 0 | CHAR | (N' ') | No | | KZASCIN | Allow NULL? |
| 14 | CURIN | Indicator: breakdown by currency | char | 1 | 0 | CHAR | (N' ') | No | | KZCURIN | Allow NULL? |
| 15 | ADFIN | Breakdown by additional field | char | 1 | 0 | CHAR | (N' ') | No | | FK_ADFIN | Allow NULL? |
| 16 | SETS | Definition of totals item | nvarchar | 60 | 0 | CHAR | (N' ') | No | | DEFSUMPOS | Allow NULL? |
| 17 | ITCON | Contra item | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM_CON | Allow NULL? |
| 18 | NEWIT | New financial statement item number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | RITEM_NEW | Allow NULL? |
| 19 | ALTIT | Reference item | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | RITEM_ALT | Allow NULL? |
| 20 | KZEIS | Indicator: Totals item for EIS reporting | char | 1 | 0 | CHAR | (N' ') | No | | KZEIS | Allow NULL? |
