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.
In one of My report is using for calculating the age for material.In that report first i am selecting the all quantites from MARD table then for each material i am calculating the quantity from MCHB table fnally i am calculating the age and calculating the quantity for other columns like MARD(qty) - MCHB(Qty) and it will display in other columns.
But My problem is when we executed the report at the same time if i ran the T.Code for MM1B for transfer the goods by using Movement type 311 that time i got negative values in other columns.
In debugg mode i have observed following points.
1.After fetching the MARD qty for XXXXX material(Ex :100) and put into one internal table,if you transfer the goods by using Movement type 311 then if you fetch the data from MCHB table and do the calculation it will get the negative value .
Could you please tell me how to avoid the these negattive values.
As Dzed mentioned you can avoid running the report when MB1B is running.
Just check if you can put a validation in the zprogram which checks if MB1B transaction is running,if running give an error message "Report can't be executed as MB1B is under execution currently" else as usually carry on executing the report.
May be there will be a field which lets us know whether a transaction is under execution or not which can be used in the above said validation.
Bluesky
