Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 281
	Members: 0
	Total: 281

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

Looking for the SQL behind a program in M3

1 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Vilfred

New Member

Posts: 1

4/3/2013 9:34 AM

I want to make reports with Crystal Report. Have find table using MDP. In program MOS320 I want to find the key to table used (CSYTAB), but I don't know the key filtered on. If I could take out the sql behind the program, I beleve I will see this. How can I find the sql behind each program in M3?

my kind regards Vilfred.

Ellen Bats

Advanced Member

Posts: 21

4/3/2013 1:10 PM

Hi Vilfred,

You have to look in the table CSYTAB and used the field CTSTCO. For instance when you look at MOS320 the fieldname is EVTY.
In SQL you can make a query select * from csytab where ctstco = 'EVTY' and then you see all records. The field CTSTKY contains the values which you can see in MOS320

Ellen