C_PurOrdItemCO2eqFootprint

DDL: C_PURORDITEMCO2EQFOOTPRINT SQL: CPURPOITMFPRNT Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN_V2
6 Fields 2 Data Sources

Purchase Order Item CO2e Footprint

C_PurOrdItemCO2eqFootprint is a Consumption CDS View that provides data about "Purchase Order Item CO2e Footprint" in SAP S/4HANA. It reads from 2 data sources (R_PurchaseOrderItem, I_PFMTransDataCO2eqFprnt) and exposes 6 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_PUR_PO_MAINTAIN_V2.

Data Sources (2)

SourceAliasJoin Type
R_PurchaseOrderItem _PurchaseOrderItem inner
I_PFMTransDataCO2eqFprnt I_PFMTransDataCO2eqFprnt from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPURPOITMFPRNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Order Item CO2e Footprint view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated false view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Search.searchable false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem R_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PFMTransDataFootprintUUID R_PurchaseOrderItem PFMTransDataFootprintUUID Transaction Data Footprint
PFMFootprintQuantity I_PFMTransDataCO2eqFprnt PFMFootprintFxdPtDcmlQuantity CO2e Footprint
PFMFootprintUnit I_PFMTransDataCO2eqFprnt PFMFootprintUnit Unit
PFMTransDataFprntBusObjType I_PFMTransDataCO2eqFprnt PFMTransDataFprntBusObjType Business Object Type

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_PurOrdItemCO2eqFootprint.
-- 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.
-- SQL view name: CPURPOITMFPRNT

CREATE VIEW C_PurOrdItemCO2eqFootprint AS
SELECT
  _PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  _PurchaseOrderItem.PFMTransDataFootprintUUID AS PFMTransDataFootprintUUID,
  I_PFMTransDataCO2eqFprnt.PFMFootprintFxdPtDcmlQuantity AS PFMFootprintQuantity,
  I_PFMTransDataCO2eqFprnt.PFMFootprintUnit AS PFMFootprintUnit,
  I_PFMTransDataCO2eqFprnt.PFMTransDataFprntBusObjType AS PFMTransDataFprntBusObjType
FROM I_PFMTransDataCO2eqFprnt
INNER JOIN R_PurchaseOrderItem AS _PurchaseOrderItem ON /* join condition not captured in parsed metadata */
;

Learn More