ESH_S_ASSET

Search view for search model ASSET_H | view: ESH_U_ASSET | Extraction: Not supported | Component: Asset Accounting
Tables used: ANLHANKAANLAANLZT001CSKSUSR21ADRPANKTANLTCSKTT095TT499STGSBTTKA02
Column Name Description
Column Name Description
Column Name Description
Column Name Description
erdat Date on which the record was created
aedat Changed On
aktiv Asset Capitalization Date
Column Name Description
Column Name Description Domain name
anln2 Asset Subnumber
anlar Asset types
ernam Name of Person Responsible for Creating the Object
aenam Name of Person Who Changed Object
liefe Name of asset supplier TEXT30
herst Manufacturer of Asset
eaufn Investment Order AUFNR
typbz Asset Type Name TYPBZ_ANLA
invzu Supplementary Inventory Specifications INVZU_ANLA
invnr Inventory Number INVNR_ANLA
txt50 Asset Description
sernr Serial number GERNR
anlhtxt Asset Main Number Text
txk20 Short Text for Asset Class Name
butxt Name of Company Code or Company
kostl Cost Center KOSTL
ktext General Name
ktgrtx Name of Account Determination
KTEXT2 Text, 40 Characters Long
gtext Business area description
pernr Personnel Number PERNR
kfzkz License Plate No. of Vehicle
budget_pd Budget Period FM_BUDGET_PERIOD
geber Fund BP_GEBER
fkber Functional Area FKBER
grant_nbr Grant GM_GRANT_NBR
txa50 Asset Description
prctr Profit Center PRCTR
NAME_TEXT1 Full Name of Person
name_text Full Name of Person
kostlv Cost Center Responsible for Asset KOSTL
Master Data Relations Join Conditions
Internal Order
  • Internal Order
  • Client
  • ESH_S_ASSET.CAUFN == AUFK.AUFNR
  • ESH_S_ASSET.MANDT == AUFK.MANDT
Business Area
  • Business Area
  • Client
  • ESH_S_ASSET.GSBER == TGSB.GSBER
  • ESH_S_ASSET.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • ESH_S_ASSET.KOKRS == TKA01.KOKRS
  • ESH_S_ASSET.MANDT == TKA01.MANDT
Account number of vendor (other key word)
  • Account number of vendor (other key word)
  • Client
  • ESH_S_ASSET.LIFNR == LFA1.LIFNR
  • ESH_S_ASSET.MANDT == LFA1.MANDT
Asset location
  • Plant
  • Client
  • Asset location
  • ESH_S_ASSET.WERKS == T499S.WERKS
  • ESH_S_ASSET.MANDT == T499S.MANDT
  • ESH_S_ASSET.STORT == T499S.STAND
Plant
  • Plant
  • Client
  • ESH_S_ASSET.WERKS == T001W.WERKS
  • ESH_S_ASSET.MANDT == T001W.MANDT