C_StRpFxdAstAcquisitionFormQry

Column Name Description
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
AcquisitionValueAmtInCCCrcy Asset Acquisition Value
Column Name Description
Column Name Description
PostingDate Posting Date
FormPrintDate Date printed on Fixed Asset Form
DocumentDate Journal Entry Date
AssetValueDate Asset Value Date
AssetCapitalizationDate Asset Capitalization Date
Column Name Description
PlannedUsefulLifeInPeriods Planned Useful Life in Periods Show values
Column Name Description Domain name
MasterFixedAsset Fixed Asset ANLN1
MasterFixedAssetDescription Asset Main Number Text TEXT50
FixedAsset Asset Subnumber ANLN2
FixedAssetDescription Asset Description TEXT50
FixedAssetFormNumber Fixed Asset Form Number NUMC10
AccountingDocument Journal Entry BELNR
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
AssetClassDescription Asset class description TEXT50
Inventory Inventory Number INVNR_ANLA
AssetAdditionalDescription Additional Asset Description TEXT50
NationalClassification National Classification Code GLO_NATL_CLFN_CODE
NationalClassificationDesc National Classification Code Description TEXT50
AssetSerialNumber Serial number GERNR
PersonnelNumber Personnel Number PERNR
DepreciationKeyName Depreciation Key Name TEXT50
PlannedUsefulLifeInYears Planned Useful Life in Years JARAF
SupplierName Name of Supplier TEXT80
AssetCostCenter Asset Cost Center KOSTL
AssetCostCenterName Cost Center Name TEXT20
CompanyCode Company Code BUKRS
CompanyCodeName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
AssetDepreciationArea Asset Depreciation Area (Real or Derived) AFABE
StatryRptgEntity Reporting Entity SRF_REPORTING_ENTITY
StatryRptCategory Report Category ID SRF_REP_CAT_ID
Master Data Relations Join Conditions
Asset location
  • Asset Plant
  • Client
  • Asset location
  • C_STRPFXDASTACQUISITIONFORMQRY.ASSETPLANT == T499S.WERKS
  • C_STRPFXDASTACQUISITIONFORMQRY.MANDT == T499S.MANDT
  • C_STRPFXDASTACQUISITIONFORMQRY.ASSETLOCATION == T499S.STAND
Asset Plant
  • Asset Plant
  • Client
  • C_STRPFXDASTACQUISITIONFORMQRY.ASSETPLANT == T001W.WERKS
  • C_STRPFXDASTACQUISITIONFORMQRY.MANDT == T001W.MANDT
Help for depreciation keys
  • ?
  • Depreciation key
  • Client
  • C_STRPFXDASTACQUISITIONFORMQRY.[column in domain "AFAPL"] == T090NA.AFAPL
  • C_STRPFXDASTACQUISITIONFORMQRY.DEPRECIATIONKEY == T090NA.AFASL
  • C_STRPFXDASTACQUISITIONFORMQRY.MANDT == T090NA.MANDT
Account number of vendor (other key word)
  • Client
  • Account number of vendor (other key word)
  • C_STRPFXDASTACQUISITIONFORMQRY.MANDT == LFA1.MANDT
  • C_STRPFXDASTACQUISITIONFORMQRY.SUPPLIER == LFA1.LIFNR