SAP table LPRSN (Personalization)

SAP table LPRSN has 4 primary key fields being MANDT,APPLC,LOCAT,PERSN.

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 LMBP_PERSN_FIELD
MMENU Main Menu of the Profile CHAR 10 0 LMNCT LMBP_MAIN_DYNMEN

LPRSN foreign key relationships

Table Field Check Table Check Field
0 LPRSN MMENU LMNCT Menu item catalog MANDT
0 LPRSN MMENU LMNCT Menu item catalog APPLC
0 LPRSN MMENU LMNCT Menu item catalog LMENU