| 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 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | AFAPL | Allow NULL? |
| 3 | GEGST | Asset Class | nvarchar | 8 | 0 | CHAR | (N' ') | No | * | ANLKL | Allow NULL? |
| 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | AFABE_D | Allow NULL? |
| 5 | ADATU | Date for beginning of validity | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ADATU | Allow NULL? |
| 6 | BDATU | Date validity ends | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDATU | Allow NULL? |
| 7 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 8 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 9 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 10 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 11 | XLOEV | Indicator: Class/area marked for deletion | char | 1 | 0 | CHAR | (N' ') | Yes | | XLOEV_ANKB | Allow NULL? |
| 12 | NDJAR | Planned useful life in years | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NDJAR | Allow NULL? |
| 13 | NDPER | Planned useful life in periods | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NDPER | Allow NULL? |
| 14 | WBIND | Index series for replacement values | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | WBIND | Allow NULL? |
| 15 | ALIND | Index series for replacement values by age | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | ALIND | Allow NULL? |
| 16 | APROP | Variable depreciation portion | decimal | 7 | 4 | DEC | ((0)) | Yes | | APROP | |
