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

Mapping clarification

Hello,

We are using PI 7.1.1.

We have a file to IDOC scenario where we might require to do an ecc lookup in the mapping.

My source structure has the following nodes

Salesline

Barcode

Qty

Price

My part of idoc structure has

E1J3p01

menge

These are the values that i get in the salesline node

5000000001

20

2.00

5000000002

30

3.00

500000003

40

4.00

I need to do an ecc lookup passing the barcode values to check whether these are present in an Z table.

Following that assume 1 and 3 are present, I need to map the corresponding qty into e1j3p01-menge.

Since the key is barcode, these are the following questions.

1. Should i be using RFC lookup and if so how do i do it

2. Based on the return value of true or false, how do i map it , do i require any udf

3. Can i do this without BPM and do we have any special functionality in pi7.1.1 for lookup to ECC

Any blogs or examples would be good.

Thanks in advance,

Regards

Anandh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2012 at 09:32 AM

    Hi Anandh, yes you can use RFC lookup from a mapping. No BPM necessary for this.

    Please have a look at the following blogs they will guide you 😊

    SAP PI 7.1 Mapping Enhancements Series: Graphical Support for JDBC and RFC Lookups

    Graphical RFC Lookup and How you can design lookups for multiple values to be retrieved in a single call

    Best regards, Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 30, 2012 at 09:44 AM

    Hi Anandha,

    1. Should i be using RFC lookup and if so how do i do it

    Yes you can go with RFC lookup

    check below link for rfc Lookup

    http://saptechnical.com/Tutorials/XI/RFCLookup/Index.htm

    2. Based on the return value of true or false, how do i map it , do i require any udf

    you can go with createif function to create the parent node if rfc return true then it will create.

    3. Can i do this without BPM and do we have any special functionality in pi7.1.1 for lookup to ECC

    yes you can do without BPM check the above link

    Regards

    Gagan

    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.