C_PFMViewProductFootprints
Product Footprints
C_PFMViewProductFootprints is a Consumption CDS View that provides data about "Product Footprints" in SAP S/4HANA. It reads from 2 data sources (I_PFMCmbndProdPlntSuplrFprnt, I_PFMMasterDataFootprintQty) and exposes 39 fields with key field PFMMasterDataFootprintQtyUUID. It has 2 associations to related views. It is exposed through 1 OData service (UI_PFMMDFOOTPRINT_VIEW). It is used in 1 Fiori application: View Product Footprints. Part of development package ODATA_SUS_PFM_UI_MD_FOOTPRINT.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_PFMCmbndProdPlntSuplrFprnt | _PFMCmbndProdPlntSuplrFprnt | from |
| I_PFMMasterDataFootprintQty | _PFMMasterDataFootprintQty | inner |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_KeyDate | vdm_v_key_date |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_CompanyCode | _CompanyCode | $projection.CompanyCode = _CompanyCode.CompanyCode |
| [0..1] | I_SupplierCompany | _SupplierCompany | $projection.Supplier = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Product Footprints | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| UI_PFMMDFOOTPRINT_VIEW | UI_PFMMDFOOTPRINT_VIEW | V2 | C1 | NOT_TO_BE_RELEASED_STABLE |
Fiori Apps (1)
| App ID | App Name | Type | Description |
|---|---|---|---|
| F5783 | View Product Footprints | Transactional | This application enables you to view product footprints like for example the carbon footprint in CO2-equivalent. |
View Product Footprints
Business Role: Administrator - Product Footprint Management
With this app you can view product footprints that have been calculated in SAP Sustainability Footprint Management on SAP Business Technology Platform.
Fields (39)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PFMMasterDataFootprintQtyUUID | I_PFMMasterDataFootprintQty | PFMMasterDataFootprintQtyUUID | Master Data Footprint Quantity |
| PFMMasterDataFootprintUUID | I_PFMCmbndProdPlntSuplrFprnt | PFMMasterDataFootprintUUID | Master Data Footprint | |
| Product | I_PFMCmbndProdPlntSuplrFprnt | Product | Product Sold | |
| ProductName | ||||
| ProductGroup | ||||
| ProductGroupName | ||||
| Plant | I_PFMCmbndProdPlntSuplrFprnt | Plant | Valuation Area | |
| PlantName | ||||
| Supplier | I_PFMCmbndProdPlntSuplrFprnt | Supplier | Supplier | |
| BPSupplierName | ||||
| CompanyCode | _ValuationArea | CompanyCode | Receiver Company Code | |
| CompanyCodeName | _CompanyCode | CompanyCodeName | Company Name | |
| PFMFootprintCategory | I_PFMMasterDataFootprintQty | PFMFootprintCategory | Footprint Category | |
| PFMFootprintCategoryName | ||||
| PFMFootprintQuantity | ||||
| PFMFootprintUnit | I_PFMMasterDataFootprintQty | PFMFootprintUnit | Unit | |
| PFMFootprintUnitName | ||||
| PFMFootprintReferenceBasis | I_PFMMasterDataFootprintQty | PFMFootprintReferenceBasis | Reference Basis | |
| PFMFootprintReferenceBasisName | ||||
| BaseUnit | ||||
| UnitOfMeasureName | ||||
| PFMFootprintCalculatedBy | ||||
| PFMFootprintCalculatedByName | ||||
| PFMFootprintValidFromDate | ||||
| PFMFootprintValidToDate | ||||
| PFMFootprintPeriodStartDate | ||||
| PFMFootprintPeriodEndDate | ||||
| SupplierAuthznGrp | ||||
| SupplierCompanyAuthznGroup | _SupplierCompany | AuthorizationGroup | AuthorizGroup | |
| DataControllerSet | ||||
| _BaseUnitOfMeasure | ||||
| _Plant | I_PFMCmbndProdPlntSuplrFprnt | _Plant | ||
| _Product | I_PFMCmbndProdPlntSuplrFprnt | _Product | ||
| _ProductGroup_2 | ||||
| _CompanyCode | _CompanyCode | |||
| _UnitOfMeasure | I_PFMMasterDataFootprintQty | _UnitOfMeasure | ||
| _PFMFootprintCategory | I_PFMMasterDataFootprintQty | _PFMFootprintCategory | ||
| _PFMFootprintReferenceBasis | I_PFMMasterDataFootprintQty | _PFMFootprintReferenceBasis | ||
| _PFMFootprintCalculatedBy |
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.
-- Parameters: P_KeyDate : vdm_v_key_date
CREATE VIEW C_PFMViewProductFootprints AS
SELECT
_PFMMasterDataFootprintQty.PFMMasterDataFootprintQtyUUID AS PFMMasterDataFootprintQtyUUID,
_PFMCmbndProdPlntSuplrFprnt.PFMMasterDataFootprintUUID AS PFMMasterDataFootprintUUID,
_PFMCmbndProdPlntSuplrFprnt.Product AS Product,
_PFMCmbndProdPlntSuplrFprnt._Product._Text[1: Language= $session.system_language ].ProductName AS ProductName,
_PFMCmbndProdPlntSuplrFprnt._Product.ProductGroup AS ProductGroup,
_PFMCmbndProdPlntSuplrFprnt._Product._ProductGroupText_2[1: Language= $session.system_language ].ProductGroupName AS ProductGroupName,
_PFMCmbndProdPlntSuplrFprnt.Plant AS Plant,
_PFMCmbndProdPlntSuplrFprnt._Plant.PlantName AS PlantName,
_PFMCmbndProdPlntSuplrFprnt.Supplier AS Supplier,
_PFMCmbndProdPlntSuplrFprnt._Supplier.BPSupplierName AS BPSupplierName,
_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,
_PFMCmbndProdPlntSuplrFprnt._Product.BaseUnit AS BaseUnit,
_PFMCmbndProdPlntSuplrFprnt._Product._BaseUnitOfMeasureText[1: Language= $session.system_language ].UnitOfMeasureName AS UnitOfMeasureName,
_PFMMasterDataFootprintQty._PFMMasterDataFootprint.PFMFootprintCalculatedBy AS PFMFootprintCalculatedBy,
_PFMMasterDataFootprintQty._PFMMasterDataFootprint._PFMFootprintCalculatedBy._Text[1: Language= $session.system_language ].PFMFootprintCalculatedByName AS PFMFootprintCalculatedByName,
_PFMMasterDataFootprintQty._PFMMasterDataFootprint.PFMFootprintValidFromDate AS PFMFootprintValidFromDate,
_PFMMasterDataFootprintQty._PFMMasterDataFootprint.PFMFootprintValidToDate AS PFMFootprintValidToDate,
_PFMMasterDataFootprintQty._PFMMasterDataFootprint.PFMFootprintPeriodStartDate AS PFMFootprintPeriodStartDate,
_PFMMasterDataFootprintQty._PFMMasterDataFootprint.PFMFootprintPeriodEndDate AS PFMFootprintPeriodEndDate,
_PFMCmbndProdPlntSuplrFprnt._Supplier.AuthorizationGroup AS SupplierAuthznGrp,
_SupplierCompany.AuthorizationGroup AS SupplierCompanyAuthznGroup,
_PFMCmbndProdPlntSuplrFprnt._Supplier.DataControllerSet AS DataControllerSet,
_PFMCmbndProdPlntSuplrFprnt._Product._BaseUnitOfMeasure AS _BaseUnitOfMeasure,
_PFMCmbndProdPlntSuplrFprnt._Plant AS _Plant,
_PFMCmbndProdPlntSuplrFprnt._Product AS _Product,
_PFMCmbndProdPlntSuplrFprnt._Product._ProductGroup_2 AS _ProductGroup_2,
_PFMMasterDataFootprintQty._UnitOfMeasure AS _UnitOfMeasure,
_PFMMasterDataFootprintQty._PFMFootprintCategory AS _PFMFootprintCategory,
_PFMMasterDataFootprintQty._PFMFootprintReferenceBasis AS _PFMFootprintReferenceBasis,
_PFMMasterDataFootprintQty._PFMMasterDataFootprint._PFMFootprintCalculatedBy AS _PFMFootprintCalculatedBy
FROM I_PFMCmbndProdPlntSuplrFprnt AS _PFMCmbndProdPlntSuplrFprnt
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]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- SAP Fiori Apps Architecture — How Fiori Apps Connect to Data
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA