I_DemandDrivenExtdProduct

DDL: I_DEMANDDRIVENEXTDPRODUCT SQL: IDDEXTPRODUCT Type: view COMPOSITE Package: PPH_DD_VDM_STLM
40 Fields 1 Data Sources 2 Associations

Demand Driven Extended Product Details

I_DemandDrivenExtdProduct is a Composite CDS View that provides data about "Demand Driven Extended Product Details" in SAP S/4HANA. It reads from 1 data source (I_DemandDrivenProduct) and exposes 40 fields with key fields Material, Plant, MRPArea. It has 2 associations to related views. Part of development package PPH_DD_VDM_STLM.

Data Sources (1)

SourceAliasJoin Type
I_DemandDrivenProduct I_DemandDrivenProduct from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BufferedMaterialPlant1 _BufMatPlant $projection.Material = _BufMatPlant.Material and $projection.Plant = _BufMatPlant.Plant
[1..1] I_MaterialMRPArea _MatMRPAreaDets $projection.Material = _MatMRPAreaDets.Material and $projection.Plant = _MatMRPAreaDets.Plant and $projection.MRPArea = _MatMRPAreaDets.MRPArea

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDDEXTPRODUCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Demand Driven Extended Product Details view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
MRPControllerendasMRPController
MRPTypeendasMRPType
PlanningTimeFenceendasPlanningTimeFence
ConsumptionCode ConsumptionCode Value Indicator
ConsumptionMode ConsumptionMode Value Mode
ConsumptionValue ConsumptionValue
ProductConsumptionAmount ProductConsumptionAmount Value for ABC Analysis
Currency Currency Valuation Crcy
VariabilityCode VariabilityCode Variability Indicator
VariabilityMode VariabilityMode Variability Mode
VariabilityQuantity VariabilityQuantity Value from XYZ Analysis
VariabilityUnit VariabilityUnit Base Unit
ReplenishmentLeadTimeCode ReplenishmentLeadTimeCode DLT Indicator
ReplenishmentLeadTimeMode ReplenishmentLeadTimeMode DLT Mode
ProcurementType ProcurementType Procurement
ReplenishmentLeadTimeValue ReplenishmentLeadTimeValue Value from EFG Analysis
BOMUsageCode BOMUsageCode BOM Usage Indicator
BOMUsageMode BOMUsageMode BOM Usage Mode
BOMUsageValue BOMUsageValue Value from PQR Analysis
IndividualLeadTime IndividualLeadTime Individual Lead Time
DecoupledLeadTime DecoupledLeadTime Decoupled Lead Time
HorizonDaysInPast HorizonDaysInPast Horizon for past
HorizonDaysInFuture HorizonDaysInFuture Horizon for future
PastHorizonDLTMultiplierValue PastHorizonDLTMultiplierValue DLT Multiplier for Past
FutureHrznDLTMultiplierValue FutureHrznDLTMultiplierValue DLT Multiplier for Future
DDScopeProduct DDScopeProduct Scope for DD
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
IsBulkMaterial _BufMatPlant IsBulkMaterial Bulk material
IsPhantomItem _BufMatPlant IsPhantomItem Phantom item
BaseUnit _BufMatPlant BaseUnit Unit of Measure
ProductGroup _BufMatPlant ProductGroup Product Sold Group
_MatStatus _BufMatPlant _MatStatus
_MatMRPAreaDets _MatMRPAreaDets
_BufMatPlant _BufMatPlant

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_DemandDrivenExtdProduct.
-- 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: IDDEXTPRODUCT

CREATE VIEW I_DemandDrivenExtdProduct AS
SELECT
  Material,
  Plant,
  MRPArea,
  case when Plant != MRPArea then _MatMRPAreaDets.MRPController else _BufMatPlant.MRPController end as MRPController AS MRPControllerendasMRPController,
  case when Plant != MRPArea then _MatMRPAreaDets.MRPType else _BufMatPlant.MRPType end as MRPType AS MRPTypeendasMRPType,
  case when Plant != MRPArea then _MatMRPAreaDets.PlanningTimeFence else _BufMatPlant.PlanningTimeFence end as PlanningTimeFence AS PlanningTimeFenceendasPlanningTimeFence,
  ConsumptionCode,
  ConsumptionMode,
  ConsumptionValue,
  ProductConsumptionAmount,
  Currency,
  VariabilityCode,
  VariabilityMode,
  VariabilityQuantity,
  VariabilityUnit,
  ReplenishmentLeadTimeCode,
  ReplenishmentLeadTimeMode,
  ProcurementType,
  ReplenishmentLeadTimeValue,
  BOMUsageCode,
  BOMUsageMode,
  BOMUsageValue,
  IndividualLeadTime,
  DecoupledLeadTime,
  HorizonDaysInPast,
  HorizonDaysInFuture,
  PastHorizonDLTMultiplierValue,
  FutureHrznDLTMultiplierValue,
  DDScopeProduct,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  LastChangeDateTime,
  _BufMatPlant.IsBulkMaterial AS IsBulkMaterial,
  _BufMatPlant.IsPhantomItem AS IsPhantomItem,
  _BufMatPlant.BaseUnit AS BaseUnit,
  _BufMatPlant.ProductGroup AS ProductGroup,
  _BufMatPlant._MatStatus AS _MatStatus
FROM I_DemandDrivenProduct
LEFT OUTER JOIN I_BufferedMaterialPlant1 AS _BufMatPlant ON Material = _BufMatPlant.Material AND Plant = _BufMatPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MaterialMRPArea AS _MatMRPAreaDets ON Material = _MatMRPAreaDets.Material AND Plant = _MatMRPAreaDets.Plant AND MRPArea = _MatMRPAreaDets.MRPArea  -- association [1..1]
;

Learn More