SAP table ENT5821 (Generated Table for View)

SAP table ENT5821 has 3 primary key fields being MANDT,AUFPL,APLZL.

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
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL General counter for order NUMC 8 0 CO_APLZL
PLNFL Sequence CHAR 6 0 PLNFOLGE
PLNAL Group Counter CHAR 2 0 PLNAL
PLNKN Number of the Task List Node NUMC 8 0 PLNKN
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
VORNR Operation/Activity Number CHAR 4 0 VORNR
LTXA1 Operation Short Text CHAR 40 0 LTXA1
TXTSP Language Key LANG 1 0 T002 SPRAS
RSTRA Reduction Strategy per Operation CHAR 2 0 RSTRA
MLSTN Usage CHAR 5 0 T433 MILESTONE
PPRIO Priority CHAR 2 0 PRIORITAET
APLFL Sequence CHAR 6 0 PLNFOLGE
RUECK Completion confirmation number for the operation NUMC 10 0 CO_RUECK
RMZHL Confirmation counter NUMC 8 0 CO_RMZHL
PROJN Work breakdown structure element (WBS element) NUMC 8 0 PRPS PS_PSP_ELE
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
SELKZ Selection indicator for costing line items CHAR 1 0 TCK08 CO_SELKZ
KALID Factory Calendar CHAR 2 0 TFACD WFCID
FRSP Earliest possible activity / Latest possible activity CHAR 1 0 FRSP
1 Earliest possible
2 Latest possible
DAUNO Normal duration of the activity QUAN 5 1 DAUNOR
EINSE Constraint on the finish date of the activity CHAR 1 0 EINSCHRE
EINSA Constraint on the basic start date for the activity CHAR 1 0 EINSCHRA
DAUME Unit for the minimum duration UNIT 3 0 T006 DAUMINE
DAUMI Minimum activity duration QUAN 5 1 DAUMIN
DAUNE Normal duration/unit UNIT 3 0 T006 DAUNORE
FSAVD Earliest scheduled start: Execution (date) DATS 8 0 FSAVD
FSAVZ Earliest scheduled start: Execution (time) TIMS 6 0 FSAVZ
FSEDD Earliest scheduled finish: Execution (date) DATS 8 0 FSEDD
FSEDZ Earliest scheduled finish: Execution (time) TIMS 6 0 FSEDZ
SSAVD Latest scheduled start: Execution (date) DATS 8 0 SSAVD
SSAVZ Latest scheduled start: Execution (time) TIMS 6 0 SSAVZ
SSEDD Latest scheduled finish: Execution (date) DATS 8 0 SSEDD
SSEDZ Latest scheduled finish: Execution (time) TIMS 6 0 SSEDZ
ISAVD Actual Operation Start Date DATS 8 0 ISAVD
IEAVD Actual Operation End Date DATS 8 0 IEAVD
ISDD Actual Execution Start Date DATS 8 0 ISDD
ISDZ Actual Execution Start Time TIMS 6 0 ISDZ
IEDD Actual Execution End Date DATS 8 0 IEDD
EWSTA Forecast date constraint on activity start CHAR 1 0 PS_RESTA
EWSTE Forecast date constraint on activity finish CHAR 1 0 PS_RESTE
EWDME Unit for forecast minimum duration UNIT 3 0 T006 EWDME
EWDAM Minimum duration (from forecast) for activity QUAN 5 1 EWDAM
EWDNE Unit for forecast normal duration UNIT 3 0 T006 EWDNE
EWDAN Normal duration (from forecast) of activity QUAN 5 1 EWDAN
EWENZ Forecast finish time for the activity TIMS 6 0 EWENDEZ
EWEND Forecast finish date DATS 8 0 EWENDED
EWSTZ Forecast start time of the activity TIMS 6 0 EWSTARTZ
EWSTD Forecasted start date for the activity DATS 8 0 EWSTARTD
NTENZ Basic finish time of the activity TIMS 6 0 VORGABEENZ
NTEND Constraint for Finish of Activity (Basic) DATS 8 0 VORGABEEND2
NTANZ Constraint for activity start time (Basic) TIMS 6 0 VORGABESTZ
NTANF Constraint for activity start (Basic) DATS 8 0 VORGABESTD
PUFGS Total float DEC 3 0 PUFFR_GESM
PUFFR Free float DEC 3 0 PUFFR_FREI
PEDZ Forecast End Time of Operation from Confirmation TIMS 6 0 CO_PEDZ
PEDD Forecast finish date of operation from confirmation DATS 8 0 CO_PEDD
IEDZ Actual Execution End Time TIMS 6 0 IEDZ
SLWID Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
USR00 User field with 20 characters CHAR 20 0 USRCHAR20
USR01 User field with 20 characters CHAR 20 0 USRCHAR20
USR02 User Field with 10 Characters CHAR 10 0 USRCHAR10
USR03 User Field with 10 Characters CHAR 10 0 USRCHAR10
USR04 User field for quantity (length 10.3) QUAN 13 3 USRQUAN13
USE04 User field: Unit for quantity fields UNIT 3 0 T006 USRUNIT
USR05 User field for quantity (length 10.3) QUAN 13 3 USRQUAN13
USE05 User field: Unit for quantity fields UNIT 3 0 T006 USRUNIT
USR06 User-defined field for values (length 10,3) CURR 13 3 USRCURR13
USE06 User field: Unit for value fields CUKY 5 0 TCURC USRCUKY
USR07 User-defined field for values (length 10,3) CURR 13 3 USRCURR13
USE07 User field: Unit for value fields CUKY 5 0 TCURC USRCUKY
USR08 User field for date DATS 8 0 USRDATE
USR09 User field for date DATS 8 0 USRDATE
USR10 User-defined field: Indicator for reports CHAR 1 0 USRFLAG
USR11 User-defined field: Indicator for reports CHAR 1 0 USRFLAG
STEUS Control key CHAR 4 0 T430 STEUS
PRKST Costs in the activity CURR 11 2 PRKST

ENT5821 foreign key relationships

Table Field Check Table Check Field
0 ENT5821 DAUME T006 Units of Measurement MANDT
0 ENT5821 DAUME T006 Units of Measurement MSEHI
1 ENT5821 DAUNE T006 Units of Measurement MANDT
0 ENT5821 EWDME T006 Units of Measurement MANDT
0 ENT5821 EWDME T006 Units of Measurement MSEHI
1 ENT5821 EWDNE T006 Units of Measurement MANDT
0 ENT5821 MANDT T000 Clients MANDT
1 ENT5821 MLSTN T433 Milestone Indicator MANDT
0 ENT5821 OBJNR ONR00 General Object Number MANDT
1 ENT5821 PLNTY TCA01 Task list types MANDT
0 ENT5821 PROJN PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 ENT5821 PROJN PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 ENT5821 SELKZ TCK08 Indicator for Relevancy to Costing MANDT
1 ENT5821 SELKZ TCK08 Indicator for Relevancy to Costing SELKZ
0 ENT5821 SLWID TCN00 Key Word ID for PS User Fields MANDT
1 ENT5821 STEUS T430 Operation/Activity control key MANDT
1 ENT5821 STEUS T430 Operation/Activity control key PLNAW
1 ENT5821 STEUS T430 Operation/Activity control key STEUS
0 ENT5821 TXTSP T002 Language Keys (Component BC-I18) SPRAS
1 ENT5821 USE04 T006 Units of Measurement MANDT
0 ENT5821 USE05 T006 Units of Measurement MANDT
1 ENT5821 USE06 TCURC Currency Codes MANDT
1 ENT5821 USE06 TCURC Currency Codes WAERS
0 ENT5821 USE07 TCURC Currency Codes MANDT
0 ENT5821 USE07 TCURC Currency Codes WAERS