FMLV_MLAUFCR_UCT_UNION

DDL: FMLV_MLAUFCR_UCT_UNION SQL: FMLAUFCRUCTSDM Type: view
25 Fields 7 Data Sources

ML Currency Table for Order History w. cor. CURTP

FMLV_MLAUFCR_UCT_UNION is a CDS View that provides data about "ML Currency Table for Order History w. cor. CURTP" in SAP S/4HANA. It reads from 7 data sources and exposes 25 fields with key fields mlvnr, vgabe, gjahr, belnr, buzei.

Data Sources (7)

SourceAliasJoin Type
aufk aufk inner
finsv_unique_cvtyps curr left_outer
finsv_unique_cvtyps curtp left_outer
fmlv_external_curtype_ml curtp_ml left_outer
mlorderhist hist inner
mlaufcr MLCR union_all
mlaufcrld MLCRLD from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FMLAUFCRUCTSDM view
EndUserText.label ML Currency Table for Order History w. cor. CURTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY mlvnr mlvnr ML Transactn No
KEY vgabe vgabe Transact. Type
KEY gjahr gjahr Settlement Year
KEY belnr belnr SD Document
KEY buzei buzei Posting View Item
KEY kalnr kalnr ProdCostEst.No.
KEY curtp finsv_unique_cvtyps curtype Currency Type
waers waers Transaction Currency
shkzg shkzg Returns
wrbtr wrbtr Gross Amount
arewr arewr Ord.GRIR.Val
reewr reewr Ord.Set.Value
mlvnr ML Transactn No
KEY vgabe vgabe Transact. Type
KEY gjahr gjahr Settlement Year
KEY belnr belnr SD Document
KEY buzei buzei Posting View Item
KEY kalnr kalnr ProdCostEst.No.
KEY curtp finsv_unique_cvtyps curtype Currency Type
waers mlaufcr waers Transaction Currency
shkzg shkzg Returns
wrbtr wrbtr Gross Amount
arewr arewr Ord.GRIR.Val
reewr reewr Ord.Set.Value
sdm_version sdm_version status value done

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 FMLV_MLAUFCR_UCT_UNION.
-- 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: FMLAUFCRUCTSDM

CREATE VIEW FMLV_MLAUFCR_UCT_UNION AS
SELECT
  mlvnr,
  vgabe,
  gjahr,
  belnr,
  buzei,
  kalnr,
  curr.curtype AS curtp,
  waers,
  shkzg,
  wrbtr,
  arewr,
  reewr,
  sdm_version
FROM mlaufcrld AS MLCRLD
LEFT OUTER JOIN finsv_unique_cvtyps AS curr ON /* join condition not captured in parsed metadata */
INNER JOIN mlorderhist AS hist ON /* join condition not captured in parsed metadata */
INNER JOIN aufk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fmlv_external_curtype_ml AS curtp_ml ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsv_unique_cvtyps AS curtp ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): mlaufcr
;

Learn More