Lookup issue for File to Idoc scenario-- Urgent Pls.

[Former Member]

Hi All,

Iam doing File to IDoc scenario with one file --> any of 3 R/3 systems.

Routing has to be done dynamically using a lookup file, based on the incoming GLN code and last character of the Order Reference number.

The last character of the Order ref Num will have A,B or C.

Where, ' A' for R/3 152 Client

' B' for R/3 142 Client

'C' for R/3 132 Client.

1. PlantGLN_Routing lookup file :

DestinationSystem, Plant GLNCode, Partner Number,

A, 5000243000473, GDKDVRC152,

B, 5000243000473, GDKDVRC142,

C, 5000243000473, GDKDVRC132,

A 500034000487 GDKDVRC152,

B 500034000487 GDKDVRC142,

C 500034000487 GDKDVRC132,

By Using DestinationSystem and Plant GLN Code as lookup key --> I need to get the value of partner system.

2. IdocCtrlLookup

Purpose: To read the IdocCtrlLookup file to populate the Idoc control segment

Now based on the partner system from previous table --> I need to get the details of Sender Port , Sender Partner Type , Sender Partner Function , Sender Partner Number , Rx Port , Rx Partner Type , Rx Partner Function , Rx Partner Number.

Please help me how can acheive this scenario with the help of lookups.

Its very urgent.

Regards

Krupakar.

[Former Member · Accepted solution]

HI,

Here you would have to use one mapping for dynamic routing , based on this create IM and use it in receiver determination.

the another mapping is general to file to idoc.

see the dynamic routing link here

Dynamic Configuration of Some Communication Channel Parameters using Message Mapping -

/people/william.li/blog/2006/04/18/dynamic-configuration-of-some-communication-channel-parameters-using-message-mapping

Also if you know the field name the context object can be defined for partner no that can be used in receiver determination in condition. to particular partner no in receiver determination.

Regards

Chilla