SAP table TMC7 (Standard Analyses in Logistics Controlling)

SAP table TMC7 has 3 primary key fields being MANDT,MCAPP,MCANA.

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
MCAPP Number of application CHAR 2 0 TMCAP MCAPP
MCANA Number of standard analysis CHAR 4 0 MCANA
MCINF Name of information structure CHAR 8 0 TMC4 MCINF
MCREPO Central evaluation report in LIS CHAR 40 0 TRDIR MCREPO
MCREPO_T Evaluation report for daily updating to LIS CHAR 40 0 TRDIR MCREPO_T
MCREPO_W Evaluation report for weekly updating to LIS CHAR 40 0 TRDIR MCREPO_W
MCREPO_M Evaluation report for monthly updating to LIS CHAR 40 0 TRDIR MCREPO_M
MCREPO_P Evaluation report for posting period-based updating to LIS CHAR 40 0 TRDIR MCREPO_P
ZUSATZ_TAB Table Name CHAR 30 0 DD02L TABNAME
MCGEVERS Generated version of LIS object CHAR 4 0 MCGEVERS
SPERI Period split: info structure CHAR 1 0 SPERI
No period unit
M Month
P Posting period
T Day
W Week

TMC7 foreign key relationships

Table Field Check Table Check Field
0 TMC7 MCAPP TMCAP Applications: Logistics Information System MANDT
0 TMC7 MCAPP TMCAP Applications: Logistics Information System MCAPP
1 TMC7 MCINF TMC4 Global Control Elements: LIS Info Structure MANDT
0 TMC7 MCREPO TRDIR Generated Table for View NAME
1 TMC7 MCREPO_M TRDIR Generated Table for View NAME
0 TMC7 MCREPO_P TRDIR Generated Table for View NAME
1 TMC7 MCREPO_T TRDIR Generated Table for View NAME
0 TMC7 MCREPO_W TRDIR Generated Table for View NAME
1 TMC7 ZUSATZ_TAB DD02L SAP Tables TABNAME
1 TMC7 ZUSATZ_TAB DD02L SAP Tables AS4LOCAL
1 TMC7 ZUSATZ_TAB DD02L SAP Tables AS4VERS