R_FixedAssetTimeBasedValnTP

DDL: R_FIXEDASSETTIMEBASEDVALNTP Type: view_entity TRANSACTIONAL Package: FINS_FAA_MD_RAP_BO

Fixed Asset Time-based Valuation

R_FixedAssetTimeBasedValnTP is a Transactional CDS View that provides data about "Fixed Asset Time-based Valuation" in SAP S/4HANA. It reads from 1 data source (I_AssetTimeBasedValuation) and exposes 44 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea. It has 2 associations to related views. Part of development package FINS_FAA_MD_RAP_BO.

1 data source(s) 44 fields

Data Sources (1)

SourceAliasJoin Type
I_AssetTimeBasedValuation I_AssetTimeBasedValuation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_FixedAssetTP _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset
[1..1] I_LedgerCompanyCodeCrcyRoles _CurrencyRoles $projection.CompanyCode = _CurrencyRoles.CompanyCode and $projection.Ledger = _CurrencyRoles.Ledger

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Fixed Asset Time-based Valuation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY Ledger Ledger
KEY AssetDepreciationArea AssetDepreciationArea
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
DepreciationKey DepreciationKey
PlannedUsefulLifeInYears PlannedUsefulLifeInYears
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods
VariableDeprPercent VariableDeprPercent
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent
DeprCalcBaseValuePercent DeprCalcBaseValuePercent
ShiftOperationFactor ShiftOperationFactor
IsShutDown IsShutDown
ScrapAmountInCoCodeCrcy ScrapAmountInCoCodeCrcy
ScrapAmountInGlobCrcy ScrapAmountInGlobCrcy
ScrapAmountInFreeDefinedCrcy1 ScrapAmountInFreeDefinedCrcy1
ScrapAmountInFreeDefinedCrcy2 ScrapAmountInFreeDefinedCrcy2
ScrapAmountInFreeDefinedCrcy3 ScrapAmountInFreeDefinedCrcy3
ScrapAmountInFreeDefinedCrcy4 ScrapAmountInFreeDefinedCrcy4
ScrapAmountInFreeDefinedCrcy5 ScrapAmountInFreeDefinedCrcy5
ScrapAmountInFreeDefinedCrcy6 ScrapAmountInFreeDefinedCrcy6
ScrapAmountInFreeDefinedCrcy7 ScrapAmountInFreeDefinedCrcy7
ScrapAmountInFreeDefinedCrcy8 ScrapAmountInFreeDefinedCrcy8
CompanyCodeCurrency
GlobalCurrency
FreeDefinedCurrency1
FreeDefinedCurrency2
FreeDefinedCurrency3
FreeDefinedCurrency4
FreeDefinedCurrency5
FreeDefinedCurrency6
FreeDefinedCurrency7
FreeDefinedCurrency8
FunctionalCurrency
FixedAssetUsageObject FixedAssetUsageObject
AssetRevaluationIndex AssetRevaluationIndex
DepreciationAreaType DepreciationAreaType
_FixedAsset _FixedAsset
_FixedAssetValuation _FixedAssetValuation
_FixedAssetUsageObject _FixedAssetUsageObject
_FixedAssetRevaluationIndex _FixedAssetRevaluationIndex
_CurrencyRoles _CurrencyRoles 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Fixed Asset Time-based Valuation'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  semanticKey: ['CompanyCode','MasterFixedAsset','FixedAsset','Ledger','AssetDepreciationArea','ValidityEndDate'],
  usageType: {
        serviceQuality: #C,
        sizeCategory: #XXL,
        dataClass: #MASTER
    }
 }

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

define view entity R_FixedAssetTimeBasedValnTP
  as select from I_AssetTimeBasedValuation

  association        to parent R_FixedAssetValuationTP as _FixedAssetValuation on  $projection.CompanyCode           = _FixedAssetValuation.CompanyCode
                                                                               and $projection.MasterFixedAsset      = _FixedAssetValuation.MasterFixedAsset
                                                                               and $projection.FixedAsset            = _FixedAssetValuation.FixedAsset
                                                                               and $projection.Ledger                = _FixedAssetValuation.Ledger
                                                                               and $projection.AssetDepreciationArea = _FixedAssetValuation.AssetDepreciationArea

  association [1..1] to R_FixedAssetTP                 as _FixedAsset          on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                                               and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                                               and $projection.FixedAsset       = _FixedAsset.FixedAsset

    association [1..1] to I_LedgerCompanyCodeCrcyRoles as _CurrencyRoles on  $projection.CompanyCode = _CurrencyRoles.CompanyCode
                                                                         and $projection.Ledger      = _CurrencyRoles.Ledger

{

  key    CompanyCode,

  key    MasterFixedAsset,

  key    FixedAsset,

  key    Ledger,

  key    AssetDepreciationArea,

  key    ValidityEndDate,

         ValidityStartDate,

         DepreciationKey,

         PlannedUsefulLifeInYears,

         PlannedUsefulLifeInPeriods,

         VariableDeprPercent,

         AcqnProdnCostScrapPercent,

         DeprCalcBaseValuePercent,

         ShiftOperationFactor,

         IsShutDown,

         //         @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

         //         ScrapAmountInCoCodeCrcy,

         //

         //         @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

         //         ScrapAmountInGlobCrcy,

         //

         //         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

         //         ScrapAmountInFreeDefinedCrcy1,

         //

         //         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

         //         ScrapAmountInFreeDefinedCrcy2,

         //

         //         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

         //         ScrapAmountInFreeDefinedCrcy3,

         //

         //         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

         //         ScrapAmountInFreeDefinedCrcy4,

         //

         //         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

         //         ScrapAmountInFreeDefinedCrcy5,

         //

         //         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

         //         ScrapAmountInFreeDefinedCrcy6,

         //

         //         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

         //         ScrapAmountInFreeDefinedCrcy7,

         //

         //         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

         //         ScrapAmountInFreeDefinedCrcy8,


         @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
         ScrapAmountInCoCodeCrcy,

         @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
         ScrapAmountInGlobCrcy,

         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
         ScrapAmountInFreeDefinedCrcy1,

         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
         ScrapAmountInFreeDefinedCrcy2,

         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
         ScrapAmountInFreeDefinedCrcy3,

         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
         ScrapAmountInFreeDefinedCrcy4,

         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
         ScrapAmountInFreeDefinedCrcy5,

         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
         ScrapAmountInFreeDefinedCrcy6,

         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
         ScrapAmountInFreeDefinedCrcy7,

         @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
         ScrapAmountInFreeDefinedCrcy8,


//         cast('' as waers) as CompanyCodeCurrency,

//         cast('' as waers) as GlobalCurrency,

//         cast('' as waers) as FreeDefinedCurrency1,

//         cast('' as waers) as FreeDefinedCurrency2,

//         cast('' as waers) as FreeDefinedCurrency3,

//         cast('' as waers) as FreeDefinedCurrency4,

//         cast('' as waers) as FreeDefinedCurrency5,

//         cast('' as waers) as FreeDefinedCurrency6,

//         cast('' as waers) as FreeDefinedCurrency7,

//         cast('' as waers) as FreeDefinedCurrency8,

//         cast('' as waers) as FunctionalCurrency,


                  _CurrencyRoles._CoCodeCurrencyRoleCurrency.Currency as CompanyCodeCurrency,
         
                  _CurrencyRoles._GlobalCurrencyRoleCurrency.Currency as GlobalCurrency,
         
                  _CurrencyRoles._FreeDfndCrcyRole1Currency.Currency  as FreeDefinedCurrency1,
         
                  _CurrencyRoles._FreeDfndCrcyRole2Currency.Currency  as FreeDefinedCurrency2,
         
                  _CurrencyRoles._FreeDfndCrcyRole3Currency.Currency  as FreeDefinedCurrency3,
         
                  _CurrencyRoles._FreeDfndCrcyRole4Currency.Currency  as FreeDefinedCurrency4,
         
                  _CurrencyRoles._FreeDfndCrcyRole5Currency.Currency  as FreeDefinedCurrency5,
         
                  _CurrencyRoles._FreeDfndCrcyRole6Currency.Currency  as FreeDefinedCurrency6,
         
                  _CurrencyRoles._FreeDfndCrcyRole7Currency.Currency  as FreeDefinedCurrency7,
         
                  _CurrencyRoles._FreeDfndCrcyRole8Currency.Currency  as FreeDefinedCurrency8,
         
                  _CurrencyRoles._FunctionalCrcyRoleCurrency.Currency as FunctionalCurrency,

         FixedAssetUsageObject,

         AssetRevaluationIndex,

         DepreciationAreaType,
         //           @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]

         _FixedAsset,

         _FixedAssetValuation,

         _FixedAssetUsageObject,

         _FixedAssetRevaluationIndex,

 //        Association

                  _CurrencyRoles
}

Learn More