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