on 09-27-2011 1:42 PM
Hi Folks,
My client is having a requirement to generate a report which fetches the condition value details like (freight, Tax etc) against a particular sales orders.
We have noted certain cases where the condition records at the header level can be manually entered by the user at the time of creating the sales order. My question is that where exactly is the transactional data pertaining to the condition records in a sales order are stored?
How can I advice my technical guy to fetch the above mentioned data? Can you advice please
Thanks,
Safeer Rahman
Dear Safeer Rahman,
According to your requirement please find the below solution.
First take the sales order number(VBELN), go to VBAK fetch the document condition (KNUMV) and go to KONV give the document condition and execute.
You can find the condition value (KWERT_K) which condition origin (KHERK) is D.
Just now i have tried in my system .
Hope it fix your issue, please let me know the status.
Thanks&Regards
Raghu.k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
KONV table possibly won't help me here as it doesn't hold the data which i am looking for. Am I right?
Thanks,
Safeer Rahman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi this has been discussed many times..pls search the forum.
Regards,
Raghu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Raghu...
Can you please provide the links to those threads if you could find out...
Please note that KONV table holds only the condition record values.I want to know where the value which we would enter during the creation of sales order would be saved...
Pointers would be very much appreciated.
Thanks,
Safeer Rahman
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.