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 22 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 22 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FAC_AUDIT_Z3_ASSET_MASTER view left_outer Asset Master
I_AssetTimeBasedValuationTP view from TRANSACTIONAL Time Based Valuation of Asset
I_FixedAssetUsageObjWhereUsd view inner COMPOSITE Where used of Fixed Asset Usage Object
P_AssetValuationForLedger view union_all COMPOSITE
P_BG_StRpTaxDeprShutdown view union_all CONSUMPTION Tax depr. plan - shutdowns

Fields (22)

KeyField CDS FieldsUsed in Views
KEY AssetDepreciationArea AssetRealDepreciationArea 1
KEY FixedAsset FixedAsset 2
KEY Ledger Ledger 1
KEY MasterFixedAsset MasterFixedAsset 2
KEY ValidityEndDate ValidityEndDate,ValuationValidityEndDate 2
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent 1
DepreciationKey DepreciationKey 2
FixedAssetUsageObject FixedAssetUsageObject 1
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods 2
PlannedUsefulLifeInYears PlannedUsefulLifeInYears 2
ScrapAmountInCoCodeCrcy ScrapAmountInCoCodeCrcy 2
ScrapAmountInFreeDefinedCrcy1 ScrapAmountInFreeDefinedCrcy1 1
ScrapAmountInFreeDefinedCrcy2 ScrapAmountInFreeDefinedCrcy2 1
ScrapAmountInFreeDefinedCrcy3 ScrapAmountInFreeDefinedCrcy3 1
ScrapAmountInFreeDefinedCrcy4 ScrapAmountInFreeDefinedCrcy4 1
ScrapAmountInFreeDefinedCrcy5 ScrapAmountInFreeDefinedCrcy5 1
ScrapAmountInFreeDefinedCrcy6 ScrapAmountInFreeDefinedCrcy6 1
ScrapAmountInFreeDefinedCrcy7 ScrapAmountInFreeDefinedCrcy7 1
ScrapAmountInFreeDefinedCrcy8 ScrapAmountInFreeDefinedCrcy8 1
ScrapAmountInGlobCrcy ScrapAmountInGlobCrcy 1
ValidityStartDate ValidityStartDate,ValuationValidityStartDate 2
VariableDeprPercent VariableDeprPercent 1 
@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 [1..1] to I_FixedAssetUsageObject   as _FixedAssetUsageObject   on  $projection.CompanyCode = _FixedAssetUsageObject.CompanyCode
                                                                              and $projection.FixedAssetUsageObject = _FixedAssetUsageObject.FixedAssetUsageObject




{
      @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,

      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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAAT_MD_VAL_TDD"
],
"ASSOCIATED":
[
"I_ASSETVALUATIONFORLEDGER",
"I_COMPANYCODE",
"I_DEPRECIATIONAREA",
"I_FIXEDASSET",
"I_FIXEDASSETUSAGEOBJECT",
"I_LEDGER",
"I_MASTERFIXEDASSET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More