SAP table T168 (Screen Control, Purchasing)
SAP table T168 has 8 primary key fields being MANDT,VORGA,FCODE,TRTYP,AKTYP,DYNGR,STEU1,STEU2.
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
VORGA
Transaction/event
CHAR
2
0
VORGA
FCODE
Function code in purchasing
CHAR
4
0
T168F
EFCOD
TRTYP
Transaction type
CHAR
1
0
TRTYP
Possible values
*
Masked
A
Display
B
Edit
C
Display from archive
D
Print
E
Single-item planning
H
Add
K
Copy reference
L
Delete
P
Planning file entry
S
Standard parameter: normal mode
U
Convert indiv. planned order
V
Change
X
Initial transaction
AKTYP
Activity category in SAP transaction
CHAR
1
0
AKTYP
DYNGR
Screen group
CHAR
4
0
DYNGR
STEU1
Control indicator 1
CHAR
1
0
STEU1
STEU2
Control indicator 2
CHAR
1
0
STEU2
DYPNO
Screen number
CHAR
4
0
DYPNO
NAKTP
Activity category in SAP transaction
CHAR
1
0
AKTYP
NFCOD
Function code in purchasing
CHAR
4
0
T168F
EFCOD
CALKZ
Called indicator
CHAR
1
0
CALKZ
WINX1
X-coordinate 1 (left) of window
DEC
2
0
WINX1
WINY1
Y-coordinate 1 (above) of window
DEC
2
0
WINY1
WINX2
X-coordinate 2 (right) of window
DEC
2
0
WINX2
WINY2
Y-coordinate 2 (below) of window
DEC
2
0
WINY2
T168 foreign key relationships
Table
Field
Check Table
Check Field
0 T168
FCODE
T168F
Function Codes, Purchasing
MANDT
0 T168
FCODE
T168F
Function Codes, Purchasing
VORGA
0 T168
FCODE
T168F
Function Codes, Purchasing
FCODE
1 T168
MANDT
T000
Clients
MANDT
0 T168
NFCOD
T168F
Function Codes, Purchasing
MANDT
0 T168
NFCOD
T168F
Function Codes, Purchasing
VORGA
0 T168
NFCOD
T168F
Function Codes, Purchasing
FCODE