WIP table

[Former Member]

Hi All,

        I had requirement to get the WIP standard amount and WIP percentage change amount. I can see these details in COMLWIPDISP transaction but is there any tables where these values are stored. I checked many forums but did not get much help. Please someone help its really urgent.

Thanks in advance,

Priya

[Former Member]

Please someone help I used SUBMIT statement and called the report COMLWIPDISP in my zprogram. Now how I can I retrieve the values from the report into my ZProgram.

[Rodrigo-Giner]

Hi Priya,

Regarding your first post, before running COMLWIPDISP in another session windows go to ST05 activate trace (make sure only SQL trace checkbox is set it), go back to COMLWIPDISP run it so the data is showed. Go Back to ST05 deactive trace and "display trace", leave those parameter and press ok, the next screen will show you all the tables used in that lap of time.

So you can know where the info is searched. This work every time you dont know the tables but you know how to display it via transactions.

Check this blog fo more detailed info

Regarding the second one, you should add to the SUBMIT statement "EXPORTING LIST TO MEMORY" en then catch it.

check this link

SAPTechnical.COM - Submit and Export List to Memory

Anyway I advice you use the ST05 and find out wich table is used.

Regards

[Former Member]

Hi Rodrigo,

             Thanks for your reply. I checked using ST05 but not getting the 'WIP Price differences percentage change' amount. I could see the WIP standard in table COSB but not 'WIP Price differences percentage change' amount. I need to display these 2 amounts in my zprogram. I submit the report and used 'exporting list to memory' then used call function 'LIST_FROM_MEMORY' and call function 'LIST_TO_ASCI' but I don't want to write this data instead update to another internal table and then from internal table just select the fields that are required. Please someone help.

Thanks & Regards,

Priya

[Rodrigo-Giner]

Perhaps the values that you need are calculated and Cant be retrive directly from DB. You could debug the standard program to check how those field are populated, perhaps  there is some functions that you could use.

The other option, if you read the list from memory, you could parse that info and retrieve only the values that you need althought is not very elegant. The output that you get is separated with "|" ? then you could split string at "|" to see witch column number has the value that you need and then loop split and take the values that you need.

IMO debug the standard report and try to find out how the field is populated.

Regards

[Former Member]

Hi Rodrigo,

         I got the values from COSB table. Thanks for your support.

Thanks & Regards,

Priya