I need to build the report in BW. For that I need to bring the data from both the tables PLAF and MSEG to Bw and find a way to relate each others data I mean actuls and planned order quantity.
I dont know how to relate them both in BW other than using material as coomon feild.
I am also not sure if relating both tables with Material will bring up correct values.
I don't know if you have already got the response to your query. But for your requirement, i believe you should be looking at PLAF & tables like AFKO, AFPO, AFRU.
AFKO is order header, AFPO for the order details & AFRU for the confirmations.
From the PLAF you can get planned order details, from the others you can get the order & qty which has been converted to production order, the qty which has been confirmed.
Have a look at these tables & if you need any further inputs, message back & will try my best to be of some help.
Thanks alot for the response I am not good at functional stuff. I am sure what you are saying makes absoulte sense.I need to talk to my end user and ask him what his exact requirement is. Once Again thanks for your help and I will come back as soon as I have the reporting req.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.