SAP table T311 (Definition of WM Groups)
SAP table T311 has 3 primary key fields being MANDT,LGNUM,REFNR.
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
*
MANDT
LGNUM
Warehouse Number / Warehouse Complex
CHAR
3
0
T300
LGNUM
REFNR
Group
CHAR
10
0
LVS_REFNR
REFNT
Group Description
CHAR
40
0
LVS_REFNT
RBTYP
Type of reference document for group
CHAR
1
0
LVS_RBTYP
Possible values
B
Group of transfer requirements
L
Grouped deliveries
KZSPE
Indicator: reference number blocked
CHAR
1
0
T311KZSPE
KZAKT
Indicator: multiple processing activated for reference no.
CHAR
1
0
T311KZAKT
KZDRU
Indicator: Printout for Reference Number Complete
CHAR
1
0
T311KZDRU
DATUM
Creation date of reference number
DATS
8
0
T311DATUM
DRUKZ
Indicator: form and sort code for printing transfer orders
CHAR
2
0
T329F
LVS_DRUKZ
LDEST
Name of printer
CHAR
4
0
TSP03
LVS_LDEST
DRDAT
Date of printout using reference number
DATS
8
0
T311DRDAT
KZKOM
Indicator that communication with WCU has taken place
CHAR
1
0
T311_KZKOM
KZERL
Ind: TO Creation Executed for All Documents
CHAR
1
0
T311_KZERL
SAMMG
Group
CHAR
10
0
VBSK
SAMMG
KWPRO
Picking wave profile
CHAR
6
0
*
KW_PROFIL
KAPTP
Shift Definition
CHAR
4
0
*
KAPTPROG
L2SKR
Relevance for Two-Step Picking
CHAR
1
0
T311_L2SKR
L2SKM
Indicator: 2-step characteristic material-dependent
CHAR
1
0
LVS_2SKMAT
L2SKP
2-step relevancy for reference number checked
CHAR
1
0
T311_L2SKP
TRART
Shipment Type
CHAR
1
0
LVS_TRART
CDSTO
Create Transfer Order for Multiple Deliveries
CHAR
1
0
LVS_CDSTO
RLSDT
Release Time
DEC
15
0
LXHME_RLSDT
LRLSD
Latest Release Time
DEC
15
0
LXHME_LRLSD
T311 foreign key relationships
Table
Field
Check Table
Check Field
0 T311
DRUKZ
T329F
Print Control Table
MANDT
0 T311
DRUKZ
T329F
Print Control Table
LGNUM
1 T311
LDEST
TSP03
Spool: Printer declaration
PADEST
0 T311
LGNUM
T300
WM Warehouse Numbers
MANDT
0 T311
LGNUM
T300
WM Warehouse Numbers
LGNUM
1 T311
SAMMG
VBSK
Collective Processing for a Sales Document Header
MANDT
1 T311
SAMMG
VBSK
Collective Processing for a Sales Document Header
SAMMG