I_ProductPlantWD

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_ProductPlantWD.
-- 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: IPRDPLANTWD

CREATE VIEW I_ProductPlantWD AS
SELECT
  Plant.Product AS Product,
  Plant.Plant AS Plant,
  Plant.Product AS ProductForEdit,
  Plant.Plant AS PlantForEdit,
  Plant.ProfileCode AS ProfileCode,
  Plant.ProfileValidityStartDate AS ProfileValidityStartDate,
  Plant.FiscalYearVariant AS FiscalYearVariant,
  Plant.PeriodType AS PeriodType,
  Plant.ProfitCenter AS ProfitCenter,
  Plant.IsMarkedForDeletion AS IsMarkedForDeletion,
  Plant.ConfigurableProduct AS ConfigurableProduct,
  Plant.StockDeterminationGroup AS StockDeterminationGroup,
  Plant.IsBatchManagementRequired AS IsBatchManagementRequired,
  Plant.SerialNumberProfile AS SerialNumberProfile,
  Plant.IsNegativeStockAllowed AS IsNegativeStockAllowed,
  Plant.IsInternalBatchManaged AS IsInternalBatchManaged,
  Plant.ProductCFOPCategory AS ProductCFOPCategory,
  Plant.ProductIsExciseTaxRelevant AS ProductIsExciseTaxRelevant,
  cast('' as kokrs) AS ControllingArea,
  Reference.SalesOrganization AS SalesOrganization,
  Reference.DistributionChannel AS DistributionChannel,
  Reference.PlantCategory AS PlantCategory,
  Reference.ReferenceDistributionCenter AS ReferenceDistributionCenter,
  Reference.ReferenceStore AS ReferenceStore,
  Reference.IsReferenceDistributionCenter AS IsReferenceDistributionCenter,
  Reference.IsReferenceStore AS IsReferenceStore,
  cast('' as vchclf_side_effect_data) AS ConfigurationSideEffect,
  Plant.GoodsIssueUnit AS GoodsIssueUnit,
  Plant.DistrCntrDistributionProfile AS DistrCntrDistributionProfile,
  Plant.ProductMaxControlTemperature AS ProductMaxControlTemperature,
  Plant.ProductMinControlTemperature AS ProductMinControlTemperature,
  Plant.ProductControlTemperatureUnit AS ProductControlTemperatureUnit,
  Plant.MaterialFreightGroup AS ProductFreightGroup,
  Plant._ProductFreightGroup AS _ProductFreightGroup,
  Plant._ProductFreightGroupText AS _ProductFreightGroupText
FROM I_ProductPlantBasic AS Plant
LEFT OUTER JOIN P_PlantReferences AS Reference ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_Productplant AS _ActiveExtension ON Product = _ActiveExtension.Product AND Plant = _ActiveExtension.Plant  -- association [0..1]
LEFT OUTER JOIN E_Productplant AS _DraftExtension ON Product = _DraftExtension.Product AND Plant = _DraftExtension.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductStorageLocationWD AS _StorageLocation ON Product = _StorageLocation.Product AND Plant = _StorageLocation.Plant  -- association [0..*]
LEFT OUTER JOIN I_Productplantprocurementwd AS _PlantProcurement ON Product = _PlantProcurement.Product AND Plant = _PlantProcurement.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductplantsalesWD AS _PlantSales ON Product = _PlantSales.Product AND Plant = _PlantSales.Plant  -- association [0..1]
LEFT OUTER JOIN I_Productplantqtmanagementwd AS _PlantQualityMgmt ON Product = _PlantQualityMgmt.Product AND Plant = _PlantQualityMgmt.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanningWD AS _MaterialLotSizingProcedure ON Product = _MaterialLotSizingProcedure.Product AND Plant = _MaterialLotSizingProcedure.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantForecastTP AS _ProductPlantForecast ON Product = _ProductPlantForecast.Product AND Plant = _ProductPlantForecast.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductWorkSchedulingWD AS _GoodsMovementQuantity ON Product = _GoodsMovementQuantity.Product AND Plant = _GoodsMovementQuantity.Plant  -- association [0..1]
LEFT OUTER JOIN I_Productplantstoragewd AS _PlantStorage ON Product = _PlantStorage.Product AND Plant = _PlantStorage.Plant  -- association [0..1]
LEFT OUTER JOIN I_Productplantadvplanwd AS _AdvancedPlanning ON Product = _AdvancedPlanning.Product AND Plant = _AdvancedPlanning.Plant  -- association [0..1]
LEFT OUTER JOIN I_AdvncdPlngProductDmndPnltyTP AS _DemandPenalty ON Product = _DemandPenalty.Product AND Plant = _DemandPenalty.Plant  -- association [0..*]
LEFT OUTER JOIN I_ProductPlantMRPTP AS _MRPAreaData ON Product = _MRPAreaData.Product AND Plant = _MRPAreaData.Plant  -- association [1..*]
LEFT OUTER JOIN I_ProductPlantIntlTrdTP AS _ProdPlantInternationalTrade ON Product = _ProdPlantInternationalTrade.Product AND Plant = _ProdPlantInternationalTrade.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantCostingTP AS _ProductPlantCosting ON Product = _ProductPlantCosting.Product AND Plant = _ProductPlantCosting.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProdReplnmtRecipientTP AS _ProductReplnmtRecipient ON Product = _ProductReplnmtRecipient.Product AND Plant = _ProductReplnmtRecipient.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProdPlntFcstParametersTP AS _ProdPlntFcstParameters ON Product = _ProdPlntFcstParameters.Product AND Plant = _ProdPlntFcstParameters.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProdPlantPurchaseTaxTP AS _ProdPlantPurchaseTax ON Product = _ProdPlantPurchaseTax.Product AND Plant = _ProdPlantPurchaseTax.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantESPPTP AS _ProdPlantESPP ON Product = _ProdPlantESPP.Product AND Plant = _ProdPlantESPP.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProdSrvcPartsLocProductTP AS _ProdSrvcPartsLoc ON Product = _ProdSrvcPartsLoc.Product AND Plant = _ProdSrvcPartsLoc.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPRTByInternalKeyTP AS _ProdPlantPRT ON Product = _ProdPlantPRT.Product AND Plant = _ProdPlantPRT.Plant  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyQuantityPurchasingTP AS _CmmdtyQuantityPurchasing ON Product = _CmmdtyQuantityPurchasing.Product AND Plant = _CmmdtyQuantityPurchasing.Plant  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyStructuralQuantityTP AS _CommodityStructuralQuantity ON Product = _CommodityStructuralQuantity.Product AND Plant = _CommodityStructuralQuantity.Plant  -- association [0..*]
;