SAP table LMENU (Menu tree)

SAP table LMENU has 6 primary key fields being MANDT,APPLC,LOCAT,PERSN,FMENU,SQNCE.

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 * MANDT
APPLC Application NUMC 2 0 LMBP_APPLC
00 Task & Resource Management
01 Yard Management
02 VAS
LOCAT Presentation Profile/Site CHAR 4 0 LMBP_LOCAT
PERSN Personalization profile CHAR 2 0 LPRSN LMBP_PERSN_FIELD
FMENU Dynamic Menu CHAR 10 0 LMNCT LMBP_DYNMEN
SQNCE Menu Item Sequence NUMC 2 0 LMBP_ITEM_MENU_SQNCE_NUMBER
TTRNS Logical Transaction Code CHAR 20 0 LTRCT LMBP_TRANS
TMENU Lower-Level Menu for Profile CHAR 10 0 LMNCT LMBP_NEXT_DYNMEN
EXTRN External Transaction CHAR 20 0 TSTC LMBP_EXTERNAL_TRANSACTION

LMENU foreign key relationships

Table Field Check Table Check Field
0 LMENU EXTRN TSTC SAP Transaction Codes TCODE
1 LMENU FMENU LMNCT Menu item catalog MANDT
1 LMENU FMENU LMNCT Menu item catalog APPLC
1 LMENU FMENU LMNCT Menu item catalog LMENU
0 LMENU PERSN LPRSN Personalization MANDT
0 LMENU PERSN LPRSN Personalization APPLC
1 LMENU TMENU LMNCT Menu item catalog MANDT
1 LMENU TMENU LMNCT Menu item catalog APPLC
1 LMENU TMENU LMNCT Menu item catalog LMENU
0 LMENU TTRNS LTRCT Logical transaction catalog MANDT
0 LMENU TTRNS LTRCT Logical transaction catalog APPLC