| 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 | LEDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | No | T881 | RLDNR | Allow NULL? |
| 3 | RVERS | Version for hidden reserves | nvarchar | 3 | 0 | CHAR | (N' ') | No | | RVERS_HR | Allow NULL? |
| 4 | RCOMP | Company | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | RCOMP_D | Allow NULL? |
| 5 | RYEAR | Fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RYEAR | Allow NULL? |
| 6 | PERID | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PERIODE | Allow NULL? |
| 7 | ITEM | Consolidation item | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM | Allow NULL? |
| 8 | SITEM | Subitem | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SITEM | Allow NULL? |
| 9 | RSUBD | Subgroup | nvarchar | 3 | 0 | CHAR | (N' ') | No | T852 | RSUBD | Allow NULL? |
| 10 | PRIOT | Priority: hidden reserves | char | 1 | 0 | NUMC | (N'0') | No | | PRIO1 | Allow NULL? |
| 11 | STILC | Hidden reserves/goodwill in local currency | decimal | 15 | 2 | CURR | ((0)) | No | | VLCUR_HR | |
| 12 | STIRE | Hidden reserves/GW in group currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_HR | |
| 13 | DEPLC | Accumulated amortization in local currency | decimal | 15 | 2 | CURR | ((0)) | No | | VLCUR_ACDP | |
| 14 | DEPAC | Accumulated amortization in group currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_ACDP | |
| 15 | DEPRT | Depreciation method | char | 1 | 0 | CHAR | (N' ') | No | | DEPRT | Allow NULL? |
| 16 | DEPRP | Depreciation percentage rate | decimal | 7 | 4 | DEC | ((0)) | No | | AFPROZ | |
| 17 | DEPRL | Life of depreciation (amortization) in years | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DEPRL | Allow NULL? |
| 18 | DEPRM | Depreciable (amortizable) life for first year in months | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DEPRMFY | Allow NULL? |
| 19 | DEPRI | Amortization item in income statement | nvarchar | 10 | 0 | CHAR | (N' ') | No | T854 | RITEM_DEPR | Allow NULL? |
| 20 | EXTY1 | Exchange rate indicator | char | 1 | 0 | CHAR | (N' ') | No | | CUTYP | Allow NULL? |
| 21 | EXCH1 | Exchange rate | nvarchar | 9 | 0 | NUMC | (N'000000000') | No | | KURSC | Allow NULL? |
| 22 | IQERT1 | Exchange rate entered at indirect quotation | char | 1 | 0 | CHAR | (N' ') | No | | LC_IQERT | Allow NULL? |
| 23 | EXTY2 | Exchange rate indicator | char | 1 | 0 | CHAR | (N' ') | No | | CUTYP | Allow NULL? |
| 24 | EXCH2 | Exchange rate | nvarchar | 9 | 0 | NUMC | (N'000000000') | No | | KURSC | Allow NULL? |
| 25 | IQERT2 | Exchange rate entered at indirect quotation | char | 1 | 0 | CHAR | (N' ') | No | | LC_IQERT | Allow NULL? |
| 26 | TXT | Text, length 40 | nvarchar | 40 | 0 | CHAR | (N' ') | No | | TXT40 | Allow NULL? |
| 27 | DEPMO | Life of depreciation (amortization) in months | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DEPRM | Allow NULL? |
