P_DMVCActivityMaterialPair

DDL: P_DMVCACTIVITYMATERIALPAIR SQL: PDMVCAMPAIR Type: view COMPOSITE Package: ODATA_ML_MATLVCA_DISP
15 Fields 1 Data Sources 2 Associations

DMVC: Activity/Material Pair

P_DMVCActivityMaterialPair is a Composite CDS View that provides data about "DMVC: Activity/Material Pair" in SAP S/4HANA. It reads from 1 data source (P_MaterialLedgerDocument) and exposes 15 fields with key field ProcessCategory. It has 2 associations to related views. Part of development package ODATA_ML_MATLVCA_DISP.

Data Sources (1)

SourceAliasJoin Type
P_MaterialLedgerDocument _MaterialLedgerDocument from

Parameters (4)

NameTypeDefault
P_DateFrom calendardate
P_DateTo calendardate
P_CurrencyType fins_curtype
P_Ledger fins_ledger

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessTransactionType _BusinessTransactionType _MaterialLedgerDocument.glvor = _BusinessTransactionType.BusinessTransactionType
[0..1] P_MLProcessCategory _ProcessCategory _MaterialLedgerDocument.ProcessCategory = _ProcessCategory.ProcessCategory

Annotations (7)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProcessCategory ProcessCategory Visibility (I/E/V/C)
DocumentReference docref Orig.docum.num.
Plant Plant Valuation Area
BusinessTransactionType glvor Bus.transaction
BusinessTransactionTypeName
ProcessCategoryName
LedgerValuationCurrencyRole LedgerValuationCurrencyRole Valuation Area
ValuationQuantity ValuationQuantity Trans. Qty Val. Unit
ValuationQuantityUnit ValuationQuantityUnit Valuation Unit
InventoryAmtInCCCrcy InventoryAmtInCCCrcy Trs. Invent. Value
PriceDifferenceAmtInCCCrcy PriceDifferenceAmtInCCCrcy Price Difference
ExchRateDiffAmtInCoCodeCrcy ExchRateDiffAmtInCoCodeCrcy Exch.Rate Diff.
Currency Currency Valuation Crcy
_BusinessTransactionType _BusinessTransactionType
_ProcessCategory _ProcessCategory

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_DMVCActivityMaterialPair.
-- 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: PDMVCAMPAIR
-- Parameters: P_DateFrom : calendardate, P_DateTo : calendardate, P_CurrencyType : fins_curtype, P_Ledger : fins_ledger

CREATE VIEW P_DMVCActivityMaterialPair AS
SELECT
  ProcessCategory,
  docref AS DocumentReference,
  Plant,
  glvor AS BusinessTransactionType,
  _BusinessTransactionType._Text[1:Language = $session.system_language].BusinessTransactionTypeName AS BusinessTransactionTypeName,
  _ProcessCategory._Text[1:Language = $session.system_language].ProcessCategoryName AS ProcessCategoryName,
  LedgerValuationCurrencyRole,
  ValuationQuantity,
  ValuationQuantityUnit,
  InventoryAmtInCCCrcy,
  PriceDifferenceAmtInCCCrcy,
  ExchRateDiffAmtInCoCodeCrcy,
  Currency
FROM P_MaterialLedgerDocument AS _MaterialLedgerDocument
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON _MaterialLedgerDocument.glvor = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN P_MLProcessCategory AS _ProcessCategory ON _MaterialLedgerDocument.ProcessCategory = _ProcessCategory.ProcessCategory  -- association [0..1]
;

Learn More