SAP table TMC4 (Global Control Elements: LIS Info Structure)

SAP table TMC4 has 2 primary key fields being MANDT,MCINF.

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
MCINF Name of information structure CHAR 8 0 MCINF
GSTRU Generated DDIC table for LIS, conditions, messages CHAR 30 0 * GSTRU
STABL Report Writer table CHAR 30 0 * SUPERTAB
DDICT Table Name CHAR 30 0 * TABNAME
SPERI Period split: info structure CHAR 1 0 SPERI
No period unit
M Month
P Posting period
T Day
W Week
MCAPP Number of application CHAR 2 0 TMCAP MCAPP
KBTCH Indicator for U1/U2/U3 updating of info structures CHAR 1 0 KBTCH
No update
1 Synchronous updating (1)
2 Asynchronous updating (2)
3 Asynchronous updating (3)
D Updating in dialog (intern)
MCITY Type of info structure, type <> space: internal use CHAR 1 0 MC_INFTYP
SPZIS Type of info structure CHAR 1 0 TMCZ SPZIS
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
HIERT Hierarchy category for Sales and Operations Planning CHAR 4 0 * HIERT
MCSTI LIS: status of the information structure CHAR 1 0 MCSTI
0 New
1 New
2 Partially Active
3 Revised
4 Active
5 Revised
PLREL Information structure without planning (Yes/No) CHAR 1 0 PLREL
Info structure can be planned
X Info structure cannot be planned

TMC4 foreign key relationships

Table Field Check Table Check Field
0 TMC4 MCAPP TMCAP Applications: Logistics Information System MANDT
0 TMC4 MCAPP TMCAP Applications: Logistics Information System MCAPP
1 TMC4 PERIV T009 Fiscal Year Variants MANDT
1 TMC4 PERIV T009 Fiscal Year Variants PERIV
0 TMC4 SPZIS TMCZ Special Categories of Info Structures SPZIS