FMLV_MLAUFCR_UCT

DDL: FMLV_MLAUFCR_UCT SQL: FMLAUFCRUCT Type: view
13 Fields 2 Data Sources

ML Currency Table for Order History w. cor. CURTP

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

Data Sources (2)

SourceAliasJoin Type
finsv_unique_cvtyps curr left_outer
mlaufcrld MLD from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FMLAUFCRUCT 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 (13)

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
sdm_version

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.
-- 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: FMLAUFCRUCT

CREATE VIEW FMLV_MLAUFCR_UCT AS
SELECT
  mlvnr,
  vgabe,
  gjahr,
  belnr,
  buzei,
  kalnr,
  curr.curtype AS curtp,
  waers,
  shkzg,
  wrbtr,
  arewr,
  reewr,
  cast( '01' as fins_ml_sdm_version ) AS sdm_version
FROM mlaufcrld AS MLD
LEFT OUTER JOIN finsv_unique_cvtyps AS curr ON /* join condition not captured in parsed metadata */
;

Learn More