SAP Table
TMSI2 Processing Key for Sub-Items
SAP table TMSI2 has 2 primary key fields being MANDT,SIKGR.
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
TMSI2 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeySIKGR | 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 |