C_ProductStoreCosting

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_ProductStoreCosting.
-- 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: CPRDSTRCSTNG

CREATE VIEW C_ProductStoreCosting AS
SELECT
  Costing.Product AS Product,
  Costing.Plant AS Plant,
  Costing.PlantForEdit AS PlantForEdit,
  Costing.IsCoProduct AS IsCoProduct,
  Costing.CostingLotSize AS CostingLotSize,
  BaseUnit,
  Costing.CostingSpecialProcurementType AS CostingSpecialProcurementType,
  Costing.ProductIsCostingRelevant AS ProductIsCostingRelevant,
  Costing.CostingProductionVersion AS CostingProductionVersion,
  Costing.IsFixedPriceCoProduct AS IsFixedPriceCoProduct
FROM I_ProductPlantCostingTP AS Costing
LEFT OUTER JOIN C_Productstore AS _Store ON Product = _Store.Product AND Plant = _Store.Plant  -- association [1..1]
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_ProdPlntProcmtProfileText AS _SpecialProcurementTypeText ON CostingSpecialProcurementType = _SpecialProcurementTypeText.CostingSpecialProcurementType AND Plant = _SpecialProcurementTypeText.Plant  -- association [0..*]
;