SAP table T160M (Message Control: Purchasing (System Messages))

SAP table T160M has 4 primary key fields being MANDT,MSGVS,ARBGB,MSGNR.

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
MSGVS Message control version: Purchasing/Sales CHAR 8 0 MSGVS
ARBGB Application Area CHAR 20 0 T100A ARBGB
MSGNR Message number CHAR 3 0 T100 MSGNR
MSGTP System message category, purchasing CHAR 1 0 MSGTE
No Message
E Error Message
I Information
P Dialog Box
S Result Message
W Warning
X Program Termination (Dump)
MSGTYWS Message type - shipping processing CHAR 1 0 MSGTYWS
No notification
E Background: System reaction + log / Dialog: error
I Background: conditional log / Dialog: info message
W Background: no log / Dialog: warning
MILL_VS_MSGTE Message type -> Automatic creation of versions CHAR 1 0 MILL_VS_MSGTE
No check
E Check, automatic copy, log if necessary
I Check, log if necessary
W Check, dialog for decision, log if necessary

T160M foreign key relationships

Table Field Check Table Check Field
0 T160M ARBGB T100A Message IDs for T100 ARBGB
1 T160M MANDT T000 Clients MANDT
0 T160M MSGNR T100 Messages SPRSL
0 T160M MSGNR T100 Messages ARBGB
0 T160M MSGNR T100 Messages MSGNR