SAP Table

TMSI1 Sub-Item Category in Purchasing

SAP table TMSI1 has 2 primary key fields being MANDT,UPTYP.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

TMSI1 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyUPTYP Subitem Category, Purchasing Document CHAR 1 0 UPTYP
SIKGR Processing key for sub-items CHAR 3 0 TMSI2 SIKGR
UPREI Sequence of sub-item generation NUMC 2 0 UPREI
/ Relationships

TMSI1 foreign keys.

Table Field Check Table Description Check Field
TMSI1 SIKGR TMSI2 Processing Key for Sub-Items MANDT
TMSI1 SIKGR TMSI2 Processing Key for Sub-Items SIKGR
Back to SAP tables