Restricted values in dropdown lists for Order Reason and Rejection Reason

[former_member207661]

Hello all,

Here is a blog about recently added standard functionality.

 

Requirement:

In my current project, I came across a scenario for Sales Order, where we wanted to restrict dropdown values for Order Reason.

For example, let's say we have maintained below 5 Order Reasons via customization:

980, 981, 982, 983, 984

Now, for a particular scenario (combination of Document Type + Sales Organization), if we want to display only 980, 981 and 982 as possible Order Reason, this was not possible in general (can be achieve with enhancements).

So far, all the possible values were available in drop-down for Order Reason and Rejection Reason.

 

Solution:

On searching in SAP ONE Support, I found that SAP has released a standard solution(SAP Note 2477027 in Mar 2019) for this, which is available starting from SAP_APPL 605-17 and other similar releases and packs.(detailed information available in SAP Note).

As part of this solution, we can now restrict drop-down values for Order Reason and Rejection Reason based on Sales Organization and Sales Document Type by maintaining entries in

• Table TVAU_AUART_VKO for filtering drop down values in Order Reason (Tcode VAUP)


• Table TVAG_AUART_VKO for filtering drop down values in Rejection Reason (Tcode VAGP)

 

For Order Reason, if we need only 980, 981 and 982 for Sales Org 7111 and Document Type ZSAM, below highlighted entries need to be maintained.



 

Outcome is as below:



 

Similarily, this can be achieved for Order Rejection Reason also via TCode VAGP.

 

Hope this will help some of the consultants / clients who have been looking for this feature.

 

Thanks for reading. Do let me know your feedback in comments section below.

 

Warm Regards,

Shyam Agrawal

[arnabsarkar2601]

Hi Shyam,

I am not able to find the T code - VAGP . Can you please help on this ?

 

Regards,

Arnab

[former_member207661]

Hi Arnab,

Please refer Note 2477027 to see if this feature is available for your system.(based on SAP_APPL version).

Also check if maintenance view V_TVAG_AUART_VKO exists in your system.

There are few pre-requisites also, which might need to be done in order to use this feature(if it is not available already).

Regards,

Shyam

[mmcisme1]

Nice one.  I did know about the order reason - simply because we had to do something similar.  It's always nice to have a blog.  I can't remember how I eventually figured it out.  I think I finally found it by working through IMG step by step until I found it.  There are probably questions out there too.

 

[former_member183501]

Hi Shyam,

Good one and thanks for sharing!

Such requirement comes from business and only enhancement becomes an option to restrict this.

This will surely help to many SD consultants.

Regards

Kamlesh

[former_member513833]

Hi Shyam,

Thank you so much for sharing this blog for SAP note. This solution also worked for our business requirement as well.

Just only one issue I observed that. It did not create any IMG path in SPRO after note implementation. I have crated Transaction codes as per pre-requisites. But how to link to SPRO ?

1. VAUP = customizing to maintain the permitted order reasons (IMG path "Sales and Distribution -> Sales -> Sales Documents -> Sales Document Header -> Assign Order Reasons to Sales Document Types and Sales Organizations").


2. VAGP = customizing to maintain the permitted rejection reasons (IMG path "Sales and Distribution -> Sales -> Sales Documents -> Sales Document Item -> Assign Rejection Reasons to Sales Document Types and Sales Organizations").
   Examples

Thanks

Ritesh Parikh