ESH_N_ASSET_NEW_MD

Anchor view -ASSET_NEW_MD | view: ESH_L_ASSETNEWMD | Extraction: Not supported | Component: Asset Accounting
Tables used: CSKT, FAAC_ACCTDET0_T, FAAC_ACLS0_T, FAAT_MD, FAAT_MD_ROOT, T001W, TGSBT, FAAT_MD_TDD, TKA02, T001, TKA02, T499S, USR21
Column Name Description
COMPANYCODE FK Company Code
FIXEDASSET Asset Subnumber
MASTERFIXEDASSET Main Asset Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ASSETACCOUNTDETERMINATIONDESC Name of Account Determination TEXT50
ASSETADDITIONALDESCRIPTION Additional Asset Description TEXT50
ASSETCLASSNAME Short Text for Asset Class Name TEXT20
ASSETLOCATIONNAME Location Name TEXT40
ASSETMANUFACTURERNAME Manufacturer of Asset TEXT30
ASSETSERIALNUMBER Serial number GERNR
ASSETTYPENAME Asset Type Name TYPBZ_ANLA
BUDGETPERIOD Budget Period FM_BUDGET_PERIOD
BUSINESSAREANAME Business area description TEXT30
COMPANYCODENAME Name of Company Code or Company TEXT25
COSTCENTER Cost Center KOSTL
COSTCENTERNAME General Name TEXT20
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
CREATEDBYUSERNAME User Description SUIDTECHDESC
FIXEDASSETDESCRIPTION Asset Description TEXT50
FUNCTIONALAREA Functional Area FKBER
FUND Fund BP_GEBER
GRANTID Grant GM_GRANT_NBR
INVENTORY Inventory Number INVNR_ANLA
INVENTORYNOTE Supplementary Inventory Specifications INVZU_ANLA
INVESTMENTORDER Investment Order AUFNR
LASTCHANGEDBYUSER Name of Person Who Changed Object USNAM
LASTCHANGEDBYUSERNAME User Description SUIDTECHDESC
PERSONNELNUMBER Personnel Number PERNR
PLANTNAME Name TEXT30
PROFITCENTER Profit Center PRCTR
RESPONSIBLECOSTCENTER Cost Center Responsible for Asset KOSTL
VEHICLELICENSEPLATENUMBER License Plate No. of Vehicle AM_KFZKZ
Master Data Relations Join Conditions
Asset location
  • Client
  • Asset location
  • Plant
  • ESH_N_ASSET_NEW_MD.MANDT == T499S.MANDT
  • ESH_N_ASSET_NEW_MD.ASSETLOCATION == T499S.STAND
  • ESH_N_ASSET_NEW_MD.PLANT == T499S.WERKS
Business Area
  • Business Area
  • Client
  • ESH_N_ASSET_NEW_MD.BUSINESSAREA == TGSB.GSBER
  • ESH_N_ASSET_NEW_MD.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • ESH_N_ASSET_NEW_MD.CONTROLLINGAREA == TKA01.KOKRS
  • ESH_N_ASSET_NEW_MD.MANDT == TKA01.MANDT
Internal Order
  • Internal Order
  • Client
  • ESH_N_ASSET_NEW_MD.INTERNALORDER == AUFK.AUFNR
  • ESH_N_ASSET_NEW_MD.MANDT == AUFK.MANDT
Plant
  • Client
  • Plant
  • ESH_N_ASSET_NEW_MD.MANDT == T001W.MANDT
  • ESH_N_ASSET_NEW_MD.PLANT == T001W.WERKS
Account number of vendor (other key word)
  • Account number of vendor (other key word)
  • Client
  • ESH_N_ASSET_NEW_MD.SUPPLIER == LFA1.LIFNR
  • ESH_N_ASSET_NEW_MD.MANDT == LFA1.MANDT