MMPURORDHISTMATCOSTCURTP

DDL: MMPURORDHISTMATCOSTCURTP SQL: MMPOHMAMATCSTCUR Type: view Package: ME
18 Fields 3 Data Sources

Material Costs in MAA PO History on unique CURTP Level

MMPURORDHISTMATCOSTCURTP is a CDS View that provides data about "Material Costs in MAA PO History on unique CURTP Level" in SAP S/4HANA. It reads from 3 data sources (finsv_unique_cvtyps, ekbe_ma, MMPURORDHISTMATCOSTLEDGER) and exposes 18 fields with key fields ebeln, ebelp, zekkn, vgabe, gjahr. Part of development package ME.

Data Sources (3)

SourceAliasJoin Type
finsv_unique_cvtyps curr left_outer
ekbe_ma EMA inner
MMPURORDHISTMATCOSTLEDGER POH_LD from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName MMPOHMAMATCSTCUR 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 unique CURTP Level view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ebeln MMPURORDHISTMATCOSTLEDGER ebeln Source PurchDoc
KEY ebelp MMPURORDHISTMATCOSTLEDGER ebelp Item pur. doc.
KEY zekkn MMPURORDHISTMATCOSTLEDGER zekkn Account Assgmt No.
KEY vgabe MMPURORDHISTMATCOSTLEDGER vgabe Transact. Type
KEY gjahr MMPURORDHISTMATCOSTLEDGER gjahr Settlement Year
KEY belnr MMPURORDHISTMATCOSTLEDGER belnr SD Document
KEY buzei MMPURORDHISTMATCOSTLEDGER buzei Posting View Item
KEY curtp finsv_unique_cvtyps curtype Currency Type
lfgja ekbe_ma lfgja Year Cur.Period
lfbnr ekbe_ma lfbnr Reference Doc.
lfpos ekbe_ma lfpos Ref. Doc. Item
shkzg MMPURORDHISTMATCOSTLEDGER shkzg Returns
bukrs MMPURORDHISTMATCOSTLEDGER bukrs Value
wrbtr MMPURORDHISTMATCOSTLEDGER wrbtr Gross Amount
arewr MMPURORDHISTMATCOSTLEDGER arewr Ord.GRIR.Val
reewr MMPURORDHISTMATCOSTLEDGER reewr Ord.Set.Value
kudif MMPURORDHISTMATCOSTLEDGER kudif Exch.Rate Diff.
waers MMPURORDHISTMATCOSTLEDGER 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 MMPURORDHISTMATCOSTCURTP.
-- 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: MMPOHMAMATCSTCUR

CREATE VIEW MMPURORDHISTMATCOSTCURTP AS
SELECT
  POH_LD.ebeln AS ebeln,
  POH_LD.ebelp AS ebelp,
  POH_LD.zekkn AS zekkn,
  POH_LD.vgabe AS vgabe,
  POH_LD.gjahr AS gjahr,
  POH_LD.belnr AS belnr,
  POH_LD.buzei AS buzei,
  curr.curtype AS curtp,
  EMA.lfgja AS lfgja,
  EMA.lfbnr AS lfbnr,
  EMA.lfpos AS lfpos,
  POH_LD.shkzg AS shkzg,
  POH_LD.bukrs AS bukrs,
  POH_LD.wrbtr AS wrbtr,
  POH_LD.arewr AS arewr,
  POH_LD.reewr AS reewr,
  POH_LD.kudif AS kudif,
  POH_LD.waers AS waers
FROM MMPURORDHISTMATCOSTLEDGER AS POH_LD
LEFT OUTER JOIN finsv_unique_cvtyps AS curr ON /* join condition not captured in parsed metadata */
INNER JOIN ekbe_ma AS EMA ON /* join condition not captured in parsed metadata */
;

Learn More