| 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 | * | 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 | AFABE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | AFABE_D | Allow NULL? |
| 6 | BDATU | Date validity ends | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BDATU | Allow NULL? |
| 7 | ADATU | Date for beginning of validity | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ADATU | Allow NULL? |
| 8 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 9 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 10 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 11 | AEDAT | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT_ANLA | Allow NULL? |
| 12 | XLOEV | Indicator: Account marked for deletion? | char | 1 | 0 | CHAR | (N' ') | Yes | | XLOEV | Allow NULL? |
| 13 | XSPEB | Indicator: Is Account Blocked for Posting? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPEB | Allow NULL? |
| 14 | FELEI | Screen layout for Asset Accounting | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T082A | FELEI | Allow NULL? |
| 15 | XNEGA | Indicator: Negative values allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | XNEGA | Allow NULL? |
| 16 | XGWGK | Low-value asset amount and quantity check | char | 1 | 0 | NUMC | (N'0') | Yes | | XGWGK | Allow NULL? |
| 17 | XUNTA | Indicator: Depreciate main asset number totally | char | 1 | 0 | CHAR | (N' ') | Yes | | XUNTA | Allow NULL? |
| 18 | AFABG | Depreciation calculation start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AFABG | Allow NULL? |
| 19 | ZINBG | Start date for interest calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZINBG | Allow NULL? |
| 20 | SAFBG | Start date for special depreciation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SAFBG | Allow NULL? |
| 21 | INVSL | Investment support key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T085 | INVSL | Allow NULL? |
| 22 | AFASL | Depreciation key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T090NA | AFASL | Allow NULL? |
| 23 | NDJAR | Planned useful life in years | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NDJAR | Allow NULL? |
| 24 | NDPER | Planned useful life in periods | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NDPER | Allow NULL? |
| 25 | NAPRZ | Ordinary depreciation percentage rate | decimal | 7 | 4 | DEC | ((0)) | Yes | | NAPRZ | |
| 26 | SAPRZ | Special depreciation percentage rate | decimal | 7 | 4 | DEC | ((0)) | Yes | | SAPRZ | |
| 27 | WBIND | Index series for replacement values | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T094A | WBIND | Allow NULL? |
| 28 | ALIND | Index series for replacement values by age | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T094A | ALIND | Allow NULL? |
| 29 | APROP | Variable depreciation portion | decimal | 7 | 4 | DEC | ((0)) | Yes | | APROP | |
| 30 | UMJAR | Depreciation key for the changeover year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | UMJAR | Allow NULL? |
| 31 | NDURJ | Original useful life in years | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NDURJ | Allow NULL? |
| 32 | NDURP | Original useful life in periods | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NDURP | Allow NULL? |
| 33 | SCHRW | Asset scrap value | decimal | 13 | 2 | CURR | ((0)) | Yes | | SCHRW | |
| 34 | LGJAN | Last fiscal year for the annual values in Asset Acct. | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LGJAN | Allow NULL? |
| 35 | PERFY | Period scaling in depreciation start year | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PERFY | Allow NULL? |
| 36 | ANUPD | Indicator: Type of change to table | char | 1 | 0 | CHAR | (N' ') | Yes | | ANUPD | Allow NULL? |
| 37 | AUFWTG | Revaluation | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | AUFWTG | Allow NULL? |
| 38 | XAFBE | Indicator: Depreciation area is deactivated | char | 1 | 0 | CHAR | (N' ') | Yes | | XAFBE | Allow NULL? |
| 39 | ANLGR | Group asset | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ANLH | ANLGR | Allow NULL? |
| 40 | ANLGR2 | Subnumber of group asset | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ANLA | ANLGR2 | Allow NULL? |
| 41 | VYEAR | Acquisition year of the asset (manually changeable) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | VYEAR | Allow NULL? |
| 42 | VMNTH | Asset Accounting: Acquis. month (in depreciation area) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | VMNTH | Allow NULL? |
| 43 | INBDA | Asset Accounting: Date of operating readiness | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | INBDA | Allow NULL? |
| 44 | ABGDAT_B | Value date of last retirement for the depreciation area | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABGDAT_B | Allow NULL? |
| 45 | J_1AARVKEY | Revaluation Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | J_1AAA2 | J_1AARVKEY | Allow NULL? |
| 46 | J_1AALTDAT | Last Revaluation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1AALTDAT | Allow NULL? |
| 47 | J_1AALTIDX | Last Index Used | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | J_1AALTIDX | Allow NULL? |
| 48 | SCHRW_PROZ | Scrap Value as Percentage of APC | decimal | 14 | 11 | DEC | ((0)) | Yes | | SCHRW_PROZ | |
| 49 | UMPER | Changeover Period of Depreciation Key | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | UMPER | Allow NULL? |
