SAP table LYLOC (Yard location)

SAP table LYLOC has 4 primary key fields being MANDT,LYARD,YLCCL,YLOCT.

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
LYARD Yard CHAR 3 0 * LXYRD_YARD
YLCCL Location Class CHAR 2 0 LXYRD_YLCCL
01 External location
02 Checkpoint
03 Parking space
04 Weighing point
05 Door
06 Staging area
YLOCT Location CHAR 10 0 LXYRD_YLOCT
PLCTY Physical Location Type CHAR 2 0 LXYRD_PLCTY
BLIND Block CHAR 1 0 LXYRD_BLOCK
BLRSN Reason Code CHAR 2 0 LXYRD_RSNCD
YRGLN Global Location Number CHAR 10 0 LXYRD_YRGLN
GLCGR Location Group CHAR 3 0 LYLGR LXYRD_GLCGR

LYLOC foreign key relationships

Table Field Check Table Check Field
0 LYLOC GLCGR LYLGR Geographical location group MANDT
0 LYLOC GLCGR LYLGR Geographical location group LYARD