SAP table WSUSER (User-Dependent Workspaces)

SAP table WSUSER has 5 primary key fields being MANDT,WSUSERNAME,WSUSERKOKRS,WSUSERINSTANCE,WSUSERINSTANCENO.

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
WSUSERNAME User Name CHAR 12 0 SYUNAME
WSUSERKOKRS Controlling Area CHAR 4 0 * KOKRS
WSUSERINSTANCE 4 Byte Signed Integer INT4 10 0 INT4
WSUSERINSTANCENO 4 Byte Signed Integer INT4 10 0 INT4
WSUSEREXTENDISPL New Input Values CHAR 1 0 XFLAG
Blank
. Radio button
X Selection
WSUSEREXTCONTNUM Character field, length 64 CHAR 64 0 CHAR64
KNOTTYPE Type/Content of Container in Worklist CHAR 2 0 WSSEGTYPE
KNOTNAME Name of worklist or of container in worklist CHAR 20 0 WSNAME
KNOTNAME_NEW Name of worklist or of container in worklist CHAR 20 0 WSNAME
KNOTSHAREDFLG Flag: Folder/Worklist Global (X) or User-Specific CHAR 1 0 WSSHAREDFLG
KNOTWSTYPE Type/Origin of Worklist CHAR 1 0 WSTYPE
0 Memo
1 Multilevel Unit Costing
KNOTCONTAINTYPE Type/Content of Container in Worklist CHAR 2 0 WSSEGTYPE
KNOTKEYSTRING Char255 CHAR 255 0 CHAR255

WSUSER foreign key relationships

Table Field Check Table Check Field
0 WSUSER MANDT T000 Clients MANDT