MLORDERHIST

Transparent Table Application Table
12 Fields 5 CDS Views

Umschlüsseltabelle für die Auftragsentwicklung

MLORDERHIST is an SAP database table in S/4HANA. Umschlüsseltabelle für die Auftragsentwicklung. 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.

-- Umschlüsseltabelle für die Auftragsentwicklung
-- 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