Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

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
New Member
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
    Advanced Member
    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