SAP Table ESTLP

EHS: Report Variant

ESTLP (EHS: Report Variant) 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 ESTLP to other SAP tables.

ESTLP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RECN Sequential Number of Data Record ESERECN NUMC 20 0
ACTN Sequential Number of the Change State ESEACTN NUMC 20 0
VALFR Valid-From Date ESEVALFR DATS 8 0
VALTO Valid-To Date ESEVALTO DATS 8 0
AENNR Change Number ESEAENNR AENR CHAR 12 0
DELFLG Deletion Indicator ESEDELFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PARKFLG Data Record Is Inactive ESEPARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
CRDAT Created On ESECRDAT DATS 8 0
CRNAM Created By ESECRNAM CHAR 12 0
UPDDAT Changed On ESEUPDDAT DATS 8 0
UPDNAM Last Changed By ESEUPDNAM CHAR 12 0
SRSID Source of Data ESESRSID TCG56 CHAR 10 0
OWNID Data Provider ESEVENDRID CHAR 10 0
RECNROOT Sequential Number of Data Record ESERECN NUMC 20 0
DOKAR Document Type DOKAR TDWA CHAR 3 0
DOKNR Document number DOKNR ESD_DRAW CHAR 25 0
DOKVR Document Version DOKVR ESD_DRAW CHAR 2 0
DOKTL Document Part DOKTL_D CHAR 3 0
ORD Sort Sequence ESEORD NUMC 4 0
LDEPID Report Generation Variant ESELDEPID CHAR 10 0
RVLID Validity Area ESERVLID TCG91 CHAR 10 0
REPTYPE Report Category ESEREPTYPE TCGL1 CHAR 10 0
INITRELST Report Status ESEREPSTAT CHAR 2 0
WRKLISTFLG Report Is Validated Manually ESEWRKLFLG CHAR 1 0
VERSIONFLG Report must be versioned ESEVERSFLG CHAR 1 0
DATFM Date format XUDATFM CHAR 1 0
1 DD.MM.YYYY
2 MM/DD/YYYY
3 MM-DD-YYYY
4 YYYY.MM.DD
5 YYYY/MM/DD
6 YYYY-MM-DD
7 GYY.MM.DD (Japanese Date)
8 GYY/MM/DD (Japanese Date)
9 GYY-MM-DD (Japanese Date)
A YYYY/MM/DD (Islamic Date 1)
B YYYY/MM/DD (Islamic Date 2)
C YYYY/MM/DD (Iranian Date)
DCPFM Decimal Format XUDCPFM CHAR 1 0
NULL 1.234.567,89
X 1,234,567.89
Y 1 234 567,89
AUTOGENFLG Manual Report Requests Are Generated Automatically ESEAGENFLG CHAR 1 0
MARKCHGFLG Generate Change Marks ESEMCHGFLG CHAR 1 0
AUTOHISFLG Set Reports to Historical Automatically ESEAHISFLG CHAR 1 0
USAGECHECK Selection for Usage Check ESEUSGCCK CHAR 1 0
0 Subset
1 Intersection
2 1:1 check
3 Superset
STCCKFLG Status Check ESESTCCKFLG CHAR 1 0
MARKCHECK Change Mark Selection ESEMCHCCK CHAR 1 0
0 No Change Mark
1 Create Change Mark
2 Change Mark If Specification Exchanged

ESTLP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ESTLP AENNR SY MANDT AENR Change Master MANDT
ESTLP AENNR ESTLP AENNR AENR Change Master AENNR
ESTLP DOKAR ESTLP DOKAR TDWA Document Types DOKAR
ESTLP DOKAR SYST MANDT TDWA Document Types MANDT
ESTLP DOKNR SY LANGU ESD_DRAW Generated Table for View LANGU
ESTLP DOKNR * ESD_DRAW Generated Table for View DKTXT
ESTLP DOKNR ESTLP DOKAR ESD_DRAW Generated Table for View DOKAR
ESTLP DOKNR ESTLP DOKNR ESD_DRAW Generated Table for View DOKNR
ESTLP DOKNR ESTLP DOKVR ESD_DRAW Generated Table for View DOKVR
ESTLP DOKNR ESTLP DOKTL ESD_DRAW Generated Table for View DOKTL
ESTLP DOKNR SY MANDT ESD_DRAW Generated Table for View MANDT
ESTLP DOKVR ESTLP DOKTL ESD_DRAW Generated Table for View DOKTL
ESTLP DOKVR SY MANDT ESD_DRAW Generated Table for View MANDT
ESTLP DOKVR SY LANGU ESD_DRAW Generated Table for View LANGU
ESTLP DOKVR * ESD_DRAW Generated Table for View DKTXT
ESTLP DOKVR ESTLP DOKAR ESD_DRAW Generated Table for View DOKAR
ESTLP DOKVR ESTLP DOKNR ESD_DRAW Generated Table for View DOKNR
ESTLP DOKVR ESTLP DOKVR ESD_DRAW Generated Table for View DOKVR
ESTLP MANDT ESTLP MANDT T000 Clients MANDT
ESTLP REPTYPE ESTLP MANDT TCGL1 EHS: Report types MANDT
ESTLP REPTYPE ESTLP REPTYPE TCGL1 EHS: Report types REPTYPE
ESTLP RVLID ESTLP MANDT TCG91 EHS: Validity Area MANDT
ESTLP RVLID ESTLP RVLID TCG91 EHS: Validity Area RVLID
ESTLP SRSID * TCG56 EHS: Data Origin MANDT
ESTLP SRSID ESTLP SRSID TCG56 EHS: Data Origin SRSID