P_DMVCMaterialValuation

DDL: P_DMVCMATERIALVALUATION SQL: PDMVCMATLVAL Type: view COMPOSITE Package: ODATA_ML_MATLVCA_DISP

DMVC: Material Valuation

P_DMVCMaterialValuation is a Composite CDS View that provides data about "DMVC: Material Valuation" in SAP S/4HANA. It reads from 1 data source (I_ProductPlant) and exposes 31 fields with key fields CostEstimate, ProcessCategory. Part of development package ODATA_ML_MATLVCA_DISP.

1 data source(s) 31 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductPlant _marc inner

Parameters (4)

NameTypeDefault
P_DateFrom calendardate
P_DateTo calendardate
P_CurrencyType curtp
P_Ledger rldnr

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PDMVCMATLVAL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate _Material CostEstimate
KEY ProcessCategory _Material ProcessCategory
Material _Material Material
ValuationArea _Material ValuationArea
InventoryValuationType _Material InventoryValuationType
CompanyCode _Material CompanyCode
Plant _Material Plant
MaterialName _Material MaterialName
MaterialProcurementType _Material MaterialProcurementType
MaterialType _Material MaterialType
MaterialTypeName _Material MaterialTypeName
MaterialValuationClass _Material MaterialValuationClass
MaterialConsumptionQty _Material MaterialConsumptionQty
MaterialConsumptionValue _Material MaterialConsumptionValue
ValuationQuantity _Material ValuationQuantity
ValuationQuantityUnit _Material ValuationQuantityUnit
InventoryAmtInCCCrcy _Material InventoryAmtInCCCrcy
Currency _Material Currency
LedgerValuationCurrencyRole _Material LedgerValuationCurrencyRole
ProfitCenter _Material ProfitCenter
SalesDocument _Material SalesDocument
SalesDocumentItem _Material SalesDocumentItem
WBSElement _Material WBSElement
Supplier _Material Supplier
SourceLedger _Material SourceLedger
SourceCompanyCode _Material SourceCompanyCode
FiscalYear _Material FiscalYear
AccountingDocument _Material AccountingDocument
LedgerGLLineItem _Material LedgerGLLineItem
Timestamp _Material Timestamp
ProfitCenterMD I_ProductPlant ProfitCenter 
@AbapCatalog.sqlViewName: 'PDMVCMATLVAL'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true


@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_DMVCMaterialValuation
  with parameters
    P_DateFrom     : calendardate,
    P_DateTo       : calendardate,
    P_CurrencyType : curtp,
    P_Ledger       : rldnr
  as select distinct from P_DMVCMaterial( P_DateFrom :$parameters.P_DateFrom, P_DateTo :$parameters.P_DateTo, P_CurrencyType :$parameters.P_CurrencyType, P_Ledger :$parameters.P_Ledger ) as _Material
  
  inner join I_ProductPlant as _marc on _Material.Material = _marc.Product and _Material.Plant = _marc.Plant
  
{
  key _Material.CostEstimate,
  key _Material.ProcessCategory,
      _Material.Material,
      _Material.ValuationArea,
      _Material.InventoryValuationType,
      _Material.CompanyCode,
      _Material.Plant,
      _Material.MaterialName,
      _Material.MaterialProcurementType,
      _Material.MaterialType,
      _Material.MaterialTypeName,
      _Material.MaterialValuationClass,
      _Material.MaterialConsumptionQty   as MaterialConsumptionQty,
      _Material.MaterialConsumptionValue as MaterialConsumptionValue,
      @Semantics.quantity.unitOfMeasure: 'ValuationQuantityUnit'
      _Material.ValuationQuantity        as ValuationQuantity,
      @Semantics.unitOfMeasure: true
      _Material.ValuationQuantityUnit,
      @Semantics.amount.currencyCode: 'Currency'
      _Material.InventoryAmtInCCCrcy     as InventoryAmtInCCCrcy,
      @Semantics.currencyCode: true
      _Material.Currency,
      _Material.LedgerValuationCurrencyRole,
      _Material.ProfitCenter,
      _Material.SalesDocument,
      _Material.SalesDocumentItem,
      _Material.WBSElement,
      _Material.Supplier,
      _Material.SourceLedger,
      _Material.SourceCompanyCode,
      _Material.FiscalYear,
      _Material.AccountingDocument,
      _Material.LedgerGLLineItem,
      _Material.Timestamp,
      _marc.ProfitCenter as ProfitCenterMD
}

Learn More