Skip to Content

Putting filter in message mapping

I am trying to put a filter for company codes such that if a type of company code comes in the file from source, it will filter out and send it to target system. I have set of company codes and values that I want to pass but want to filter out some company codes with certain values only. How can I achieve that? One possible way I can think of is If/then/Else logic with fixed values mapping.

Is there a blog or step by step guide? Can anyone help how I can do this in message mapping?

Thanks for your help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jun 20, 2006 at 03:23 AM

    Rajan,

    You can do Conditional receiver Determination wherein , you can do content based routing.

    If you want to do the filtering in your mapping, then you can use the If..then.. else Function of graphical mapping. Take a look at this link for the same,

    http://help.sap.com/saphelp_nw04/helpdata/en/5d/db0e83e8e74202a5bff527055ab7e5/content.htm

    Regards,

    Bhavesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rajan,

      All you have yo do in the message mapping is:

      Companycode >Ifelse >Parent node.

      But you have to make sure as to there will be one record in the file which will be valid else your receiver structure will not be created and mapping will go into error.

      Else, if there is a condtion that there might be no valid records in the file then you can check that in Module of the file adpater and reject hte file if there is no data.

      Regards

      Vijaya

  • author's profile photo Former Member
    Former Member
    Posted on Jun 20, 2006 at 04:26 AM

    Rajan

    Using FixedValues might be a solution, you can use a Key-Value pair to fix values to CompanyCodes from input file,with an option to filter out the rest with default or empty value..

    If not then using IF-ELSE would be your solution

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2008 at 04:19 AM

    Filtering of the records based on values of the fields is possible.

    See SAP Help: [MapExampleFilterRecordsByQualifier|http://help.sap.com/saphelp_nw70/helpdata/en/84/e8763c997fda50e10000000a11405a/frameset.htm]

    Note The conditional field is assigned to the higher context so that it can be read before the target field (to be filtered) is created.

    Add a comment
    10|10000 characters needed characters exceeded

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.