SAP table T318 (Picking waves profile)
SAP table T318 has 3 primary key fields being MANDT,LGNUM,KWPRO.
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
KWPRO
Picking wave profile
CHAR
6
0
KW_PROFIL
ERZEUG_ART
Creation type of a picking wave
CHAR
1
0
ERZEUG_ART
Possible values
KAP_BESCHR
Indicator: capacity limitation of a picking wave
CHAR
1
0
KAP_BESCHR
DUNKEL_VER
Picking waves: Indicator manual control required
CHAR
1
0
DUNKEL_VER
Possible values
1
Function only possible in dialog mode after display
2
Function always possible
MAXKOMMPOS
Maximum number of picking items in a picking wave
INT4
10
0
MAXKOMMPOS
MAXAUMETYP
Maximum number of picking activities
DEC
15
0
MAXAUMETYP
MAXVERHART
Maximum Number of Packaging Materials
DEC
15
2
MAXVERHART
MAXGEWICHT
Maximum weight of a picking wave
QUAN
15
3
MAXG
MAXVOLUMEN
Maximum volume of a picking wave
QUAN
15
3
MAXV
MAXZEIT
Maximum available capacity of a picking wave in hours
DEC
15
3
MAXZEIT
T318 foreign key relationships
Table
Field
Check Table
Check Field
0 T318
LGNUM
T300
WM Warehouse Numbers
MANDT
0 T318
LGNUM
T300
WM Warehouse Numbers
LGNUM
1 T318
MANDT
T000
Clients
MANDT