bksc2000
26th August 2002, 14:15
Hi,
Can any one tell ,while generating MRP by session Generate Planned MRP Orders (timrp1210m000) .this session is linked to how may tables?and which all the tables are linked while genrating MRP?
Flip_J
27th August 2002, 11:23
What info are you looking for?
Unless you look at the extremely complicated script for MRP this will be impossible to know and even then it depends on the setup of your data and what specific modules you use or don't use.
What problem are you trying to solve by knowing the amount of tables used by MRP?
bksc2000
27th August 2002, 13:10
Originally posted by Flip_J
What info are you looking for?
Unless you look at the extremely complicated script for MRP this will be impossible to know and even then it depends on the setup of your data and what specific modules you use or don't use.
What problem are you trying to solve by knowing the amount of tables used by MRP?
suppose i have implemented entire manufacturing,ti,pcs,sales and distribution then??
OmeLuuk
27th August 2002, 13:53
Like stated before, check the souces or run this command line:
bic_info6.1 otimrp1210 | grep table
This will give an impression on what tables are used.
You can also run without the grep statement and then check for the string statemens (SQL statements).
You can also run the session with the DBSLOG statement to see all what it is doing, but this is strongly dissuaded due to the size of the logfile generated and the time taken (probably over 2 times normal run time).
k_paga
2nd September 2002, 15:11
Run the session ttadv2401m000-
Else go to Tools->Applicaiton Development-> Sessions->
Print Current sessions for Package VRC.
Give the ' ti ' package and enter the 'mrp1210m000' in session field and check the 'tables' and check the display.
This display includes a list of tables used in the session given.