ML4H_CDS_CONSUMP_CCS

DDL: ML4H_CDS_CONSUMP_CCS SQL: V_CONSUMP_CCS Type: view
17 Fields 2 Data Sources

Sum of consumption CCS with WIP Reduction

ML4H_CDS_CONSUMP_CCS is a CDS View that provides data about "Sum of consumption CCS with WIP Reduction" in SAP S/4HANA. It reads from 2 data sources (mldocccs, mldoc) and exposes 17 fields with key fields kalnr, curtp, CATEG, PTYP, process.

Data Sources (2)

SourceAliasJoin Type
mldocccs cc left_outer
mldoc rp from

Parameters (7)

NameTypeDefault
P_kalnr ck_kalnr
p_curtp curtp
p_jahrper_low ml4h_jahrper
p_jahrper_high ml4h_jahrper
p_runref ml4h_runref
p_xabr ml4h_xabr
P_timestamp ml4h_timestamp

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName V_CONSUMP_CCS view
AbapCatalog.compiler.compareFilter true view
ClientDependent true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass TRANSACTIONAL view
EndUserText.label Sum of consumption CCS with WIP Reduction view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY kalnr mldoc kalnr ProdCostEst.No.
KEY curtp mldoc curtp Valuation Area
KEY CATEG mldoc categ Category
KEY PTYP mldoc ptyp Visibility (I/E/V/C)
KEY process mldoc process Trans.
KEY waers mldoc waers Transaction Currency
KEY meins mldoc meins Valuation Unit
KEY elesmhk mldocccs elesmhk Cost Comp. Str.
KEY element mldocccs element Target identifier
KEY patnr mldocccs patnr Partner number
KEY dipa mldocccs dipa Direct Partner
KEY keart mldocccs keart Type of CCS
KEY svrel mldocccs svrel Relev. f. Stock Val.
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 ML4H_CDS_CONSUMP_CCS.
-- 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: V_CONSUMP_CCS
-- Parameters: P_kalnr : ck_kalnr, p_curtp : curtp, p_jahrper_low : ml4h_jahrper, p_jahrper_high : ml4h_jahrper, p_runref : ml4h_runref, p_xabr : ml4h_xabr, P_timestamp : ml4h_timestamp

CREATE VIEW ML4H_CDS_CONSUMP_CCS AS
SELECT
  rp.kalnr AS kalnr,
  rp.curtp AS curtp,
  rp.categ AS CATEG,
  rp.ptyp AS PTYP,
  rp.process AS process,
  rp.waers AS waers,
  rp.meins AS meins,
  cc.elesmhk AS elesmhk,
  cc.element AS element,
  cc.patnr AS patnr,
  cc.dipa AS dipa,
  cc.keart AS keart,
  cc.svrel AS svrel,
  sum (cc.tot ) AS tot,
  sum (cc.fix) AS fix,
  sum (cc.totll) AS totll,
  sum (cc.fixll) AS fixll
FROM mldoc AS rp
LEFT OUTER JOIN mldocccs AS cc ON /* join condition not captured in parsed metadata */
;

Learn More