R_MigrtdMatlLdgrDocItmReval

DDL: R_MIGRTDMATLLDGRDOCITMREVAL SQL: RMGMLDOCITMREVAL Type: view BASIC
9 Fields 1 Data Sources

R_MigrtdMatlLdgrDocItmReval is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mlcrfld) and exposes 9 fields with key fields MaterialLedgerDocument, MaterialLedgerDocumentYear, DocumentItemNumber, FiscalYear, FiscalPeriod.

Data Sources (1)

SourceAliasJoin Type
mlcrfld mlcrfld from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName RMGMLDOCITMREVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaterialLedgerDocument belnr SD Document
KEY MaterialLedgerDocumentYear kjahr Year
KEY DocumentItemNumber posnr WBS Element
KEY FiscalYear bdatj Year
KEY FiscalPeriod poper Posting periods
KEY Ledger rldnr Ledger (Compat.)
KEY CurrencyRole ext_curtype Crcy.Type/Val.View
MatlLdgrPriceRevaluationAmount prdif Price Diff.
MatlLdgrExchRateRevalAmount krdif Exch.Rate Diff.

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 R_MigrtdMatlLdgrDocItmReval.
-- 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: RMGMLDOCITMREVAL

CREATE VIEW R_MigrtdMatlLdgrDocItmReval AS
SELECT
  belnr AS MaterialLedgerDocument,
  kjahr AS MaterialLedgerDocumentYear,
  posnr AS DocumentItemNumber,
  bdatj AS FiscalYear,
  poper AS FiscalPeriod,
  rldnr AS Ledger,
  ext_curtype AS CurrencyRole,
  prdif AS MatlLdgrPriceRevaluationAmount,
  krdif AS MatlLdgrExchRateRevalAmount
FROM mlcrfld
;

Learn More