Skip to Content
0
Former Member
Feb 26, 2009 at 07:25 AM

connect a few MM&FI tables

492 Views

hi,

I need to link the tables EKKO, EKKN, EKPO, MSEG, BSEG (need dmbtr, gjahr) and BKPF (only need hwaer)!

After searching a while i found the following connections:

EKKO - EKPO (using ebeln)

EKPO - EKKN (using ebeln & ebelp)

EKPO - MSEG over Table EKBE with (EKPO-EKBE ebeln&ebelp AND EKBE(lfbnr, lfgja,lfpos)-MSEG(mblnr, mjahr, zeile)

EKPO - BSEG (using ebeln&ebelp)

BSEG - BKPF (using bukrs,belnr,gjahr)

Are these connections alright?

To join the tables with the mentioned connections is very slow - so is there another way to link them? Especially the clustered table bseg will be a problem!

Hope to see a solution!

Regards

Jacko