Blocking Sale by 3 digit Zip code

[Former Member]

Hi Experts,

Is it possible to block the sale for selected items to selected 3 digit Zip code ?

Regards,

Christine

[Former Member]

Hi Christine;

1. In T.Code OV06 add the field ZIP Code to the filed catalouge. Once done create a table with ZIP code alone. Include this as part of your access sequence in the Listings/Exclusion condition type.Once done use VB01 to create a Condition record and list all the materials to be excluded under this ZIP code.From now on when ever you want to create a order for these materials in the ZIP code you will not be able to....this would typically solve your issue.... but this is not advisable as this is too generic.

2. What you can do is to add a couple of more fields in terms of Customer # and other parameters as you may wish and then proceed as above. This is will be more specific and you will have better control ove the whole process.

Regards,

Mani.

[Former Member]

Hi

Currently I am working for a US Project. My client want to block the sale of some materials to some particular Zip code. Zip code has to read from the customer master data. Every line item material entry has to check the Zip code. If the Zip code is under the Exclusin list then the system should block the sales order creation for that particular item.

Regards

Christine.

[Former Member]

Hi christine,

Well you can set up a customer block based on the sales area, now since the customer data also includes his zip so its more or less same.

You can set up a delivery block at OVLS according to Order, picking Confirmation etc.. You can also set up a block in VD05 and like wise you can add additional requirements with your ABAP ers help.

Reward if helpful

thanks

Adi

[Former Member]

HI critine,

if u want to achieve this without abapper's help,then u can go for material exclusion.

in spro customise for material exclusion with condition table fields as kunnr,material and zipcode field from kna1 table ,if this field is not included in field catalogue,then u will have to append this field into required structure.

so that if u maintain records for customer x and zipcode 100 with material xyz,system will not allow to create sales order for a particular line item

this is doable and achievable,

reward if helps.

else u can also take abapper's help and write a small validation check in exit MV45AFZZ post save command ,that if customer's zipcode is 100 and material is ur own business logic,then system gives an error message.

this is also a work around,if not interested in above customising.

reward if helps !!!!!

[Former Member]

i didnt get your point could you be more specific?

thanks

adi