FAA_ES_ASSET_MD_TDD

FAA_ES_ASSET_MD_TDD | view: FAAESMDTDD | Extraction: Not supported | Component: Master Data
Tables used: FAAT_MD_TDDTKA02
Column Name Description
CompanyCode FK Company Code
MasterFixedAsset Main Asset Number
FixedAsset Asset Subnumber
ValidityEndDate Date Validity Ends
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Date Validity Ends
ValidityStartDate Date for Beginning of Validity
Column Name Description
Column Name Description Domain name
CostCenter Cost Center KOSTL
PersonnelNumber Personnel Number PERNR
vehiclelicenseplatenumber License Plate No. of Vehicle AM_KFZKZ
budgetperiod Budget Period FM_BUDGET_PERIOD
Fund Fund BP_GEBER
functionalarea Functional Area FKBER
grantid Grant GM_GRANT_NBR
ProfitCenter Profit Center PRCTR
responsiblecostcenter Cost Center Responsible for Asset KOSTL
Master Data Relations Join Conditions
Asset location
  • Client
  • Asset location
  • Plant
  • FAA_ES_ASSET_MD_TDD.MANDT == T499S.MANDT
  • FAA_ES_ASSET_MD_TDD.ASSETLOCATION == T499S.STAND
  • FAA_ES_ASSET_MD_TDD.PLANT == T499S.WERKS
Business Area
  • Client
  • Business Area
  • FAA_ES_ASSET_MD_TDD.MANDT == TGSB.MANDT
  • FAA_ES_ASSET_MD_TDD.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Controlling Area
  • Client
  • FAA_ES_ASSET_MD_TDD.CONTROLLINGAREA == TKA01.KOKRS
  • FAA_ES_ASSET_MD_TDD.MANDT == TKA01.MANDT
Internal Order
  • Client
  • Internal Order
  • FAA_ES_ASSET_MD_TDD.MANDT == AUFK.MANDT
  • FAA_ES_ASSET_MD_TDD.INTERNALORDER == AUFK.AUFNR
Plant
  • Client
  • Plant
  • FAA_ES_ASSET_MD_TDD.MANDT == T001W.MANDT
  • FAA_ES_ASSET_MD_TDD.PLANT == T001W.WERKS