Looking for the SQL behind a program in M3

Sort:
You are not authorized to post a reply.
Author
Messages
Vilfred
New Member
Posts: 1
New Member
    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
      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
      You are not authorized to post a reply.