What is I_CO2eqSuplrFprntAvgBaseUoM_2 in SAP S/4HANA?

I_CO2eqSuplrFprntAvgBaseUoM_2 is a composite CDS view in SAP S/4HANA. Avg Suplr Related CO2eq Footprint It contains 19 fields.

Which tables does I_CO2eqSuplrFprntAvgBaseUoM_2 read from?

I_CO2eqSuplrFprntAvgBaseUoM_2 reads data from: I_PFMMasterDataFootprint, I_PFMMasterDataFootprintQty, I_PFMProdPlntSuplrFootprint.

What VDM layer is I_CO2eqSuplrFprntAvgBaseUoM_2?

I_CO2eqSuplrFprntAvgBaseUoM_2 is classified as a Composite view that combines data from multiple basic views.

I_CO2eqSuplrFprntAvgBaseUoM_2

DDL: I_CO2EQSUPLRFPRNTAVGBASEUOM_2 Type: view_entity COMPOSITE

19 Fields 3 Data Sources 1 Associations

Avg Suplr Related CO2eq Footprint

I_CO2eqSuplrFprntAvgBaseUoM_2 (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_CO2eqSuplrFprntAvgBaseUoM_2 is a Composite CDS View that provides data about "Avg Suplr Related CO2eq Footprint" in SAP S/4HANA. It reads from 3 data sources (I_PFMMasterDataFootprint, I_PFMMasterDataFootprintQty, I_PFMProdPlntSuplrFootprint) and exposes 19 fields with key fields Product, Plant, Supplier, PFMFootprintValidFromDate, PFMFootprintValidToDate. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Product Footprint Management

Purpose
This CDS view is used to access CO2e footprint data for products, plants, and suppliers. Footprint data of logically deleted suppliers or products can be retrieved regardless. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations If you want to retrieve footprint data of blocked suppliers, you need to have the proper authorizations. This CDS View requires an input parameter KeyDate . With the parameter KeyDate the footprint that is valid on that specific date will be returned. Users who want to use this CDS view don't need any special authorization.

Structure
Important fields in this view include the following: Field Name Description Product Product Plant Plant Supplier Supplier PFMFootprintQuantity The CO2e footprint quantity value as floating-point decimal (DECFLOAT34) PFMFootprintFxdPtDcmlQuantity The CO2e footprint quantity value as fixed-point decimal (QUAN). This field is provided for compatibility reasons and should be used in cases where it is technically not possible to consume the floating-point decimal value. PFMFootprintUnit The unit of measure of the CO2e footprint quantity value PFMFootprintCalculatedBY Calculator used for the footprint calculation PFMFootprintValidFromDate The Valid From date of the footprint PFMFootprintValidToDate The Valid to date of the footprint PFMFootprintPeriodStartDate The Period Start date of the footprint PFMFootprintPeriodEndDate The Period End date of the footprint Associations _CO2eqFprntAvgGHGCat : The association allows to retrieve the breakdown of the of the CO2e footprint by GHG category. See Transaction Data Footprint Breakdown by GHG Category .

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	SUS-PFM-INT
Capabilities	Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
Package	Cross Applications for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view is used to access CO2e footprint data for products, plants, and suppliers.</p> <p>Footprint data of logically deleted suppliers or products can be retrieved regardless.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (3)

Source	Alias	Join Type
I_PFMMasterDataFootprint	_PFMMasterDataFootprint	inner
I_PFMMasterDataFootprintQty	_PFMMasterDataFootprintQty	inner
I_PFMProdPlntSuplrFootprint	I_PFMProdPlntSuplrFootprint	from

Parameters (1)

Name	Type	Default
P_KeyDate	vdm_v_key_date

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_CO2eqFprntAvgGHGCat	_CO2eqFprntAvgGHGCat	`_CO2eqFprntAvgGHGCat.PFMMasterDataFootprintQtyUUID = $projection.PFMMasterDataFootprintQtyUUID`

Annotations (9)

Name	Value	Level
EndUserText.label	Avg Suplr Related CO2eq Footprint	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.viewType	#COMPOSITE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#NONE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (19)

Key	Field	Source Table	Source Field	Description
KEY	Product	I_PFMProdPlntSuplrFootprint	Product	Product Number
KEY	Plant	I_PFMProdPlntSuplrFootprint	Plant	Valuation Area
KEY	Supplier	I_PFMProdPlntSuplrFootprint	Supplier	Account Number of Supplier
KEY	PFMFootprintValidFromDate	I_PFMMasterDataFootprint	PFMFootprintValidFromDate	Footprint Valid From Date
KEY	PFMFootprintValidToDate	I_PFMMasterDataFootprint	PFMFootprintValidToDate	Footprint Valid To Date
	PFMFootprintQuantity	I_PFMMasterDataFootprintQty	PFMFootprintQuantity	Footprint Quantity
	PFMFootprintFxdPtDcmlQuantity			Footprint Quantity
	PFMFootprintUnit	I_PFMMasterDataFootprintQty	PFMFootprintUnit	Footprint Unit
	PFMFootprintCalculatedBy	I_PFMMasterDataFootprint	PFMFootprintCalculatedBy	Calculator used for the footprint calculation
	PFMFootprintPeriodStartDate	I_PFMMasterDataFootprint	PFMFootprintPeriodStartDate	Footprint Period Start Date
	PFMFootprintPeriodEndDate	I_PFMMasterDataFootprint	PFMFootprintPeriodEndDate	Footprint Period End Date
	PFMMasterDataFootprintUUID	I_PFMMasterDataFootprint	PFMMasterDataFootprintUUID	Master Data Footprint
	PFMMasterDataFootprintQtyUUID	I_PFMMasterDataFootprintQty	PFMMasterDataFootprintQtyUUID	Master Data Footprint Quantity
	DataControllerSet			BP: Data Controller Set Flag
	_Product	I_PFMProdPlntSuplrFootprint	_Product
	_Plant	I_PFMProdPlntSuplrFootprint	_Plant
	_Supplier	I_PFMProdPlntSuplrFootprint	_Supplier
	_UnitOfMeasure	I_PFMMasterDataFootprintQty	_UnitOfMeasure
	_CO2eqFprntAvgGHGCat		_CO2eqFprntAvgGHGCat

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_2.
-- 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.
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW I_CO2eqSuplrFprntAvgBaseUoM_2 AS
SELECT
  I_PFMProdPlntSuplrFootprint.Product AS Product,
  I_PFMProdPlntSuplrFootprint.Plant AS Plant,
  I_PFMProdPlntSuplrFootprint.Supplier AS Supplier,
  _PFMMasterDataFootprint.PFMFootprintValidFromDate AS PFMFootprintValidFromDate,
  _PFMMasterDataFootprint.PFMFootprintValidToDate AS PFMFootprintValidToDate,
  _PFMMasterDataFootprintQty.PFMFootprintQuantity AS PFMFootprintQuantity,
  cast (_PFMMasterDataFootprintQty.PFMFootprintQuantity as pfmfootprintquantity_quan) AS PFMFootprintFxdPtDcmlQuantity,
  _PFMMasterDataFootprintQty.PFMFootprintUnit AS PFMFootprintUnit,
  _PFMMasterDataFootprint.PFMFootprintCalculatedBy AS PFMFootprintCalculatedBy,
  _PFMMasterDataFootprint.PFMFootprintPeriodStartDate AS PFMFootprintPeriodStartDate,
  _PFMMasterDataFootprint.PFMFootprintPeriodEndDate AS PFMFootprintPeriodEndDate,
  _PFMMasterDataFootprint.PFMMasterDataFootprintUUID AS PFMMasterDataFootprintUUID,
  _PFMMasterDataFootprintQty.PFMMasterDataFootprintQtyUUID AS PFMMasterDataFootprintQtyUUID,
  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 */
LEFT OUTER JOIN I_CO2eqFprntAvgGHGCat AS _CO2eqFprntAvgGHGCat ON _CO2eqFprntAvgGHGCat.PFMMasterDataFootprintQtyUUID = PFMMasterDataFootprintQtyUUID  -- association [0..*]
;

Depth:

I_CO2eqSuplrFprntAvgBaseUoM_2 view_entity