SAP Table MPO_AC_LIST

Interface for Asset Cockpit

MPO_AC_LIST (Interface for Asset Cockpit) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MPO_AC_LIST to other SAP tables.

MPO_AC_LIST table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
TXT50 Asset description TXA50_ANLT CHAR 50 0
TXA50 Additional asset description TXA50_MORE CHAR 50 0
ANLKL Asset Class ANLKL CHAR 8 0
TXK20 Short Text for Asset Class Name TXT20_ANKT CHAR 20 0
MENGE Quantity AM_MENGE QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
TYPBZ Manufacturer model number TYPBZ CHAR 20 0
INKEN Inventory indicator INKEN CHAR 1 0
X Yes
NULL No
IVDAT Last inventory date IVDAT_ANLA DATS 8 0
INVZU Supplementary inventory specifications INVZU_ANLA CHAR 15 0
INVNR Inventory number INVNR_ANLA CHAR 25 0
ZUJHR Fiscal year in which first acquisition was posted DZUJAHR NUMC 4 0
ZUPER Period in which first acquisition was posted DZUPER NUMC 3 0
ZUGDT Asset value date of the first posting DZUGDAT DATS 8 0
AKTIV Asset capitalization date AKTIVD DATS 8 0
DEAKT Deactivation date DEAKT DATS 8 0
GPLAB Planned retirement date GPLAB DATS 8 0
BSTDT Asset purchase order date BSTDT DATS 8 0
BDATU Date validity ends BDATU DATS 8 0
ADATU Date for beginning of validity ADATU DATS 8 0
KOSTL Cost Center KOSTL CHAR 10 0
WERKS Plant WERKS_D CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
LSTAR Activity Type LSTAR CHAR 6 0
MSFAK Multiple-shift factor for multiple shift operation MSFAK DEC 3 2
XSTIL Asset shutdown XSTIL CHAR 1 0
X Yes
NULL No
STORT Asset location STORT CHAR 10 0
CAUFN Internal order CAUFN CHAR 12 0
RAUMN Room RAUMNR CHAR 8 0
IAUFN Maintenance order IAUFN CHAR 12 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
KFZKZ License plate no. of vehichle AM_KFZKZ CHAR 15 0
PERNR Personnel Number PERNR_D NUMC 8 0
KOSTLV Cost center responsible for asset KOSTLV CHAR 10 0
ANLUE Asset super number ANLUE CHAR 12 0
ORD41 Evaluation group 1 ORD41 CHAR 4 0
ORD42 Evaluation group 2 ORD42 CHAR 4 0
ORD43 Evaluation group 3 ORD43 CHAR 4 0
ORD44 Evaluation group 4 ORD44 CHAR 4 0
GDLGRP Evaluation group 5 GDLGRP CHAR 8 0
IZWEK Reason for investment IZWEK CHAR 2 0
UMWKZ Reason for environmental investment AM_UMWKZ CHAR 5 0
LIFNR Account number of vendor (other key word) AM_LIFNR CHAR 10 0
LAND1 Asset's country of origin AM_LAND1 CHAR 3 0
LIEFE Name of asset supplier LIEFE CHAR 30 0
HERST Manufacturer of asset HERST CHAR 30 0
AIBN1 Original asset that was transferred AIBN1 CHAR 12 0
AIBN2 Original asset that was transferred AIBN2 CHAR 4 0
AIBDT Original acquisition date of AuC/ transferred asset AIBDT DATS 8 0
URJHR Fiscal year of original acquisition URJHR NUMC 4 0
URWRT Original acquisition value URWRT CURR 13 2
ANTEI In-house production percentage ANTEI DEC 5 2
EAUFN Investment Order AM_AUFNR CHAR 12 0
POSNR WBS element investment project AM_POSNR NUMC 8 0
XAFABCH Asset acquired used XAFABCH CHAR 1 0
X Yes
NULL No
VMGLI Property classification key VMGLI CHAR 4 0
EIGKZ Property indicator EIGKZ CHAR 1 0
GRUND Reason for manual valuation of net assets GRUND CHAR 3 0
WRTMA Manual net worth tax value WRTMA CURR 13 2
XVRMW Manual net worth tax value XVRMW CHAR 1 0
X Yes
NULL No
GRUVO Land Register of GRUVO_ANLA DATS 8 0
GREIN Land register entry on GREIN_ANLA DATS 8 0
GRBND Land register volume GRBND_ANLA CHAR 5 0
GRBLT Land register page GRBLT_ANLA CHAR 5 0
GRLFD Land register entry: Sequence number GRLFD_ANLA CHAR 4 0
AUFLA Date of conveyance AUFLA_ANLA DATS 8 0
FLURK Land register map number FLURK_ANLA CHAR 4 0
FLURN Plot number FLURN_ANLA CHAR 10 0
EHWZU Date of last notice of assessment EHWZU_ANLA DATS 8 0
EHWNR Tax number of the notice of assessment EHWNR_ANLA CHAR 16 0
FIAMT Local tax office FIAMT CHAR 25 0
STADT Municipality ORT01_ANLA CHAR 25 0
GRUFL Surface area GRUFL QUAN 13 3
FEINS Area unit FEINS UNIT 3 0
LEAFI Leasing company LEAFI CHAR 10 0
LVDAT Leasing agreement date LVDAT DATS 8 0
LKDAT Leasing agreement notice date LKDAT DATS 8 0
LEABG Lease start date LEABG DATS 8 0
LEJAR Length of lease in years LEJAR NUMC 3 0
LEPER Length of lease in periods LEPER NUMC 3 0
0
LRYTH Lease payment cycle LRYTH NUMC 3 0
0
LEGEB Periodic lease payment paid to leasing company/lessor LEGEB CURR 13 2
LBASW Leasing base value as new LBASW CURR 13 2
LKAUF Leased asset purchase price LKAUF CURR 13 2
LZINS Leasing interest rate (capital lease) LZINS DEC 7 4
LEANZ Number of lease payments LEANZ DEC 5 0
LVTNR Leasing agreement number LVTNR CHAR 15 0
LETXT Leasing data text LETXT CHAR 50 0
LEART Leasing type LEART CHAR 2 0
LVORS Advance payments LVORS CHAR 1 0
X Yes
NULL No
AFABE Real depreciation area AFABE_D NUMC 2 0
XNEGA Indicator: Negative values allowed XNEGA CHAR 1 0
X Yes
NULL No
AFABG Depreciation calculation start date AFABG DATS 8 0
ZINBG Start date for interest calculation DZINBG DATS 8 0
SAFBG Start date for special depreciation SAFBG DATS 8 0
INVSL Investment support key INVSL CHAR 2 0
AFASL Depreciation key AFASL CHAR 4 0
NDJAR Planned useful life in years NDJAR NUMC 3 0
NDPER Planned useful life in periods NDPER NUMC 3 0
0
WBIND Index series for replacement values WBIND CHAR 5 0
ALIND Index series for replacement values by age ALIND CHAR 5 0
APROP Variable depreciation portion APROP DEC 7 4
UMJAR Depreciation key for the changeover year UMJAR NUMC 4 0
NDURJ Original useful life in years NDURJ NUMC 3 0
NDURP Original useful life in periods NDURP NUMC 3 0
0
SCHRW Asset scrap value SCHRW CURR 13 2
XAFBE Indicator: Depreciation area is deactivated XAFBE CHAR 1 0
X Yes
NULL No
ANLGR Group asset ANLGR CHAR 12 0
ANLGR2 Subnumber of group asset ANLGR2 CHAR 4 0
VYEAR Acquisition year of the asset (manually changeable) VYEAR NUMC 4 0
VMNTH Asset Accounting: Acquis. month (in depreciation area) VMNTH NUMC 3 0
INBDA Asset Accounting: Date of operating readiness INBDA DATS 8 0
GJAHR Fiscal Year GJAHR NUMC 4 0
WAERS Currency Key WAERS CUKY 5 0
ANSW_GJA Cumulative acquisition value at fiscal year start ANSW_GJA CURR 13 2
ANSW_LFD Current acquisition value ANSW_LFD CURR 13 2
ANSW_GJE Acquisition value at fiscal year end ANSW_GJE CURR 13 2
INV_GJA Cumulative investment support at fiscal year start INV_GJA CURR 13 2
INV_LFD Current investment support INV_LFD CURR 13 2
INV_GJE Investment support at fiscal year end INV_GJE CURR 13 2
AUFW_GJA Cumulative revaluation at fiscal year start AUFW_GJA CURR 13 2
AUFW_LFD Current revaluation AUFW_LFD CURR 13 2
AUFW_GJE Revaluation at fiscal year end AUFW_GJE CURR 13 2
AFA_GJA Accumulated depreciation at fiscal year start AFA_GJA CURR 13 2
AFA_LFD Current depreciation AFA_LFD CURR 13 2
AFA_GJE Depreciation at fiscal year end AFA_GJE CURR 13 2
SZINS_GJA Cumulative interest at fiscal year start SZINS_GJA CURR 13 2
SZINS_LFD Current interest SZINS_LFD CURR 13 2
SZINS_GJE Interest at fiscal year end SZINS_GJE CURR 13 2
BCHWRT_GJA Book value at fiscal year start BCHWRT_GJA CURR 13 2
BCHWRT_LFD Current book value BCHWRT_LFD CURR 13 2
BCHWRT_GJE Book value at fiscal year end BCHWRT_GJE CURR 13 2