| 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 | ANLKL | Asset Class | nvarchar | 8 | 0 | CHAR | (N' ') | No | | ANLKL | Allow NULL? |
| 3 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 4 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 5 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 6 | AEDAT | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT_ANLA | Allow NULL? |
| 7 | XLOEV | Ind.: Asseet class marked for deletion | char | 1 | 0 | CHAR | (N' ') | Yes | | XLOEV_ANKA | Allow NULL? |
| 8 | XSPEA | Indicator: Asset class is blocked | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPEA_ANKA | Allow NULL? |
| 9 | XOPVW | Asset under construct. with line item settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | OPVWA | Allow NULL? |
| 10 | NUMKR | Number range | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKR | Allow NULL? |
| 11 | KTOGR | Account determination | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T095A | KTOGR | Allow NULL? |
| 12 | ANKAR | Layout set name for asset history | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | ANKAR | Allow NULL? |
| 13 | FELEI | Screen layout for Asset Accounting | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T082A | FELEI | Allow NULL? |
| 14 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BEGRU | Allow NULL? |
| 15 | ZUAWA | Key for sorting according to assignment numbers | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TZUN | DZUAWA | Allow NULL? |
| 16 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 17 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 18 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 19 | LSTAR | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 20 | ANEQK | Indicator: Historical management | char | 1 | 0 | NUMC | (N'0') | Yes | | ANEQK | Allow NULL? |
| 21 | ANEQS | Completeness indicator for the asset | char | 1 | 0 | NUMC | (N'0') | Yes | | ANEQS | Allow NULL? |
| 22 | MACKZ | Matchcode indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | MACKZ | Allow NULL? |
| 23 | LAND1 | Asset's country of origin | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | AM_LAND1 | Allow NULL? |
| 24 | LIFNR | Account number of vendor (other key word) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | AM_LIFNR | Allow NULL? |
| 25 | LIEFE | Name of asset supplier | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | LIEFE | Allow NULL? |
| 26 | ANLUE | Asset super number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | T087U | ANLUE | Allow NULL? |
| 27 | EIGKZ | Property indicator | char | 1 | 0 | CHAR | (N' ') | Yes | T097 | EIGKZ | Allow NULL? |
| 28 | VMGLI | Property classification key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T092 | VMGLI | Allow NULL? |
| 29 | XVRMW | Manual net worth tax value | char | 1 | 0 | CHAR | (N' ') | Yes | | XVRMW | Allow NULL? |
| 30 | INVSL | Investment support key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | INVSL | Allow NULL? |
| 31 | ORD41 | Evaluation group 1 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T087 | ORD41 | Allow NULL? |
| 32 | ORD42 | Evaluation group 2 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T087 | ORD42 | Allow NULL? |
| 33 | ORD43 | Evaluation group 3 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T087 | ORD43 | Allow NULL? |
| 34 | ORD44 | Evaluation group 4 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T087 | ORD44 | Allow NULL? |
| 35 | IZWEK | Reason for investment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T087I | IZWEK | Allow NULL? |
| 36 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HERST | Allow NULL? |
| 37 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 38 | FEINS | Area unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | FEINS | Allow NULL? |
| 39 | INKEN | Inventory indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INKEN | Allow NULL? |
| 40 | FIAMT | Local tax office | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | FIAMT | Allow NULL? |
| 41 | STADT | Municipality | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT01_ANLA | Allow NULL? |
| 42 | ANLTP | Asset Category | char | 1 | 0 | NUMC | (N'0') | Yes | | ANLTP | Allow NULL? |
| 43 | XUNTV | External/internal asset subnumber assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | XUNTV | Allow NULL? |
| 44 | XAKTIV | Indicator: Capitalize fixed asset | char | 1 | 0 | CHAR | (N' ') | Yes | | XAKTIV | Allow NULL? |
| 45 | LEAFI | Leasing company | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LEAFI | Allow NULL? |
| 46 | LEJAR | Length of lease in years | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LEJAR | Allow NULL? |
| 47 | LEPER | Length of lease in periods | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LEPER | Allow NULL? |
| 48 | LRYTH | Lease payment cycle | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LRYTH | Allow NULL? |
| 49 | LMZIN | Leasing monthly interest rate (Capital Lease) | decimal | 7 | 4 | DEC | ((0)) | Yes | | LMZIN | |
| 50 | LEANZ | Number of lease payments | decimal | 5 | 0 | DEC | ((0)) | Yes | | LEANZ | |
| 51 | LETXT | Leasing data text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | LETXT | Allow NULL? |
| 52 | AIMMO | Indicator: real estate | char | 1 | 0 | NUMC | (N'0') | Yes | | AIMMO | Allow NULL? |
| 53 | GDLGRP | Evaluation group 5 | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T087G | GDLGRP | Allow NULL? |
| 54 | XERWRT | Indicator: Ignore memo value | char | 1 | 0 | CHAR | (N' ') | Yes | | XERWRT | Allow NULL? |
| 55 | XANLGR | Indicator: asset class managed as group asset | char | 1 | 0 | CHAR | (N' ') | Yes | | XANLGR | Allow NULL? |
| 56 | XINVM | Asset under Construction for Investment Measures | char | 1 | 0 | CHAR | (N' ') | Yes | | IM_XINVM | Allow NULL? |
| 57 | LEART | Leasing type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T083L | LEART | Allow NULL? |
| 58 | ABGSL | Capitalization Key for Investment Measure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TKKAA | IM_ABGR_SL | Allow NULL? |
