P_DACRConsumptions

DDL: P_DACRCONSUMPTIONS SQL: PDACRCONSUMPT Type: view COMPOSITE

Consumptions for material from MLDOC

P_DACRConsumptions is a Composite CDS View that provides data about "Consumptions for material from MLDOC" in SAP S/4HANA. It reads from 1 data source (P_MaterialLedgerDocument) and exposes 10 fields with key fields CostEstimate, LedgerValuationCurrencyRole.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
P_MaterialLedgerDocument P_MaterialLedgerDocument from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PDACRCONSUMPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consumptions for material from MLDOC view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate
KEY LedgerValuationCurrencyRole LedgerValuationCurrencyRole
Ledger Ledger
FiscalYearPeriod FiscalYearPeriod
ValuationQuantity
ValuationQuantityUnit ValuationQuantityUnit
InventoryAmtInCCCrcy
PriceDifferenceAmtInCCCrcy
ExchRateDiffAmtInCoCodeCrcy
Currency Currency 
@AbapCatalog.sqlViewName: 'PDACRCONSUMPT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Consumptions for material from MLDOC'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_DACRConsumptions
  as select from P_MaterialLedgerDocument
{
  key CostEstimate,
  key LedgerValuationCurrencyRole,
      Ledger,
      FiscalYearPeriod,
      @Semantics.quantity.unitOfMeasure: 'ValuationQuantityUnit'
      sum(ValuationQuantity)            as ValuationQuantity,
      @Semantics.unitOfMeasure: true
      ValuationQuantityUnit,
      @Semantics.amount.currencyCode: 'Currency'
      sum(InventoryAmtInCCCrcy)         as InventoryAmtInCCCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      sum(PriceDifferenceAmtInCCCrcy )  as PriceDifferenceAmtInCCCrcy,
      @Semantics.amount.currencyCode: 'Currency'
      sum(ExchRateDiffAmtInCoCodeCrcy ) as ExchRateDiffAmtInCoCodeCrcy,
      @Semantics.currencyCode: true
      Currency
}
where
  categ = 'VN'
group by
  CostEstimate,
  LedgerValuationCurrencyRole,
  Ledger,
  FiscalYearPeriod,
  ValuationQuantityUnit,
  Currency
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MATERIALLEDGERDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More