SAP table LRF_WKQU (Assignment User ->Queue)
SAP table LRF_WKQU has 3 primary key fields being MANDT,LGNUM,BNAME.
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
Client
CLNT
3
0
T000
MANDT
Warehouse Number / Warehouse Complex
CHAR
3
0
T300
LGNUM
User Name in User Master Record
CHAR
12
0
USR02
XUBNAME
QUEUE
Queue
CHAR
10
0
T346
LRF_QUEUE
STATU
Indicator: Status User
CHAR
1
0
LRFWKSTATU
DEVTY
Screen Format
CHAR
10
0
LVS_DEVTYP
Possible values
16X20
Narrow format
16X20ITS
ITS format
16X20MIN
Narrow format with minimum number of fields
8X40
Large format
EXVER
Screen Variant
NUMC
2
0
LRFWKEXVER
MMENU
Main Menu
CHAR
20
0
LRFWKMMENU
DOCNUM
Currently Processed Document Number
NUMC
10
0
LVS_DOCNUM
AUTHO
Authorization for Manual Maintenance of Logon Data
CHAR
1
0
LRFWKAUTHO
PERNR
Personnel Number of User
NUMC
8
0
LTAK_PERNR
SORSQ
Sort order of TO items with implementation of mob.data entry
NUMC
2
0
LRFWKSORSQ
LAMEN
Menu/Transaction code
CHAR
20
0
RF_MENTR
APPLC
Application
NUMC
2
0
LMBP_APPLC
Possible values
00
Task & Resource Management
01
Yard Management
02
VAS
PRSDV
Presentation Device
CHAR
10
0
LPDVC
LMBP_PRSNT_DEVICE
PERSN
Personalization profile
CHAR
2
0
LMBP_PERSN_FIELD
LRF_WKQU foreign key relationships
Table
Field
Check Table
Check Field
0 LRF_WKQU
BNAME
USR02 Logon Data (Kernel-Side Use)
BNAME
1 LRF_WKQU
LGNUM
T300 WM Warehouse Numbers
MANDT
1 LRF_WKQU
LGNUM
T300 WM Warehouse Numbers
LGNUM
0 LRF_WKQU
MANDT
T000 Clients
MANDT
1 LRF_WKQU
PRSDV
LPDVC Presentation device
MANDT
1 LRF_WKQU
PRSDV
LPDVC Presentation device
APPLC
1 LRF_WKQU
PRSDV
LPDVC Presentation device
PRSDV
0 LRF_WKQU
QUEUE
T346 RF Queue Definition
MANDT
0 LRF_WKQU
QUEUE
T346 RF Queue Definition
LGNUM
0 LRF_WKQU
QUEUE
T346 RF Queue Definition
QUEUE