C_PFMViewProductFootprints

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_PFMViewProductFootprints.
-- 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.

CREATE VIEW C_PFMViewProductFootprints AS
SELECT
  _PFMMasterDataFootprintQty.PFMMasterDataFootprintQtyUUID AS PFMMasterDataFootprintQtyUUID,
  _PFMProdPlntFootprint.Product AS Product,
  _PFMProdPlntFootprint._Product._Text[1: Language= $session.system_language ].ProductName AS ProductName,
  _PFMProdPlntFootprint._Product.ProductGroup AS ProductGroup,
  _PFMProdPlntFootprint._Product._ProductGroupText_2[1: Language= $session.system_language ].ProductGroupName AS ProductGroupName,
  _PFMProdPlntFootprint.Plant AS Plant,
  _PFMProdPlntFootprint._Plant.PlantName AS PlantName,
  cast('' as lifnr ) AS Supplier,
  cast('' as md_supplier_name) AS SupplierName,
  _ValuationArea.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PFMMasterDataFootprintQty.PFMFootprintCategory AS PFMFootprintCategory,
  _PFMMasterDataFootprintQty._PFMFootprintCategory._Text[1: Language= $session.system_language ].PFMFootprintCategoryName AS PFMFootprintCategoryName,
  cast (_PFMMasterDataFootprintQty.PFMFootprintQuantity as pfmfootprintquantity_ui) AS PFMFootprintQuantity,
  _PFMMasterDataFootprintQty.PFMFootprintUnit AS PFMFootprintUnit,
  _PFMMasterDataFootprintQty._UnitOfMeasure._Text[1: Language= $session.system_language].UnitOfMeasureName AS PFMFootprintUnitName,
  _PFMMasterDataFootprintQty.PFMFootprintReferenceBasis AS PFMFootprintReferenceBasis,
  _PFMMasterDataFootprintQty._PFMFootprintReferenceBasis._Text[1: Language= $session.system_language ].PFMFootprintReferenceBasisName AS PFMFootprintReferenceBasisName,
  _PFMProdPlntFootprint._Product.BaseUnit AS BaseUnit,
  _PFMProdPlntFootprint._Product._BaseUnitOfMeasureText[1: Language= $session.system_language ].UnitOfMeasureName AS UnitOfMeasureName,
  cast('' as brgru) AS SupplierAuthznGrp,
  cast('' as brgru) AS SupplierCompanyAuthznGroup,
  '' AS DataControllerSet,
  cast('' as bu_data_controller ) AS DataController1,
  cast('' as bu_data_controller ) AS DataController2,
  cast('' as bu_data_controller ) AS DataController3,
  cast('' as bu_data_controller ) AS DataController4,
  cast('' as bu_data_controller ) AS DataController5,
  cast('' as bu_data_controller ) AS DataController6,
  cast('' as bu_data_controller ) AS DataController7,
  cast('' as bu_data_controller ) AS DataController8,
  cast('' as bu_data_controller ) AS DataController9,
  cast('' as bu_data_controller ) AS DataController10,
  _PFMProdPlntFootprint._Product._BaseUnitOfMeasure AS _BaseUnitOfMeasure,
  _PFMProdPlntFootprint._Plant AS _Plant,
  _PFMProdPlntFootprint._Product AS _Product,
  _PFMProdPlntFootprint._Product._ProductGroup_2 AS _ProductGroup_2,
  _PFMMasterDataFootprintQty._UnitOfMeasure AS _UnitOfMeasure,
  _PFMMasterDataFootprintQty._PFMFootprintCategory AS _PFMFootprintCategory,
  _PFMMasterDataFootprintQty._PFMFootprintReferenceBasis AS _PFMFootprintReferenceBasis
FROM P_PFMViewProductFootprints AS _PFMProdPlntFootprint
INNER JOIN I_PFMMasterDataFootprintQty AS _PFMMasterDataFootprintQty ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
-- UNION ALL with additional select branch(es): P_PFMViewProdPlntSuplrFprints
;