SAP table SWOR (Classification System: Keywords)

SAP table SWOR has 4 primary key fields being MANDT,CLINT,SPRAS,KLPOS.

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
CLINT Internal Class Number NUMC 10 0 KLAH CLINT
SPRAS Language Key LANG 1 0 T002 SPRAS
KLPOS Item Number NUMC 2 0 KLAPOS
KSCHL Keywords CHAR 40 0 KLSCHL
KSCHG Keyword (Uppercase for Matchcode) CHAR 40 0 KLSCHLG

SWOR foreign key relationships

Table Field Check Table Check Field
0 SWOR CLINT KLAH Class Header Data MANDT
0 SWOR CLINT KLAH Class Header Data CLINT
1 SWOR MANDT T000 Clients MANDT