SAP table ESTLP (Report Variant)

SAP table ESTLP has 3 primary key fields being MANDT,RECN,ACTN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

ESTLP foreign key relationships

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