| 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 | ANEK | LNRAN | Allow NULL? |
| 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | ANLB | 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 | PERAF | Depreciation calculation period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PERAF | Allow NULL? |
| 11 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 12 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 13 | BZDAT | Asset value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BZDAT | Allow NULL? |
| 14 | BWASL | Asset Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TABW | BWASL | Allow NULL? |
| 15 | XAFAR | Indicator: Errors in depreciation | char | 1 | 0 | NUMC | (N'0') | Yes | | XAFAR | Allow NULL? |
| 16 | ANBTR | Amount posted | decimal | 13 | 2 | CURR | ((0)) | Yes | | ANBTR | |
| 17 | NAFAB | Ordinary depreciation on transactions | decimal | 13 | 2 | CURR | ((0)) | Yes | | NAFAB | |
| 18 | SAFAB | Special depreciation on transactions | decimal | 13 | 2 | CURR | ((0)) | Yes | | SAFAB | |
| 19 | ZINSB | Interest on transaction | decimal | 13 | 2 | CURR | ((0)) | Yes | | DZINSB | |
| 20 | XANTW | Indicator: Proportional values posted automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | XANTW | Allow NULL? |
| 21 | XAWBT | Indicator: Different posting amount entered | char | 1 | 0 | CHAR | (N' ') | Yes | | XAWBT | Allow NULL? |
| 22 | LNSAN | Sequence number of reversed asset line items | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | LNSAN | Allow NULL? |
| 23 | ANUPD | Indicator: Type of change to table | char | 1 | 0 | CHAR | (N' ') | Yes | | ANUPD | Allow NULL? |
| 24 | AUGLN | Current number of the clearing asset line item | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | ANEK | AM_AUGLN | Allow NULL? |
