I_CO2eqSuplrFprntAvgBaseUoM

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_CO2eqSuplrFprntAvgBaseUoM.
-- 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 I_CO2eqSuplrFprntAvgBaseUoM AS
SELECT
  I_PFMProdPlntSuplrFootprint.Product AS Product,
  I_PFMProdPlntSuplrFootprint.Plant AS Plant,
  I_PFMProdPlntSuplrFootprint.Supplier AS Supplier,
  _PFMMasterDataFootprintQty.PFMFootprintQuantity AS PFMFootprintQuantity,
  cast (_PFMMasterDataFootprintQty.PFMFootprintQuantity as pfmfootprintquantity_quan) AS PFMFootprintFxdPtDcmlQuantity,
  _PFMMasterDataFootprintQty.PFMFootprintUnit AS PFMFootprintUnit,
  _PFMMasterDataFootprint.PFMFootprintCalculatedBy AS PFMFootprintCalculatedBy,
  _PFMMasterDataFootprint.PFMFootprintValidFromDate AS PFMFootprintValidFromDate,
  _PFMMasterDataFootprint.PFMFootprintValidToDate AS PFMFootprintValidToDate,
  _PFMMasterDataFootprint.PFMFootprintPeriodStartDate AS PFMFootprintPeriodStartDate,
  _PFMMasterDataFootprint.PFMFootprintPeriodEndDate AS PFMFootprintPeriodEndDate,
  I_PFMProdPlntSuplrFootprint._Supplier.DataControllerSet AS DataControllerSet,
  I_PFMProdPlntSuplrFootprint._Product AS _Product,
  I_PFMProdPlntSuplrFootprint._Plant AS _Plant,
  I_PFMProdPlntSuplrFootprint._Supplier AS _Supplier,
  _PFMMasterDataFootprintQty._UnitOfMeasure AS _UnitOfMeasure
FROM I_PFMProdPlntSuplrFootprint
INNER JOIN I_PFMMasterDataFootprintQty AS _PFMMasterDataFootprintQty ON /* join condition not captured in parsed metadata */
INNER JOIN I_PFMMasterDataFootprint AS _PFMMasterDataFootprint ON /* join condition not captured in parsed metadata */
;