CIC_PRD_CONSUMPTION_QTY

DDL: CIC_PRD_CONSUMPTION_QTY Type: view_entity
19 Fields 2 Data Sources

CDS for Prd Consumption Qty

CIC_PRD_CONSUMPTION_QTY is a CDS View that provides data about "CDS for Prd Consumption Qty" in SAP S/4HANA. It reads from 2 data sources (mara, mver) and exposes 19 fields with key fields Product, Plant, FiscalYear, PeriodCategory, FollowOnRecords.

Data Sources (2)

SourceAliasJoin Type
mara _mara inner
mver _mver from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS for Prd Consumption Qty view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Product mver matnr Vehicle Model
KEY Plant mver werks Receiving Plant
KEY FiscalYear mver gjahr Settlement Year
KEY PeriodCategory mver perkz Period Type
KEY FollowOnRecords mver zahlr Follow-on recs.
BaseUnitofMeasure mara meins Valuation Unit
gsv01 mver gsv01 Tot.consumption
gsv02 mver gsv02 Tot.consumption
gsv03 mver gsv03 Tot.consumption
gsv04 mver gsv04 Tot.consumption
gsv05 mver gsv05 Tot.consumption
gsv06 mver gsv06 Tot.consumption
gsv07 mver gsv07 Tot.consumption
gsv08 mver gsv08 Tot.consumption
gsv09 mver gsv09 Tot.consumption
gsv10 mver gsv10 Tot.consumption
gsv11 mver gsv11 Tot.consumption
gsv12 mver gsv12 Tot.consumption
gsv13 mver gsv13 Tot.consumption

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 CIC_PRD_CONSUMPTION_QTY.
-- 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.

CREATE VIEW CIC_PRD_CONSUMPTION_QTY AS
SELECT
  _mver.matnr AS Product,
  _mver.werks AS Plant,
  _mver.gjahr AS FiscalYear,
  _mver.perkz AS PeriodCategory,
  _mver.zahlr AS FollowOnRecords,
  _mara.meins AS BaseUnitofMeasure,
  _mver.gsv01 AS gsv01,
  _mver.gsv02 AS gsv02,
  _mver.gsv03 AS gsv03,
  _mver.gsv04 AS gsv04,
  _mver.gsv05 AS gsv05,
  _mver.gsv06 AS gsv06,
  _mver.gsv07 AS gsv07,
  _mver.gsv08 AS gsv08,
  _mver.gsv09 AS gsv09,
  _mver.gsv10 AS gsv10,
  _mver.gsv11 AS gsv11,
  _mver.gsv12 AS gsv12,
  _mver.gsv13 AS gsv13
FROM mver AS _mver
INNER JOIN mara AS _mara ON /* join condition not captured in parsed metadata */
;

Learn More