SAP table TMCLVBW (Transaction Key for SAP BW)

SAP table TMCLVBW has 4 primary key fields being MANDT,APPLNM,MCAPP,VORG.

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
APPLNM Application Component CHAR 30 0 ROAPPL RSAPPLNM
MCAPP Number of application CHAR 2 0 TMCAP MCAPP
VORG BW: Transaction Key SAP BW NUMC 3 0 MCBW_VORG
STAT Transaction Key Relevance for SAP BW CHAR 1 0 MCBW_STAT
No Relevance
X Transaction key relevant for SAP BW
VORG_BASIS Superior Transaction Key SAP BW NUMC 3 0 MCBW_VORGV

TMCLVBW foreign key relationships

Table Field Check Table Check Field
0 TMCLVBW APPLNM ROAPPL BW: Application Components APPLNM
1 TMCLVBW MCAPP TMCAP Applications: Logistics Information System MANDT
1 TMCLVBW MCAPP TMCAP Applications: Logistics Information System MCAPP