| 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 | BUKRSN | Company code for number assignment | nvarchar | 4 | 0 | CHAR | (N' ') | No | T093N | BUKRSN | Allow NULL? |
| 4 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | T009 | PERIV | Allow NULL? |
| 5 | MONMIT | First day of the second half of the month | nvarchar | 2 | 0 | NUMC | (N'00') | No | | MONMIT | Allow NULL? |
| 6 | XRUMPF | Indicator: Shortened fiscal year | char | 1 | 0 | CHAR | (N' ') | No | | XRUMPF | Allow NULL? |
| 7 | DATUM | Value date for legacy asset data transferred | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATE_T093C | Allow NULL? |
| 8 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | CHAR | (N' ') | No | T096 | AFAPL | Allow NULL? |
| 9 | VRMAFB | Depreciation area for net worth tax valuation | nvarchar | 2 | 0 | NUMC | (N'00') | No | T093 | VRMAFB | Allow NULL? |
| 10 | BKRAKT | Cost center check across company codes | char | 1 | 0 | CHAR | (N' ') | No | | BKRAKT | Allow NULL? |
| 11 | XREBUW | Ind: Enter net book value during legacy data transfer | char | 1 | 0 | CHAR | (N' ') | No | | XREBUW | Allow NULL? |
| 12 | XANUEB | Staus of asset data transfer in the company code | char | 1 | 0 | NUMC | (N'0') | No | | XANUEB | Allow NULL? |
| 13 | LGJAHR | Last fiscal year opened by the fiscal year change | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | LGJAHR | Allow NULL? |
| 14 | AFBLRT | Document type for depreciation posting | nvarchar | 2 | 0 | CHAR | (N' ') | No | T003 | AFBLRT | Allow NULL? |
| 15 | XVRSKU | Recalculate cumulative insurance base value | char | 1 | 0 | CHAR | (N' ') | No | | XVRSKU | Allow NULL? |
| 16 | MWSKZVA | Input tax code - Assets without input tax | nvarchar | 2 | 0 | CHAR | (N' ') | No | T007A | MWSKZVA | Allow NULL? |
| 17 | MWSKZAA | Output tax code - asset is exempt from tax (unused) | nvarchar | 2 | 0 | CHAR | (N' ') | No | T007A | MWSKZAA | Allow NULL? |
| 18 | KZRBWB | Indicator post net book value for retirement | char | 1 | 0 | CHAR | (N' ') | No | | KZRBWB | Allow NULL? |
| 19 | APROF | Settlement profile for assets under construction | nvarchar | 6 | 0 | CHAR | (N' ') | No | TKB1A | AM_APROF | Allow NULL? |
| 20 | TTECH | Min. retention period of assets and asset values | tinyint | 3 | 0 | INT1 | ((0)) | No | | TTECH | |
| 21 | TKUND | Retention period of asset and asset values (cust. specific) | tinyint | 3 | 0 | INT1 | ((0)) | No | | TKUND | |
| 22 | XANLE | Indicator: Original line item for proof of origin | char | 1 | 0 | CHAR | (N' ') | No | | IM_XANLE | Allow NULL? |
| 23 | VARBZD | Variant for determining asset value date | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | TABVA | VARBZDAT | Allow NULL? |
| 24 | J_1AAOFFCL | Official document class for Asset Movements | char | 1 | 0 | CHAR | (N' ') | Yes | * | J_1AAOFFCL | Allow NULL? |
| 25 | XZORG | Indicator: Time-independent management of organiz. units | char | 1 | 0 | CHAR | (N' ') | Yes | | XZORG | Allow NULL? |
| 26 | APERBLRT | Document Type for Periodic Posting of APC Values | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | APERBLRT | Allow NULL? |
| 27 | XNOSKONTO | Subsequent Capitalization of Discount Not Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | XNOSKONTO | Allow NULL? |
| 28 | XDFYV | Allow Different Fiscal Year Variants | char | 1 | 0 | CHAR | (N' ') | Yes | | XDFYV | Allow NULL? |
| 29 | REVDMETH | Method for Revenue Distribution at Asset Retirement | char | 1 | 0 | CHAR | (N' ') | Yes | | REVDMETH | Allow NULL? |
