| 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 | T000 | MANDT | Allow NULL? |
| 2 | FIXVS | Version: Selected FS items | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF212 | FC_FIXVS | Allow NULL? |
| 3 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG | Allow NULL? |
| 4 | DTEQI | Scope of reported data for the equity method | char | 1 | 0 | NUMC | (N'0') | No | TF665 | FC_DTEQI | Allow NULL? |
| 5 | ITEM | Investment item for equity consolidation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_DTEQII | Allow NULL? |
| 6 | SITYP | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 7 | SITEMD | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 8 | SITEMC | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 9 | CITEMD | Debits offsetting item for equity method | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_DTEQIDI | Allow NULL? |
| 10 | CSITYPD | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 11 | CSITEMD | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 12 | CITEMC | Credits offsetting item for equity method | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_DTEQICI | Allow NULL? |
| 13 | CSITYPC | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 14 | CSITEMC | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 15 | STITEM | Statistical Scope of Reported Data for Equity Method | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_STITEM | Allow NULL? |
| 16 | DITEMD | Offsetting item for divestitures - debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_DITEMD | Allow NULL? |
| 17 | DSITYPD | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 18 | DSITEMD | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 19 | DITEMC | Offsetting item for divestitures - credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_DITEMC | Allow NULL? |
| 20 | DSITYPC | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 21 | DSITEMC | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 22 | NITEM | Equity holding item for negative book value | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_DTEQINI | Allow NULL? |
| 23 | NSITYP | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 24 | NSITEM | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 25 | NCITEM | Offsetting equity item for negative investment book value | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_DTEQINC | Allow NULL? |
| 26 | NCSITYP | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 27 | NCSITEM | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
