I_AssetAssignmentTP

Asset Assignment | view: IASSETASSGMTTP | TRAN | Extraction: Not supported | Component: Master Data
Tables used: T001TKA02ANLZFAAT_MD_TDDTKA02
Column Name Description
CompanyCode FK Company Code
MasterFixedAsset FK Main Asset Number
FixedAsset FK 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
ValidityEndDateForEdit Date Validity Ends
Column Name Description
AssetAuthorizationContext Asset Authorization Context Show values
Column Name Description Domain name
CostCenter Cost Center KOSTL
CostCenterName Cost Center Name TEXT20
CostCtrActivityType Activity Type LSTAR
CostCtrActivityTypeName General Name TEXT20
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
FundsCenter Funds Center FISTL
FundsCenterName Funds Center Name TEXT20
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSElementDescription WBS Element Name TEXT40
RealEstateObject Internal Key for Real Estate Object IMKEY
ProfitCenter Profit Center PRCTR
ProfitCenterName Description of Profit Center TEXT20
BudgetPeriod Budget Period FM_BUDGET_PERIOD
ResponsibleCostCenter Cost Center Responsible for Asset KOSTL
ResponsibleCostCenterName Cost Center Name TEXT20
Room Room CHAR8
VehicleLicensePlateNumber License Plate No. of Vehicle AM_KFZKZ
PersonnelNumber Personnel Number PERNR
BusinessPlace Business Place J_1BBRANCH
LongText null
ReferenceDocumentType Reference procedure AWTYP
LogicalSystem Logical system of source document LOGSYS
ReferenceDocumentContext Reference Organizational Units AWORG
ReferenceDocument Reference document number AWREF
Master Data Relations Join Conditions
Asset location
  • Client
  • Asset location
  • Plant
  • I_ASSETASSIGNMENTTP.MANDT == T499S.MANDT
  • I_ASSETASSIGNMENTTP.ASSETLOCATION == T499S.STAND
  • I_ASSETASSIGNMENTTP.PLANT == T499S.WERKS
Business Area
  • Client
  • Business Area
  • I_ASSETASSIGNMENTTP.MANDT == TGSB.MANDT
  • I_ASSETASSIGNMENTTP.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Controlling Area
  • Client
  • I_ASSETASSIGNMENTTP.CONTROLLINGAREA == TKA01.KOKRS
  • I_ASSETASSIGNMENTTP.MANDT == TKA01.MANDT
Financial Management Area
  • Client
  • Financial Management Area
  • I_ASSETASSIGNMENTTP.MANDT == FM01.MANDT
  • I_ASSETASSIGNMENTTP.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Asset Subnumber
  • Asset Subnumber
  • Main Asset Number
  • Client
  • Company Code
  • I_ASSETASSIGNMENTTP.FIXEDASSET == ANLA.ANLN2
  • I_ASSETASSIGNMENTTP.MASTERFIXEDASSET == ANLA.ANLN1
  • I_ASSETASSIGNMENTTP.MANDT == ANLA.MANDT
  • I_ASSETASSIGNMENTTP.COMPANYCODE == ANLA.BUKRS
Internal Order
  • Internal Order
  • Client
  • I_ASSETASSIGNMENTTP.INTERNALORDER == AUFK.AUFNR
  • I_ASSETASSIGNMENTTP.MANDT == AUFK.MANDT
Plant
  • Client
  • Plant
  • I_ASSETASSIGNMENTTP.MANDT == T001W.MANDT
  • I_ASSETASSIGNMENTTP.PLANT == T001W.WERKS
Segment
  • Segment for Segmental Reporting
  • Client
  • I_ASSETASSIGNMENTTP.SEGMENT == FAGL_SEGM.SEGMENT
  • I_ASSETASSIGNMENTTP.MANDT == FAGL_SEGM.MANDT
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • I_ASSETASSIGNMENTTP.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_ASSETASSIGNMENTTP.MANDT == TTXJ.MANDT
  • I_ASSETASSIGNMENTTP.TAXJURISDICTION == TTXJ.TXJCD