I_Productplantadvplan

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_Productplantadvplan.
-- 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: IPRODPLNTADVPLN

CREATE VIEW I_Productplantadvplan AS
SELECT
  ActiveDocument.Product AS Product,
  ActiveDocument.Plant AS Plant,
  ActiveDocument.LocProdGoodsReceiptProcHours AS LocProdGoodsReceiptProcHours,
  ActiveDocument.LocProdGoodsIssueProcHours AS LocProdGoodsIssueProcHours,
  ActiveDocument.LocProdStorageCostValue AS LocProdStorageCostValue,
  ActiveDocument.ReplenishmentLeadTimeDays AS ReplenishmentLeadTimeDays,
  ActiveDocument.PPPlanningProcedure AS PPPlanningProcedure,
  ActiveDocument.ProdnPlngHeuristic AS ProdnPlngHeuristic,
  ActiveDocument.ProductPlanningPackage AS ProductPlanningPackage,
  ActiveDocument.SftyStkVioltnPnltyCostValue AS SftyStkVioltnPnltyCostValue,
  ActiveDocument.ProductAlertRelevanceCode AS ProductAlertRelevanceCode,
  ActiveDocument.ResourceNetworkName AS ResourceNetworkName,
  ActiveDocument.GRHandlingCapacityQuantity AS GRHandlingCapacityQuantity,
  ActiveDocument.GRHandlingCapacityUnit AS GRHandlingCapacityUnit,
  ActiveDocument.GIHandlingCapacityQuantity AS GIHandlingCapacityQuantity,
  ActiveDocument.GIHandlingCapacityUnit AS GIHandlingCapacityUnit,
  ActiveDocument.IsLocDependentShelfLifeUsed AS IsLocDependentShelfLifeUsed,
  ActiveDocument.ShelfLifeLocDependent AS ShelfLifeLocDependent,
  ActiveDocument.MaturationDurnLocDependent AS MaturationDurnLocDependent,
  ActiveDocument.RqdMinShelfLifeLocDepdnt AS RqdMinShelfLifeLocDepdnt,
  ActiveDocument.RqdMaxShelfLifeLocDepdnt AS RqdMaxShelfLifeLocDepdnt,
  ActiveDocument.LotSizeUnit AS LotSizeUnit,
  ActiveDocument.ReorderDaysSupplyInWorkDays AS ReorderDaysSupplyInWorkDays,
  ActiveDocument.TargetDaysSupplyInWorkDays AS TargetDaysSupplyInWorkDays,
  ActiveDocument.PlngCalendarPerdcLotSizing AS PlngCalendarPerdcLotSizing,
  ActiveDocument.RequirementStrategy AS RequirementStrategy,
  ActiveDocument.AlertThldForDlydRcptDurn AS AlertThldForDlydRcptDurn,
  ActiveDocument.AlertThldForEarlyRcptDurn AS AlertThldForEarlyRcptDurn,
  ActiveDocument.PeggingStrategy AS PeggingStrategy,
  ActiveDocument.IsAlertsInPeggingAvoided AS IsAlertsInPeggingAvoided,
  ActiveDocument.IsFixedPeggingForProdRetained AS IsFixedPeggingForProdRetained,
  ActiveDocument.BOMTypeExplosionUsed AS BOMTypeExplosionUsed,
  ActiveDocument.IsAdvancedPlanningUsed AS IsAdvancedPlanningUsed,
  ActiveDocument.ProductPlanningGroup AS ProductPlanningGroup,
  ActiveDocument.InteractiveSourcingProfile AS InteractiveSourcingProfile,
  ActiveDocument.ProductPriority AS ProductPriority,
  ActiveDocument.MinPassingAmtContinuousPegging AS MinPassingAmtContinuousPegging,
  ActiveDocument.ConversionRule AS ConversionRule,
  ActiveDocument.IsTotalQtyReceiptElement AS IsTotalQtyReceiptElement,
  ActiveDocument.IsTotalQtyStockElement AS IsTotalQtyStockElement,
  ActiveDocument.ProductProcurementCostsVal AS ProductProcurementCostsVal,
  ActiveDocument.GoodsReceiptHandlingCost AS GoodsReceiptHandlingCost,
  ActiveDocument.GoodsIssueHandlingCost AS GoodsIssueHandlingCost,
  ActiveDocument.ConsumptionOfStorageCapacity AS ConsumptionOfStorageCapacity,
  ActiveDocument.ConsumptionOfStorageCapUnit AS ConsumptionOfStorageCapUnit,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  ActiveDocument. GIPostingIsSynchronous AS GIPostingIsSynchronous
FROM P_ProductPlantBasic AS ActiveDocument
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN E_Productplant AS _ProdPlantAdvPlanExt ON Product = _ProdPlantAdvPlanExt.Product AND Plant = _ProdPlantAdvPlanExt.Plant  -- association [0..1]
LEFT OUTER JOIN I_OrderConversionRule AS _OrderConversionRule ON ConversionRule = _OrderConversionRule.ConversionRule  -- association [0..1]
LEFT OUTER JOIN I_OrderConversionRuleText AS _OrderConversionRuleText ON ConversionRule = _OrderConversionRuleText.ConversionRule  -- association [0..*]
LEFT OUTER JOIN I_InteractiveSourceProfile AS _InteractiveSourceProfile ON Plant = _InteractiveSourceProfile.Plant AND InteractiveSourcingProfile = _InteractiveSourceProfile.SourcingProfile  -- association [0..1]
LEFT OUTER JOIN I_IntactvSourceProfileText AS _IntactvSourceProfileText ON Plant = _IntactvSourceProfileText.Plant AND InteractiveSourcingProfile = _IntactvSourceProfileText.SourcingProfile  -- association [0..*]
LEFT OUTER JOIN I_ProductPlanningGroup AS _ProductPlanningGroup ON ProductPlanningGroup = _ProductPlanningGroup.ProductPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductPlanningGroupText AS _ProductPlanningGroupText ON ProductPlanningGroup = _ProductPlanningGroupText.ProductPlanningGroup  -- association [0..*]
LEFT OUTER JOIN I_ProposedStrategy AS _RequirementStrategy ON RequirementStrategy = _RequirementStrategy.ProposedStrategy  -- association [0..1]
LEFT OUTER JOIN I_ProposedStrategyText AS _RequirementStrategyText ON RequirementStrategy = _RequirementStrategyText.ProposedStrategy  -- association [0..*]
LEFT OUTER JOIN I_ProductHeuristic AS _ProdnPlngHeuristic ON ProdnPlngHeuristic = _ProdnPlngHeuristic.ProdnPlngHeuristic  -- association [0..1]
LEFT OUTER JOIN I_ProductHeuristicText AS _ProdnPlngHeuristicText ON ProdnPlngHeuristic = _ProdnPlngHeuristicText.ProdnPlngHeuristic  -- association [0..*]
LEFT OUTER JOIN I_ProductAlert AS _ProductAlertRelevanceCode ON ProductAlertRelevanceCode = _ProductAlertRelevanceCode.ProductAlert  -- association [0..1]
LEFT OUTER JOIN I_ProductAlertText AS _ProductAlertRelevanceCodeText ON ProductAlertRelevanceCode = _ProductAlertRelevanceCodeText.ProductAlert  -- association [0..*]
LEFT OUTER JOIN I_PlanningCalendarText AS _PlanningCalendarText ON PlngCalendarPerdcLotSizing = _PlanningCalendarText.PlngCalendarPerdcLotSizing  -- association [0..*]
LEFT OUTER JOIN I_PlanningPackage AS _ProductPlanningPackage ON ProductPlanningPackage = _ProductPlanningPackage.PlanningPackage  -- association [0..1]
LEFT OUTER JOIN I_PlanningPackageText AS _ProductPlanningPackageText ON ProductPlanningPackage = _ProductPlanningPackageText.PlanningPackage  -- association [0..*]
LEFT OUTER JOIN I_ProdnPlanningProcedure AS _PPPlanningProcedure ON PPPlanningProcedure = _PPPlanningProcedure.ProdnPlanningProcedure  -- association [0..1]
LEFT OUTER JOIN I_ProdnPlngProcedureText AS _PPPlanningProcedureText ON PPPlanningProcedure = _PPPlanningProcedureText.ProdnPlanningProcedure  -- association [0..*]
LEFT OUTER JOIN I_FixedPegging AS _FixedPegging ON IsFixedPeggingForProdRetained = _FixedPegging.FixedPegging  -- association [0..1]
LEFT OUTER JOIN I_FixedPeggingText AS _FixedPeggingText ON IsFixedPeggingForProdRetained = _FixedPeggingText.FixedPegging  -- association [0..*]
LEFT OUTER JOIN I_PeggingStrategy AS _PeggingStrategy ON PeggingStrategy = _PeggingStrategy.PeggingStrategy  -- association [0..1]
LEFT OUTER JOIN I_PeggingStrategyText AS _PeggingStrategyText ON PeggingStrategy = _PeggingStrategyText.PeggingStrategy  -- association [0..*]
LEFT OUTER JOIN I_PlanExplosion AS _PlanExplosion ON BOMTypeExplosionUsed = _PlanExplosion.PlanExplosionType  -- association [0..1]
LEFT OUTER JOIN I_PlanExplosionText AS _PlanExplosionText ON BOMTypeExplosionUsed = _PlanExplosionText.PlanExplosionType  -- association [0..*]
LEFT OUTER JOIN I_ProductPlantAdvPlanEnhanced AS _ProductPlantAdvPlanEnhanced ON Product = _ProductPlantAdvPlanEnhanced.Product AND Plant = _ProductPlantAdvPlanEnhanced.Plant  -- association [0..1]
LEFT OUTER JOIN I_AdvancedPlanningStatus AS _AdvancedPlanningStatus ON Product = _AdvancedPlanningStatus.Product AND Plant = _AdvancedPlanningStatus.LocationExternalID AND _AdvancedPlanningStatus.MaterialPlanningStatusAppl = 'PPS' AND ( _AdvancedPlanningStatus.LocationType = '1001' OR _AdvancedPlanningStatus.LocationType = '1002' )  -- association [0..1]
;