Skip to Content
author's profile photo Former Member
Former Member

Using 'Not equal to' in condition record


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?



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 12, 2012 at 01:26 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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).

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2012 at 06:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.