I_PlndIndepRqmtSalesFcst

DDL: I_PLNDINDEPRQMTSALESFCST SQL: IPIRSFP Type: view COMPOSITE Package: PPH_FORECAST_DEMAND_MASS
20 Fields 3 Data Sources

Sales PIR and Forecast for materials

I_PlndIndepRqmtSalesFcst is a Composite CDS View that provides data about "Sales PIR and Forecast for materials" in SAP S/4HANA. It reads from 3 data sources (I_PlndIndepRqmtItemPlanIndTP, I_SalesForecast, I_PlndIndepRqmtSalesMnthWk) and exposes 20 fields with key fields Product, Plant, MRPArea, PlndIndepRqmtType, PlndIndepRqmtVersion. Part of development package PPH_FORECAST_DEMAND_MASS.

Data Sources (3)

SourceAliasJoin Type
I_PlndIndepRqmtItemPlanIndTP _Material left_outer
I_SalesForecast forecast left_outer
I_PlndIndepRqmtSalesMnthWk sales from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPIRSFP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Sales PIR and Forecast for materials view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Product I_PlndIndepRqmtSalesMnthWk Product Product Sold
KEY Plant I_PlndIndepRqmtSalesMnthWk Plant Valuation Area
KEY MRPArea I_PlndIndepRqmtSalesMnthWk MRPArea MRP Area
KEY PlndIndepRqmtType I_PlndIndepRqmtSalesMnthWk PlndIndepRqmtType
KEY PlndIndepRqmtVersion I_PlndIndepRqmtSalesMnthWk PlndIndepRqmtVersion
KEY RequirementPlan I_PlndIndepRqmtSalesMnthWk RequirementPlan Requirements Plan
KEY RequirementSegment I_PlndIndepRqmtSalesMnthWk RequirementSegment Req. Segment
KEY PlndIndepRqmtPeriod I_PlndIndepRqmtSalesMnthWk PlndIndepRqmtPeriod Year Month
KEY PeriodType I_PlndIndepRqmtSalesMnthWk PeriodType PeriodIndicator
PlndIndepRqmtPeriodStartDate I_PlndIndepRqmtItemPlanIndTP PlndIndepRqmtPeriodStartDate
PlndIndepRqmtInternalID I_PlndIndepRqmtItemPlanIndTP PlndIndepRqmtInternalID
WorkingDayDate I_PlndIndepRqmtItemPlanIndTP WorkingDayDate
PlannedQuantity I_PlndIndepRqmtItemPlanIndTP PlannedQuantity
WithdrawalQuantity I_PlndIndepRqmtItemPlanIndTP WithdrawalQuantity
LastChangedByUser I_PlndIndepRqmtItemPlanIndTP LastChangedByUser User Name
LastChangeDate I_PlndIndepRqmtItemPlanIndTP LastChangeDate Time Stamp
PlndIndepRqmtLastChgdDateTime I_PlndIndepRqmtItemPlanIndTP PlndIndepRqmtLastChgdDateTime
UnitOfMeasure I_PlndIndepRqmtSalesMnthWk UnitOfMeasure Unit Protected Qty
SalesVolumeQuantity I_PlndIndepRqmtSalesMnthWk SalesVolumeQuantity
MaterialBaseUnit

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 I_PlndIndepRqmtSalesFcst.
-- 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: IPIRSFP

CREATE VIEW I_PlndIndepRqmtSalesFcst AS
SELECT
  sales.Product AS Product,
  sales.Plant AS Plant,
  sales.MRPArea AS MRPArea,
  sales.PlndIndepRqmtType AS PlndIndepRqmtType,
  sales.PlndIndepRqmtVersion AS PlndIndepRqmtVersion,
  sales.RequirementPlan AS RequirementPlan,
  sales.RequirementSegment AS RequirementSegment,
  sales.PlndIndepRqmtPeriod AS PlndIndepRqmtPeriod,
  sales.PeriodType AS PeriodType,
  _Material.PlndIndepRqmtPeriodStartDate AS PlndIndepRqmtPeriodStartDate,
  _Material.PlndIndepRqmtInternalID AS PlndIndepRqmtInternalID,
  _Material.WorkingDayDate AS WorkingDayDate,
  _Material.PlannedQuantity AS PlannedQuantity,
  _Material.WithdrawalQuantity AS WithdrawalQuantity,
  _Material.LastChangedByUser AS LastChangedByUser,
  _Material.LastChangeDate AS LastChangeDate,
  _Material.PlndIndepRqmtLastChgdDateTime AS PlndIndepRqmtLastChgdDateTime,
  sales.UnitOfMeasure AS UnitOfMeasure,
  sales.SalesVolumeQuantity AS SalesVolumeQuantity,
  cast ('%' as meins) AS MaterialBaseUnit
FROM I_PlndIndepRqmtSalesMnthWk AS sales
LEFT OUTER JOIN I_PlndIndepRqmtItemPlanIndTP AS _Material ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesForecast AS forecast ON /* join condition not captured in parsed metadata */
;

Learn More