cancel
Showing results for 
Search instead for 
Did you mean: 

Sales Documents changes - Report

Former Member
0 Kudos

Hi Gurus,

In our SAP environment most of the orders are created thru web, when this order lands in SAP I can see order created by as "WEBUSER". Due to some portal issues sometime some data is getting missed out and orders placed in SAP missing some data Ex: delivery date.

As a manual work around user input this data in SAP via VA02.

Requirement: Business want a report of all oders where manual changes are done.

how can i get this report? is it possible from any table?

Yash

Accepted Solutions (1)

Accepted Solutions (1)

former_member131745
Product and Topic Expert
Product and Topic Expert
0 Kudos

You could also create your own Ztable and pass the information across with the help of a userexit e,.g. USEREXIT_SAVE_DOCUMENT.

I hope this helps.

Gerard

Answers (1)

Answers (1)

former_member183879
Active Contributor
0 Kudos

Hi,

You have to create a Z report of yourself. You have to make use of the tables CDHDR and CDPOS. In these tables the document numbers, the table name which was changed are all available. So you need to explore little bit and standardise your logic.

You can use CDHDR-TCODE = VA02 and find out the changes done. Once you get the document numbers, you can pass these document numbers in CDPOS and get the changes done at the item level also

You can make use of the field CDHDR-CHANGE_IND to get only insertions/deletions/modifications etc.