| 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 | CTRGR | Translation method | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | RNDIN | Rounding entry | char | 1 | 0 | | | | Allow NULL? |
| 6 | SEQNR | Sequence number in a method | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | ISET1 | Item set 1 | nvarchar | 34 | 0 | | | | Allow NULL? |
| 8 | STYP2 | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | SSET2 | Subitem set | nvarchar | 34 | 0 | | | | Allow NULL? |
| 10 | ISET3 | Item set 2 | nvarchar | 34 | 0 | | | | Allow NULL? |
| 11 | ERTIN | Exchange rate indicator | char | 1 | 0 | | | | Allow NULL? |
| 12 | CTKEY | Currency translation key | char | 1 | 0 | | | | Allow NULL? |
| 13 | ERPYR | Use the exchange rate from the prior year | char | 1 | 0 | | | | Allow NULL? |
| 14 | AVGER | Use average exchange rate for reductions | char | 1 | 0 | | | | Allow NULL? |
| 15 | ITEMD | Item - debit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | ITEMC | Item - credit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | AIDIN | Affects earnings-Dr | char | 1 | 0 | | | | Allow NULL? |
| 18 | AICIN | Affects earnings - credit | char | 1 | 0 | | | | Allow NULL? |
| 19 | BSIIN | Set contains balance sheet items | char | 1 | 0 | | | | Allow NULL? |
| 20 | SITYP | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | SITEM | Subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | UEXIT | Name of exit for user-defined exchange rate determination | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | GVREF | State consolidated value at the reference exchange rate | char | 1 | 0 | | | | Allow NULL? |
| 24 | TDIFF | Disclosure of Temporal Translation Differences | char | 1 | 0 | | | | Allow NULL? |
| 25 | DTPCU | Break down translation differences by partner unit | char | 1 | 0 | | | | Allow NULL? |
| 26 | DTCUR | Break down translation differences by transaction currency | char | 1 | 0 | | | | Allow NULL? |