I_AssetValuationTP

DDL: I_ASSETVALUATIONTP SQL: IASSETVALNTP Type: view TRANSACTIONAL Package: FINS_FAA_MD_BOPF

Asset Valuation

I_AssetValuationTP is a Transactional CDS View that provides data about "Asset Valuation" in SAP S/4HANA. It reads from 1 data source (I_AssetValuation) and exposes 49 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea. It has 5 associations to related views. Part of development package FINS_FAA_MD_BOPF.

1 data source(s) 49 fields

Data Sources (1)

SourceAliasJoin Type
I_AssetValuation AssetValuation from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_AssetTP _AssetTP $projection.CompanyCode = _AssetTP.CompanyCode and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset and $projection.FixedAsset = _AssetTP.FixedAsset
[1..1] I_AssetLedgerTP _AssetLedgerTP $projection.CompanyCode = _AssetLedgerTP.CompanyCode and $projection.MasterFixedAsset = _AssetLedgerTP.MasterFixedAsset and $projection.FixedAsset = _AssetLedgerTP.FixedAsset and $projection.Ledger = _AssetLedgerTP.Ledger
[1..*] I_AssetTimeBasedValuationTP _AssetTimeBasedValuationTP $projection.CompanyCode = _AssetTimeBasedValuationTP.CompanyCode and $projection.MasterFixedAsset = _AssetTimeBasedValuationTP.MasterFixedAsset and $projection.FixedAsset = _AssetTimeBasedValuationTP.FixedAsset and $projection.Ledger = _AssetTimeBasedValuationTP.Ledger and $projection.AssetDepreciationArea = _AssetTimeBasedValuationTP.AssetDepreciationArea
[1..*] I_AssetYearOpeningValnAttribTP _AssetYearOpeningValnAttribTP $projection.CompanyCode = _AssetYearOpeningValnAttribTP.CompanyCode and $projection.MasterFixedAsset = _AssetYearOpeningValnAttribTP.MasterFixedAsset and $projection.FixedAsset = _AssetYearOpeningValnAttribTP.FixedAsset and $projection.Ledger = _AssetYearOpeningValnAttribTP.Ledger and $projection.AssetDepreciationArea = _AssetYearOpeningValnAttribTP.AssetDepreciationArea
[0..*] I_GlobAssetTimeBasedValnTP _GlobAssetTimeBasedValnTP $projection.CompanyCode = _GlobAssetTimeBasedValnTP.CompanyCode and $projection.MasterFixedAsset = _GlobAssetTimeBasedValnTP.MasterFixedAsset and $projection.FixedAsset = _GlobAssetTimeBasedValnTP.FixedAsset and $projection.Ledger = _GlobAssetTimeBasedValnTP.Ledger and $projection.AssetDepreciationArea = _GlobAssetTimeBasedValnTP.AssetDepreciationArea

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IASSETVALNTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Asset Valuation view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
Metadata.allowExtensions false view
ObjectModel.writeActivePersistence FAAV_MD_VAL view
ObjectModel.writeDraftPersistence FAAD_MD_VAL view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY Ledger Ledger
KEY AssetDepreciationArea AssetDepreciationArea
AssetLeadingDepreciationArea
ChartOfDepreciation
DepreciationKey I_AssetValuation DepreciationKey
PlannedUsefulLifeInYears I_AssetValuation PlannedUsefulLifeInYears
PlannedUsefulLifeInPeriods I_AssetValuation PlannedUsefulLifeInPeriods
NegativeAmountIsAllowed NegativeAmountIsAllowed
DepreciationStartDate DepreciationStartDate
SpecialDeprStartDate SpecialDeprStartDate
InterestCalcStartDate InterestCalcStartDate
AssetOpgReadinessDate AssetOpgReadinessDate
ReplacementValueIndexSers ReplacementValueIndexSers
RplcmtValueAgingIndexSers RplcmtValueAgingIndexSers
DeprKeyChangeoverYear DeprKeyChangeoverYear
DeprKeyChangeoverPeriod DeprKeyChangeoverPeriod
LowValueAssetAmountCheckType LowValueAssetAmountCheckType
LastRetirementValueDate LastRetirementValueDate
AssetCurrentFiscalYear AssetCurrentFiscalYear
AssetNumberOfPeriods AssetNumberOfPeriods
DepreciationAreaType DepreciationAreaType
ExpiredUsefulLifeInYrs ExpiredUsefulLifeInYrs
ExpiredUsefulLifeInPerds ExpiredUsefulLifeInPerds
SpclExpiredUsefulLifeInYrs SpclExpiredUsefulLifeInYrs
SpclExpiredUsefulLifeInPerds SpclExpiredUsefulLifeInPerds
CoCodeCurrencyErrorIsIgnored CoCodeCurrencyErrorIsIgnored
GlobalCurrencyErrorIsIgnored GlobalCurrencyErrorIsIgnored
FreeDefinedCrcy1ErrorIsIgnored FreeDefinedCrcy1ErrorIsIgnored
FreeDefinedCrcy2ErrorIsIgnored FreeDefinedCrcy2ErrorIsIgnored
FreeDefinedCrcy3ErrorIsIgnored FreeDefinedCrcy3ErrorIsIgnored
FreeDefinedCrcy4ErrorIsIgnored FreeDefinedCrcy4ErrorIsIgnored
FreeDefinedCrcy5ErrorIsIgnored FreeDefinedCrcy5ErrorIsIgnored
FreeDefinedCrcy6ErrorIsIgnored FreeDefinedCrcy6ErrorIsIgnored
FreeDefinedCrcy7ErrorIsIgnored FreeDefinedCrcy7ErrorIsIgnored
FreeDefinedCrcy8ErrorIsIgnored FreeDefinedCrcy8ErrorIsIgnored
_AssetTP _AssetTP
_AssetLedgerTP _AssetLedgerTP
_AssetTimeBasedValuationTP _AssetTimeBasedValuationTP
_AssetYearOpeningValnAttribTP _AssetYearOpeningValnAttribTP
_GlobAssetTimeBasedValnTP _GlobAssetTimeBasedValnTP
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_Ledger _Ledger
_DepreciationArea _DepreciationArea
_AssetValuationForLedger _AssetValuationForLedger 
@AbapCatalog.sqlViewName: 'IASSETVALNTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Asset Valuation'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@Metadata.allowExtensions: false
@ObjectModel: {
    writeActivePersistence: 'FAAV_MD_VAL',
    writeDraftPersistence:  'FAAD_MD_VAL',
    semanticKey: ['CompanyCode','MasterFixedAsset','FixedAsset','AssetDepreciationArea','Ledger'],
    //entityChangeStateId:  'LastChangeDateTime',

    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    usageType: {
        serviceQuality: #B,
        sizeCategory: #XXL,
        dataClass: #MASTER
    }
}

define view I_AssetValuationTP
  as select from I_AssetValuation as AssetValuation
  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_AssetLedgerTP                as _AssetLedgerTP                on  $projection.CompanyCode      = _AssetLedgerTP.CompanyCode
                                                                                        and $projection.MasterFixedAsset = _AssetLedgerTP.MasterFixedAsset
                                                                                        and $projection.FixedAsset       = _AssetLedgerTP.FixedAsset
                                                                                        and $projection.Ledger           = _AssetLedgerTP.Ledger

  association [1..*] to I_AssetTimeBasedValuationTP    as _AssetTimeBasedValuationTP    on  $projection.CompanyCode           = _AssetTimeBasedValuationTP.CompanyCode
                                                                                        and $projection.MasterFixedAsset      = _AssetTimeBasedValuationTP.MasterFixedAsset
                                                                                        and $projection.FixedAsset            = _AssetTimeBasedValuationTP.FixedAsset
                                                                                        and $projection.Ledger                = _AssetTimeBasedValuationTP.Ledger
                                                                                        and $projection.AssetDepreciationArea = _AssetTimeBasedValuationTP.AssetDepreciationArea

  association [1..*] to I_AssetYearOpeningValnAttribTP as _AssetYearOpeningValnAttribTP on  $projection.CompanyCode           = _AssetYearOpeningValnAttribTP.CompanyCode
                                                                                        and $projection.MasterFixedAsset      = _AssetYearOpeningValnAttribTP.MasterFixedAsset
                                                                                        and $projection.FixedAsset            = _AssetYearOpeningValnAttribTP.FixedAsset
                                                                                        and $projection.Ledger                = _AssetYearOpeningValnAttribTP.Ledger
                                                                                        and $projection.AssetDepreciationArea = _AssetYearOpeningValnAttribTP.AssetDepreciationArea

  association [0..*] to I_GlobAssetTimeBasedValnTP     as _GlobAssetTimeBasedValnTP     on  $projection.CompanyCode           = _GlobAssetTimeBasedValnTP.CompanyCode
                                                                                        and $projection.MasterFixedAsset      = _GlobAssetTimeBasedValnTP.MasterFixedAsset
                                                                                        and $projection.FixedAsset            = _GlobAssetTimeBasedValnTP.FixedAsset
                                                                                        and $projection.Ledger                = _GlobAssetTimeBasedValnTP.Ledger
                                                                                        and $projection.AssetDepreciationArea = _GlobAssetTimeBasedValnTP.AssetDepreciationArea
  //  association [0..1] to P_ChartOfDeprByCoCdLdDeprArea  as _ChartOfDepreciation          on  $projection.CompanyCode           = _ChartOfDepreciation.CompanyCode

  //                                                                                        and $projection.Ledger                = _ChartOfDepreciation.Ledger

  //                                                                                        and $projection.AssetDepreciationArea = _ChartOfDepreciation.AssetDepreciationArea



{
           @ObjectModel.readOnly: true
  key      CompanyCode,
           @ObjectModel.readOnly: true
  key      MasterFixedAsset,
           @ObjectModel.readOnly: true
  key      FixedAsset,
           @ObjectModel.readOnly: true
  key      Ledger,
           @ObjectModel.readOnly: true
  key      AssetDepreciationArea,

           //           @ObjectModel.readOnly: true

           //           AssetValuation.Ledger                                                                                               as      LedgerForEdit,

           //

           //           @ObjectModel.readOnly: true

           //           AssetValuation.AssetDepreciationArea                                                                                as      AssetDepreciationAreaForEdit,



           cast ( cast ( '00' as abap.numc(2) )  as afaber ) as AssetLeadingDepreciationArea, // TBD


           cast ( cast ( '' as abap.char(4)  ) as afapl )    as ChartOfDepreciation,
           //@ObjectModel.readOnly:true

           //_ChartOfDepreciation.ChartOfDepreciation,


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


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

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

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

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

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

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

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

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

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

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

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

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

           //Use dummy fields since CE2002

           //cast ( cast ( '' as abap.char(12) )  as anlgr )   as GroupMasterFixedAsset,

           //cast ( cast ( '' as abap.char(12) )  as anlgr2 )  as GroupFixedAsset,


           LastRetirementValueDate,

           AssetCurrentFiscalYear,

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

           @ObjectModel.readOnly: true
           DepreciationAreaType,

           // fields in ydda part

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

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

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

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

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

           //DepreciatedUnitsQuantity,


           CoCodeCurrencyErrorIsIgnored,

           GlobalCurrencyErrorIsIgnored,

           FreeDefinedCrcy1ErrorIsIgnored,
           FreeDefinedCrcy2ErrorIsIgnored,
           FreeDefinedCrcy3ErrorIsIgnored,
           FreeDefinedCrcy4ErrorIsIgnored,
           FreeDefinedCrcy5ErrorIsIgnored,
           FreeDefinedCrcy6ErrorIsIgnored,
           FreeDefinedCrcy7ErrorIsIgnored,
           FreeDefinedCrcy8ErrorIsIgnored,

           // Associations

           @ObjectModel.association.type:  [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
           _AssetTP,

           _AssetLedgerTP,

           @ObjectModel.association.type:  #TO_COMPOSITION_CHILD
           _AssetTimeBasedValuationTP,

           @ObjectModel.association.type:  #TO_COMPOSITION_CHILD
           _AssetYearOpeningValnAttribTP,

           @ObjectModel.association.type:  #TO_COMPOSITION_CHILD
           _GlobAssetTimeBasedValnTP,


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

           _AssetValuationForLedger

}

Learn More