C_Plant_Fs

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_Plant_Fs.
-- 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: CPLANTFS

CREATE VIEW C_Plant_Fs AS
SELECT
  Plant.Product AS Product,
  Plant.Plant AS Plant,
  Plant.PurchasingGroup AS PurchasingGroup,
  Plant.MRPResponsible AS MRPResponsible,
  Plant.MRPControllerName AS MRPControllerName,
  Plant.PurchasingGroupName AS PurchasingGroupName,
  Plant.RegionName AS RegionName,
  Plant.RegionOfOrigin AS RegionOfOrigin,
  Plant.ABCIndicator AS ABCIndicator,
  Plant.CountryOfOrigin AS CountryOfOrigin,
  Plant.PlantName AS PlantName,
  Plant.PurchasingGroupPhoneNumber AS PurchasingGroupPhoneNumber,
  Plant.MRPControllerPhoneNumber AS MRPControllerPhoneNumber
FROM P_Plant_Fs AS Plant
LEFT OUTER JOIN C_Product_Fs AS _Product ON Product = _Product.Material  -- association [1..1]
;