mapping issue in idoc to JDBC scenario

[Former Member]

mapping issue in idoc to JDBC scenario

source structure

E1KNB1M

BUKRS = 1000

E1KNB1M

BUKRS= 9000

E1KNB1M

BUKRS= 2000

THE NODE E1KNB1M is repeated many times and the field BUKRS is also repeated with E1KNB1M as above

TARGET field : ISFRANCHISE

if any where value of BUKRS =9000 we have to pass Y to the target filed, else N

if BUKRS = 9000 THEN ISFRANCHISE= Y

ELSE

ISFRANCHISE=N

I've done the mapping as below

BUKRS = 9000--> IF THEN Y ELSE N--

---

> ISFRANCHISE

BUT everry time the target value is N only

pl suggest

rgds

mojib

[Former Member · Accepted solution]

Hi,

U can mapp like this

http://img19.imageshack.us/img19/7862/mapps.jpg

Regards

[Former Member · Accepted solution]

Hi Krishna ,

I tried ur mapping but every time for the first value of ISFRANCHISE is Y irrespective of the value of BUKRS and other values are not coming

pl help

rgds

mojib

[Former Member]

Hi Mojib,

What ever you have done that is correct, but you have to change the context of the source node (means BUKRS).

if you change the BUKRS context then it should work.

If we change the context then only it checks the next value of the particulat field otherwise it checks only first occurance only.

Regards

Ramesh

[Former Member]

Hi

I tried by changing the context to the uppper node , currently the context of BUKRS is at

E1KNB1M, thats why the question is in the forum

rgds

mojib

[Former Member]

Hi mojib

> I tried by changing the context to the uppper node , currently the context of BUKRS is at

> E1KNB1M, thats why the question is in the forum

Try by setting the context to parent of E1KNB1M node.

Regards

Ramesh

[Former Member]

Hi Ramesh

I did set the context to the parent node that is E1KNA1M, but it didnt work , rather I'ad done before writing to SDN

more suggestions pl ...

rgds

mojib

[Former Member]

mapped like this

BUKRS--->SORT---->
                                             EQUALS --------IF---THEN    Y
9000------------------------>                                               ----------------->ISFRANCHISE
                                                              ELSE   N

context of BUKRS set to parent node

its worked

thanks to all for valuable suggestions

rgds

mojib

[Former Member]

HI,

use the queues option provided in graphical mappings..

which shows the value passing at runtime and the output it is going to produce...

so in this case check the values passed for BUKRS by using display queue by right clicking on the node in mapping section

and observe what values are passing...

HTH

Rajesh