FMLV_MLAUFMFCR_UCT_UNION

CDS View
30 Fields 1 CDS Views

ML Item Table Inner Join ML Currency table for Order History

FMLV_MLAUFMFCR_UCT_UNION is a CDS View in S/4HANA. ML Item Table Inner Join ML Currency table for Order History. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FMLV_PRDH_UCT view inner Super Join: MLORDERHIST/MLAUF/MLAUFCR

Fields (30)

KeyField CDS FieldsUsed in Views
KEY BELNR BELNR 1
KEY BUZEI BUZEI 1
KEY CURTP CURTP 1
KEY GJAHR GJAHR 1
KEY KALNR KALNR 1
KEY VGABE VGABE 1
arewr arewr 1
aufnr MLAUF_AUFNR 1
bdatj bdatj 1
bstme bstme 1
bstmg bstmg 1
budat budat 1
bwart bwart 1
cpudt MLAUF_CPUDT 1
cputm MLAUF_CPUTM 1
hrkft hrkft 1
kstar kstar 1
meins meins 1
menge menge 1
poper poper 1
posnr MLAUF_POSNR 1
reewr reewr 1
saprl saprl 1
settle_poper settle_poper 1
shkzg shkzg 1
storno MLAUF_STORNO 1
waers MLAUFCR_WAERS 1
werks werks 1
wrbtr wrbtr 1
xwoff xwoff 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- ML Item Table Inner Join ML Currency table for Order History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMLV_MLAUFMFCR_UCT_UNION (
    BELNR,
    BUZEI,
    CURTP,
    GJAHR,
    KALNR,
    VGABE,
    AREWR,
    AUFNR,
    BDATJ,
    BSTME,
    BSTMG,
    BUDAT,
    BWART,
    CPUDT,
    CPUTM,
    HRKFT,
    KSTAR,
    MEINS,
    MENGE,
    POPER,
    POSNR,
    REEWR,
    SAPRL,
    SETTLE_POPER,
    SHKZG,
    STORNO,
    WAERS,
    WERKS,
    WRBTR,
    XWOFF,
    PRIMARY KEY (BELNR, BUZEI, CURTP, GJAHR, KALNR, VGABE)
);

Learn More