MMPURORDHISTDELCOSTLEDGER

DDL: MMPURORDHISTDELCOSTLEDGER SQL: MMPOHMADELCSTLDG Type: view
37 Fields 3 Data Sources

Delivery Costs in MAA PO History on Ledger/CURTP Level

MMPURORDHISTDELCOSTLEDGER is a CDS View that provides data about "Delivery Costs in MAA PO History on Ledger/CURTP Level" in SAP S/4HANA. It reads from 3 data sources (ekbez_ma_ld, ekbz_ma, MMPURORDHISTDELCOST_SDM) and exposes 37 fields with key fields ebeln, ebelp, zekkn, stunr, zaehk.

Data Sources (3)

SourceAliasJoin Type
ekbez_ma_ld ekbezmald from
ekbz_ma ekbzma inner
MMPURORDHISTDELCOST_SDM ekbzma1 union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName MMPOHMADELCSTLDG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Delivery 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 (37)

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 stunr ekbez_ma_ld stunr Step Number
KEY zaehk ekbez_ma_ld zaehk Counter
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 MMPURORDHISTDELCOST_SDM Ebelp Item pur. doc.
KEY zekkn MMPURORDHISTDELCOST_SDM Zekkn Account Assgmt No.
KEY stunr MMPURORDHISTDELCOST_SDM stunr Step Number
KEY zaehk MMPURORDHISTDELCOST_SDM zaehk Counter
KEY vgabe MMPURORDHISTDELCOST_SDM Vgabe Transact. Type
KEY gjahr MMPURORDHISTDELCOST_SDM Gjahr Settlement Year
KEY belnr MMPURORDHISTDELCOST_SDM Belnr SD Document
KEY buzei MMPURORDHISTDELCOST_SDM Buzei Posting View Item
KEY ext_curtype MMPURORDHISTDELCOST_SDM ext_curtype Crcy.Type/Val.View
KEY rldnr MMPURORDHISTDELCOST_SDM rldnr Ledger (Compat.)
KEY costtype MMPURORDHISTDELCOST_SDM costtype Type of Costs
shkzg MMPURORDHISTDELCOST_SDM shkzg Returns
bukrs MMPURORDHISTDELCOST_SDM bukrs Value
wrbtr MMPURORDHISTDELCOST_SDM wrbtr Gross Amount
arewr MMPURORDHISTDELCOST_SDM arewr Ord.GRIR.Val
reewr MMPURORDHISTDELCOST_SDM reewr Ord.Set.Value
kudif MMPURORDHISTDELCOST_SDM kudif Exch.Rate Diff.
waers MMPURORDHISTDELCOST_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 MMPURORDHISTDELCOSTLEDGER.
-- 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: MMPOHMADELCSTLDG

CREATE VIEW MMPURORDHISTDELCOSTLEDGER AS
SELECT
  ekbezmald.ebeln AS ebeln,
  ekbezmald.ebelp AS ebelp,
  ekbezmald.zekkn AS zekkn,
  ekbezmald.stunr AS stunr,
  ekbezmald.zaehk AS zaehk,
  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,
  ekbzma1.waers AS waers
FROM ekbez_ma_ld AS ekbezmald
INNER JOIN ekbz_ma AS ekbzma ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): MMPURORDHISTDELCOST_SDM
;

Learn More