1. Home
  2. Resources
  3. SAP Tables
  4. TMSI1 - Sub-Item Category in Purchasing

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 Decimals
MANDT Client MANDT T000 CLNT 3 0
UPTYP Subitem Category, Purchasing Document UPTYP CHAR 1 0
SIKGR Processing key for sub-items SIKGR TMSI2 CHAR 3 0
UPREI Sequence of sub-item generation UPREI NUMC 2 0

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