on 02-24-2009 1:13 PM
Dear all,
I am a BI Consultant. I dont have much idea on SD tables. here is my reporting requirement:
Need to track the number of manual intervention by Customer on the price during the order entry.
In certain exceptional cases, the Customer can change Price, Rebates, Surcharge charges etc. for a sales order..
so i want to know, which SD table holds these type of price changes information???
i mean where can i get all these Price Change Summary? [Manually changed by Customer!!]..
help me out..
Thanks n advance.
Luv
Srini
Hi
Please check the table CDHDR (for Header) and CDPOS (for Line Item) for any change in document. You may check by making any change in the order and then Put the Order no. in Object Value field (OBJECTID ) in the table CDHDR & CDPOS (Transaction SE16 ) and execute.
Hope it will help
Regards
AA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srini
Check the table KONV and KOMP,KOMK which are related to pricing
Also check VBAK ,VBAP tables which are related to sales order
Regards
Srinath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.