cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping clarification

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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 

Best regards, Martin

Answers (1)

Answers (1)

gagandeep_batra
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hello

I created an RFC lookup but the mapping seems to be incomplete as it is in yellow.

I have kept the result as boolean value and based on t or f, mapping the node.

Is it that i can apply rfc lookup only for element and not for node ?

Former Member
0 Kudos

Hi Anandha,

You can apply rfc lookup only for element.

Could you please paste your mapping here.  So that we will check and suggest you.

thanks,

Satish.

Former Member
0 Kudos

Hello,

Please find the screenshot.

I even mapped the rfclookup to an element and it is also in yellow.

I am using an tables parameter for returning the value.

Regards

Anandh.B

Former Member
0 Kudos

The red triangle indicates there is some error with the config of the RFC lookup.

Did you create a mapping parameter of type adapter and assigned it as Communication Channel to the RFC lookup?

Regards, Martin