MKAL_AEND

Transparent Table Application Table
13 Fields 2 CDS Views

Change History of Production Version (Recipes Only)

MKAL_AEND is an SAP database table in S/4HANA. Change History of Production Version (Recipes Only). It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ProdnVersLastChangeHistory view inner BASIC
P_ProdnVersLastChgHistCntr view_entity from BASIC

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks werks_d Plant
KEY verid verid Prod. Version
KEY zaehl numc4 Counter
aennr aennr Change Number
datuv datuv Valid From
datub datub to
andat andat Created On
annam annam Created by
aedat aedat Changed On
aenam aenam Changed By
vbkz vbkz Update ind.

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.

-- Change History of Production Version (Recipes Only)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MKAL_AEND (
    MANDT,  -- Client [mandt]
    MATNR,  -- Material [matnr]
    WERKS,  -- Plant [werks_d]
    VERID,  -- Prod. Version [verid]
    ZAEHL,  -- Counter [numc4]
    AENNR,  -- Change Number [aennr]
    DATUV,  -- Valid From [datuv]
    DATUB,  -- to [datub]
    ANDAT,  -- Created On [andat]
    ANNAM,  -- Created by [annam]
    AEDAT,  -- Changed On [aedat]
    AENAM,  -- Changed By [aenam]
    VBKZ,   -- Update ind. [vbkz]
    PRIMARY KEY (MANDT, MATNR, WERKS, VERID, ZAEHL)
);

Learn More