Listing & Exclusion Query

[Former Member]

Dear Experts,

I have a query regaridng Listing and Exclusion, there is a customer A and material 1234 and the same material has a product hirerchy ABC123. Now we maintained listing and exclusion in following way for example:-

1. Lising :- Customer/material/sales org --A/1234/ABBB

2. Exclusion:- Customer/Product Hirerchy/Sales Org -- A/ABC123/ABBB

Now when i was trying to create a sales order with customer A & material number 1234 i am getting an error of exclusion. as the material is having product hirerechy ABC123.

So my Question is, is it possible when we create a sales order the system will check listing first and then exclusion, i mean to say that the system will allow material 1234(listing) but will exclude other material which are having product hirerchy ABC123.

I hope that the question is clear.

looking forward for your replies.

Regards,

Subhrangshu

[Former Member]

Hi,

Go to the T-code VB02,and give the sales area,and your material,then check the listing and exclusion,maintained for the specific material.

if listing is there for specific material, only u can use in the sales order,but not the exclusion material,

i think this will help u

Regards,

Atiq

[neeraj_lal]

Subhrangshu,

In Standard SAP Exclusion always get priority to listing.

So in standard SAP you can not achieve listing prior than exclusion.

If in case you need such logic than you have to check possibility of zdevelopment.

Any way sequence of field which you mentioned do not look correct. it should be sales org/ customer material ....

Regards

Neeraj

[former_member740474]

Hi Pitabash,

The system will check in this sequence:

1. If the material is allowed for the sales area where the order is placed.

2. Material is in the Exclusion list.

3. Materail is in the Listing list.

Hope this helps.

thanks

Saravanan Chinniah.

[Former Member]

Hi,

Your condition table creation is not correct. try  to follow SAP rule .

Always put the header date first then item like :- Sales org/Customer/material

Sales org/Customer/ product hirerchy

But make sure you have a logical condition.

Like you have maintained the material in listing & exclusion. so system will through error.

There is no special logic to search first Listing and then Exclusion.

If this is the scenario then create the condition table for Exclusion table like this:-

Sales org/Customer/ product hirerchy/material . So that it will restrict to that material rather than a group.

Hope it will help you to understand

Regards

Pitabash