P_MatlLdgrPriceByValuation

DDL: P_MATLLDGRPRICEBYVALUATION Type: view_entity COMPOSITE

Material Ledger Price by Valuation

P_MatlLdgrPriceByValuation is a Composite CDS View that provides data about "Material Ledger Price by Valuation" in SAP S/4HANA. It reads from 1 data source (I_MaterialLedgerPrice) and exposes 10 fields with key fields CostEstimate, Ledger, CurrencyRole, MaterialPriceType, MaterialPriceSubtype.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialLedgerPrice I_MaterialLedgerPrice from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Material Ledger Price by Valuation view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate
KEY Ledger Ledger
KEY CurrencyRole CurrencyRole
KEY MaterialPriceType MaterialPriceType
KEY MaterialPriceSubtype MaterialPriceSubtype
KEY MaterialPriceValidityStartDate MaterialPriceValidityStartDate
KEY MaterialPriceValidityEndDate MaterialPriceValidityEndDate
KEY CompanyCode CompanyCode
MaterialPrice MaterialPrice
Currency Currency 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{ serviceQuality: #B,
                         sizeCategory: #XXL,
                         dataClass: #MIXED }
@VDM: {
  viewType: #COMPOSITE,
  private:true
}
@EndUserText.label: 'Material Ledger Price by Valuation'
define root view entity P_MatlLdgrPriceByValuation
  as select from I_MaterialLedgerPrice

{
  key cast( concat( CurrencyRole,
            concat( '/', coalesce(Ledger, ' ') ) ) as fml_valncrcyrolesemkey ) as MatlLdgrPrValnCrcyRoleSemKey,

  key CostEstimate,
  key Ledger,
  key CurrencyRole,
  key MaterialPriceType,
  key MaterialPriceSubtype,
  key MaterialPriceValidityStartDate,
  key MaterialPriceValidityEndDate,
  key CompanyCode,

      MaterialPrice,
      Currency

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

Learn More