Trx. WRF_DIS_SEL in combination with table VAPMA an field VBAP-ABGRU

[frank_schwerin2]

Hi together,
I've a question regarding the transacation 'WRF_DIS_SEL - Client-Wide Material Discontinuation' - specially with the function Material Discontinuation for Plants in combination with field 'reason for rejection - VBAP-ABGRU.
Please let me explain the situation: I've created a sales order for material A witch is assigned to plant A10Land another sales order for material A, but these material is assigned to plant A10A - see attachment. For these sales order the reason for rejection (K7) is set, so that the status of the sales order is full completed.
Now I try to discontinue the material for plant A10A with transaction WRF_DIS_SEL. But it is not possible because I get the message: material is use in sales and distribution - fully processed.
Is there someone who can me tell the reason for that and what I've to do in this case.
Many thanks in advance for your help.

material-plant.jpg

sales-order.jpg

material-discontinuation-for-plants.jpg

[Jelena]

Regarding my analysis the problem could be the entry in table VAPMA. Is 
there any possibility to reorganize the table VAPMA or to delete entries
 in table VAPMA?

VAPMA is simply an index table by material. It is populated based on VBAP table. It's used to improve performance when looking up data by material number. It's simply duplicate data (here duplication is intentional) and the main source is VBAP.

Even when line item is rejected, this will never delete an entry in VAPMA. Otherwise this would create data inconsistency since VAPMA is a "shadow" of VBAP. With this in mind, your options are as follows:

1. Remove reason for rejection and delete the line items using a standard transaction. This will permanently delete both VBAP and VAPMA entries. It may or may not be feasible or desired.

2. Archive sales order data. This can only be done with the whole order, not individual lines though. But this would also result in data deletion after archiving.

3. If this transaction works fine with completed items but not rejected ones, contact SAP Support. Rejected items should be treated same way as completed ones for discontinuation purposes IMHO.

[frank_schwerin2]

Hi,

many thanks for your answer. But the named OSS notes do not help.
Regarding my analysis the problem could be the entry in table VAPMA. Is there any possibility to reorganize the table VAPMA or to delete entries in table VAPMA?

[Lakshmipathi]

I believe the primary tag which you used "Sales and Distribution" should have been IS Retail which I have added as a secondary tag. Meanwhile, have a look at OSS notes 1236086 and 1268969