‎2008 Aug 04 2:55 PM
Hi all,
While Entering Strategy and Usage in T-code CS02 for Item level Materials Table STPO gets updated with the values what we entered in the CS02 screen.
I need to know which Table Holds the Calculation Value of Strategy and Usage ?
EX:Strategy - 1 (Manual Entry)
Usage - 2
Which Table Stores the Required Quantity? For Example,if the demand is 100 and usage is 2 the required is 2%of100 = 2.
‎2008 Aug 05 6:27 PM
Before you hit save in your transaction start an SQL trace (transaction ST05) in a different session. Now hit save and wait until all update tasks are finished. Don't do anything else until you deactivate the trace again. When you now look at the SQL trace it will list all the tables that have been updated on the DB during SAVE. You should find the table you are looking for in that list.
It is also possible that it doesn't store the required qty. at all but calculates it at runtime, then this is what you would have to do as well.
Hope that helps,
Michael
‎2008 Aug 05 6:27 PM
Before you hit save in your transaction start an SQL trace (transaction ST05) in a different session. Now hit save and wait until all update tasks are finished. Don't do anything else until you deactivate the trace again. When you now look at the SQL trace it will list all the tables that have been updated on the DB during SAVE. You should find the table you are looking for in that list.
It is also possible that it doesn't store the required qty. at all but calculates it at runtime, then this is what you would have to do as well.
Hope that helps,
Michael