P_DMVCMaterial

DDL: P_DMVCMATERIAL SQL: PDMVCMATERIAL Type: view COMPOSITE
30 Fields 1 Data Sources 4 Associations

P_DMVCMaterial is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_MLMaterialHeader) and exposes 30 fields with key fields CostEstimate, FiscalYearPeriod, LedgerValuationCurrencyRole, ProcessCategory. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_MLMaterialHeader _MLMaterialHeader from

Parameters (4)

NameTypeDefault
P_DateFrom calendardate
P_DateTo calendardate
P_CurrencyType curtp
P_Ledger rldnr

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Purreqvaluationarea _Purreqvaluationarea _MLMaterialHeader.ValuationArea = _Purreqvaluationarea.ValuationArea
[0..1] I_ProductPlant _Product _Product.Product = _MLMaterialHeader.Material
[1..1] I_Material _Material _Material.Material = _MLMaterialHeader.Material
[0..1] I_MaterialValuation _MaterialValuation _MaterialValuation.CostEstimate = _MLMaterialHeader.CostEstimate

Annotations (7)

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

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate P_MLMaterialHeader CostEstimate Cost EstimateNo
KEY FiscalYearPeriod _MaterialLedgerDocument FiscalYearPeriod Period/Year
KEY LedgerValuationCurrencyRole _MaterialLedgerDocument LedgerValuationCurrencyRole
KEY ProcessCategory _MaterialLedgerDocument ProcessCategory
ValuationQuantity _MaterialLedgerDocument ValuationQuantity
ValuationQuantityUnit _MaterialLedgerDocument ValuationQuantityUnit
InventoryAmtInCCCrcy _MaterialLedgerDocument InventoryAmtInCCCrcy
Currency _MaterialLedgerDocument Currency Valuation Crcy
Material P_MLMaterialHeader Material Vehicle Model
ValuationArea P_MLMaterialHeader ValuationArea Valuation Area
InventoryValuationType P_MLMaterialHeader InventoryValuationType Valuation Type
CompanyCode _Purreqvaluationarea CompanyCode Receiver Company Code
Plant _Product Plant Valuation Area
MaterialProcurementType _Product ProcurementType Procurement
MaterialType _Material MaterialType Material Type
MaterialTypeName
MaterialName
MaterialValuationClass _MaterialValuation MaterialValuationClass Valuation Class
MaterialConsumptionQty
MaterialConsumptionValue
SourceLedger _acdoca rldnr Ledger (Compat.)
SourceCompanyCode _acdoca rbukrs Company Code
FiscalYear _acdoca gjahr Settlement Year
AccountingDocument _acdoca belnr SD Document
LedgerGLLineItem _acdoca docln Matching Document Line Item
Timestamp _acdoca timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
SalesDocument P_MLMaterialHeader vbeln SD Sched. Agmt
SalesDocumentItem P_MLMaterialHeader posnr WBS Element
WBSElement P_MLMaterialHeader pspnr WBS Element
Supplier P_MLMaterialHeader Supplier Supplier

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_DMVCMaterial.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PDMVCMATERIAL
-- Parameters: P_DateFrom : calendardate, P_DateTo : calendardate, P_CurrencyType : curtp, P_Ledger : rldnr

CREATE VIEW P_DMVCMaterial AS
SELECT
  _MLMaterialHeader.CostEstimate AS CostEstimate,
  _MaterialLedgerDocument.FiscalYearPeriod AS FiscalYearPeriod,
  _MaterialLedgerDocument.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  _MaterialLedgerDocument.ProcessCategory AS ProcessCategory,
  _MaterialLedgerDocument.ValuationQuantity AS ValuationQuantity,
  _MaterialLedgerDocument.ValuationQuantityUnit AS ValuationQuantityUnit,
  _MaterialLedgerDocument.InventoryAmtInCCCrcy AS InventoryAmtInCCCrcy,
  _MaterialLedgerDocument.Currency AS Currency,
  _MLMaterialHeader.Material AS Material,
  _MLMaterialHeader.ValuationArea AS ValuationArea,
  _MLMaterialHeader.InventoryValuationType AS InventoryValuationType,
  _Purreqvaluationarea.CompanyCode AS CompanyCode,
  _Product.Plant AS Plant,
  _Product.ProcurementType AS MaterialProcurementType,
  _Material.MaterialType AS MaterialType,
  _Material._MaterialType._Text[1:Language=$session.system_language].MaterialTypeName AS MaterialTypeName,
  _Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  _MaterialValuation.MaterialValuationClass AS MaterialValuationClass,
  cast(0 as ml4h_quantity) AS MaterialConsumptionQty,
  cast(0 as ml4h_stval) AS MaterialConsumptionValue,
  _acdoca.rldnr AS SourceLedger,
  _acdoca.rbukrs AS SourceCompanyCode,
  _acdoca.gjahr AS FiscalYear,
  _acdoca.belnr AS AccountingDocument,
  _acdoca.docln AS LedgerGLLineItem,
  _acdoca.timestamp AS Timestamp,
  _MLMaterialHeader.vbeln AS SalesDocument,
  _MLMaterialHeader.posnr AS SalesDocumentItem,
  _MLMaterialHeader.pspnr AS WBSElement,
  _MLMaterialHeader.Supplier AS Supplier
FROM P_MLMaterialHeader AS _MLMaterialHeader
LEFT OUTER JOIN I_Purreqvaluationarea AS _Purreqvaluationarea ON _MLMaterialHeader.ValuationArea = _Purreqvaluationarea.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _Product ON _Product.Product = _MLMaterialHeader.Material  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = _MLMaterialHeader.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialValuation AS _MaterialValuation ON _MaterialValuation.CostEstimate = _MLMaterialHeader.CostEstimate  -- association [0..1]
;

Learn More