Deprecated
This CDS view is deprecated in S/4HANA. Use I_CO2eqFprntAvgRltvBaseUoM_2 instead. View all deprecated CDS views →

I_CO2eqFprntAvgRltvBaseUoM

DDL: I_CO2EQFPRNTAVGRLTVBASEUOM Type: view_entity COMPOSITE
13 Fields 3 Data Sources

Avg Rltv CO2eq Footprint of Prod at Plnt

I_CO2eqFprntAvgRltvBaseUoM (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_CO2eqFprntAvgRltvBaseUoM is a Composite CDS View that provides data about "Avg Rltv CO2eq Footprint of Prod at Plnt" in SAP S/4HANA. It reads from 3 data sources (I_PFMMasterDataFootprint, I_PFMMasterDataFootprintQty, I_PFMProdPlntFootprint) and exposes 13 fields with key fields Product, Plant.

SAP Help Documentation

CategoryCDS Views for Product Footprint Management
Purpose
This CDS view is used to access CO2e footprint data for products and plants.

Prerequisites
None

Structure
Important fields in this view include the following: Field Name Description Product Product Plant Plant PFMFootprintQuantity The CO2e footprint quantity value PFMFootprintUnit The unit of measure of the CO2e footprint quantity value

View on SAP Help Portal →

SAP API Hub

StateDeprecated
Line of BusinessCross Applications
Application ComponentSUS-PFM-INT
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is used to access CO2e footprint data for products and plants.</p>

Documentation

Data Sources (3)

SourceAliasJoin Type
I_PFMMasterDataFootprint _PFMMasterDataFootprint inner
I_PFMMasterDataFootprintQty _PFMMasterDataFootprintQty inner
I_PFMProdPlntFootprint I_PFMProdPlntFootprint from

Annotations (10)

NameValueLevelField
EndUserText.label Avg Rltv CO2eq Footprint of Prod at Plnt view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_CO2eqFprntAvgRltvBaseUoM_2 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Product I_PFMProdPlntFootprint Product Product Number
KEY Plant I_PFMProdPlntFootprint Plant Valuation Area
PFMFootprintQuantity I_PFMMasterDataFootprintQty PFMFootprintQuantity Footprint Quantity
PFMFootprintFxdPtDcmlQuantity Footprint Quantity
PFMFootprintUnit I_PFMMasterDataFootprintQty PFMFootprintUnit CO2e Footprint Unit
PFMFootprintCalculatedBy I_PFMMasterDataFootprint PFMFootprintCalculatedBy Calculator used for the footprint calculation
PFMFootprintValidFromDate I_PFMMasterDataFootprint PFMFootprintValidFromDate Footprint Valid From Date
PFMFootprintValidToDate I_PFMMasterDataFootprint PFMFootprintValidToDate Footprint Valid To Date
PFMFootprintPeriodStartDate I_PFMMasterDataFootprint PFMFootprintPeriodStartDate Footprint Period Start Date
PFMFootprintPeriodEndDate I_PFMMasterDataFootprint PFMFootprintPeriodEndDate Footprint Period End Date
_Product I_PFMProdPlntFootprint _Product
_Plant I_PFMProdPlntFootprint _Plant
_UnitOfMeasure I_PFMMasterDataFootprintQty _UnitOfMeasure

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_CO2eqFprntAvgRltvBaseUoM.
-- 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_CO2eqFprntAvgRltvBaseUoM AS
SELECT
  I_PFMProdPlntFootprint.Product AS Product,
  I_PFMProdPlntFootprint.Plant AS Plant,
  _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_PFMProdPlntFootprint._Product AS _Product,
  I_PFMProdPlntFootprint._Plant AS _Plant,
  _PFMMasterDataFootprintQty._UnitOfMeasure AS _UnitOfMeasure
FROM I_PFMProdPlntFootprint
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 */
;

Learn More