SAP table ENT5819 (Generated Table for View)

SAP table ENT5819 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
STEUS Control key CHAR 4 0 T430 STEUS
ARBID Object ID of the resource NUMC 8 0 CRID CR_OBJID
WERKS Plant CHAR 4 0 T001W WERKS_D
KTSCH Standard text key CHAR 7 0 T435 KTSCH_CHG
DDEHN Indicator: flexible duration CHAR 1 0 DAUDEHN
ANZZL Number of capacities required INT1 3 0 ANZKAP
PRZNT Work percentage INT1 3 0 APROZENT
ANFKO Requesting Cost Center CHAR 10 0 CSKS ANFKO
ANFKOKRS Controlling area of the requesting cost center CHAR 4 0 TKA01 ANFKOKRS
BEDID ID of the Capacity Requirements Record NUMC 12 0 BEDID
BEDZL Internal counter NUMC 8 0 CIM_COUNT
VERTL Distr.cap.reqmts (plant maint.,process order, network) CHAR 8 0 TC29 CR_VERTN
LARNT Activity Type CHAR 6 0 CSLA LSTAR
INDET Key for calculation CHAR 1 0 INDET
0 Maintain manually
1 Calculate duration
2 Calculate work
3 Calculate number of capacities
MEINH Unit of measure for activity UNIT 3 0 T006 VORME
UMREN Denominator for Converting Routing and Operation UoM DEC 5 0 CP_UMREN
UMREZ Numerator for Converting Routing and Operation UoM DEC 5 0 CP_UMREZ
BMSCH Base Quantity QUAN 13 3 BMSCH
ARBEI Work involved in the activity QUAN 7 1 ARBEIT
ARBEH Unit for work UNIT 3 0 T006 ARBEITE
BEARZ Processing Time FLTP 16 16 BEARZEIT
BEAZE Unit of measure for processing time UNIT 3 0 BEAZE
OFMNW Forecasted work (actual + remaining) QUAN 7 1 OFMNW
FPAVD Earliest scheduled start date (forecast) DATS 8 0 FPAVD
FPAVZ Earliest scheduled start time (forecast) TIMS 6 0 FPAVZ
FPEDD Earliest scheduled finish date (forecast) DATS 8 0 FPEDD
FPEDZ Earliest scheduled finish time (forecast) TIMS 6 0 FPEDZ
SPAVD Latest scheduled start date (forecast) DATS 8 0 SPAVD
SPAVZ Latest scheduled start time (forecast) TIMS 6 0 SPAVZ
SPEDD Latest scheduled finish date (forecast) DATS 8 0 SPEDD
SPEDZ Latest scheduled finish time (forecast) TIMS 6 0 SPEDZ
BEAZP Unit of processing time (Forecast) UNIT 3 0 BEAZEP
PUFGP Total float (from forecast) DEC 3 0 PPUFF_GESM
PUFFP Free float (from forecast) DEC 3 0 PPUFF_FREI
BEARP Processing time (forecast) FLTP 16 16 PBEARZEIT

ENT5819 foreign key relationships

Table Field Check Table Check Field
0 ENT5819 ANFKO CSKS Cost Center Master Record MANDT
0 ENT5819 ANFKO CSKS Cost Center Master Record KOKRS
0 ENT5819 ANFKO CSKS Cost Center Master Record DATBI
1 ENT5819 ANFKOKRS TKA01 Controlling Areas MANDT
0 ENT5819 ARBEH T006 Units of Measurement MANDT
1 ENT5819 ARBID CRID CIM Resource - Entities MANDT
1 ENT5819 ARBID CRID CIM Resource - Entities OBJID
0 ENT5819 KTSCH T435 Standard texts for routing/ref. op set items MANDT
1 ENT5819 LARNT CSLA Activity master MANDT
1 ENT5819 LARNT CSLA Activity master KOKRS
1 ENT5819 LARNT CSLA Activity master DATBI
0 ENT5819 MANDT T000 Clients MANDT
1 ENT5819 MEINH T006 Units of Measurement MANDT
1 ENT5819 MEINH T006 Units of Measurement MSEHI
0 ENT5819 STEUS T430 Operation/Activity control key MANDT
0 ENT5819 STEUS T430 Operation/Activity control key PLNAW
0 ENT5819 STEUS T430 Operation/Activity control key STEUS
1 ENT5819 VERTL TC29 Distribution key for capacity load MANDT
0 ENT5819 WERKS T001W Plants/Branches WERKS