P_DMVCActivityMaterialPairCCS

DDL: P_DMVCACTIVITYMATERIALPAIRCCS SQL: PDMVCAMPAIRCCS Type: view COMPOSITE Package: ODATA_ML_MATLVCA_DISP

Cost Component Split(s) for a Pair (edge aggregate)

P_DMVCActivityMaterialPairCCS is a Composite CDS View that provides data about "Cost Component Split(s) for a Pair (edge aggregate)" in SAP S/4HANA. It reads from 2 data sources (P_DMVCMLDOCCostComponentSplit, P_DMVCActivityMaterialPair) and exposes 11 fields with key fields MaterialValueChainNodeFrom, MaterialValueChainNodeTo, ProcessCategory. It has 1 association to related views. Part of development package ODATA_ML_MATLVCA_DISP.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
P_DMVCMLDOCCostComponentSplit _Ccs inner
P_DMVCActivityMaterialPair P_DMVCActivityMaterialPair from

Parameters (4)

NameTypeDefault
P_DateFrom calendardate
P_DateTo calendardate
P_CurrencyType fins_curtype
P_Ledger fins_ledger

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CostComponent _CostComponent _Ccs.elesmhk = _CostComponent.CostComponentStructure and _Ccs.element = _CostComponent.CostComponent

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PDMVCAMPAIRCCS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MaterialValueChainNodeFrom MaterialValueChainNodeFrom
KEY MaterialValueChainNodeTo MaterialValueChainNodeTo
KEY ProcessCategory ProcessCategory
LedgerValuationCurrencyRole _Pair LedgerValuationCurrencyRole
docref P_DMVCMLDOCCostComponentSplit docref
CostComponentStructure P_DMVCMLDOCCostComponentSplit elesmhk
CostComponent P_DMVCMLDOCCostComponentSplit element
CostComponentName
CostComponentENName
Currency P_DMVCMLDOCCostComponentSplit waers
TotalCostValue P_DMVCMLDOCCostComponentSplit tot 
@AbapCatalog.sqlViewName: 'PDMVCAMPAIRCCS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_DMVCActivityMaterialPairCCS
  with parameters
    P_DateFrom     : calendardate,
    P_DateTo       : calendardate,
    P_CurrencyType : fins_curtype,
    P_Ledger       : fins_ledger
  as select from P_DMVCActivityMaterialPair(P_DateFrom: :P_DateFrom, P_DateTo: :P_DateTo, P_CurrencyType: :P_CurrencyType, P_Ledger: :P_Ledger) as _Pair

    inner join   P_DMVCMLDOCCostComponentSplit                                                                                                              as _Ccs on  _Pair.DocumentReference           = _Ccs.docref
                                                                                                                                                                    and _Pair.LedgerValuationCurrencyRole = _Ccs.LedgerValuationCurrencyRole
                                                                                                                                                                    and _Ccs.CostComponentSplitType       = 'H'

  association [0..1] to I_CostComponent as _CostComponent on  _Ccs.elesmhk = _CostComponent.CostComponentStructure
                                                          and _Ccs.element = _CostComponent.CostComponent

{
  key MaterialValueChainNodeFrom,
  key MaterialValueChainNodeTo,
  key ProcessCategory,
      _Pair.LedgerValuationCurrencyRole,
      
      _Ccs.docref,

      _Ccs.elesmhk                                             as CostComponentStructure,
      @ObjectModel.text.element: 'CostComponentName'
      _Ccs.element                                             as CostComponent,
      _CostComponent._Text[1:Language = $session.system_language].CostComponentName,
      _CostComponent._Text[1:Language = 'E'].CostComponentName as CostComponentENName,
      @Semantics.currencyCode: true
      _Ccs.waers                                               as Currency,
      @Semantics.amount.currencyCode : 'Currency'
      _Ccs.tot                                                 as TotalCostValue
}
where
  _Pair.ProcessCategory != 'VW'

Learn More