I_DemandDrivenMaterialData

DDL: I_DEMANDDRIVENMATERIALDATA SQL: IDDMATDATA Type: view COMPOSITE Package: PPH_DD_VDM_STLM
55 Fields 2 Data Sources 1 Associations

Data related to materials

I_DemandDrivenMaterialData is a Composite CDS View that provides data about "Data related to materials" in SAP S/4HANA. It reads from 2 data sources (I_BufferedMaterialPlant1, I_MaterialMRPArea) and exposes 55 fields with key fields Material, Plant, MRPArea, Plant, MRPArea. It has 1 association to related views. Part of development package PPH_DD_VDM_STLM.

Data Sources (2)

SourceAliasJoin Type
I_BufferedMaterialPlant1 _marc union_all
I_MaterialMRPArea _mdma from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BufferedMaterialPlant1 _MaterialPlant $projection.Material = _MaterialPlant.Material and $projection.Plant = _MaterialPlant.Plant

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IDDMATDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data related to materials view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY Material I_MaterialMRPArea Material Vehicle Model
KEY Plant I_MaterialMRPArea Plant Valuation Area
KEY MRPArea I_MaterialMRPArea MRPArea Valuation Area
MRPGroup MRPGroup MRP Group
MRPType MRPType MRP Type
MRPController MRPController MRP Controller
LotSizingProcedure LotSizingProcedure Lot Sizing Procedure
MinimumLotSizeQuantity MinimumLotSizeQuantity Min. Lot Size
PlanningTimeFence PlanningTimeFence Plng time fence
MaterialMaxStockLevelQuantity MaterialMaxStockLevelQuantity Max.Stock Level
ReorderThresholdQuantity ReorderThresholdQuantity Reorder Point
SafetyStockQuantity SafetyStockQuantity Safety stock
IsMRPAreaExisting
PurchasingGroup _MaterialPlant PurchasingGroup Purchasing Group
GoodsReceiptDuration _MaterialPlant GoodsReceiptDuration GR proc. time
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays Plnd dely time
IsPlannedDeliveryTime IsPlannedDeliveryTime Consider PlDelTime
MaximumLotSizeQuantity MaximumLotSizeQuantity Max. Lot Size
LotSizeRoundingQuantity LotSizeRoundingQuantity Rounding value
RoundingProfile RoundingProfile Rnding Profile
DeletionIndicator DeletionIndicator Deletion Ind.
MaterialProcurementProfile MaterialProcurementProfile Special Procur.
DfltStorLocForExtProcmt
IsBulkMaterial _MaterialPlant IsBulkMaterial Bulk material
IsPhantomItem _MaterialPlant IsPhantomItem Phantom item
_MatStatus _MaterialPlant _MatStatus
_Material _Material
MaterialasMaterial
KEY Plant I_BufferedMaterialPlant1 Plant Valuation Area
KEY MRPArea I_BufferedMaterialPlant1 Plant Valuation Area
MRPGroup MRPGroup MRP Group
MRPType MRPType MRP Type
MRPController MRPController MRP Controller
LotSizingProcedure LotSizingProcedure Lot Sizing Procedure
MinimumLotSizeQuantity MinimumLotSizeQuantity Min. Lot Size
PlanningTimeFence PlanningTimeFence Plng time fence
MaterialMaxStockLevelQuantity MaterialMaxStockLevelQuantity Max.Stock Level
ReorderThresholdQuantity ReorderThresholdQuantity Reorder Point
SafetyStockQuantity SafetyStockQuantity Safety stock
IsMRPAreaExisting IsMRPAreaExisting
PurchasingGroup PurchasingGroup Purchasing Group
GoodsReceiptDuration GoodsReceiptDuration GR proc. time
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays Plnd dely time
IsPlannedDeliveryTime Consider PlDelTime
MaximumLotSizeQuantity MaximumLotSizeQuantity Max. Lot Size
LotSizeRoundingQuantity LotSizeRoundingQuantity Rounding value
RoundingProfile RoundingProfile Rnding Profile
DeletionIndicator Deletion Ind.
MaterialProcurementProfile MaterialProcurementProfile Special Procur.
DfltStorLocForExtProcmt DfltStorLocForExtProcmt
IsBulkMaterial I_BufferedMaterialPlant1 IsBulkMaterial Bulk material
IsPhantomItem I_BufferedMaterialPlant1 IsPhantomItem Phantom item
_MatStatus I_BufferedMaterialPlant1 _MatStatus
_Material _Material
_MRPType _MRPType

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_DemandDrivenMaterialData.
-- 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: IDDMATDATA

CREATE VIEW I_DemandDrivenMaterialData AS
SELECT
  _mdma.Material AS Material,
  _mdma.Plant AS Plant,
  _mdma.MRPArea AS MRPArea,
  MRPGroup,
  MRPType,
  MRPController,
  LotSizingProcedure,
  MinimumLotSizeQuantity,
  PlanningTimeFence,
  MaterialMaxStockLevelQuantity,
  ReorderThresholdQuantity,
  SafetyStockQuantity,
  cast ( 'X' as abap.char(1)) AS IsMRPAreaExisting,
  _MaterialPlant.PurchasingGroup AS PurchasingGroup,
  _MaterialPlant.GoodsReceiptDuration AS GoodsReceiptDuration,
  PlannedDeliveryDurationInDays,
  IsPlannedDeliveryTime,
  MaximumLotSizeQuantity,
  LotSizeRoundingQuantity,
  RoundingProfile,
  DeletionIndicator,
  MaterialProcurementProfile,
  cast('' as lgfsb) AS DfltStorLocForExtProcmt,
  _MaterialPlant.IsBulkMaterial AS IsBulkMaterial,
  _MaterialPlant.IsPhantomItem AS IsPhantomItem,
  _MaterialPlant._MatStatus AS _MatStatus
FROM I_MaterialMRPArea AS _mdma
LEFT OUTER JOIN I_BufferedMaterialPlant1 AS _MaterialPlant ON Material = _MaterialPlant.Material AND Plant = _MaterialPlant.Plant  -- association [1..1]
-- UNION ALL with additional select branch(es): I_BufferedMaterialPlant1
;

Learn More