SAP Table AENRB

Change Master Document Table

AENRB (Change Master Document Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AENRB to other SAP tables.

Source: AENRB (Change Master Document Table)

AENRB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AENNR Change Number AENNR CHAR 12 0
AENST Status of change number AENST T419S NUMC 2 0
AENBE Authorization group for change master record CC_AENBE CHAR 4 0
DATUV Valid-From Date CC_CCDAT DATS 8 0
TECHV Technical status from CC_TECHV CHAR 12 0
ANDAT Date record created on CC_ANDAT DATS 8 0
ANNAM User who created record CC_ANNAM CHAR 12 0
AEDAT Date of Last Change CC_AEDAT DATS 8 0
AENAM Name of person who changed object CC_AENAM CHAR 12 0
AETXT Change Number Description CC_AETXT CHAR 40 0
LTXSP Language: The long text was stored in this language CC_LTXSP T002 LANG 1 0
AEGRU Reason for change CC_AEGRU CHAR 40 0
CCART Change type CC_CCART NUMC 3 0
CCSTM Maximum partial status keys in engineering change management CCSTM_D NUMC 8 0
DYDAT Indicator: change number with dynamic date CC_DYDAT CHAR 1 0
X Yes
NULL No
CONT1 Digital signature (process improvement) CC_DSIGN CHAR 1 0
NULL Signature procedure ended
A Check signature process order
B Signature process order checked
C Signature process order approved
D Convert signature process order
E Complete signature process order
F Release signature process order
G Reject signature process order
H Cancel signature process approval
I Signature process order incomplete
J Signature process order complete
K Lock signature process
L Cancel signature process lock
M Change to signature process possible
N Change to signature process unnecessary
O Change to signature process impossible
P Complete change to signature process
Q Release change to signature process
R Change to signature process contains errors
S Error in signature process corrected
AEFUN Change number function CC_AEFUN CHAR 1 0
NULL Without release key
1 With release key
2 Change package
3 Leading change master record
UESTR Indicator: Overriding possible CC_UESTR CHAR 1 0
X Yes
NULL No
RLKEY Release Key for Change Master Record CC_RLKEY TCC10 NUMC 2 0
LVORM Deletion Flag for Change Number (Reorganization) CC_LOEKZ CHAR 1 0
X Yes
NULL No
CLINT Internal class number describing effectivity type CC_CLINT NUMC 10 0
AERNG ECM: rank of change number CC_AERNG NUMC 2 0
RLDAT Date when the release key was changed CC_RLDAT DATS 8 0
RLTIM Time when the release key was changed CC_RLTIM TIMS 6 0
TEREL Indicator: Technical release occurs CC_TEREL CHAR 1 0
X Yes
NULL No
NACHT Indicator: Change Package Created After Release CC_NACHT CHAR 1 0
INDAT Effective Date of Statutory Regulation CC_INDAT DATS 8 0
AUDAT End Date for Transitional Period (Prescribed by Law) CC_AUDAT DATS 8 0
FLUSE Change number has been used for data maintenance CC_FLUSE CHAR 1 0
X Yes
NULL No
AEDIF ECM: differentiate effectivity types CC_AEDIF NUMC 10 0
ERLED Indicator for basic change CC_AEERL CHAR 1 0
X Yes
NULL No
DBART Change Type CCART NUMC 3 0
DBDAT Valid-From Date CC_DATUV DATS 8 0
DBSTS Status Profile CC_J_STSMA CHAR 8 0
EFFTYP Effectivity Type CC_EFFT CHAR 10 0
OBJNR Object no. CC_J_OBJNR CHAR 22 0
VBKZ Update indicator CC_VBKZ CHAR 1 0
I Insert
U Update
D Delete
LTXVB Update indicator CC_VBKZ CHAR 1 0
I Insert
U Update
D Delete

AENRB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AENRB AENST AENRB MANDT T419S Change Master Status MANDT
AENRB AENST AENRB AENST T419S Change Master Status AENST
AENRB LTXSP AENRB LTXSP T002 Language Keys (Component BC-I18) SPRAS
AENRB MANDT AENRB MANDT T000 Clients MANDT
AENRB RLKEY AENRB MANDT TCC10 Engineering change management: release key MANDT
AENRB RLKEY AENRB RLKEY TCC10 Engineering change management: release key RLKEY