| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LEDNR | Ledger | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | RVERS | Version for hidden reserves | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | RSUBD | Subgroup | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | RCOMP | Company | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | ITEM | Consolidation item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | SITEM | Subitem | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | FYEAR | Year of amortization of goodwill/hidden reserves | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | FPERI | Period of amortization of goodwill and hidden reserves | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | CYEAR | Fiscal year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | CPERI | Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | DEPRL | Life of depreciation (amortization) in years | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | DEPMO | Life of depreciation (amortization) in months | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | DEPRT | Depreciation method | char | 1 | 0 | | | | Allow NULL? |
| 16 | DEPRP | Depreciation percentage rate | decimal | 7 | 4 | | | | |
| 17 | ADDVL | Acquisition value in reporting currency | decimal | 15 | 2 | | | | |
| 18 | BBKVL | Beginning book value in group currency | decimal | 15 | 2 | | | | |
| 19 | NDEPR | Ordinary depreciation in group currency | decimal | 15 | 2 | | | | |
| 20 | SDEPR | Special amortization in reporting currency | decimal | 15 | 2 | | | | |
| 21 | ZUSCH | Write-up in group currency | decimal | 15 | 2 | | | | |
| 22 | ABGAN | Asset retirement in group currency | decimal | 15 | 2 | | | | |
| 23 | EBKVL | Net book value in group currency | decimal | 15 | 2 | | | | |
| 24 | SIGN | Sign for goodwill/hidden reserves | char | 1 | 0 | | | | Allow NULL? |
| 25 | DEPRM | Depreciable (amortizable) life for first year in months | nvarchar | 2 | 0 | | | | Allow NULL? |