Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table for usage and Startegy

Former Member
0 Likes
331

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
308

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

1 REPLY 1
Read only

Former Member
0 Likes
309

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