SAP table TMSI2 (Processing Key for Sub-Items)
SAP table TMSI2 has 2 primary key fields being MANDT,SIKGR.
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 | |
| SIKGR | Processing key for sub-items | CHAR | 3 | 0 | SIKGR | ||
| WEPOS | Goods Receipt Indicator | CHAR | 1 | 0 | WEPOS | ||
| WEUNB | Goods Receipt, Non-Valuated | CHAR | 1 | 0 | WEUNB | ||
| REPOS | Invoice receipt indicator | CHAR | 1 | 0 | REPOS | ||
| SIKON | Conditions in sub-items | CHAR | 1 | 0 | SIKON | ||
| SIEIN | Schedule Lines in Subitems | CHAR | 1 | 0 | SIEIN | ||
| SIKNT | Account assignments in sub-items | CHAR | 1 | 0 | SIKNT | ||
| SIIMP | Import data in sub-items | CHAR | 1 | 0 | SIIMP | ||
| SIANL | Delivery address in sub-items | CHAR | 1 | 0 | SIANL | ||
| SITXO | Text processing in sub-items | CHAR | 1 | 0 | SITXO | ||
| SITXD | Text printout in sub-items | CHAR | 1 | 0 | SITXD | ||
| STAFO | Update Group for statistics update | CHAR | 6 | 0 | * | STAFO | |
| SIDRU | Sub-item not to be printed | CHAR | 1 | 0 | SIDRU | ||
| SIQUA | Total quantity of all sub-items equals quantity of main item | CHAR | 1 | 0 | SIQUA | ||
| STAPO | Item is statistical | CHAR | 1 | 0 | STAPO |