I_ASSETVALUATIONFORLEDGER

CDS View

Fixed Asset Valuation for Ledger

I_ASSETVALUATIONFORLEDGER is a CDS View in S/4HANA. Fixed Asset Valuation for Ledger. It contains 18 fields. 12 CDS views read from this table.

Used by 12 CDS view(s) 18 fields

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_RO_StRpFxdAstChartValueCube view inner CONSUMPTION RO Asset Chart Values and Trans - Cube
I_CN_CADEFixedAssetValueCube view left_outer COMPOSITE Fixed Asset Balance Cube for CADE
I_FxdAstDeprAreaByFsclPerdEnd view from COMPOSITE Depreciation Area valid at fiscal period end date
P_AUDIT_AT_AssetHistorySheet view left_outer COMPOSITE Austrian Audit Asset History Sheet
P_AUDIT_AT_AssetTransaction view left_outer COMPOSITE Austrian Audit Asset Transaction
P_DepreciationEndDate view from COMPOSITE Depreciation End Date
P_IT_StRpFxdAstRegDeprArea view from CONSUMPTION IT FxdAst Reg. - Depr.area at FY per.end
P_PH_Excd1PMTaxItem view left_outer COMPOSITE Asset Tax Item Exceeding 1PM for PH VAT
P_PL_SAFTMainAreasFields10 view_entity from CONSUMPTION PL SAFT Fixed Asset Area Level 10
P_RO_SAFTFixedAsset view_entity inner COMPOSITE RO SAFT Fixed Asset Master Data
P_RS_TaxDeprBookAreaFields view from COMPOSITE RS Tax depr. - Book area fields
P_RS_TaxDeprTaxAreaFields view from COMPOSITE RS Tax depr. - Tax area fields

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AssetRealDepreciationArea AssetDepreciationArea,AssetRealDepreciationArea 2
KEY CompanyCode CompanyCode 5
KEY FixedAsset FixedAsset 4
KEY Ledger Ledger 2
KEY MasterFixedAsset MasterFixedAsset 4
_CompanyCode _CompanyCode 1
_FixedAsset _FixedAsset 1
_Ledger _Ledger 1
_MasterFixedAsset _MasterFixedAsset 1
AssetOpgReadinessDate AssetOpgReadinessDate 1
DepreciationKey DepreciationKey 2
DepreciationStartDate DepreciationStartDate 1
DeprKeyChangeoverYear DeprKeyChangeoverYear 1
LastRetirementValueDate LastRetirementValueDate 1
PlannedUsefulLifeInPeriods BookPlannedUsefulLifeInPeriods,PlannedUsefulLifeInPeriods 3
PlannedUsefulLifeInYears BookPlannedUsefulLifeInYears,PlannedUsefulLifeInYears 3
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1 
@AbapCatalog: {sqlViewName: 'IFIASTVALFORLDGR', preserveKey: true, compiler.compareFilter: true}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Fixed Asset Valuation for Ledger'
@VDM.viewType: #COMPOSITE
@ObjectModel: { usageType.serviceQuality: #C,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MASTER,
                modelingPattern: #NONE,
                supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE]
              }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_AssetValuationForLedger
  as select from I_AssetTimeBasedValuation
    inner join   I_AssetValuation on  I_AssetValuation.CompanyCode           = I_AssetTimeBasedValuation.CompanyCode
                                  and I_AssetValuation.MasterFixedAsset      = I_AssetTimeBasedValuation.MasterFixedAsset
                                  and I_AssetValuation.FixedAsset            = I_AssetTimeBasedValuation.FixedAsset
                                  and I_AssetValuation.Ledger                = I_AssetTimeBasedValuation.Ledger
                                  and I_AssetValuation.AssetDepreciationArea = I_AssetTimeBasedValuation.AssetDepreciationArea

  association [1..1] to I_CompanyCode               as _CompanyCode               on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_MasterFixedAsset          as _MasterFixedAsset          on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                                  and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
  association [1..1] to I_FixedAsset                as _FixedAsset                on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                                                  and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                                                  and $projection.FixedAsset       = _FixedAsset.FixedAsset
  association [1..1] to I_Ledger                    as _Ledger                    on  $projection.Ledger = _Ledger.Ledger
  association [0..1] to I_DepreciationAreaForLedger as _DepreciationArea          on  $projection.CompanyCode               = _DepreciationArea.CompanyCode
                                                                                  and $projection.Ledger                    = _DepreciationArea.Ledger
                                                                                  and $projection.AssetRealDepreciationArea = _DepreciationArea.AssetDepreciationArea
  association [0..1] to I_ReplacementValueIndexSers as _ReplacementValueIndexSers on  $projection.ReplacementValueIndexSers = _ReplacementValueIndexSers.ReplacementValueIndexSers
  association [0..1] to I_Currency                  as _CompanyCodeCurrency       on  $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
  association [0..1] to I_FixedAssetUsageObject     as _FixedAssetUsageObject     on  $projection.CompanyCode           = _FixedAssetUsageObject.CompanyCode
                                                                                  and $projection.FixedAssetUsageObject = _FixedAssetUsageObject.FixedAssetUsageObject
  association [0..1] to I_AssetRevaluationIndex     as _AssetRevaluationIndex     on  $projection.AssetRevaluationIndex = _AssetRevaluationIndex.AssetRevaluationIndex
  association [1..1] to I_AssetValuationScrapAmount as _ScrapAmount               on  $projection.CompanyCode               = _ScrapAmount.CompanyCode
                                                                                  and $projection.MasterFixedAsset          = _ScrapAmount.MasterFixedAsset
                                                                                  and $projection.FixedAsset                = _ScrapAmount.FixedAsset
                                                                                  and $projection.Ledger                    = _ScrapAmount.Ledger
                                                                                  and $projection.AssetRealDepreciationArea = _ScrapAmount.AssetRealDepreciationArea
                                                                                  and $projection.ValidityEndDate           = _ScrapAmount.ValidityEndDate
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key I_AssetTimeBasedValuation.CompanyCode                                   as CompanyCode,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key I_AssetTimeBasedValuation.MasterFixedAsset                              as MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
  key I_AssetTimeBasedValuation.FixedAsset                                    as FixedAsset,
      @ObjectModel.foreignKey.association: '_Ledger'
  key I_AssetTimeBasedValuation.Ledger                                        as Ledger,
      @ObjectModel.foreignKey.association: '_DepreciationArea'
  key cast(I_AssetTimeBasedValuation.AssetDepreciationArea as afabe_d)        as AssetRealDepreciationArea,
  key I_AssetTimeBasedValuation.ValidityEndDate                               as ValidityEndDate,

      I_AssetTimeBasedValuation.ValidityStartDate                             as ValidityStartDate,
      I_AssetValuation.DepreciationStartDate                                  as DepreciationStartDate,
      I_AssetValuation.SpecialDeprStartDate                                   as SpecialDeprStartDate,
      cast(I_AssetValuation.DeprKeyChangeoverYear as fis_umjar)               as DeprKeyChangeoverYear,
      I_AssetValuation.DeprKeyChangeoverPeriod                                as DeprKeyChangeoverPeriod,
      I_AssetTimeBasedValuation.DepreciationKey                               as DepreciationKey,
      cast('' as faa_invsl)                                                   as InvestmentSupportMeasure, //Not supported with active BF

      cast(I_AssetTimeBasedValuation.PlannedUsefulLifeInPeriods as fis_ndper) as PlannedUsefulLifeInPeriods,
      cast(I_AssetTimeBasedValuation.PlannedUsefulLifeInYears as fis_ndjar)   as PlannedUsefulLifeInYears,
      cast('0000' as fis_vyear)                                               as VintageYear, //Not supported with active BF

      cast('000' as fis_vmnth)                                                as VintageMonth, //Not supported with active BF

      cast('000' as fis_ndurp)                                                as OriglAstUsefulLifeInPerds, //Not supported with active BF

      cast('000' as ndurj)                                                    as OriglAstUsefulLifeInYears, //Not supported with active BF

      @ObjectModel.foreignKey.association: '_ReplacementValueIndexSers'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'AssetRevaluationIndex'
      @VDM.lifecycle: {status: #DEPRECATED}
      @VDM.lifecycle.successor: 'AssetRevaluationIndex'
      I_AssetValuation.ReplacementValueIndexSers                              as ReplacementValueIndexSers,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'AssetRevaluationIndex'
      @VDM.lifecycle: {status: #DEPRECATED}
      @VDM.lifecycle.successor: 'AssetRevaluationIndex'
      cast(I_AssetValuation.RplcmtValueAgingIndexSers as fis_alind)           as RplcmtValueAgingIndexSers,
      I_AssetTimeBasedValuation.AcqnProdnCostScrapPercent                     as AcqnProdnCostScrapPercent,
      I_AssetTimeBasedValuation.VariableDeprPercent                           as VariableDeprPercent,
      I_AssetTimeBasedValuation.ShiftOperationFactor                          as ShiftOperationFactor,
      I_AssetTimeBasedValuation.IsShutDown                                    as IsShutDown,
      I_AssetTimeBasedValuation.DeprCalcBaseValuePercent                      as DeprCalcBaseValuePercent,
      I_AssetValuation.LastRetirementValueDate                                as LastRetirementValueDate,
      I_AssetValuation.DepreciationAreaType                                   as DepreciationAreaType,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      I_AssetTimeBasedValuation.ScrapAmountInCoCodeCrcy                       as ScrapAmountInCoCodeCrcy,
      @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
      @Semantics.currencyCode: true
      _CompanyCode.Currency                                                   as CompanyCodeCurrency,
      I_AssetValuation.AssetOpgReadinessDate                                  as AssetOpgReadinessDate,
      @ObjectModel.foreignKey.association: '_FixedAssetUsageObject'
      I_AssetTimeBasedValuation.FixedAssetUsageObject                         as FixedAssetUsageObject,
      @ObjectModel.foreignKey.association: '_AssetRevaluationIndex'
      I_AssetTimeBasedValuation.AssetRevaluationIndex                         as AssetRevaluationIndex,

      /* Associations */
      _CompanyCode,
      _MasterFixedAsset,
      _FixedAsset,
      _Ledger,
      _DepreciationArea,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_AssetRevaluationIndex'      
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_FixedAssetRevaluationIndex'
      _ReplacementValueIndexSers,
      _CompanyCodeCurrency,
      _FixedAssetUsageObject,
      _AssetRevaluationIndex,
      _ScrapAmount
}

Learn More