SAP Table TMSI1

Sub-Item Category in Purchasing

TMSI1 (Sub-Item Category in Purchasing) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TMSI1 to other SAP tables.

TMSI1 table fields

Field	Data element	Checktable	Datatype	Length
MANDT Client	MANDT	T000	CLNT	3
UPTYP Subitem Category, Purchasing Document	UPTYP		CHAR	1
SIKGR Processing key for sub-items	SIKGR	TMSI2	CHAR	3
UPREI Sequence of sub-item generation	UPREI		NUMC	2

TMSI1 foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
TMSI1	MANDT	TMSI1	MANDT	T000 Clients	MANDT
TMSI1	SIKGR	TMSI1	MANDT	TMSI2 Processing Key for Sub-Items	MANDT
TMSI1	SIKGR	TMSI1	SIKGR	TMSI2 Processing Key for Sub-Items	SIKGR