MLWERE

Transparent Table Application Table
8 Fields 4 CDS Views

Conversion Table between Purchasing and Material Ledger

MLWERE is an SAP database table in S/4HANA. Conversion Table between Purchasing and Material Ledger. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FMLV_EKBEBZ_UCT_UNION view inner History per Purchasing Document w. External CURTP
FMLV_EKBEBZH_UCT_UNION view inner History per Purchasing Document w. External CURTP
FMLV_MLBECR_UCT_UNION view inner
FMLV_MLBECRH_UCT_UNION view inner Material Ledger Currency Table for GR/IR relevant transactions w. correct CURTP

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mlvnr CK_MLVNR ML Transactn No
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
stunr STUNR Step Number
zaehk DZAEHK Counter
zekkn DZEKKN Account Assgmt No.
_dataaging DATA_TEMPERATURE Data Aging

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 between Purchasing and Material Ledger
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLWERE (
    MANDT,       -- Client [MANDT]
    MLVNR,       -- ML Transactn No [CK_MLVNR]
    EBELN,       -- Purchasing Doc. [EBELN]
    EBELP,       -- Item [EBELP]
    STUNR,       -- Step Number [STUNR]
    ZAEHK,       -- Counter [DZAEHK]
    ZEKKN,       -- Account Assgmt No. [DZEKKN]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, MLVNR)
);

Learn More