I_ProductMRPArea

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_ProductMRPArea.
-- 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: IPRODMRPAREA

CREATE VIEW I_ProductMRPArea AS
SELECT
  cast(matnr as productnumber preserving type) AS Product,
  werks AS MRPPlant,
  disgr AS MRPGroup,
  dismm AS MRPType,
  cast(dispo as pph_dispo preserving type) AS MRPController,
  cast(dispr as vdm_dispr preserving type) AS MRPProfile,
  mrppp AS MRPPlanningCalendar,
  sfty_stk_meth AS MRPSafetyStockMethod,
  cast(sobsl as pph_sobsl preserving type) AS MaterialProcurementProfile,
  cast(lgpro as vdm_lgpro preserving type) AS ProductionStorageLocation,
  cast(rwpro as pph_rwpro preserving type) AS RangeOfCoverageProfile,
  cast(shpro as pph_shpro preserving type) AS SafetyTimePeriodProfile,
  cast(shflg as pph_shflg preserving type) AS ProductSafetyTimeMRPRelevance,
  cast(ahdis as pph_ahdis preserving type) AS DependentRqmtMRPRelevance,
  lagpr AS StorageCostsPercentageCode,
  rdprf AS RoundingProfile,
  loekz AS IsMarkedForDeletion,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  plifz AS PlannedDeliveryDurationInDays,
  cast(fxhor as vdm_fxhor preserving type) AS PlanningTimeFenceInDays,
  takzt AS RqmtQtyRcptTaktTmeInWrkgDays,
  ausss AS AssemblyScrapPercent,
  _Product.BaseUnit AS BaseUnit,
  bstmi AS MinimumLotSizeQuantity,
  bstma AS MaximumLotSizeQuantity,
  mabst AS MaterialMaxStockLevelQuantity,
  eisbe AS SafetyStockQuantity,
  cast(bstrf as vdm_bstrf preserving type) AS LotSizeRoundingQuantity,
  minbe AS ReorderThresholdQuantity
FROM mdma
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON MRPPlant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant ON MRPPlant = _ProductPlant.Plant AND Product = _ProductPlant.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantMRP AS _ProductPlantMRPArea ON Product = _ProductPlantMRPArea.Product AND MRPArea = _ProductPlantMRPArea.MRPArea AND MRPPlant = _ProductPlantMRPArea.Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_MRPType AS _MRPType ON MRPType = _MRPType.MRPType  -- association [1..1]
LEFT OUTER JOIN I_MRPGroup AS _MRPGroup ON MRPGroup = _MRPGroup.MRPGroup AND MRPPlant = _MRPGroup.MRPPlant  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPResponsible ON MRPPlant = _MRPResponsible.Plant AND MRPController = _MRPResponsible.MRPController  -- association [0..1]
LEFT OUTER JOIN I_MRPProfile AS _MRPProfile ON MRPProfile = _MRPProfile.MRPProfile  -- association [0..1]
LEFT OUTER JOIN I_MRPPlanningPeriod AS _MRPPlanningCalendar ON MRPPlant = _MRPPlanningCalendar.MRPPlant AND MRPPlanningCalendar = _MRPPlanningCalendar.MRPPlanningCalendar  -- association [0..1]
LEFT OUTER JOIN I_MRPPlanningPeriod AS _MRPPlanningCycle ON MRPPlant = _MRPPlanningCycle.MRPPlant AND MRPPlanningCycle = _MRPPlanningCycle.MRPPlanningCalendar  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _ProductionStorageLocation ON MRPPlant = _ProductionStorageLocation.Plant AND ProductionStorageLocation = _ProductionStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _ExtProcmtStorageLocation ON MRPPlant = _ExtProcmtStorageLocation.Plant AND DfltStorLocForExtProcmt = _ExtProcmtStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MRPLotSizingProcedure AS _MRPLotSizingProcedure ON LotSizingProcedure = _MRPLotSizingProcedure.MaterialLotSizingProcedure  -- association [0..1]
LEFT OUTER JOIN I_MatlProcurementProfile AS _MatlProcurementProfile ON MaterialProcurementProfile = _MatlProcurementProfile.MaterialProcurementProfile AND MRPPlant = _MatlProcurementProfile.Plant  -- association [0..1]
LEFT OUTER JOIN I_RangeOfCoverageProfile AS _RangeOfCoverageProfile ON MRPPlant = _RangeOfCoverageProfile.Plant AND RangeOfCoverageProfile = _RangeOfCoverageProfile.RangeOfCoverageProfile  -- association [0..1]
LEFT OUTER JOIN I_SafetyTimePeriodProfile AS _SafetyTimePeriodProfile ON MRPPlant = _SafetyTimePeriodProfile.Plant AND SafetyTimePeriodProfile = _SafetyTimePeriodProfile.SafetyTimePeriodProfile  -- association [0..1]
LEFT OUTER JOIN I_ProdSafetyTimeMRPRelevance AS _ProdSafetyTimeMRPRelevance ON ProductSafetyTimeMRPRelevance = _ProdSafetyTimeMRPRelevance.ProductSafetyTimeMRPRelevance  -- association [0..1]
LEFT OUTER JOIN I_DepdntRqmtMRPRelevance AS _DependentRqmtMRPRelevance ON DependentRqmtMRPRelevance = _DependentRqmtMRPRelevance.DependentRqmtMRPRelevance  -- association [0..1]
LEFT OUTER JOIN I_StorageCostsPercentageCode AS _StorageCostsPercentage ON MRPPlant = _StorageCostsPercentage.Plant AND StorageCostsPercentageCode = _StorageCostsPercentage.StorageCostsPercentageCode  -- association [0..1]
LEFT OUTER JOIN I_MRPSafetyStockMethod AS _MRPSafetyStockMethod ON MRPSafetyStockMethod = _MRPSafetyStockMethod.MRPSafetyStockMethod  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..1]
;