| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DIMEN | Dimension | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | CMETH | Method | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | SEQNO | Sequence number in a method | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | CONGR | Limit to a specific consolidation group | nvarchar | 18 | 0 | | | | Allow NULL? |
| 7 | IITEM | Triggering FS item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | IITSET | Identification of a set | nvarchar | 34 | 0 | | | | Allow NULL? |
| 9 | ISITYP | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | ISITEM | Triggering subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | ISISET | Identification of a set | nvarchar | 34 | 0 | | | | Allow NULL? |
| 12 | IBUPTR | Reclassification: Partner unit of the triggering item | nvarchar | 18 | 0 | | | | Allow NULL? |
| 13 | IBPSET | Identification of a set | nvarchar | 34 | 0 | | | | Allow NULL? |
| 14 | FITEM | Reclassification: Source FS item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | FSITYP | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | FSITEM | Reclassification: "From" subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | FBUPTR | Reclassification: Source partner unit | nvarchar | 18 | 0 | | | | Allow NULL? |
| 18 | TITEM | Reclassification: Destination FS item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | TSITYP | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | TSITEM | Reclassification: "To" subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | TBUPTR | Reclassifications: Destination partner unit | nvarchar | 18 | 0 | | | | Allow NULL? |
| 22 | BSIGN | Debit/credit sign for balance during reclassification | char | 1 | 0 | | | | Allow NULL? |
| 23 | PERCT | Percentage to be reclassified | decimal | 7 | 4 | | | | |
| 24 | PBIND | Post to the partner unit | char | 1 | 0 | | | | Allow NULL? |
| 25 | PERIND | Periodic reclassification | char | 1 | 0 | | | | Allow NULL? |
| 26 | FSCAT | Consolidation frequency | char | 1 | 0 | | | | Allow NULL? |
| 27 | DOCIND | Cumulative document | char | 1 | 0 | | | | Allow NULL? |
| 28 | BAL_SUBIT | Sign-triggered reclass.: Balance per characteristic | char | 1 | 0 | | | | Allow NULL? |
| 29 | BAL_BUPTR | Net balance per partner (Dr/Cr sign-triggered recl.) | char | 1 | 0 | | | | Allow NULL? |
| 30 | RCL_MO | Inclusion of parent/subsidiary | char | 1 | 0 | | | | Allow NULL? |
| 31 | RCLDIV | Reclassification of taxes on investment income | char | 1 | 0 | | | | Allow NULL? |
| 32 | RCLCGREST | Selection Type for Group Restrictions in Reclassification | char | 1 | 0 | | | | Allow NULL? |
| 33 | RCLCGBUPTR | Logic for partner inclusion at posting level 30 | char | 1 | 0 | | | | Allow NULL? |