| 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 | RSUBD | Subgroup | nvarchar | 3 | 0 | CHAR | (N' ') | No | T852 | RSUBD | Allow NULL? |
| 5 | RCOMP | Company | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | RCOMP_D | Allow NULL? |
| 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | RASSC | 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 | FYEAR | Year of amortization of goodwill/hidden reserves | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RYEAR_RV | Allow NULL? |
| 10 | FPERI | Period of amortization of goodwill and hidden reserves | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PERIOD_RV | Allow NULL? |
| 11 | CYEAR | Fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RYEAR | Allow NULL? |
| 12 | CPERI | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PERIODE | Allow NULL? |
| 13 | DEPRL | Life of depreciation (amortization) in years | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DEPRL | Allow NULL? |
| 14 | DEPMO | Life of depreciation (amortization) in months | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DEPRM | Allow NULL? |
| 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 | ADDVL | Acquisition value in reporting currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_BB | |
| 18 | BBKVL | Beginning book value in group currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_NBV | |
| 19 | NDEPR | Ordinary depreciation in group currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_OAM | |
| 20 | SDEPR | Special amortization in reporting currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_SAM | |
| 21 | ZUSCH | Write-up in group currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_WU | |
| 22 | ABGAN | Asset retirement in group currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_AR | |
| 23 | EBKVL | Net book value in group currency | decimal | 15 | 2 | CURR | ((0)) | No | | VGCUR_YEB | |
| 24 | SIGN | Sign for goodwill/hidden reserves | char | 1 | 0 | CHAR | (N' ') | No | | SIGN_GWHR | Allow NULL? |
| 25 | DEPRM | Depreciable (amortizable) life for first year in months | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DEPRMFY | Allow NULL? |
