C_CN_CADEFixedAssetBalanceQry

Column Name Description
Column Name Description
💲 Display Currency (DisplayCurrency):
AcqnProdnAmtInDspCrcy Amount in Display Currency
RevaluationAmountInDspCrcy Amount in Display Currency
NetBookValueAmtInDspCrcy Debit Amount in Company Code Currency
PlannedScrapAmountInDspCrcy Starting Balance Amount In Company Code Currency
Column Name Description
Column Name Description
AssetCapitalizationDate Asset Capitalization Date
Column Name Description
Column Name Description Domain name
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
FiscalYear Fiscal Year GJAHR
FiscalPeriod null
FixedAssetExternalID Asset Number CHAR17
FixedAssetDescription Asset Description TEXT50
CumulativeDepreciationAmount null
OrdinaryDeprAmtInDspCrcy null
PostingFiscalPeriod Fiscal Period POPER
AssetClassName Short Text for Asset Class Name TEXT20
CurrencyShortName Short text TEXT15
Quantity New contents of changed field
Inventory Inventory Number INVNR_ANLA
AssetSerialNumber Inventory Number
PlannedUsefulLifeInPeriods null
ExpiredUsefulLifeInPerds null
CN_CADEFixedAssetUsage Evaluation group:Short description
AcqnProdnCostScrapPercent null
ChartOfDepreciation Chart of Depreciaton for Asset Valuation AFAPL
DepreciationPercentage null
AcqnProdnCostGLAccount null
OrdinaryDeprValAdjmtGLAccount null
RevalOrdnryDeprValAdjmtGLAcct null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_CN_CADEFIXEDASSETBALANCEQRY.MANDT == T006.MANDT
  • C_CN_CADEFIXEDASSETBALANCEQRY.BASEUNIT == T006.MSEHI
Help for depreciation keys
  • Depreciation key
  • Client
  • ?
  • C_CN_CADEFIXEDASSETBALANCEQRY.DEPRECIATIONKEY == T090NA.AFASL
  • C_CN_CADEFIXEDASSETBALANCEQRY.MANDT == T090NA.MANDT
  • C_CN_CADEFIXEDASSETBALANCEQRY.[column in domain "AFAPL"] == T090NA.AFAPL