MLORDERHIST

Transparent Table Application Table
12 Fields 5 CDS Views

Conversion Table for Order History

MLORDERHIST is an SAP database table in S/4HANA. Conversion Table for Order History. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FMLV_MLAUFCR_UCT_UNION view inner ML Currency Table for Order History w. cor. CURTP
FMLV_MLAUFCRH_UCT_UNION view inner History table for summerized MLAUFCR data w. correct CURPT
FMLV_MLAUFKEPH_UCT_UNION view inner ML: Cost Component Split for Order History w. correct CURTP
FMLV_MLAUFKEPHH_UCT_UNION view inner History table for summarized MLAUFKEPH data w. correct CURTP
FMLV_PRDH_UCT view from Super Join: MLORDERHIST/MLAUF/MLAUFCR

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mlvnr CK_MLVNR ML Transactn No
aufnr AUFNR Order
posnr CO_POSNR Item Number
logsys LOGSYS Logical system
initpoper POPER Posting Period
initbdatj BDATJ Year
init_done XFELD Checkbox
grir_active CK_MULTI Multiple Usage
mldoc_only CK_MLDOC_ONLY MLDOC Enrich. Ind.
at_settle_new CK_AT_SETTLE_NEW Indicator Cost Component Split of Activity Consumptions
at_settle_period ML4H_JAHRPER Year / Period

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.

-- Conversion Table for Order History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLORDERHIST (
    MANDT,             -- Client [MANDT]
    MLVNR,             -- ML Transactn No [CK_MLVNR]
    AUFNR,             -- Order [AUFNR]
    POSNR,             -- Item Number [CO_POSNR]
    LOGSYS,            -- Logical system [LOGSYS]
    INITPOPER,         -- Posting Period [POPER]
    INITBDATJ,         -- Year [BDATJ]
    INIT_DONE,         -- Checkbox [XFELD]
    GRIR_ACTIVE,       -- Multiple Usage [CK_MULTI]
    MLDOC_ONLY,        -- MLDOC Enrich. Ind. [CK_MLDOC_ONLY]
    AT_SETTLE_NEW,     -- Indicator Cost Component Split of Activity Consumptions [CK_AT_SETTLE_NEW]
    AT_SETTLE_PERIOD,  -- Year / Period [ML4H_JAHRPER]
    PRIMARY KEY (MANDT, MLVNR)
);

Learn More