I_ProductPlantMRPTP

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_ProductPlantMRPTP.
-- 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: IPRDPLNTMRPTP

CREATE VIEW I_ProductPlantMRPTP AS
SELECT
  MRPData.Product AS Product,
  MRPData.MRPArea AS MRPArea,
  MRPData.Plant AS Plant,
  MRPData.Product AS ProductForEdit,
  MRPData.Plant AS PlantForEdit,
  MRPData.MRPArea AS MRPAreaForEdit,
  MRPData.MRPType AS MRPType,
  MRPData.MRPResponsible AS MRPResponsible,
  MRPData.MRPGroup AS MRPGroup,
  MRPData.ReorderThresholdQuantity AS ReorderThresholdQuantity,
  MRPData.PlanAndOrderDayDetermination AS PlanAndOrderDayDetermination,
  MRPData.PlanningTimeFence AS PlanningTimeFence,
  MRPData.LotSizingProcedure AS LotSizingProcedure,
  MRPData.RoundingProfile AS RoundingProfile,
  MRPData.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  MRPData.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  MRPData.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  MRPData.MaximumStockQuantity AS MaximumStockQuantity,
  MRPData.AssemblyScrapPercent AS AssemblyScrapPercent,
  MRPData.ProcurementSubType AS ProcurementSubType,
  MRPData.StorageLocation AS StorageLocation,
  MRPData.DfltStorageLocationExtProcmt AS DfltStorageLocationExtProcmt,
  MRPData.MRPPlanningCalendar AS MRPPlanningCalendar,
  MRPData.SafetyStockQuantity AS SafetyStockQuantity,
  MRPData.RangeOfCvrgPrflCode AS RangeOfCvrgPrflCode,
  MRPData.SafetyDuration AS SafetyDuration,
  MRPData.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  MRPData.LotSizeIndependentCosts AS LotSizeIndependentCosts,
  MRPData.StorageCostsPercentageCode AS StorageCostsPercentageCode,
  MRPData.SrvcLvl AS SrvcLvl,
  MRPData.IsMarkedForDeletion AS IsMarkedForDeletion,
  MRPData.PerdPrflForSftyTme AS PerdPrflForSftyTme,
  MRPData.DependentRqmtMRPRelevance AS DependentRqmtMRPRelevance,
  MRPData.MaintenanceStatusName AS MaintenanceStatusName,
  MRPData.ProductSafetyTimeMRPRelevance AS ProductSafetyTimeMRPRelevance,
  MRPData.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  MRPData.IsPlannedDeliveryTime AS IsPlannedDeliveryTime,
  MRPData.CreationDate AS CreationDate,
  MRPData.RqmtQtyRcptTaktTmeInWrkgDays AS RqmtQtyRcptTaktTmeInWrkgDays,
  MRPData.PPPlanningProcedure AS PPPlanningProcedure,
  MRPData.ProdnPlngHeuristic AS ProdnPlngHeuristic,
  MRPData.ProductPlanningPackage AS ProductPlanningPackage,
  MRPData.ProductPlanningGroup AS ProductPlanningGroup,
  MRPData.AdvncdPlngPPDSHorizonInDays AS AdvncdPlngPPDSHorizonInDays,
  MRPData.LotSizeUnit AS LotSizeUnit,
  MRPData.ReorderDaysSupplyInWorkDays AS ReorderDaysSupplyInWorkDays,
  cast ( cast ( 0 as abap.quan(6,2) ) as cmd_prd_reord_dur preserving type ) AS ReorderDaysSupplyInWorkDayCalc,
  MRPData.TargetDaysSupplyInWorkDays AS TargetDaysSupplyInWorkDays,
  cast ( cast ( 0 as abap.quan(6,2) ) as cmd_prd_target_dur preserving type ) AS TargetDaysSupplyInWorkDaysCalc,
  MRPData.PlngCalendarPerdcLotSizing AS PlngCalendarPerdcLotSizing,
  MRPData.LocProdGoodsReceiptProcHours AS LocProdGoodsReceiptProcHours,
  cast ( cast ( 0 as abap.quan(6,2) ) as cmd_prd_good_rcpt_proc_time preserving type ) AS LocProdGoodsRcptProcHoursCalc,
  MRPData.LocProdGoodsIssueProcHours AS LocProdGoodsIssueProcHours,
  cast ( cast ( 0 as abap.quan(6,2) ) as cmd_prd_good_issue_proc_time preserving type ) AS LocProdGoodsIssueProcHoursCalc,
  MRPData.GRHandlingCapacityQuantity AS GRHandlingCapacityQuantity,
  MRPData.GRHandlingCapacityUnit AS GRHandlingCapacityUnit,
  MRPData.GIHandlingCapacityQuantity AS GIHandlingCapacityQuantity,
  MRPData.GIHandlingCapacityUnit AS GIHandlingCapacityUnit,
  MRPData.SrvcPartsThroughputTimeDurn AS SrvcPartsThroughputTimeDurn,
  cast ( cast ( 0 as abap.quan(6,2) ) as cmd_prd_srvcprts_thruput_time preserving type ) AS SrvcPartsThroughputTmeDurnCalc,
  MRPData.ParLocSafetyStockQuantity AS ParLocSafetyStockQuantity,
  MRPData.VCLSafetyStockQuantity AS VCLSafetyStockQuantity,
  MRPData.VCLParLocSafetyStockQuantity AS VCLParLocSafetyStockQuantity,
  MRPData.VCLReorderPointQuantity AS VCLReorderPointQuantity,
  MRPData.VCLMaximumStockQuantity AS VCLMaximumStockQuantity,
  MRPData.CostFactorForStockHoldingVal AS CostFactorForStockHoldingVal,
  MRPData.ProductProcurementCostsVal AS ProductProcurementCostsVal,
  MRPData.GoodsReceiptHandlingCost AS GoodsReceiptHandlingCost,
  MRPData.GoodsIssueHandlingCost AS GoodsIssueHandlingCost,
  MRPData.ConsumptionOfStorageCapacity AS ConsumptionOfStorageCapacity,
  MRPData.ConsumptionOfStorageCapUnit AS ConsumptionOfStorageCapUnit,
  MRPData.BaseUnit AS BaseUnit,
  MRPData.Currency AS Currency,
  MRPData.MRPSafetyStockMethod AS MRPSafetyStockMethod,
  MRPData.MaxDaysOfSupplyIsActive AS MaxDaysOfSupplyIsActive,
  MRPData.MaxDaysOfSupplyPenaltyAmount AS MaxDaysOfSupplyPenaltyAmount,
  MRPData.AdvncdPlngSftyStkMeth AS AdvncdPlngSftyStkMeth,
  MRPData.AdvncdPlngTgtStkLvlMeth AS AdvncdPlngTgtStkLvlMeth,
  MRPData.SftyStkMethIsAutomlyDtmnd AS SftyStkMethIsAutomlyDtmnd,
  MRPData.PeriodFactorIsUsed AS PeriodFactorIsUsed,
  MRPData.AdvncdPlngPeriodFactorValue AS AdvncdPlngPeriodFactorValue,
  MRPData.TimeDepdntStkLvlPerdFactorVal AS TimeDepdntStkLvlPerdFactorVal,
  MRPData.LocProdStorageCostValue AS LocProdStorageCostValue,
  MRPData.SftyStkVioltnPnltyCostValue AS SftyStkVioltnPnltyCostValue
FROM I_ProductPlantMRP AS MRPData
LEFT OUTER JOIN I_AdvncdPlngProdMRPDmndPnltyTP AS _DemandPenalty ON Product = _DemandPenalty.Product AND MRPArea = _DemandPenalty.MRPArea AND Plant = _DemandPenalty.Plant  -- association [0..*]
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantWD AS _Plant ON Product = _Plant.Product AND Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProdSrvcPartsLocProductMRPTP AS _ProdSrvcPartsLocProductMRP ON Product = _ProdSrvcPartsLocProductMRP.Product AND MRPArea = _ProdSrvcPartsLocProductMRP.MRPArea AND Plant = _ProdSrvcPartsLocProductMRP.Plant  -- association [1..1]
;