Duplicate in Sales Order...

[Former Member]

Hi,

When we make a Sales Order, we don't want duplicate material codes in order, but in our case it is accepting duplicate material.

How to restrict duplicate material in sales order.

Yusuf

[Former Member]

If you want to eliminate duplicate sales order use the transaction SDD1

[Former Member]

Hi Jenibalet,

Not Sales Orders, We want to Eliminate Duplicate Item(Materials) in same Sales Order.

Yusuf

[Former Member]

Hi Yusuf,

As Siarhei has mentioned earlier, I feel you would need to handle this through user exit for the Sales order. Do the code changes in form USEREXIT_CHECK_VBAP in the include MV45AFZB (program SAPMV45A)..you should make a check on XVBAP internal table to check if the table includes duplicate material number and trigger error message accordingly. Please take help of Abaper to do the changes

Regards,

[Former Member]

If you want to prevent 2 items in sales order with same material - in userexit like userexit_check_vbap or userexit_move_field_to_vbap, read internal table xvbap and issue an error message if your material is there with different item number.

[Former Member]

Hi,

Can please elaborate as to what is a duplicate material code. Is it that say enter line 10 as pen, it should not repeat again in the sales order. Please confirm.

Thanks & Regards

Sadhu Kishore

[Former Member]

Hi Kishore,

Yes, What U have explained that is right.

So, What is the solution.

Yusuf

[Former Member]

In the material master why dont you try giving the valid from date for a future date. then these materials cant be used for your sales order.

or you can use the other filed to restrict the usage

"Distribution-chain-specific material status"

Indicates whether, for a specific distribution chain, the material may be used in individual functions in Sales and Distribution.

Use

The distribution-chain-specific material status restricts the usability of the material for the distribution chain concerned, that is, it defines whether a warning or error message is displayed if you include the material in a particular function.

Example

The material may be a part under development or one to be discontinued.

reward points if it helps

regards

Biju