SAP table LWRKA (Working Area)
SAP table LWRKA has 3 primary key fields being MANDT,LOCAT,WAREA.
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
LOCAT
Site
CHAR
4
0
LLOCT
LTRM_LOCAT
WAREA
Working Area
CHAR
10
0
LTRT_WAREA
SRCZG
Source Zone Group
CHAR
10
0
LZGDF
LTRT_SRCZG
SRCZN
Source Zone
CHAR
10
0
LZNDF
LTRT_SRCZN
DSTZG
Destination Zone Group
CHAR
10
0
LZGDF
LTRT_DSTZG
DSTZN
Destination Zone
CHAR
10
0
LZNDF
LTRT_DSTZN
BDRCT
Both Directions
CHAR
1
0
LTRT_BOTH_DIRCT
Possible values
Only Forward
X
Both Directions
LWRKA foreign key relationships
Table
Field
Check Table
Check Field
0 LWRKA
DSTZG
LZGDF
Zone group definition
MANDT
0 LWRKA
DSTZG
LZGDF
Zone group definition
LOCAT
0 LWRKA
DSTZG
LZGDF
Zone group definition
ZNGRP
1 LWRKA
DSTZN
LZNDF
Zone
MANDT
1 LWRKA
DSTZN
LZNDF
Zone
LOCAT
1 LWRKA
DSTZN
LZNDF
Zone
RZONE
0 LWRKA
LOCAT
LLOCT
Site
MANDT
1 LWRKA
SRCZG
LZGDF
Zone group definition
MANDT
1 LWRKA
SRCZG
LZGDF
Zone group definition
LOCAT
1 LWRKA
SRCZG
LZGDF
Zone group definition
ZNGRP
0 LWRKA
SRCZN
LZNDF
Zone
MANDT
0 LWRKA
SRCZN
LZNDF
Zone
LOCAT
0 LWRKA
SRCZN
LZNDF
Zone
RZONE