FMLV_MLAUFCRH_UCT

DDL: FMLV_MLAUFCRH_UCT SQL: FMLAUFCRHUCT Type: view Package: FINS_ML_UCT_TABLES
14 Fields 2 Data Sources

History table for summerized MLAUFCR data w. correct CURPT

FMLV_MLAUFCRH_UCT is a CDS View that provides data about "History table for summerized MLAUFCR data w. correct CURPT" in SAP S/4HANA. It reads from 2 data sources (finsv_unique_cvtyps, mlaufcrldh) and exposes 14 fields with key fields mlvnr, vgabe, gjahr, belnr, buzei. Part of development package FINS_ML_UCT_TABLES.

Data Sources (2)

SourceAliasJoin Type
finsv_unique_cvtyps curr left_outer
mlaufcrldh MLDH from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FMLAUFCRHUCT view
EndUserText.label History table for summerized MLAUFCR data w. correct CURPT 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 (14)

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 sumdno sumdno Sum Mat doc
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_MLAUFCRH_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: FMLAUFCRHUCT

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

Learn More