I_ASSETTIMEBASEDVALUATION

CDS View

Time Based Valuation of Asset

I_ASSETTIMEBASEDVALUATION is a CDS View in S/4HANA. Time Based Valuation of Asset. It contains 27 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 27 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_ASSET_MASTER view left_outer Asset Master
I_AssetRevalIndexWhereUsed view_entity inner COMPOSITE Where used of Asset Revaluation Index
I_AssetTimeBasedValuationTP view from TRANSACTIONAL Time Based Valuation of Asset
I_AssetValuationForLedger view from COMPOSITE Fixed Asset Valuation for Ledger
I_FixedAssetUsageObjWhereUsd view inner COMPOSITE Where used of Fixed Asset Usage Object
P_AssetValuationForLedger view union_all COMPOSITE Asset Valuation For Ledger
P_AssetValuationScrapAmount view_entity from COMPOSITE Fixed Asset Valuation Scrap Values
P_BG_StRpTaxDeprShutdown view union_all CONSUMPTION Tax depr. plan - shutdowns
R_FixedAssetTimeBasedValnTP view_entity from TRANSACTIONAL Fixed Asset Time-based Valuation

Fields (27)

KeyField CDS FieldsUsed in Views
KEY AssetDepreciationArea AssetRealDepreciationArea 1
KEY CompanyCode CompanyCode 3
KEY FixedAsset FixedAsset 5
KEY Ledger Ledger 3
KEY MasterFixedAsset MasterFixedAsset 5
KEY ValidityEndDate ValidityEndDate,ValuationValidityEndDate 4
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent 3
AssetRevaluationIndex AssetRevaluationIndex 1
DeprCalcBaseValuePercent DeprCalcBaseValuePercent 1
DepreciationKey DepreciationKey 3
FixedAssetUsageObject FixedAssetUsageObject 2
IsShutDown IsShutDown 1
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 2
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 2
ScrapAmountInCoCodeCrcy ScrapAmountInCoCodeCrcy 4
ScrapAmountInFreeDefinedCrcy1 ScrapAmountInFreeDefinedCrcy1 2
ScrapAmountInFreeDefinedCrcy2 ScrapAmountInFreeDefinedCrcy2 2
ScrapAmountInFreeDefinedCrcy3 ScrapAmountInFreeDefinedCrcy3 2
ScrapAmountInFreeDefinedCrcy4 ScrapAmountInFreeDefinedCrcy4 2
ScrapAmountInFreeDefinedCrcy5 ScrapAmountInFreeDefinedCrcy5 2
ScrapAmountInFreeDefinedCrcy6 ScrapAmountInFreeDefinedCrcy6 2
ScrapAmountInFreeDefinedCrcy7 ScrapAmountInFreeDefinedCrcy7 2
ScrapAmountInFreeDefinedCrcy8 ScrapAmountInFreeDefinedCrcy8 2
ScrapAmountInGlobCrcy ScrapAmountInGlobCrcy 2
ShiftOperationFactor ShiftOperationFactor 1
ValidityStartDate ValidityStartDate,ValuationValidityStartDate 4
VariableDeprPercent VariableDeprPercent 2 
@AbapCatalog.sqlViewName: 'IASTTIMEBSDVALN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Time Based Valuation of Asset'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel: {
    usageType.serviceQuality: #A,
    usageType.sizeCategory: #XXL,
    usageType.dataClass: #MASTER
}

define view I_AssetTimeBasedValuation
  as select from faat_md_val_tdd as AssetTimeBasedValuation


  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 [1..1] to I_DepreciationArea        as _DepreciationArea           on  $projection.CompanyCode           = _DepreciationArea.CompanyCode
                                                                                 and $projection.Ledger                = _DepreciationArea.Ledger
                                                                                 and $projection.AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea
  //association [0..1] to I_DepreciationKey             as _DepreciationKey             on  $projection.DepreciationKey     = _DepreciationKey.DepreciationKey

  //                                                                                      and $projection.chartofdepreciation = _DepreciationKey.ChartOfDepreciation

  association [0..*] to I_AssetValuationForLedger as _AssetValuationForLedger    on  $projection.CompanyCode           = _AssetValuationForLedger.CompanyCode
                                                                                 and $projection.MasterFixedAsset      = _AssetValuationForLedger.MasterFixedAsset
                                                                                 and $projection.FixedAsset            = _AssetValuationForLedger.FixedAsset
                                                                                 and $projection.Ledger                = _AssetValuationForLedger.Ledger
                                                                                 and $projection.AssetDepreciationArea = _AssetValuationForLedger.AssetRealDepreciationArea
  //                                                                              and $projection.ValidityEndDate       = _AssetValuationForLedger.ValidityEndDate

  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 _FixedAssetRevaluationIndex on  $projection.AssetRevaluationIndex = _FixedAssetRevaluationIndex.AssetRevaluationIndex

{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key comp_code             as CompanyCode,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key asset_no              as MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
  key asset_subno           as FixedAsset,
      @ObjectModel.foreignKey.association: '_Ledger'
  key ledger                as Ledger,
      @ObjectModel.foreignKey.association: '_DepreciationArea'
  key depr_area             as AssetDepreciationArea,

  key valid_to_date         as ValidityEndDate,

      valid_from_date       as ValidityStartDate,

      depr_key              as DepreciationKey,

      useful_life_years     as PlannedUsefulLifeInYears,

      useful_life_periods   as PlannedUsefulLifeInPeriods,

      var_dep_portion       as VariableDeprPercent,

      scrap_value_percent   as AcqnProdnCostScrapPercent,

      multiple_shift        as ShiftOperationFactor,

      shutdown_indicator    as IsShutDown,

      base_value_percent    as DeprCalcBaseValuePercent,

      usage_object          as FixedAssetUsageObject,

      reval_index           as AssetRevaluationIndex,

      scrap_value_hsl       as ScrapAmountInCoCodeCrcy,

      scrap_value_ksl       as ScrapAmountInGlobCrcy,

      scrap_value_osl       as ScrapAmountInFreeDefinedCrcy1,

      scrap_value_vsl       as ScrapAmountInFreeDefinedCrcy2,

      scrap_value_bsl       as ScrapAmountInFreeDefinedCrcy3,

      scrap_value_csl       as ScrapAmountInFreeDefinedCrcy4,

      scrap_value_dsl       as ScrapAmountInFreeDefinedCrcy5,

      scrap_value_esl       as ScrapAmountInFreeDefinedCrcy6,

      scrap_value_fsl       as ScrapAmountInFreeDefinedCrcy7,

      scrap_value_gsl       as ScrapAmountInFreeDefinedCrcy8,

      calculation_view_type as DepreciationAreaType,

      // Association

      _CompanyCode,
      _MasterFixedAsset,
      _FixedAsset,
      _Ledger,
      _DepreciationArea,
      //_DepreciationKey,

      _AssetValuationForLedger,
      _FixedAssetUsageObject,
      _FixedAssetRevaluationIndex
}

Learn More