on 01-11-2010 6:07 AM
Dear All
My client want to track all the changes which user will made in the sales order, they want this in report where they will show all the change which user made in the sales order within that period.
Changes may be anything for example price, tax code change, quantity, material change, if material is entered first and later that material is deleted this should also need to be tracked.
Example: While creating purchase orders in MM module, there is a version control mechanism for tracking changes in terms of price, quantity, taxes or even cancellations. Similar type of tracking is needed for Sales orders also.
If you have any idea on this please suggest me.
Thanks and Regards
Bhushan Kolte
Hi,
Try this t-code S_P6B_12000144, it used to display change documents for sales document, hope can help you!
Good luck
Tao
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Tao
Thanks for information. but this cant give information for example if material is changed then it didn't give information about old material and new material ( In which table this information will go and how i will fetch this information)
if material is deleted by the user then from which table the deleted material information i will fetch.
Thanks and Regards
Bhushan Kolte
Hi,
You can track changes CDHDR (for header changes) and CDPOS (for item changes), you can thus prepare a report with the help from ABAPer.
For example go to se11 and out CDHDR and put your sales document number and this table will show you the changes made with time and user also. But you just need to be sure about the object value and change doc object, so that you can give proper inputs to ABAPer.
I hope this is useful..
Regards
Arya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Arya
I made changes in the line item, when i am going to check this item in table CDPOS ( SE11) ,But the changes i cant in the output.
similarly i made change in the sales order at header level ( in the purchase order VBKD-BSTKD) but still not appear in CDHDR table.
Thanks and Regards
Bhushan Kolte
Hi Bhushan,
For example if you have changed customer purchase order number sales order. Then please follow this process.
Go to SE11> table CDHDR> in object value field put you document number as XXXX (please put star before and after the sales document number) and put date also, when change in made> from the output list get the object value > put these object values in the selection list of object value in CDPOS> you will get the list of old value and new values for various changes made..
I have again tried this just now...and I am able to get the data..
Hope it is useful....revert in case of doubts..
Regards
Arya
Edited by: Arya Achalam on Jan 11, 2010 1:34 PM
Hi,
Go to program MV45AFZZ, check tables XVBUK,XVBUP & YVBUK,YVBUP, there you can view the old values and new values of overall status changes.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can get the CHANGES Iin the report RSVTPROT
Goto the Transaction code SE38 and enter the report and get the change logs for the table VBAK
Please check and revert back if you need more details
regards,
santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Santosh
Thanks for information. but this cant give information for example if material is changed then it didn't give information about old material and new material ( In which table this information will go and how i will fetch this information)
if material is deleted by the user then from which table the deleted material information i will fetch.
Thanks and Regards
Bhushan Kolte
Dear Bhushan,
I hope you can get sales order changes on this report by executing this prg. RVSCD100 through SE38.
With regards,
Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Go to - VA02 >>> Envionment >>> Changes >>> Display document changes screen will appear >>>Execute >>>
Duble click on any row you will get details old value & new value.
Kapil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Kapil
Thanks for information. but this cant give information for example if material is changed then it didn't give information about old material and new material ( In which table this information will go and how i will fetch this information)
if material is deleted by the user then from which table the deleted material information i will fetch.
Thanks and Regards
Bhushan Kolte
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
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.