2009 Jun 19 7:58 AM
Dear all,
I created a report that extract all 551 / 552 movement types using MB1A. I want to see Data that was used during MB1A transaction.
1. I execute MB1A, insert data
2. When I execute the report to see the data, It does not show, but when I run the MB1A transaction for the second time, the Data appears (The first data I entered).
The report picks it up one step behind. I cant retrieve information I just entered, I have to enter the second MB1A transaction then the first transaction data will show.
Please help.
2009 Jun 19 8:10 AM
Hi,
Sometimes system will take some time to update the things.
Also check the code you have used.
Regards,
Santhosh.
2009 Jun 19 8:10 AM
Hi,
Sometimes system will take some time to update the things.
Also check the code you have used.
Regards,
Santhosh.
2009 Jun 19 8:20 AM
This is the Code!!!
SELECT aMBLNR ausnam acpudt atcode2
bmenge bbwart bMATNR bwerks c~maktx
INTO (MBLNR, usnam, cpudt, tcode2, menge, bwart, MATNR, werks,
maktx )
FROM mkpf as a INNER JOIN mseg AS b
on aMBLNR = bMBLNR
INNER JOIN makt AS C
ON bmatnr = Cmatnr
where b~bwart IN move and
a~cpudt IN s_budat and
a~tcode2 = 'MB1A' AND
b~werks = sales.