C_PurchaseReqnItemCO2eqFprnt

DDL: C_PURCHASEREQNITEMCO2EQFPRNT SQL: CPURREQNITMFPRNT Type: view CONSUMPTION

Purchase Reqn Item CO2e Footprint

C_PurchaseReqnItemCO2eqFprnt is a Consumption CDS View that provides data about "Purchase Reqn Item CO2e Footprint" in SAP S/4HANA. It reads from 2 data sources (I_Purchaserequisitionitem, I_PFMTransDataCO2eqFprnt) and exposes 6 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_Purchaserequisitionitem _PurchaseRequisitionItem inner
I_PFMTransDataCO2eqFprnt I_PFMTransDataCO2eqFprnt from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CPURREQNITMFPRNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Reqn 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 PurchaseRequisition I_Purchaserequisitionitem PurchaseRequisition
KEY PurchaseRequisitionItem I_Purchaserequisitionitem PurchaseRequisitionItem
PFMTransDataFootprintUUID I_Purchaserequisitionitem PFMTransDataFootprintUUID
PFMFootprintQuantity I_PFMTransDataCO2eqFprnt PFMFootprintFxdPtDcmlQuantity CO2e Footprint
PFMFootprintUnit I_PFMTransDataCO2eqFprnt PFMFootprintUnit
PFMTransDataFprntBusObjType I_PFMTransDataCO2eqFprnt PFMTransDataFprntBusObjType 
@AbapCatalog.sqlViewName: 'CPURREQNITMFPRNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Reqn Item CO2e Footprint'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION
@ObjectModel: {
   transactionalProcessingDelegated: false,
   semanticKey: ['PurchaseRequisition', 'PurchaseRequisitionItem' ],
   createEnabled: false,
   updateEnabled: false,
   deleteEnabled: false
}
@Search.searchable: false
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL


define view C_PurchaseReqnItemCO2eqFprnt as select from I_PFMTransDataCO2eqFprnt 
  inner join I_Purchaserequisitionitem as _PurchaseRequisitionItem on _PurchaseRequisitionItem.PFMTransDataFootprintUUID = I_PFMTransDataCO2eqFprnt.PFMTransDataFootprintUUID
{
  key _PurchaseRequisitionItem.PurchaseRequisition,
  key _PurchaseRequisitionItem.PurchaseRequisitionItem,
  _PurchaseRequisitionItem.PFMTransDataFootprintUUID,
  
  @Semantics.quantity.unitOfMeasure: 'PFMFootprintUnit'
  @EndUserText.label: 'CO2e Footprint'
  //@ObjectModel.enabled: 'EXTERNAL_CALCULATION'

  //cast( I_PFMTransDataCO2eqFprnt.PFMFootprintQuantity as abap.quan(31,14) ) as PFMFootprintQuantity,

  I_PFMTransDataCO2eqFprnt.PFMFootprintFxdPtDcmlQuantity as PFMFootprintQuantity,
  @Semantics.unitOfMeasure: true
  I_PFMTransDataCO2eqFprnt.PFMFootprintUnit,
  
  // needed for DCL

  I_PFMTransDataCO2eqFprnt.PFMTransDataFprntBusObjType
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PFMTRANSDATACO2EQFPRNT",
"I_PURCHASEREQUISITIONITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More