SAP table T312 (Control Performance Data and TO Split)

SAP table T312 has 5 primary key fields being MANDT,LGNUM,BWLVS,VLTYP,NLTYP.

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
BWLVS Movement Type for Warehouse Management NUMC 3 0 T333 BWLVS
VLTYP Source Storage Type CHAR 3 0 T301 LTAP_VLTYP
NLTYP Destination Storage Type CHAR 3 0 T301 LTAP_NLTYP
PRLEI Profile for performance data CHAR 6 0 T312A T312_PRLEI
PRSPL Profile for transfer order split CHAR 6 0 T312B T312_PRSPL

T312 foreign key relationships

Table Field Check Table Check Field
0 T312 BWLVS T333 WM Movement Types MANDT
0 T312 BWLVS T333 WM Movement Types LGNUM
1 T312 LGNUM T300 WM Warehouse Numbers MANDT
1 T312 LGNUM T300 WM Warehouse Numbers LGNUM
0 T312 MANDT T000 Clients MANDT
1 T312 NLTYP T301 WM Storage Types MANDT
1 T312 NLTYP T301 WM Storage Types LGNUM
1 T312 NLTYP T301 WM Storage Types LGTYP
0 T312 PRLEI T312A Profile for performance data MANDT
0 T312 PRLEI T312A Profile for performance data LGNUM
1 T312 PRSPL T312B Profile for Transfer Order Split MANDT
1 T312 PRSPL T312B Profile for Transfer Order Split LGNUM
1 T312 PRSPL T312B Profile for Transfer Order Split PRSPL
0 T312 VLTYP T301 WM Storage Types MANDT
0 T312 VLTYP T301 WM Storage Types LGNUM
0 T312 VLTYP T301 WM Storage Types LGTYP