AENR

Transparent Table Application Table
33 Fields 4 CDS Views

Change Master

AENR is an SAP database table in S/4HANA. Change Master. It contains 33 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ChangeMaster view from BASIC Change Number
I_Chgnrvh view from BASIC Change Number Value Help
I_ProdStrucVariantChangeState view left_outer BASIC Product Structure Variant Change State
I_VariantHistlData view left_outer BASIC Variant Historical Data

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aennr AENNR Change Number
aenst AENST Chg. no. status
aenbe CC_AENBE Auth. group
datuv CC_CCDAT Valid From
techv CC_TECHV Tech st from
andat CC_ANDAT Created On
annam CC_ANNAM Created By
aedat CC_AEDAT Changed On
aenam CC_AENAM Changed by
aetxt CC_AETXT Description
ltxsp CC_LTXSP Long text lang
aegru CC_AEGRU Reason for chg
ccart CC_CCART Change type
ccstm CCSTM_D Status key
dydat CC_DYDAT Dynamic date
cont1 CC_DSIGN Proc. Signature
aefun CC_AEFUN Function
uestr CC_UESTR Overridable
rlkey CC_RLKEY Release key
lvorm CC_LOEKZ Deletion Flag
clint CC_CLINT Int class no.
aerng CC_AERNG Rank
rldat CC_RLDAT Date when the release key was changed
rltim CC_RLTIM Time when the release key was changed
terel CC_TEREL Rel. technical.
nacht CC_NACHT Late Package
indat CC_INDAT Regulation Date
audat CC_AUDAT Trans. Period End
fluse CC_FLUSE Usage indicator
aedif CC_AEDIF ECM: Distinguish Effectivity Types
erled CC_AEERL Basic change
lastchangeddatetime TIMESTAMPL Time Stamp

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 Master
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AENR (
    MANDT,                -- Client [MANDT]
    AENNR,                -- Change Number [AENNR]
    AENST,                -- Chg. no. status [AENST]
    AENBE,                -- Auth. group [CC_AENBE]
    DATUV,                -- Valid From [CC_CCDAT]
    TECHV,                -- Tech st from [CC_TECHV]
    ANDAT,                -- Created On [CC_ANDAT]
    ANNAM,                -- Created By [CC_ANNAM]
    AEDAT,                -- Changed On [CC_AEDAT]
    AENAM,                -- Changed by [CC_AENAM]
    AETXT,                -- Description [CC_AETXT]
    LTXSP,                -- Long text lang [CC_LTXSP]
    AEGRU,                -- Reason for chg [CC_AEGRU]
    CCART,                -- Change type [CC_CCART]
    CCSTM,                -- Status key [CCSTM_D]
    DYDAT,                -- Dynamic date [CC_DYDAT]
    CONT1,                -- Proc. Signature [CC_DSIGN]
    AEFUN,                -- Function [CC_AEFUN]
    UESTR,                -- Overridable [CC_UESTR]
    RLKEY,                -- Release key [CC_RLKEY]
    LVORM,                -- Deletion Flag [CC_LOEKZ]
    CLINT,                -- Int class no. [CC_CLINT]
    AERNG,                -- Rank [CC_AERNG]
    RLDAT,                -- Date when the release key was changed [CC_RLDAT]
    RLTIM,                -- Time when the release key was changed [CC_RLTIM]
    TEREL,                -- Rel. technical. [CC_TEREL]
    NACHT,                -- Late Package [CC_NACHT]
    INDAT,                -- Regulation Date [CC_INDAT]
    AUDAT,                -- Trans. Period End [CC_AUDAT]
    FLUSE,                -- Usage indicator [CC_FLUSE]
    AEDIF,                -- ECM: Distinguish Effectivity Types [CC_AEDIF]
    ERLED,                -- Basic change [CC_AEERL]
    LASTCHANGEDDATETIME,  -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, AENNR)
);

Learn More