| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | ANLH | ANLN1 | Allow NULL? |
| 4 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | No | ANLA | ANLN2 | Allow NULL? |
| 5 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 6 | LNRAN | Sequence number of asset line items in fiscal year | nvarchar | 5 | 0 | NUMC | (N'00000') | No | ANEP | LNRAN | Allow NULL? |
| 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | AFABE_D | Allow NULL? |
| 8 | ZUJHR | Asset acquisition year (currently not used) | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | DZUJHR | Allow NULL? |
| 9 | ZUCOD | Sub-classification of asset acquisitions(currently not used) | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | DZUCOD | Allow NULL? |
| 10 | AUFWV | Proportional cumulative revaluation on replacement value | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUFWV | |
| 11 | INVZV | Proportional cumulative investment grants | decimal | 13 | 2 | CURR | ((0)) | Yes | | INVZV | |
| 12 | NAFAV | Proportional accumulated ordinary depreciation | decimal | 13 | 2 | CURR | ((0)) | Yes | | NAFAV | |
| 13 | SAFAV | Proportional cumulative special depreciation | decimal | 13 | 2 | CURR | ((0)) | Yes | | SAFAV | |
| 14 | AAFAV | Proportional cumulative unplanned depreciation | decimal | 13 | 2 | CURR | ((0)) | Yes | | AAFAV | |
| 15 | MAFAV | Proportional cumulative transfer of reserves | decimal | 13 | 2 | CURR | ((0)) | Yes | | MAFAV | |
| 16 | AUFNV | Proportional cum. revaluation on ordinary depreciation | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUFNV | |
| 17 | AUFWL | Proportional revaluation for the year on replacement value | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUFWL | |
| 18 | INVZL | Proportional investment grant for the year | decimal | 13 | 2 | CURR | ((0)) | Yes | | INVZL | |
| 19 | NAFAL | Proportional ordinary depreciation for the year | decimal | 13 | 2 | CURR | ((0)) | Yes | | NAFAL | |
| 20 | SAFAL | Proportional special depreciation for the year | decimal | 13 | 2 | CURR | ((0)) | Yes | | SAFAL | |
| 21 | AAFAL | Proportional unplanned depreciation for the year | decimal | 13 | 2 | CURR | ((0)) | Yes | | AAFAL | |
| 22 | MAFAL | Proportional transfer of reserves for the year | decimal | 13 | 2 | CURR | ((0)) | Yes | | MAFAL | |
| 23 | AUFNL | Proportional revaluation of annual ordinary dep. | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUFNL | |
| 24 | ERLBT | Revenue from asset sale | decimal | 13 | 2 | CURR | ((0)) | Yes | | ERLBT | |
| 25 | ANUPD | Indicator: Type of change to table | char | 1 | 0 | CHAR | (N' ') | Yes | | ANUPD | Allow NULL? |
| 26 | VERKO | Costs from asset retirement | decimal | 13 | 2 | CURR | ((0)) | Yes | | VERKO_D | |
| 27 | SANWV | Prop. statistical acquisition value retired | decimal | 13 | 2 | CURR | ((0)) | Yes | | SANWV | |
