P_Fcdm_Keyf_Read_Custrq_Sls

DDL: P_FCDM_KEYF_READ_CUSTRQ_SLS SQL: PFKRCS Type: view BASIC Package: PPH_FORECAST_DEMAND_MASS
11 Fields 3 Data Sources

Read Customer sales Forecast Demand Keyfigures

P_Fcdm_Keyf_Read_Custrq_Sls is a Basic CDS View that provides data about "Read Customer sales Forecast Demand Keyfigures" in SAP S/4HANA. It reads from 3 data sources (vbak, vbap, vbep) and exposes 11 fields with key fields matnr, werks, berid, vbeln, posnr. Part of development package PPH_FORECAST_DEMAND_MASS.

Data Sources (3)

SourceAliasJoin Type
vbak vbak from
vbap vbap inner
vbep vbep inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFKRCS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #AUTOMATED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY matnr vbap matnr Vehicle Model
KEY werks vbap werks Receiving Plant
KEY berid vbap werks Receiving Plant
KEY vbeln vbap vbeln SD Sched. Agmt
KEY posnr vbep posnr WBS Element
KEY etenr vbep etenr Schedule Line
lgort vbap lgort Sublocation
wmeng vbep wmeng Order Quantity
edatu
meins vbep meins Valuation Unit
thequantityisnowinMEINS

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_Fcdm_Keyf_Read_Custrq_Sls.
-- 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: PFKRCS

CREATE VIEW P_Fcdm_Keyf_Read_Custrq_Sls AS
SELECT
  vbap.matnr AS matnr,
  vbap.werks AS werks,
  vbap.werks AS berid,
  vbap.vbeln AS vbeln,
  vbep.posnr AS posnr,
  vbep.etenr AS etenr,
  vbap.lgort AS lgort,
  vbep.wmeng AS wmeng,
  vbep.meins AS meins
FROM vbak
INNER JOIN vbap ON /* join condition not captured in parsed metadata */
INNER JOIN vbep ON /* join condition not captured in parsed metadata */
;

Learn More