C_AssetTP

Asset | view: CASSETTP | Extraction: Not supported | Component: Master Data
Tables used: T001, TKA02, PRPS, ANKA, FAAC_ACLS0, ANKT, FAAC_ACLS0_T, ANLA, FAAT_MD, FAAT_MD_ROOT, GLOFAAASSETDATA, GLO_FAAT_MD
Column Name Description
CompanyCode FK Company Code
MasterFixedAsset FK Main Asset Number
FixedAsset Asset Subnumber
Column Name Description
💲 Original Acquisition Value Currency (OriginalAcquisitionCurrency):
OriginalAcquisitionAmount Original Acquisition Value
Column Name Description
📏 Area Unit (AreaSizeUnit):
AreaSize Surface Area
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Changed On
AssetCreationValidityDate Validity Date from Asset Class
FixedAssetOrderDate Asset Purchase Order Date
OriginalFixedAssetValueDate Original Acquisition Date of AuC/ Transferred Asset
LastInventoryDate Last Inventory Date
LastAssessmentNoticeDate Date of last notice of assessment
LandRegisterDate Land Register of
LandRegisterEntryDate Land Register Entry on
ConveyanceDate Date of conveyance
LeaseAgreementDate Leasing agreement date
LeaseTermEndDate Leasing agreement notice date
LeaseTermStartDate Lease start date
LastReorganizationDate Date of Last Reorganization
LegacyDataTransferDate Legacy Data Transfer Date
RU_ManufacturingDate Manufacturing Date
JP_Annex16LeasingAgrmtDate Japan: Leasing Agreement Date of Annex16-4 Report
IN_AssetPutToUseDate India: Put to use date
Column Name Description
AssetCompletenessStatus Completeness Status Show values
AssetLifecycleStatus Lifecycle Status Show values
AssetUnderConstructionStatus Asset Under Construction Status Show values
IsMainAsset Indicator for Main Asset Show values
HasHistory Indicator: Historical management Show values
AccountIsBlockedForPosting Indicator: Asset Locked to Acquisition Postings Show values
IsLegacyAsset Indicator for Legacy Asset Show values
AssetIsForPostCapitalization Indicator for Asset for Post-Cap. Show values
InventoryIsCounted Inventory Indicator Show values
LeaseDurationInFiscalPeriods Length of lease in periods Show values
AssetIsRealEstate Indicator: Real Estate Show values
AssetIsAcquiredUsed Asset acquired used Show values
AssetAuthorizationContext Asset Authorization Context Show values
RU_VehicleEcologicalClass Ecological Class Show values
IN_AssetIsResearchAndDev India: R & D Asset Show values
PT_VehicleTypeByEnergy Portugal: Vehicle Type Show values
PT_AssetReportFormCategory Portugal: Asset Report Form Category Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
FixedAssetForEdit Asset Subnumber ANLN2
FixedAssetFrmLegacySyst Asset Subnumber ANLN2
FixedAssetExternalID Asset Number CHAR17
ChangeDocumentUUID null
AssetCompletenessStatusName Completeness Status Text DDTEXT
AssetLifecycleStatusName Lifecycle Status Text DDTEXT
AssetUndrConstructionStsName AuC Status Text DDTEXT
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LastChangedByUser Name of Person Who Changed Object USNAM
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
AssetClassName Short Text for Asset Class Name TEXT20
AssetScreenLayout Layout for Asset Master Data
AssetAccountDeterminationDesc Name of Account Determination TEXT50
FixedAssetDescription Asset Description TEXT50
AssetAdditionalDescription Additional Asset Description TEXT50
AssetSerialNumber Serial number GERNR
Inventory Inventory Number INVNR_ANLA
SupplierName Name of Supplier TEXT80
AssetManufacturerName Manufacturer of Asset TEXT30
OriginalMasterFixedAsset Original Asset That Was Transferred ANLN1
OriginalFixedAsset Original Asset That Was Transferred ANLN2
OriginalAcquisitionFiscalYear Fiscal Year of Original Acquisition GJAHR
InHouseProdnPercent In-house production percentage PRZ32
AssetTypeName Asset Type Name TYPBZ_ANLA
PartnerCompanyName Company name TEXT30
InvestmentOrder Investment Order AUFNR
InvmtProjWBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSDescription WBS Element Name TEXT40
ProjectSummaryTaskUUIDString null
InventoryNote Supplementary Inventory Specifications INVZU_ANLA
LocalTaxOffice Local Tax Office TEXT25
NoticeOfAssessmentTaxID Tax Number of the Notice of Assessment EHWNR_ANLA
Municipality Municipality TEXT25
LandRegisterEntrySequence Land Register Entry: Sequence Number GRLFD_ANLA
LandRegisterVolume Land Register Volume GRBND_ANLA
LandRegisterPage Land Register Page GRBLT_ANLA
LandRegisterMap Land Register Map Number CHAR4
LandPlot Plot Number CHAR10
LeaseAgreement Leasing agreement number CHAR15
LeaseDurationInFiscalYears Length of Lease in Years JARAF
LeasedAssetNote Leasing data text TEXT50
LegacyMasterFixedAsset Legacy Main Asset Number FAA_MD_LDT_ASSET_NO
LegacyFixedAsset Legacy Asset Subnumber FAA_MD_LDT_ASSET_SUBNO
LegacyFixedAssetCompanyCode Legacy Fixed Asset Company Code FAA_MD_LDT_COMP_CODE
LegacyDataTransferSequence Legacy Data Transfer - sequence number NUMC5
BaseUnitName Unit of Measurement Text (Maximum 10 Characters) TEXT10
NationalClassification National Classification Code GLO_NATL_CLFN_CODE
NationalClassificationDesc National Classification Code Description TEXT50
TaxDepreciationGroup Tax Depreciation Group GLO_TAX_DEPR_GRP
TaxDepreciationGroupDesc Tax Depreciation Group Description TEXT30
RU_LongSerialNumber Russia: Serial Number CHAR32
RU_WorkwearMaterial Material Number MATNR
RU_RetiredMasterFixedAsset Number of Retired Asset ANLN1
RU_RetiredFixedAsset Subnumber of Retired Asset ANLN2
RU_VehicleIdNumber Manufacturer Vehicle Identification Number for Fleet Object FLEET_VIN
RU_PropertyAddress Russia: Property Address AD_ADDRNUM
ChartOfAccounts Chart of Accounts KTOPL
ChartOfAccountsText Chart of Accounts Description TEXT50
GLAccount G/L Account Number SAKNR
GLAccountText G/L Account Long Text TEXT50
JP_Annex16AssetStructureDesc Asset Structure Text TEXT50
JP_Annex16AssetItemDesc Asset Item Text TEXT50
JP_PrptyTxRptAddlDepr Additional Depreciation Code
IN_AssetBlock India: Block Key GLO_IN_BLK_KEY
IN_AdditionalAssetBlock India: Additional Depreciation Block Key GLO_IN_ADNL_BLK_KEY
IN_AssetIsPriorYear India: Prior Year Transaction GLO_IN_PRIOR_YR
PT_VehicleIsWithoutLimit Portugal: Is Vehicle Without Limit ABAP_BOOL
PT_BigRepairAssetLink Portugal: Repair Asset Link CHAR8
PT_LandAssetLink Portugal: Land Asset Link CHAR8
PT_AmortizedAssetIsReevaluated Portugal: Is Amortized Asset Revaluated ABAP_BOOL
Master Data Relations Join Conditions
Area Unit
  • Client
  • Area Unit
  • C_ASSETTP.MANDT == T006.MANDT
  • C_ASSETTP.AREASIZEUNIT == T006.MSEHI
Asset's Country/Region of Origin
  • Client
  • Country/Region Key
  • Asset's Country/Region of Origin
  • C_ASSETTP.MANDT == T005.MANDT
  • C_ASSETTP.COUNTRY == T005.LAND1
  • C_ASSETTP.ASSETCOUNTRYOFORIGIN == T005.LAND1
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_ASSETTP.MANDT == T006.MANDT
  • C_ASSETTP.BASEUNIT == T006.MSEHI
Country/Region Key
  • Client
  • Country/Region Key
  • Asset's Country/Region of Origin
  • C_ASSETTP.MANDT == T005.MANDT
  • C_ASSETTP.COUNTRY == T005.LAND1
  • C_ASSETTP.ASSETCOUNTRYOFORIGIN == T005.LAND1
Reason for Environmental Investment
  • Client
  • Reason for Environmental Investment
  • C_ASSETTP.MANDT == T087K.MANDT
  • C_ASSETTP.ENVRNMTLINVESTMENTREASON == T087K.UMWKZ
Asset Super Number
  • Asset Super Number
  • Client
  • C_ASSETTP.FIXEDASSETGROUP == T087U.ANLUE
  • C_ASSETTP.MANDT == T087U.MANDT
Property Indicator
  • Client
  • Property Indicator
  • C_ASSETTP.MANDT == T097.MANDT
  • C_ASSETTP.FIXEDASSETPROPERTYTYPE == T097.EIGKZ
Reason for Investment
  • Client
  • Reason for Investment
  • C_ASSETTP.MANDT == T087I.MANDT
  • C_ASSETTP.INVESTMENTREASON == T087I.IZWEK
Japan: Asset Item of Annex16
  • Japan: Asset Item of Annex16
  • Client
Japan: Asset Structure of Annex16
  • Client
  • Japan: Asset Structure of Annex16
Guideline group
  • Client
  • Japan: City Code of Property Tax Report
  • C_ASSETTP.MANDT == T087G.MANDT
  • C_ASSETTP.JP_PRPTYTXRPTCITY == T087G.GDLGRP
Property classification
  • Client
  • Japan: Classification Key of Property Tax Report
  • Property classification key
  • C_ASSETTP.MANDT == T092.MANDT
  • C_ASSETTP.JP_PRPTYTXRPTCLASSFCTNKEY == T092.VMGLI
  • C_ASSETTP.PROPERTYCLASS == T092.VMGLI
Japan: Special Depreciation Code of Property Tax Report
  • Client
  • Japan: Special Depreciation Code of Property Tax Report
  • C_ASSETTP.MANDT == T098.MANDT
  • C_ASSETTP.JP_PRPTYTXRPTSPCLDEPR == T098.GRUND
Leasing company
  • Leasing company
  • Client
  • C_ASSETTP.LEASESUPPLIER == LFA1.LIFNR
  • C_ASSETTP.MANDT == LFA1.MANDT
Leasing type
  • Leasing type
  • Client
  • C_ASSETTP.LEASETYPE == T083L.LEART
  • C_ASSETTP.MANDT == T083L.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_ASSETTP.MANDT == T880.MANDT
  • C_ASSETTP.PARTNERCOMPANY == T880.RCOMP
Property classification
  • Client
  • Japan: Classification Key of Property Tax Report
  • Property classification key
  • C_ASSETTP.MANDT == T092.MANDT
  • C_ASSETTP.JP_PRPTYTXRPTCLASSFCTNKEY == T092.VMGLI
  • C_ASSETTP.PROPERTYCLASS == T092.VMGLI
Transport Type
  • Transport Type
  • Client
Account number of vendor (other key word)
  • Client
  • Account number of vendor (other key word)
  • C_ASSETTP.MANDT == LFA1.MANDT
  • C_ASSETTP.SUPPLIER == LFA1.LIFNR