P_ProductMasterLeadTime

DDL: P_PRODUCTMASTERLEADTIME SQL: PPRDMASTERLT Type: view CONSUMPTION
6 Fields 5 Data Sources

Lead Time Details from Product Master

P_ProductMasterLeadTime is a Consumption CDS View that provides data about "Lead Time Details from Product Master" in SAP S/4HANA. It reads from 5 data sources (I_BufferedMaterialPlant, I_BufferedMaterialPlant, I_MaterialMRPArea, I_MatlProcurementProfile, I_MatlProcurementProfile) and exposes 6 fields with key fields Material, ProductionPlant, MRPArea, ProductionPlant, MRPArea.

Data Sources (5)

SourceAliasJoin Type
I_BufferedMaterialPlant _marc from
I_BufferedMaterialPlant _marc union_all
I_MaterialMRPArea _mdma inner
I_MatlProcurementProfile _prfl left_outer
I_MatlProcurementProfile _prfl left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPRDMASTERLT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Lead Time Details from Product Master view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Material I_BufferedMaterialPlant Material Vehicle Model
KEY ProductionPlant I_BufferedMaterialPlant Plant Valuation Area
KEY MRPArea I_MaterialMRPArea MRPArea Valuation Area
MaterialasMaterial
KEY ProductionPlant I_BufferedMaterialPlant Plant Valuation Area
KEY MRPArea I_BufferedMaterialPlant Plant Valuation Area

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_ProductMasterLeadTime.
-- 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: PPRDMASTERLT

CREATE VIEW P_ProductMasterLeadTime AS
SELECT
  _marc.Material AS Material,
  _marc.Plant AS ProductionPlant,
  _mdma.MRPArea AS MRPArea,
  case when _marc.ProcurementType = 'F' then case when _mdma.PlannedDeliveryDurationInDays is not null and _mdma.PlannedDeliveryDurationInDays <> 0 then _mdma.PlannedDeliveryDurationInDays else _marc.PlannedDeliveryDurationInDays end else _marc.MaterialPlannedProductionDurn end as IndividualLeadTime AS MaterialasMaterial
FROM I_BufferedMaterialPlant AS _marc
INNER JOIN I_MaterialMRPArea AS _mdma ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlProcurementProfile AS _prfl ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_BufferedMaterialPlant
;

Learn More