P_DACRMLDOC

DDL: P_DACRMLDOC Type: view_entity COMPOSITE Package: ODATA_ML_ACR_DISP
17 Fields 1 Data Sources

MLDOC for DACR

P_DACRMLDOC is a Composite CDS View that provides data about "MLDOC for DACR" in SAP S/4HANA. It reads from 1 data source (P_MaterialLedgerDocument) and exposes 17 fields with key fields docref, CurrencyRole. Part of development package ODATA_ML_ACR_DISP.

Data Sources (1)

SourceAliasJoin Type
P_MaterialLedgerDocument P_MaterialLedgerDocument from

Parameters (5)

NameTypeDefault
P_CostEstimate ck_kalnr
P_FiscalYearPeriod fins_fyearperiod
P_CurrencyRole fins_curtype
P_Ledger fins_ledger
P_BaseUnit valum

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MLDOC for DACR 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 (17)

KeyFieldSource TableSource FieldDescription
KEY docref docref Orig.docum.num.
KEY CurrencyRole LedgerValuationCurrencyRole Valuation Area
CostEstimate CostEstimate Cost EstimateNo
Ledger Ledger Ledger
FiscalYearPeriod FiscalYearPeriod Period/Year
MaterialLedgerCategory categ Category
MaterialLedgerCategoryText
ProcessCategory ProcessCategory Visibility (I/E/V/C)
ProcessCategoryName
ValuationQuantity ValuationQuantity Trans. Qty Val. Unit
ValuationQuantityUnit ValuationQuantityUnit Valuation Unit
InventoryAmtInCCCrcy InventoryAmtInCCCrcy Trs. Invent. Value
PriceDifferenceAmtInCCCrcy PriceDifferenceAmtInCCCrcy Price Difference
ExchRateDiffAmtInCoCodeCrcy ExchRateDiffAmtInCoCodeCrcy Exch.Rate Diff.
StandardPrice stprs Standard price
MaterialLedgerItemType posart Item type
Currency Currency Valuation Crcy

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_DACRMLDOC.
-- 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.
-- Parameters: P_CostEstimate : ck_kalnr, P_FiscalYearPeriod : fins_fyearperiod, P_CurrencyRole : fins_curtype, P_Ledger : fins_ledger, P_BaseUnit : valum

CREATE VIEW P_DACRMLDOC AS
SELECT
  docref,
  LedgerValuationCurrencyRole AS CurrencyRole,
  CostEstimate,
  Ledger,
  FiscalYearPeriod,
  categ AS MaterialLedgerCategory,
  _categname._Text[1: Language = $session.system_language ].MaterialLedgerCategoryText AS MaterialLedgerCategoryText,
  ProcessCategory,
  _procatname._Text[1: Language = $session.system_language ].ProcessCategoryName AS ProcessCategoryName,
  ValuationQuantity,
  ValuationQuantityUnit,
  InventoryAmtInCCCrcy,
  PriceDifferenceAmtInCCCrcy,
  ExchRateDiffAmtInCoCodeCrcy,
  stprs AS StandardPrice,
  posart AS MaterialLedgerItemType,
  Currency
FROM P_MaterialLedgerDocument
;

Learn More