R_FixedAssetValuationTP

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Fixed Asset Valuation'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  semanticKey: ['CompanyCode','MasterFixedAsset','FixedAsset','Ledger','AssetDepreciationArea'],
  usageType: {
        serviceQuality: #B,
        sizeCategory: #XXL,
        dataClass: #MASTER
    }
 }
@AbapCatalog.extensibility: {
  extensible: true,
  allowNewCompositions: true
}

@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]

define view entity R_FixedAssetValuationTP as 
  
  // CE2602 - performance improvement

  select from I_AssetValuation
   association to parent R_FixedAssetTP as _FixedAsset on $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                      and  $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                       and $projection.FixedAsset       = _FixedAsset.FixedAsset
                                                       
    composition [1..*] of R_FixedAssetTimeBasedValnTP    as _FixedAssetTimeBasedValn  
   
    composition [1..*] of R_FixedAssetYrOpngValnAttribTP as _FixedAssetYrOpngValnAttrib 
  
{
           
  key      CompanyCode,
           
  key      MasterFixedAsset,
           
  key      FixedAsset,
           
  key      Ledger,
           
  key      AssetDepreciationArea,
           
           DepreciationKey,
           
           PlannedUsefulLifeInYears,

           PlannedUsefulLifeInPeriods,

           NegativeAmountIsAllowed,

           DepreciationStartDate,

           SpecialDeprStartDate,

           InterestCalcStartDate,

           AssetOpgReadinessDate,

           DeprKeyChangeoverYear,

           DeprKeyChangeoverPeriod,

           LowValueAssetAmountCheckType,

           LastRetirementValueDate,

           AssetCurrentFiscalYear,

           AssetNumberOfPeriods,

           DepreciationAreaType,

           ExpiredUsefulLifeInYrs,

           ExpiredUsefulLifeInPerds,

           SpclExpiredUsefulLifeInYrs,

           SpclExpiredUsefulLifeInPerds,
           
//           @Consumption.hidden: true

           cast( '' as abap_boolean preserving type )                              as IsChanged,
           
           _FixedAsset,
           
           _FixedAssetTimeBasedValn,
           
           _FixedAssetYrOpngValnAttrib,
           
           _CompanyCode,
           _MasterFixedAsset,
           _Ledger,
           _DepreciationArea
//           _AssetValuationForLedger

}