FMLV_MLAUFMFCR_UCT

DDL: FMLV_MLAUFMFCR_UCT SQL: FMLAUFMFCRUCT Type: view
33 Fields 3 Data Sources

ML Item Table Inner Join ML Currency table for Order History

FMLV_MLAUFMFCR_UCT is a CDS View that provides data about "ML Item Table Inner Join ML Currency table for Order History" in SAP S/4HANA. It reads from 3 data sources (ML, mlauf, FMLV_MLAUFCR_UCT) and exposes 33 fields with key fields MLVNR, VGABE, GJAHR, BELNR, BUZEI.

Data Sources (3)

SourceAliasJoin Type
ML ML inner
mlauf MLF from
FMLV_MLAUFCR_UCT MLFCR inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FMLAUFMFCRUCT view
EndUserText.label ML Item Table Inner Join ML Currency table for Order History 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 (33)

KeyFieldSource TableSource FieldDescription
KEY MLVNR mlauf mlvnr ML Transactn No
KEY VGABE mlauf vgabe Transact. Type
KEY GJAHR mlauf gjahr Settlement Year
KEY BELNR mlauf belnr SD Document
KEY BUZEI mlauf buzei Posting View Item
KEY KALNR mlauf kalnr ProdCostEst.No.
KEY CURTP FMLV_MLAUFCR_UCT curtp Valuation Area
budat budat Posting Date
menge menge WarrCountValue
poper poper Posting periods
bdatj bdatj Year
hrkft hrkft Origin group order
kstar kstar Settlement CE
bwart bwart Valuation Type
aufnr aufnr SettlementOrder
posnr posnr WBS Element
settle_poper settle_poper Posting Period
saprl saprl SAP Release
cpudt cpudt Imported On
cputm cputm Time
xwoff xwoff Calcn of val.Open
werks werks Receiving Plant
storno storno Reversal
meins meins Valuation Unit
bstmg bstmg Quantity withdrawn for settlement
bstme bstme Unit.Order
grir_active grir_active Multiple Usage
waers 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_MLAUFMFCR_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: FMLAUFMFCRUCT

CREATE VIEW FMLV_MLAUFMFCR_UCT AS
SELECT
  MLF.mlvnr AS MLVNR,
  MLF.vgabe AS VGABE,
  MLF.gjahr AS GJAHR,
  MLF.belnr AS BELNR,
  MLF.buzei AS BUZEI,
  MLF.kalnr AS KALNR,
  MLFCR.curtp AS CURTP,
  budat,
  menge,
  poper,
  bdatj,
  hrkft,
  kstar,
  bwart,
  aufnr,
  posnr,
  settle_poper,
  saprl,
  cpudt,
  cputm,
  xwoff,
  werks,
  storno,
  meins,
  bstmg,
  bstme,
  grir_active,
  waers,
  shkzg,
  wrbtr,
  arewr,
  reewr,
  sdm_version
FROM mlauf AS MLF
INNER JOIN ML ON /* join condition not captured in parsed metadata */
INNER JOIN FMLV_MLAUFCR_UCT AS MLFCR ON /* join condition not captured in parsed metadata */
;

Learn More