SAP table T312A (Profile for performance data)

SAP table T312A has 3 primary key fields being MANDT,LGNUM,PRLEI.

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
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
PRLEI Profile for performance data CHAR 6 0 T312_PRLEI
KZLEI Indicator for performance data CHAR 1 0 LVS_KZLEI
No performance data
1 Calculation of target data
2 Enter actual data
3 Calculation of target data and entry of actual data
4 Determine incentive wages
SPLBE Split by single transfer order CHAR 1 0 LVS_SPLBE
KISTZ Indicator: Actual time required in TO CHAR 1 0 LVS_KISTZ
No actual time
1 Actual time as net duration
2 Start and end time manually
3 Start and end time automatically
KISTP Indicator: Input requirement for actual data CHAR 1 0 LVS_KISTP
SWABW Threshold value of planned/actual time deviation as percent NUMC 4 0 LVS_SWABW

T312A foreign key relationships

Table Field Check Table Check Field
0 T312A LGNUM T300 WM Warehouse Numbers MANDT
0 T312A LGNUM T300 WM Warehouse Numbers LGNUM
1 T312A MANDT T000 Clients MANDT