P_DailyWeeklyMnthlyPIRByDate

DDL: P_DAILYWEEKLYMNTHLYPIRBYDATE SQL: PDWMPIRBYDATE Type: view COMPOSITE Package: PPH_DD_VDM_STLM
20 Fields 3 Data Sources

P_DailyWeeklyMnthlyPIRByDate

P_DailyWeeklyMnthlyPIRByDate is a Composite CDS View that provides data about "P_DailyWeeklyMnthlyPIRByDate" in SAP S/4HANA. It reads from 3 data sources (I_CalendarDate, P_MatlAvgDailyUsgeCalHrznDates, P_DailyWeeklyMnthlyPIR) and exposes 20 fields with key fields Product, Plant, MRPArea. Part of development package PPH_DD_VDM_STLM.

Data Sources (3)

SourceAliasJoin Type
I_CalendarDate _CalendarDate left_outer
P_MatlAvgDailyUsgeCalHrznDates _ChartHorizonCalc left_outer
P_DailyWeeklyMnthlyPIR _PlndIndReq from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PDWMPIRBYDATE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Product P_DailyWeeklyMnthlyPIR Product Product Sold
KEY Plant P_DailyWeeklyMnthlyPIR Plant Valuation Area
KEY MRPArea P_DailyWeeklyMnthlyPIR MRPArea MRP Area
PlndIndepRqmtType PlndIndepRqmtType
PostingDate I_CalendarDate CalendarDate Calendar Date
PeriodType PeriodType PeriodIndicator
StartDate P_DailyWeeklyMnthlyPIR StartDate Valid From
EndDate P_DailyWeeklyMnthlyPIR EndDate Term to
QuantityInBaseUnit QuantityInBaseUnit Quantity
MaterialBaseUnit P_DailyWeeklyMnthlyPIR UnitOfMeasure Unit Protected Qty
TotalNoOfDays P_MatlAvgDailyUsgeCalHrznDates TotalNoOfDays
MaterialDocumentYear
MaterialDocument
MaterialDocumentItem
MaterialDocumentRecordType
StorageLocation
Supplier
MRPAreaCategory
SDate P_MatlAvgDailyUsgeCalHrznDates StartDate Valid From
EDate P_MatlAvgDailyUsgeCalHrznDates EndDate Term to

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_DailyWeeklyMnthlyPIRByDate.
-- 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: PDWMPIRBYDATE

CREATE VIEW P_DailyWeeklyMnthlyPIRByDate AS
SELECT
  _PlndIndReq.Product AS Product,
  _PlndIndReq.Plant AS Plant,
  _PlndIndReq.MRPArea AS MRPArea,
  PlndIndepRqmtType,
  _CalendarDate.CalendarDate AS PostingDate,
  PeriodType,
  _PlndIndReq.StartDate AS StartDate,
  _PlndIndReq.EndDate AS EndDate,
  QuantityInBaseUnit,
  _PlndIndReq.UnitOfMeasure AS MaterialBaseUnit,
  _ChartHorizonCalc.TotalNoOfDays AS TotalNoOfDays,
  cast('' as abap.char(10)) AS MaterialDocumentYear,
  cast('' as abap.char(10)) AS MaterialDocument,
  cast('' as abap.char(10)) AS MaterialDocumentItem,
  cast('' as abap.char(10)) AS MaterialDocumentRecordType,
  cast('' as abap.char(10)) AS StorageLocation,
  cast('' as abap.char(10)) AS Supplier,
  cast('' as abap.char(10)) AS MRPAreaCategory,
  _ChartHorizonCalc.StartDate AS SDate,
  _ChartHorizonCalc.EndDate AS EDate
FROM P_DailyWeeklyMnthlyPIR AS _PlndIndReq
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MatlAvgDailyUsgeCalHrznDates AS _ChartHorizonCalc ON /* join condition not captured in parsed metadata */
;

Learn More