Issue with a graphical mapping -

[former_member182004]

Hi folks,

I have an issue with a graphical mapping.

We are replicating the Material Master, with an interface of ECC -> PI -> JDBC.

The idoc we are using is the MATMAS.MATMAS05, and in the database we created 5 tables, simulating the structure of the source idoc. The tables are: MARA, MARC, MARD, MBEW, MAKT.

The fact is that we need some data of some segments (tables) in another ones.

In this case we I need to take a value of the segment E1MARCM (MARC) to the MBEW table. The value is: SERNP.

The condition to copy that value is the centre (WERKS). So, the condition will be:

If MBEW-WERKS == MARC-WERKS,

then MBEW-SERNP = MARC-SERNP.

The problem I'm having is that I have to lookup in many different E1MARCM segments, and the relation is not 1...1, nor, E1MBEWM is a child of it (they are in the same level.)

For example there could come:

- E1MARCM_1 (WERKS = 0001)

- E1MARCM_2 (WERKS = 0002)

- E1MARCM_3 (WERKS = 0003)

- E1MBEWM_1 (WERKS = 0001)

- E1MBEWM_2 (WERKS = 0002)

- E1MBEWM_3 (WERKS = 0002)

- E1MBEWM_4 (WERKS = 0003)

- E1MBEWM_5 (WERKS = 0003)

Am I clear with the requirement?

Any answer will be greatly appreciated.

Thanks in advance.

.Juan.

[former_member182004]

Hey folks, any advice or input about this?

Thanks again.

Juan