[ QUOTE ]
I think my explination must have been a little bit off but here is an example. If I goto the supply/demand screen (14 then 4 for my case), I can enter a part number and it gives me a bunch of data such. Would there be a way from JDE at this point to tell me which table (name) this data was just pulled from? Hopefully this makes it a bit more clear.
[/ QUOTE ]
Assuming that you are working with World software (since this is, after all, the World mailing list...)
For your information, JDE RPG program names (at least the ones run from menus or the DW Versions List) usually begin with the letter P...
Alternative 1:
If you have command line access within the JDE environment, from the JDE menu where the Supply/Demand inquiry is run type option # 25 to see the name of the program being run (Jxxxxx). If the name begins with 'J', Replace the J with a P to get the RPG program name (Pxxxxx), then use the command DSPPGMREF Pxxxxx to see a list of the programs and files referenced by the program Pxxxxx.
Alternative 2:
Use #3 on the G94 menu to inquire on the JDE menu in question and find the name of the program ("Job to Execute" - Jxxxxx). If it begins with 'J', replace the J with P to get the name of the RPG program being executed by the menu option. (The Option Key/Dream Writer Program ID is typically also the same as the program name. )
Now type the command DSPPGMREF PGMNAME (where PGMNAME is the name determined above) to see a list of the programs and files referenced by the program.
Alternative 3:
While running the supply/demand program, you can:
1) use the system request function of the emulator,
2) select option 3 (Display Current Job), which presents this screen:
------------------------------------------------------
Display Job
System: USFTW406
Job: MYJOB User: MYUSER Number: 830505
Select one of the following:
1. Display job status attributes
2. Display job definition attributes
3. Display job run attributes, if active
4. Display spooled files
10. Display job log, if active, on job queue, or pending
11. Display call stack, if active
12. Display locks, if active
13. Display library list, if active
14. Display open files, if active
15. Display file overrides, if active
16. Display commitment control status, if active
Selection
--
F3=Exit F12=Cancel
-----------------------------------------------------
From this menu, select option number 14 (Display Open Files) to see a list files that are open in the job, and you should see the files being used by the Supply/Demand inquiry program.
(Option 11(Display Call Stack) will show the program call stack, where you can find the name of the JDE program being called - it will be near the bottom of the list of programs shown on the 'Display Call Stack' panel.)
Regards,