I_PFMTRANSDATACO2EQFPRNT

CDS View

Carbon Footprint of Transaction Data

I_PFMTRANSDATACO2EQFPRNT is a CDS View in S/4HANA. Carbon Footprint of Transaction Data. It contains 4 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 4 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_PurchaseReqnItemCO2eqFprnt view from CONSUMPTION Purchase Reqn Item CO2e Footprint
C_PurOrdItemCO2eqFootprint view from CONSUMPTION Purchase Order Item CO2e Footprint
I_PPS_PurReqnItemCO2eqFprnt view_entity from COMPOSITE Purchase Reqn Item CO2e Footprint
P_PFMCarbonFootprintForPR view inner CONSUMPTION

Fields (4)

KeyField CDS FieldsUsed in Views
PFMFootprintFxdPtDcmlQuantity PFMFootprintQuantity 3
PFMFootprintQuantity PFMFootprintQuantity 1
PFMFootprintUnit PFMFootprintUnit 4
PFMTransDataFprntBusObjType PFMTransDataFprntBusObjType 3 
@EndUserText.label: 'Carbon Footprint of Transaction Data'

@AccessControl.authorizationCheck: #MANDATORY

@VDM.viewType: #COMPOSITE

@Metadata.ignorePropagatedAnnotations:true // needed for the C1 contract


@ObjectModel: {
  supportedCapabilities: [ // needed for the C1 contract

    #SQL_DATA_SOURCE,
    #CDS_MODELING_DATA_SOURCE,
    #CDS_MODELING_ASSOCIATION_TARGET
  ],
  modelingPattern: #NONE
}

@ObjectModel.usageType:
{
  serviceQuality: #A,
  sizeCategory:   #L, //based on size category of I_PFMTransDataFootprint

  dataClass:      #TRANSACTIONAL
}

define view entity I_PFMTransDataCO2eqFprnt

  as select from I_PFMTransDataFootprint

    inner join   I_PFMTransDataFootprintQty as _PFMTransDataFootprintQty on  _PFMTransDataFootprintQty.PFMTransDataFootprintUUID = I_PFMTransDataFootprint.PFMTransDataFootprintUUID
                                                                         and _PFMTransDataFootprintQty.PFMFootprintCategory      = 'GHG'
{

  key I_PFMTransDataFootprint.PFMTransDataFootprintUUID,

      // To provide a better context for the CO2-equivalent values compared to the label text of the data elements, custom labels are used here


      @EndUserText.label: 'CO2e Footprint'
      @Semantics.quantity.unitOfMeasure: 'PFMFootprintUnit'
      _PFMTransDataFootprintQty.PFMFootprintQuantity,

      @EndUserText.label: 'CO2e Footprint'
      @Semantics.quantity.unitOfMeasure: 'PFMFootprintUnit'
      cast (_PFMTransDataFootprintQty.PFMFootprintQuantity as pfmfootprintquantity_quan) as PFMFootprintFxdPtDcmlQuantity,

      @EndUserText.label: 'CO2e Footprint Unit'
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      _PFMTransDataFootprintQty.PFMFootprintUnit,

      // needed for DCL

      I_PFMTransDataFootprint.PFMTransDataFprntBusObjType,

      //foreign key assocation

      _PFMTransDataFootprintQty._UnitOfMeasure

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PFMTRANSDATAFOOTPRINT",
"I_PFMTRANSDATAFOOTPRINTQTY"
],
"ASSOCIATED":
[
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PFMTRANSDATAFOOTPRINTQTY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More