P_DACRCostComponentConsumption

DDL: P_DACRCOSTCOMPONENTCONSUMPTION SQL: PDACRCCSCONS Type: view COMPOSITE
12 Fields 2 Data Sources

Consumptions for cost components in DACR

P_DACRCostComponentConsumption is a Composite CDS View that provides data about "Consumptions for cost components in DACR" in SAP S/4HANA. It reads from 2 data sources (P_DMVCMLDOCCostComponentSplit, P_MaterialLedgerDocument) and exposes 12 fields with key fields LedgerValuationCurrencyRole, CostEstimate, CostComponentStructure, CostComponent, CostComponentSplitType.

Data Sources (2)

SourceAliasJoin Type
P_DMVCMLDOCCostComponentSplit _ccs from
P_MaterialLedgerDocument _mldoc inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PDACRCCSCONS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consumptions for cost components in DACR view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LedgerValuationCurrencyRole P_DMVCMLDOCCostComponentSplit LedgerValuationCurrencyRole Valuation Area
KEY CostEstimate P_MaterialLedgerDocument CostEstimate Cost EstimateNo
KEY CostComponentStructure P_DMVCMLDOCCostComponentSplit elesmhk Cost Comp. Str.
KEY CostComponent P_DMVCMLDOCCostComponentSplit element Target identifier
KEY CostComponentSplitType P_DMVCMLDOCCostComponentSplit CostComponentSplitType Type of CCS
FiscalYearPeriod P_MaterialLedgerDocument FiscalYearPeriod Period/Year
Ledger P_MaterialLedgerDocument Ledger Ledger
Currency P_DMVCMLDOCCostComponentSplit waers Transaction Currency
tot
fix
totll
fixll

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_DACRCostComponentConsumption.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PDACRCCSCONS

CREATE VIEW P_DACRCostComponentConsumption AS
SELECT
  _ccs.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  _mldoc.CostEstimate AS CostEstimate,
  _ccs.elesmhk AS CostComponentStructure,
  _ccs.element AS CostComponent,
  _ccs.CostComponentSplitType AS CostComponentSplitType,
  _mldoc.FiscalYearPeriod AS FiscalYearPeriod,
  _mldoc.Ledger AS Ledger,
  _ccs.waers AS Currency,
  sum(_ccs.tot ) AS tot,
  sum(_ccs.fix ) AS fix,
  sum(_ccs.totll ) AS totll,
  sum(_ccs.fixll ) AS fixll
FROM P_DMVCMLDOCCostComponentSplit AS _ccs
INNER JOIN P_MaterialLedgerDocument AS _mldoc ON /* join condition not captured in parsed metadata */
;

Learn More