I_AssetTimeBasedValuationTP

DDL: I_ASSETTIMEBASEDVALUATIONTP SQL: IASTTMBSDVALNTP Type: view TRANSACTIONAL

Time Based Valuation of Asset

I_AssetTimeBasedValuationTP is a Transactional CDS View that provides data about "Time Based Valuation of Asset" in SAP S/4HANA. It reads from 1 data source (I_AssetTimeBasedValuation) and exposes 38 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea. It has 2 associations to related views.

1 data source(s) 38 fields

Data Sources (1)

SourceAliasJoin Type
I_AssetTimeBasedValuation AssetTimeBasedValuation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_AssetTP _AssetTP $projection.CompanyCode = _AssetTP.CompanyCode and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset and $projection.FixedAsset = _AssetTP.FixedAsset
[1..1] I_AssetValuationTP _AssetValuationTP $projection.CompanyCode = _AssetValuationTP.CompanyCode and $projection.MasterFixedAsset = _AssetValuationTP.MasterFixedAsset and $projection.FixedAsset = _AssetValuationTP.FixedAsset and $projection.Ledger = _AssetValuationTP.Ledger and $projection.AssetDepreciationArea = _AssetValuationTP.AssetDepreciationArea

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IASTTMBSDVALNTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Time Based Valuation of Asset view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
Metadata.allowExtensions false view
ObjectModel.writeActivePersistence FAAV_MD_VAL_TDD view
ObjectModel.writeDraftPersistence FAAD_MD_VAL_TDD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY Ledger Ledger
KEY AssetDepreciationArea AssetDepreciationArea
KEY ValidityEndDate ValidityEndDate
ValidityEndDateForEdit ValidityEndDate
ChartOfDepreciation
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
FixedAssetUsageObject FixedAssetUsageObject
DepreciationAreaType DepreciationAreaType
_AssetTP _AssetTP
_AssetValuationTP _AssetValuationTP
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_Ledger _Ledger
_DepreciationArea _DepreciationArea
_AssetValuationForLedger _AssetValuationForLedger
_FixedAssetUsageObject _FixedAssetUsageObject 
@AbapCatalog.sqlViewName: 'IASTTMBSDVALNTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Time Based Valuation of Asset'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@Metadata.allowExtensions: false
@ObjectModel: {
    writeActivePersistence: 'FAAV_MD_VAL_TDD',
    writeDraftPersistence:  'FAAD_MD_VAL_TDD',
    semanticKey: ['ValidityEndDate','CompanyCode','MasterFixedAsset','FixedAsset','AssetDepreciationArea'],
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    usageType: {
        serviceQuality: #A,
        sizeCategory: #XXL,
        dataClass: #MASTER
    }
}

define view I_AssetTimeBasedValuationTP
  as select from I_AssetTimeBasedValuation as AssetTimeBasedValuation

  association [1..1] to I_AssetTP          as _AssetTP          on  $projection.CompanyCode      = _AssetTP.CompanyCode
                                                                and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset
                                                                and $projection.FixedAsset       = _AssetTP.FixedAsset

  association [1..1] to I_AssetValuationTP as _AssetValuationTP on  $projection.CompanyCode           = _AssetValuationTP.CompanyCode
                                                                and $projection.MasterFixedAsset      = _AssetValuationTP.MasterFixedAsset
                                                                and $projection.FixedAsset            = _AssetValuationTP.FixedAsset
                                                                and $projection.Ledger                = _AssetValuationTP.Ledger
                                                                and $projection.AssetDepreciationArea = _AssetValuationTP.AssetDepreciationArea

{
         // Keys

  key    CompanyCode,

  key    MasterFixedAsset,

  key    FixedAsset,

  key    Ledger,

  key    AssetDepreciationArea,

         @ObjectModel:{ readOnly:'true'}
  key    ValidityEndDate,

         @ObjectModel.editableFieldFor: 'ValidityEndDate'
         ValidityEndDate             as ValidityEndDateForEdit,

         cast ( '' as abap.char(4) ) as ChartOfDepreciation,

         ValidityStartDate,

         @ObjectModel.sort.enabled : true
         @ObjectModel.filter.enabled : true
         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         DepreciationKey,

         @ObjectModel.sort.enabled : true
         @ObjectModel.filter.enabled : true
         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         PlannedUsefulLifeInYears,

         @ObjectModel.sort.enabled : true
         @ObjectModel.filter.enabled : true
         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         PlannedUsefulLifeInPeriods,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         VariableDeprPercent,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         AcqnProdnCostScrapPercent,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         DeprCalcBaseValuePercent,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ShiftOperationFactor,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         IsShutDown,

         // Scrap Value Currencies

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInCoCodeCrcy,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInGlobCrcy,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInFreeDefinedCrcy1,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInFreeDefinedCrcy2,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInFreeDefinedCrcy3,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInFreeDefinedCrcy4,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInFreeDefinedCrcy5,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInFreeDefinedCrcy6,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInFreeDefinedCrcy7,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         ScrapAmountInFreeDefinedCrcy8,

         @ObjectModel:{ readOnly:'EXTERNAL_CALCULATION', enabled:'EXTERNAL_CALCULATION'}
         FixedAssetUsageObject,

         DepreciationAreaType,


         // Associations

         @ObjectModel.association.type: #TO_COMPOSITION_ROOT
         _AssetTP,

         @ObjectModel.association.type: #TO_COMPOSITION_PARENT
         _AssetValuationTP,


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

         _AssetValuationForLedger,
         _FixedAssetUsageObject
}

Learn More