C_Productplant

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 C_Productplant.
-- 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: CPRDPLANT

CREATE VIEW C_Productplant AS
SELECT
  Plant.Product AS Product,
  Plant.Plant AS Plant,
  Plant.ProductForEdit AS ProductForEdit,
  Plant.PlantForEdit AS PlantForEdit,
  Plant.ConfigurableProduct AS ConfigurableProduct,
  Plant.ProfileCode AS ProfileCode,
  Plant.ProfileValidityStartDate AS ProfileValidityStartDate,
  Plant.PeriodType AS PeriodType,
  Plant.FiscalYearVariant AS FiscalYearVariant,
  Plant.IsMarkedForDeletion AS IsMarkedForDeletion,
  Plant.PlantCategory AS PlantCategory,
  cast('' as lfmon) AS FiscalMonthCurrentPeriod,
  cast('' as lfgja) AS FiscalYearCurrentPeriod,
  Plant.GoodsIssueUnit AS GoodsIssueUnit,
  Plant.ProductCFOPCategory AS ProductCFOPCategory,
  Plant.ConfigurationSideEffect AS ConfigurationSideEffect,
  Plant.ProfitCenter AS ProfitCenter,
  Plant.IsBatchManagementRequired AS IsBatchManagementRequired,
  Plant.SerialNumberProfile AS SerialNumberProfile,
  Plant.IsNegativeStockAllowed AS IsNegativeStockAllowed,
  Plant.StockDeterminationGroup AS StockDeterminationGroup,
  Plant.ControllingArea AS ControllingArea,
  cast('' as boole_d) AS IsVariantConfigurationEnabled,
  Plant.ProductIsExciseTaxRelevant AS ProductIsExciseTaxRelevant,
  Plant.ProductMaxControlTemperature AS ProductMaxControlTemperature,
  Plant.ProductMinControlTemperature AS ProductMinControlTemperature,
  Plant.ProductControlTemperatureUnit AS ProductControlTemperatureUnit,
  Plant.ProductFreightGroup AS ProductFreightGroup,
  _ProdPlantInternationalTrade.CountryOfOrigin AS CountryOfOrigin,
  _ProdPlantInternationalTrade._CountryOfOrigin AS _CountryOfOrigin,
  _ProdPlantInternationalTrade._CountryName AS _CountryName
FROM I_ProductPlantWD AS Plant
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_Productstoragelocation AS _StorageLocation ON Product = _StorageLocation.Product AND Plant = _StorageLocation.Plant  -- association [0..*]
LEFT OUTER JOIN C_Productplantprocurment AS _PlantProcurement ON Product = _PlantProcurement.Product AND Plant = _PlantProcurement.Plant  -- association [0..1]
LEFT OUTER JOIN C_Productplantsales AS _PlantSales ON Product = _PlantSales.Product AND Plant = _PlantSales.Plant  -- association [0..1]
LEFT OUTER JOIN C_Productplantqtmanagement AS _PlantQualityMgmt ON Product = _PlantQualityMgmt.Product AND Plant = _PlantQualityMgmt.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductSupplyPlanning AS _MaterialLotSizingProcedure ON Product = _MaterialLotSizingProcedure.Product AND Plant = _MaterialLotSizingProcedure.Plant  -- association [1..1]
LEFT OUTER JOIN C_Productworkscheduling AS _GoodsMovementQuantity ON Product = _GoodsMovementQuantity.Product AND Plant = _GoodsMovementQuantity.Plant  -- association [0..1]
LEFT OUTER JOIN C_Productplantstorage AS _PlantStorage ON Product = _PlantStorage.Product AND Plant = _PlantStorage.Plant  -- association [0..1]
LEFT OUTER JOIN C_Productplantadvplan AS _AdvancedPlanning ON Product = _AdvancedPlanning.Product AND Plant = _AdvancedPlanning.Plant  -- association [0..1]
LEFT OUTER JOIN C_AdvncdPlngProductDmndPnlty AS _DemandPenalty ON Product = _DemandPenalty.Product AND Plant = _DemandPenalty.Plant  -- association [0..*]
LEFT OUTER JOIN C_ProductPlantIntlTrd AS _ProdPlantInternationalTrade ON Product = _ProdPlantInternationalTrade.Product AND Plant = _ProdPlantInternationalTrade.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductPlantCosting AS _ProductPlantCosting ON Product = _ProductPlantCosting.Product AND Plant = _ProductPlantCosting.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductPlantForecast AS _ProductPlantForecast ON Product = _ProductPlantForecast.Product AND Plant = _ProductPlantForecast.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductPlantMRP AS _MRPAreaData ON Product = _MRPAreaData.Product AND Plant = _MRPAreaData.Plant  -- association [1..*]
LEFT OUTER JOIN C_ProductBasicInfo AS _ConfigurableProduct ON ConfigurableProduct = _ConfigurableProduct.Product  -- association [0..1]
LEFT OUTER JOIN C_ProdPlntFcstParameters AS _ProdPlntFcstParameters ON Product = _ProdPlntFcstParameters.Product AND Plant = _ProdPlntFcstParameters.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProdPlantPurchaseTax AS _ProdPlantPurchaseTax ON Product = _ProdPlantPurchaseTax.Product AND Plant = _ProdPlantPurchaseTax.Plant  -- association [0..1]
LEFT OUTER JOIN C_Srlnmbrasgprftexttemp AS _SerialNumberProfileText ON SerialNumberProfile = _SerialNumberProfileText.SerialNumberProfile  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterName ON ProfitCenter = _ProfitCenterName.ProfitCenter AND ControllingArea = _ProfitCenterName.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _PlantCVH ON PlantForEdit = _PlantCVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductPlantESPP AS _ProdPlantESPP ON Product = _ProdPlantESPP.Product AND Plant = _ProdPlantESPP.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProdSrvcPartsLocProduct AS _ProdSrvcPartsLoc ON Product = _ProdSrvcPartsLoc.Product AND Plant = _ProdSrvcPartsLoc.Plant  -- association [0..1]
LEFT OUTER JOIN C_ProductPRTByInternalKey AS _ProdPlantPRT ON Product = _ProdPlantPRT.Product AND Plant = _ProdPlantPRT.Plant  -- association [0..1]
LEFT OUTER JOIN C_CommodityQuantityPurchasing AS _CmmdtyQuantityPurchasing ON Product = _CmmdtyQuantityPurchasing.Product AND Plant = _CmmdtyQuantityPurchasing.Plant  -- association [0..*]
LEFT OUTER JOIN C_CommodityStructuralQuantity AS _CommodityStructuralQuantity ON Product = _CommodityStructuralQuantity.Product AND Plant = _CommodityStructuralQuantity.Plant  -- association [0..*]
;