Reason for rejection date

[Former Member]

Hi all,

i am about to solve a problem, but have no idea how.

In tcode VA03 if you put sales document in order field and than choose in upper menu (Enviroment -> Changes) you get the 'Display Document Changes'. After F8 pushed, list of changes is displayed for every Item of the order.

Now, I am interested in change named - 'Reason for rejection of quotations and sales orders changed' and specially for it's date. This change should arise when item is canceled (rejected) and field ABGRU (Reason for rejection) change its value. (At least I've been told so).

I would like to use this functionality (with sales document as input, find the date of mentioned cancellation of item - date for 'Reason for rejection of quotations and sales orders changed') in report but I am unable to trace the proper connections between tables.

I've found out that dates of changes for sales documents are stored in table CDHDR, but there are dates for all changes made within sales document and I don't know how to choose (filter) the date for 'Reason for rejection of quotations and sales orders changed' Somehow it must be connected with field ABGRU.

Thanks in advance for every help.

[Former Member]

Hi all,

i am about to solve a problem, but have no idea how.

In tcode VA03 if you put sales document in order field and than choose in upper menu (Enviroment -> Changes) you get the 'Display Document Changes'. After F8 pushed, list of changes is displayed for every Item of the order.

Now, I am interested in change named - 'Reason for rejection of quotations and sales orders changed' and specially for it's date. This change should arise when item is canceled (rejected) and field ABGRU (Reason for rejection) change its value. (At least I've been told so).

I would like to use this functionality (with sales document as input, find the date of mentioned cancellation of item - date for 'Reason for rejection of quotations and sales orders changed') in report but I am unable to trace the proper connections between tables.

I've found out that dates of changes for sales documents are stored in table CDHDR, but there are dates for all changes made within sales document and I don't know how to choose (filter) the date for 'Reason for rejection of quotations and sales orders changed' Somehow it must be connected with field ABGRU.

Thanks in advance for every help.

[Former Member]

Hi John,

You can very well find the list of sales orders rejected on a specific day using the change document objects.

Make use of tables CDHDR and CDPOS to find the list.

Fetch the table CDHDR for the list of sales orders changed using the change document object 'VERKBELEG'.

Input the the first three fields of table CDHDR to table CDPOS.

Cross check the entries from CDPOS where the field is 'ABGRU-Reason for rejection'.

You can confirm where all the orders have been rejected.

Regards,

Babul.

[Former Member]

Hi John,

Now you just link the CDPOS table with your CDHDR table & look in the FNAME field... you will get what you want.

Thanks & regards,

Dileep .C