| 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 | DIMEN | Dimension | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF150 | FC_DIMEN | Allow NULL? |
| 3 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG | Allow NULL? |
| 4 | CMETH | Method | nvarchar | 5 | 0 | CHAR | (N' ') | No | TF550 | FC_CMETH | Allow NULL? |
| 5 | SEQNO | Sequence number in a method | nvarchar | 3 | 0 | CHAR | (N' ') | No | | FC_SEQNO | Allow NULL? |
| 6 | ITSET1 | Identification of a set | nvarchar | 34 | 0 | CHAR | (N' ') | No | | FC_SETID | Allow NULL? |
| 7 | SISET1 | Identification of a set | nvarchar | 34 | 0 | CHAR | (N' ') | No | | FC_SETID | Allow NULL? |
| 8 | SITYP1 | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 9 | ITSET2 | Identification of a set | nvarchar | 34 | 0 | CHAR | (N' ') | No | | FC_SETID | Allow NULL? |
| 10 | SISET2 | Identification of a set | nvarchar | 34 | 0 | CHAR | (N' ') | No | | FC_SETID | Allow NULL? |
| 11 | SITYP2 | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 12 | SITYP | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF110 | FC_SITYP | Allow NULL? |
| 13 | ODIFITD | Debit item for posting other differences | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF100 | FC_ODIFITD | Allow NULL? |
| 14 | ODIFITC | Credit item for posting other differences | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF100 | FC_ODIFITC | Allow NULL? |
| 15 | CDIFITD | Debit item for currency translation differences | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF100 | FC_CDIFITD | Allow NULL? |
| 16 | CDIFITC | Credit item for currency translation differences | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF100 | FC_CDIFITC | Allow NULL? |
| 17 | ODIFSTD | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 18 | ODIFSTC | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 19 | CDIFSTD | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 20 | CDIFSTC | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 21 | ODIFSID | Debit subitem for posting other differences | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF115 | FC_ODIFSID | Allow NULL? |
| 22 | ODIFSIC | Credit subitem for posting other differences | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF115 | FC_ODIFSIC | Allow NULL? |
| 23 | CDIFSID | Subitem for translation differences (debits) | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF115 | FC_CDIFSID | Allow NULL? |
| 24 | CDIFSIC | Subitem for translation differences (credits) | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF115 | FC_CDIFSIC | Allow NULL? |
| 25 | ITG1IND | Post the difference to this item set | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ITGIND | Allow NULL? |
| 26 | ITG2IND | Post the difference to this item set | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ITGIND | Allow NULL? |
