topic Re: Problem in fetching data for Tcode QA03 in Application Development and Automation Discussions

Problem in fetching data for Tcode QA03

Former Member — Wed, 04 Nov 2009 05:27:30 GMT

Hi,

I am working on a report in which i have to pick up the dates for a material i.e. when it is MIGO is done and when it is moved to unrestricted stock.

Till now i am fetching up the data from MSEG nad MKPF where i am getting the data w.r.t. movement types(101,321).

Now the problem is ,i had checked that when i execute Tcode QA03 there is a option of checking the log of it where i found that is shows the value that the purticular value has been moved to unretricted stcok..

The problem is it is storing the value in table RSTXT and field name TXLINE. How can i pick up the value for it and moreover it doesnot have the movt.type mentioned in it? Should i pick the value from MSEG n MKPF or make my logic through QALS and

RSTXT.

Please provide me some information about it...

Re: Problem in fetching data for Tcode QA03

sachin_jadhav8 — Wed, 04 Nov 2009 05:37:12 GMT

Hi,

Ur right use QALS Table To get Unrestricted-Use Stock

i.e. LMENGE01.Also U can find movement type too.

Regards ,

Sachin

Re: Problem in fetching data for Tcode QA03

Former Member — Wed, 04 Nov 2009 05:48:05 GMT

Hi Firends,

I had developed a code for it now,but the problem is i am facing right now is when try to have difference between dates and time of both mvt.types 101 and 321,there comes a problem that it is not able to calculate the diiference as the data of both present in the seperate lines of the itab. Is there anyway that it can be calculated.

Here is the link to the code which i had created, please tell me where i can rectify the error :-

I am really facing the problem in it.. plzz check the code whether it is corect or not?

http://docs.google.com/View?id=dngp529_4grr2ctf6

Edited by: nav009 on Nov 6, 2009 9:43 AM