I_LeadingDeprAreaVH

DDL: I_LEADINGDEPRAREAVH SQL: IFILEADDAVH Type: view COMPOSITE

Leading Depreciation Area Value Help

I_LeadingDeprAreaVH is a Composite CDS View that provides data about "Leading Depreciation Area Value Help" in SAP S/4HANA. It reads from 4 data sources (I_AssetValuationView, I_AstValnViewForAcctgPrinciple, I_DepreciationAreaForLedger, I_Ledger) and exposes 6 fields with key fields CompanyCode, Ledger. It has 3 associations to related views.

4 data source(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
I_AssetValuationView I_AssetValuationView inner
I_AstValnViewForAcctgPrinciple I_AstValnViewForAcctgPrinciple inner
I_DepreciationAreaForLedger I_DepreciationAreaForLedger from
I_Ledger I_Ledger inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger
[0..*] I_DeprAreaForLedgerText _Text $projection.CompanyCode = _Text.CompanyCode and $projection.Ledger = _Text.Ledger and $projection.AssetDepreciationArea = _Text.AssetDepreciationArea

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFILEADDAVH view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Leading Depreciation Area Value Help view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY Ledger I_DepreciationAreaForLedger Ledger
AssetDepreciationArea AssetDepreciationArea
_CompanyCode _CompanyCode
_Ledger _Ledger
_Text _Text 
@AbapCatalog.sqlViewName: 'IFILEADDAVH'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Leading Depreciation Area Value Help'
@VDM.viewType: #COMPOSITE
@ObjectModel: { dataCategory: #VALUE_HELP,
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_LeadingDeprAreaVH
  as select from I_DepreciationAreaForLedger
    inner join   I_Ledger                       on I_DepreciationAreaForLedger.Ledger = I_Ledger.Ledger
    inner join   I_AssetValuationView           on I_DepreciationAreaForLedger.AssetValuationView = I_AssetValuationView.AssetValuationView
    inner join   I_AstValnViewForAcctgPrinciple on I_AssetValuationView.AssetValuationView = I_AstValnViewForAcctgPrinciple.AssetValuationView

  association [1..1] to I_CompanyCode           as _CompanyCode on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_Ledger                as _Ledger      on  $projection.Ledger = _Ledger.Ledger
  association [0..*] to I_DeprAreaForLedgerText as _Text        on  $projection.CompanyCode           = _Text.CompanyCode
                                                                and $projection.Ledger                = _Text.Ledger
                                                                and $projection.AssetDepreciationArea = _Text.AssetDepreciationArea
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_Ledger'
  key I_DepreciationAreaForLedger.Ledger,

      @ObjectModel.text.association: '_Text'
      AssetDepreciationArea,

      /* Associations */
      _CompanyCode,
      _Ledger,
      _Text
}
where
      I_Ledger.IsLeadingLedger                            =  'X'
  and I_AstValnViewForAcctgPrinciple.AssetGLPostingMethod =  '1'
  and I_AssetValuationView.AcquisitionValueCalcSign       <> '0'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETVALUATIONVIEW",
"I_ASTVALNVIEWFORACCTGPRINCIPLE",
"I_DEPRECIATIONAREAFORLEDGER",
"I_LEDGER"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_DEPRAREAFORLEDGERTEXT",
"I_LEDGER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More