MMPURORDHISTMATCOSTLEDGER

DDL: MMPURORDHISTMATCOSTLEDGER SQL: MMPOHMAMATCSTLDG Type: view
33 Fields 3 Data Sources

Material Costs in MAA PO History on Ledger/CURTP Level

MMPURORDHISTMATCOSTLEDGER is a CDS View that provides data about "Material Costs in MAA PO History on Ledger/CURTP Level" in SAP S/4HANA. It reads from 3 data sources (ekbe_ma, MMPURORDHISTMATCOST_SDM, ekbez_ma_ld) and exposes 33 fields with key fields ebeln, ebelp, zekkn, vgabe, gjahr.

Data Sources (3)

SourceAliasJoin Type
ekbe_ma ekbema inner
MMPURORDHISTMATCOST_SDM ekbema1 union
ekbez_ma_ld ekbezmald from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName MMPOHMAMATCSTLDG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Material Costs in MAA PO History on Ledger/CURTP Level view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ebeln ekbez_ma_ld ebeln Source PurchDoc
KEY ebelp ekbez_ma_ld ebelp Item pur. doc.
KEY zekkn ekbez_ma_ld zekkn Account Assgmt No.
KEY vgabe ekbez_ma_ld vgabe Transact. Type
KEY gjahr ekbez_ma_ld gjahr Settlement Year
KEY belnr ekbez_ma_ld belnr SD Document
KEY buzei ekbez_ma_ld buzei Posting View Item
KEY ext_curtype ekbez_ma_ld ext_curtype Crcy.Type/Val.View
KEY rldnr ekbez_ma_ld rldnr Ledger (Compat.)
KEY costtype ekbez_ma_ld costtype Type of Costs
shkzg ekbez_ma_ld shkzg Returns
bukrs ekbez_ma_ld bukrs Value
wrbtr ekbez_ma_ld wrbtr Gross Amount
arewr ekbez_ma_ld arewr Ord.GRIR.Val
reewr ekbez_ma_ld reewr Ord.Set.Value
kudif ekbez_ma_ld kudif Exch.Rate Diff.
Ebelnasebeln
KEY ebelp MMPURORDHISTMATCOST_SDM Ebelp Item pur. doc.
KEY zekkn MMPURORDHISTMATCOST_SDM Zekkn Account Assgmt No.
KEY vgabe MMPURORDHISTMATCOST_SDM Vgabe Transact. Type
KEY gjahr MMPURORDHISTMATCOST_SDM Gjahr Settlement Year
KEY belnr MMPURORDHISTMATCOST_SDM Belnr SD Document
KEY buzei MMPURORDHISTMATCOST_SDM Buzei Posting View Item
KEY ext_curtype MMPURORDHISTMATCOST_SDM ext_curtype Crcy.Type/Val.View
KEY rldnr MMPURORDHISTMATCOST_SDM rldnr Ledger (Compat.)
KEY costtype MMPURORDHISTMATCOST_SDM costtype Type of Costs
shkzg MMPURORDHISTMATCOST_SDM shkzg Returns
bukrs MMPURORDHISTMATCOST_SDM bukrs Value
wrbtr MMPURORDHISTMATCOST_SDM wrbtr Gross Amount
arewr MMPURORDHISTMATCOST_SDM arewr Ord.GRIR.Val
reewr MMPURORDHISTMATCOST_SDM reewr Ord.Set.Value
kudif MMPURORDHISTMATCOST_SDM kudif Exch.Rate Diff.
waers MMPURORDHISTMATCOST_SDM waers Transaction Currency

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 MMPURORDHISTMATCOSTLEDGER.
-- 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: MMPOHMAMATCSTLDG

CREATE VIEW MMPURORDHISTMATCOSTLEDGER AS
SELECT
  ekbezmald.ebeln AS ebeln,
  ekbezmald.ebelp AS ebelp,
  ekbezmald.zekkn AS zekkn,
  ekbezmald.vgabe AS vgabe,
  ekbezmald.gjahr AS gjahr,
  ekbezmald.belnr AS belnr,
  ekbezmald.buzei AS buzei,
  ekbezmald.ext_curtype AS ext_curtype,
  ekbezmald.rldnr AS rldnr,
  ekbezmald.costtype AS costtype,
  ekbezmald.shkzg AS shkzg,
  ekbezmald.bukrs AS bukrs,
  ekbezmald.wrbtr AS wrbtr,
  ekbezmald.arewr AS arewr,
  ekbezmald.reewr AS reewr,
  ekbezmald.kudif AS kudif,
  ekbezmald.waers as waers AS Ebelnasebeln,
  ekbema1.waers AS waers
FROM ekbez_ma_ld AS ekbezmald
INNER JOIN ekbe_ma AS ekbema ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): MMPURORDHISTMATCOST_SDM
;

Learn More