SAP table V_T331M (Generated Table for View)
SAP table V_T331M has 3 primary key fields being MANDT,LGNUM,LGTYP.
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
LGTYP
Storage Type
CHAR
3
0
T301
LGTYP
LTYPT
Name of storage type
CHAR
25
0
LVS_LTYPT
BWWMP
WM movement type for internal warehouse supply
NUMC
3
0
T333
T331_BWWMP
REPLT
Replenishment method in the storage type
CHAR
1
0
T331_REPLT
Possible values
Replenishment report
1
Transfer orders (immed.) for fixed bin
2
Transfer orders (immed.) random
MAILK
Mail control for replenishment stor.type
CHAR
2
0
T333M
T331_MAILK
V_T331M foreign key relationships
Table
Field
Check Table
Check Field
0 V_T331M
BWWMP
T333
WM Movement Types
MANDT
0 V_T331M
BWWMP
T333
WM Movement Types
LGNUM
1 V_T331M
LGNUM
T300
WM Warehouse Numbers
MANDT
1 V_T331M
LGNUM
T300
WM Warehouse Numbers
LGNUM
0 V_T331M
LGTYP
T301
WM Storage Types
MANDT
0 V_T331M
LGTYP
T301
WM Storage Types
LGNUM
0 V_T331M
LGTYP
T301
WM Storage Types
LGTYP
1 V_T331M
MAILK
T333M
Mail control for background processing
MANDT
1 V_T331M
MAILK
T333M
Mail control for background processing
LGNUM