Using 'Not equal to' in condition record

[Former Member]

Hi

I have a requirement where some products cannot be shipped if the customer country is not equal to Italy. I wanted to create an exclusion record to achieve this but at the same time do not want to maintain multiple records for different countries.

How can I maintain the not equal to criteria in condition record?

Thanks

Kumar

[Former Member]

Dear Satish

The best solution for this is exclusion and you can avoid maintained huge data via creating a logical access sequence.

And there are only 206 some  countries,so it won't be that difficult to maintain it.

Thanking you!

Ashish Mishra

[Former Member]

Thank You Ashish

Can you eloborate 'logical access sequence'?

Regards

Kumar

[Private_Member_225646]

Hi Sathish,

You can maintain the condition record for any combination (Sales Org./Plant or Sales Org./Material) based on the business requirement, but for accessing this condition record you can maintain the requirement in VOFM routine that "if destination country is not equal to IT". So this condition record will be accessed only when the destination country is not equal to IT.

If destination country is IT then it will not pick this condition record, so your order will not be blocked for exclusion.

[Lakshmipathi]

Create a new routine in VOFM > Data Transfer > Orders,  where the coding logic can be for the field COUNTRY, except country IT, system should not proceed further if it is different.

G. Lakshmipathi

[Former Member]

Thank You Lakshmipathi.

I don't want to code this as business may decide to export the product after obtaining the required approval soon after the order is accepted.

Any other options - more maintainable?

Regards

Kumar

[Lakshmipathi]

You can have the Destination Country as one of those fields to your existing combination maintained in vb02.  Check in ov06

G. Lakshmipathi

[Jelena]

Satish Kumar wrote:
I don't want to code this as business may decide to export the product after obtaining the required approval soon after the order is accepted.

Not sure I understand the requirement completely... To my knowledge, there is no option to do "not equals" to in the condition records. Any special requirements need to be in the VOFM routine, like already suggested.

You don't have to hardcode 'Italy', but there should be some indicator maintained somewhere for what is allowed to be exported to what countries. This could be somewhere in material master or a custom table, doesn't matter. If "business decides to export", they would just change an indicator for the country / material (whatever the requirement is).