| 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 | T093C | 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 | | ANLN2 | Allow NULL? |
| 5 | ANLKL | Asset Class | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ANKA | ANLKL | Allow NULL? |
| 6 | GEGST | Technical asset number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | GEGST | Allow NULL? |
| 7 | ANLAR | Asset types | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ANLAR | 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: Asset Locked to Acquisition Postings | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPEB_ANLA | Allow NULL? |
| 14 | FELEI | Screen layout for Asset Accounting | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FELEI | Allow NULL? |
| 15 | KTOGR | Account determination | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T095A | KTOGR | Allow NULL? |
| 16 | XOPVW | Asset under construct. with line item settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | OPVWA | Allow NULL? |
| 17 | ANLTP | Asset Category | char | 1 | 0 | NUMC | (N'0') | Yes | | ANLTP | Allow NULL? |
| 18 | ZUJHR | Fiscal year in which first acquisition was posted | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | DZUJAHR | Allow NULL? |
| 19 | ZUPER | Period in which first acquisition was posted | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | DZUPER | Allow NULL? |
| 20 | ZUGDT | Asset value date of the first posting | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZUGDAT | Allow NULL? |
| 21 | AKTIV | Asset capitalization date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AKTIVD | Allow NULL? |
| 22 | ABGDT | Asset value date for the last retirement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABGDAT | Allow NULL? |
| 23 | DEAKT | Deactivation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DEAKT | Allow NULL? |
| 24 | GPLAB | Planned retirement date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GPLAB | Allow NULL? |
| 25 | BSTDT | Asset purchase order date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BSTDT | Allow NULL? |
| 26 | ORD41 | Evaluation group 1 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T087 | ORD41 | Allow NULL? |
| 27 | ORD42 | Evaluation group 2 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T087 | ORD42 | Allow NULL? |
| 28 | ORD43 | Evaluation group 3 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T087 | ORD43 | Allow NULL? |
| 29 | ORD44 | Evaluation group 4 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T087 | ORD44 | Allow NULL? |
| 30 | ANLUE | Asset super number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | T087U | ANLUE | Allow NULL? |
| 31 | ZUAWA | Key for sorting according to assignment numbers | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TZUN | DZUAWA | Allow NULL? |
| 32 | ANEQK | Indicator: Historical management | char | 1 | 0 | NUMC | (N'0') | Yes | | ANEQK | Allow NULL? |
| 33 | ANEQS | Completeness indicator for the asset | char | 1 | 0 | NUMC | (N'0') | Yes | | ANEQS | Allow NULL? |
| 34 | LIFNR | Account number of vendor (other key word) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | AM_LIFNR | Allow NULL? |
| 35 | LAND1 | Asset's country of origin | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | AM_LAND1 | Allow NULL? |
| 36 | LIEFE | Name of asset supplier | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | LIEFE | Allow NULL? |
| 37 | HERST | Manufacturer of asset | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | HERST | Allow NULL? |
| 38 | EIGKZ | Property indicator | char | 1 | 0 | CHAR | (N' ') | Yes | T097 | EIGKZ | Allow NULL? |
| 39 | AIBN1 | Original asset that was transferred | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AIBN1 | Allow NULL? |
| 40 | AIBN2 | Original asset that was transferred | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | AIBN2 | Allow NULL? |
| 41 | AIBDT | Original acquisition date of AuC/ transferred asset | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AIBDT | Allow NULL? |
| 42 | URJHR | Fiscal year of original acquisition | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | URJHR | Allow NULL? |
| 43 | URWRT | Original acquisition value | decimal | 13 | 2 | CURR | ((0)) | Yes | | URWRT | |
| 44 | ANTEI | In-house production percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | ANTEI | |
| 45 | PROJN | Old: Project number : No longer used --> PS_POSNR | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | PROJN | Allow NULL? |
| 46 | EAUFN | Investment Order | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AM_AUFNR | Allow NULL? |
| 47 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 48 | MENGE | Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | AM_MENGE | |
| 49 | TYPBZ | Asset type name | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | TYPBZ_ANLA | Allow NULL? |
| 50 | IZWEK | Reason for investment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T087I | IZWEK | Allow NULL? |
| 51 | INKEN | Inventory indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | INKEN | Allow NULL? |
| 52 | IVDAT | Last inventory date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IVDAT_ANLA | Allow NULL? |
| 53 | INVZU | Supplementary inventory specifications | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | INVZU_ANLA | Allow NULL? |
| 54 | VMGLI | Property classification key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T092 | VMGLI | Allow NULL? |
| 55 | XVRMW | Manual net worth tax value | char | 1 | 0 | CHAR | (N' ') | Yes | | XVRMW | Allow NULL? |
| 56 | WRTMA | Manual net worth tax value | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRTMA | |
| 57 | EHWRT | Assessed value | decimal | 13 | 2 | CURR | ((0)) | Yes | | EHWRT | |
| 58 | AUFLA | Date of conveyance | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUFLA_ANLA | Allow NULL? |
| 59 | EHWZU | Date of last notice of assessment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EHWZU_ANLA | Allow NULL? |
| 60 | EHWNR | Tax number of the notice of assessment | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | EHWNR_ANLA | Allow NULL? |
| 61 | GRUVO | Land Register of | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GRUVO_ANLA | Allow NULL? |
| 62 | GREIN | Land register entry on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GREIN_ANLA | Allow NULL? |
| 63 | GRBND | Land register volume | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | GRBND_ANLA | Allow NULL? |
| 64 | GRBLT | Land register page | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | GRBLT_ANLA | Allow NULL? |
| 65 | GRLFD | Land register entry: Sequence number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GRLFD_ANLA | Allow NULL? |
| 66 | FLURK | Land register map number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FLURK_ANLA | Allow NULL? |
| 67 | FLURN | Plot number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FLURN_ANLA | Allow NULL? |
| 68 | FIAMT | Local tax office | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | FIAMT | Allow NULL? |
| 69 | STADT | Municipality | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT01_ANLA | Allow NULL? |
| 70 | GRUND | Reason for manual valuation of net assets | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T098 | GRUND | Allow NULL? |
| 71 | FEINS | Area unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | FEINS | Allow NULL? |
| 72 | GRUFL | Surface area | decimal | 13 | 3 | QUAN | ((0)) | Yes | | GRUFL | |
| 73 | INVNR | Inventory number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | INVNR_ANLA | Allow NULL? |
| 74 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T880 | RASSC | Allow NULL? |
| 75 | SPRAS | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SPRAS | Allow NULL? |
| 76 | TXT50 | Asset description | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TXA50_ANLT | Allow NULL? |
| 77 | TXA50 | Additional asset description | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TXA50_MORE | Allow NULL? |
| 78 | XLTXID | Indicator: Long text active | char | 1 | 0 | CHAR | (N' ') | Yes | | XLTXID | Allow NULL? |
| 79 | XVERID | Long text indicator:Property values | char | 1 | 0 | CHAR | (N' ') | Yes | | XVERID | Allow NULL? |
| 80 | XTCHID | Indicator: Technical view long text | char | 1 | 0 | CHAR | (N' ') | Yes | | XTCHID | Allow NULL? |
| 81 | XKALID | Indicator: Long text active | char | 1 | 0 | CHAR | (N' ') | Yes | | XKALID | Allow NULL? |
| 82 | XHERID | Indicator: Long text for manufacturer/origin | char | 1 | 0 | CHAR | (N' ') | Yes | | XHERID | Allow NULL? |
| 83 | XLEAID | Indicator: Leasing data long text | char | 1 | 0 | CHAR | (N' ') | Yes | | XLEAID | Allow NULL? |
| 84 | LEAFI | Leasing company | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LEAFI | Allow NULL? |
| 85 | LVDAT | Leasing agreement date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LVDAT | Allow NULL? |
| 86 | LKDAT | Leasing agreement notice date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LKDAT | Allow NULL? |
| 87 | LEABG | Lease start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LEABG | Allow NULL? |
| 88 | LEJAR | Length of lease in years | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LEJAR | Allow NULL? |
| 89 | LEPER | Length of lease in periods | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LEPER | Allow NULL? |
| 90 | LRYTH | Lease payment cycle | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LRYTH | Allow NULL? |
| 91 | LEGEB | Periodic lease payment paid to leasing company/lessor | decimal | 13 | 2 | CURR | ((0)) | Yes | | LEGEB | |
| 92 | LBASW | Leasing base value as new | decimal | 13 | 2 | CURR | ((0)) | Yes | | LBASW | |
| 93 | LKAUF | Leased asset purchase price | decimal | 13 | 2 | CURR | ((0)) | Yes | | LKAUF | |
| 94 | LMZIN | Leasing monthly interest rate (Capital Lease) | decimal | 7 | 4 | DEC | ((0)) | Yes | | LMZIN | |
| 95 | LZINS | Leasing interest rate (capital lease) | decimal | 7 | 4 | DEC | ((0)) | Yes | | LZINS | |
| 96 | LTZBW | Posting date of the last lease payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LTZBW | Allow NULL? |
| 97 | LKUZA | Total of posted leasing payments | decimal | 13 | 2 | CURR | ((0)) | Yes | | LKUZA | |
| 98 | LKUZI | Total leasing interest posted | decimal | 13 | 2 | CURR | ((0)) | Yes | | LKUZI | |
| 99 | LLAVB | Total of long-term leasing liability | decimal | 13 | 2 | CURR | ((0)) | Yes | | LLAVB | |
| 100 | LEANZ | Number of lease payments | decimal | 5 | 0 | DEC | ((0)) | Yes | | LEANZ | |
| 101 | LVTNR | Leasing agreement number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | LVTNR | Allow NULL? |
| 102 | LETXT | Leasing data text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | LETXT | Allow NULL? |
| 103 | XAKTIV | Indicator: Capitalize fixed asset | char | 1 | 0 | CHAR | (N' ') | Yes | | XAKTIV | Allow NULL? |
| 104 | ANUPD | Indicator: Type of change to table | char | 1 | 0 | CHAR | (N' ') | Yes | | ANUPD | Allow NULL? |
| 105 | LBLNR | No. of last document with which posting to asset was made | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LBLNR | Allow NULL? |
| 106 | XV0DT | Change date: View 0 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XV0DT | Allow NULL? |
| 107 | XV0NM | Name of person in charge, who changed View0 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XV0NM | Allow NULL? |
| 108 | XV1DT | Change date: View 1 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XV1DT | Allow NULL? |
| 109 | XV1NM | Name of person in charge, who changed view 1 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XV1NM | Allow NULL? |
| 110 | XV2DT | Change date: View 2 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XV2DT | Allow NULL? |
| 111 | XV2NM | Name of the person in charge, who changed view 2 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XV2NM | Allow NULL? |
| 112 | XV3DT | Change date: View 3 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XV3DT | Allow NULL? |
| 113 | XV3NM | Name of the person in charge, who changed view 3 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XV3NM | Allow NULL? |
| 114 | XV4DT | Change date: View 4 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XV4DT | Allow NULL? |
| 115 | XV4NM | Name of the person in charge, who changed view 4 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XV4NM | Allow NULL? |
| 116 | XV5DT | Change date:View 5 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XV5DT | Allow NULL? |
| 117 | XV5NM | Name of the person in charge who changed view 5 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XV5NM | Allow NULL? |
| 118 | XV6DT | Change date:View 6 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | XV6DT | Allow NULL? |
| 119 | XV6NM | Name of the person in charge who changed view 6 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XV6NM | Allow NULL? |
| 120 | AIMMO | Indicator: real estate | char | 1 | 0 | NUMC | (N'0') | Yes | | AIMMO | Allow NULL? |
| 121 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | J_OBJNR | Allow NULL? |
| 122 | LEART | Leasing type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T083L | LEART | Allow NULL? |
| 123 | LVORS | Advance payments | char | 1 | 0 | CHAR | (N' ') | Yes | | LVORS | Allow NULL? |
| 124 | GDLGRP | Evaluation group 5 | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T087G | GDLGRP | Allow NULL? |
| 125 | POSNR | WBS element investment project | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PRPS | AM_POSNR | Allow NULL? |
| 126 | XERWRT | Indicator: Ignore memo value | char | 1 | 0 | CHAR | (N' ') | Yes | | XERWRT | Allow NULL? |
| 127 | XAFABCH | Asset acquired used | char | 1 | 0 | CHAR | (N' ') | Yes | | XAFABCH | Allow NULL? |
| 128 | XANLGR | Indicator: Asset is a group asset | char | 1 | 0 | CHAR | (N' ') | No | | XANLGR_1 | Allow NULL? |
| 129 | MCOA1 | Search term for matchcode search | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MCOA1 | Allow NULL? |
| 130 | XINVM | Asset under Construction for Investment Measures | char | 1 | 0 | CHAR | (N' ') | Yes | | IM_XINVM | Allow NULL? |
| 131 | SERNR | Serial number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | AM_SERNR | Allow NULL? |
| 132 | UMWKZ | Reason for environmental investment | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T087K | AM_UMWKZ | Allow NULL? |
| 133 | LRVDAT | Date of last revaluation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AM_LRVDAT | Allow NULL? |
| 134 | ACT_CHANGE_PM | Change Asset Master Record from Equipment Master | char | 1 | 0 | CHAR | (N' ') | Yes | | AAPM_ACT_CHANGE_PM | Allow NULL? |
| 135 | HAS_TDDP | Asset Has Time-Dependent Valuation Parameters in ANLBZA | char | 1 | 0 | CHAR | (N' ') | Yes | | HAS_TDDP | Allow NULL? |
| 136 | LAST_REORG_DATE | Date of Last Reorganization | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAA_LAST_REORG | Allow NULL? |
| 137 | INTERNAL_CODE | Internal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /ATL/INTERNAL_CODE | Allow NULL? |
| 138 | APPROVAL_NUMBER | Approval document number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | /ATL/APPROVAL_NUMBER | Allow NULL? |
| 139 | APPROVAL_VERSION | Approval version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /ATL/APPROVAL_VERSION | Allow NULL? |
| 140 | BOGUS_ANLN1 | bogus asset number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /ATL/BOGUS_ANLN1 | Allow NULL? |
| 141 | ASSET_VERSION | Asset version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /ATL/ASSET_VERSION | Allow NULL? |
