Skip to Content
0
Former Member
May 15, 2008 at 10:01 AM

reg: join statement

21 Views

Hi,

SELECT abelnr agjahr abuzei aebeln aebelp abukrs a~werks

awrbtr amwskz

b~matkl

FROM rseg AS a

JOIN ekpo AS b

ON aebeln = bebeln

AND aebelp = bebelp

AND abukrs = bbukrs

AND awerks = bwerks

INTO TABLE tbl_rseg_ekpo

FOR ALL ENTRIES IN tbl_cross

WHERE belnr = tbl_cross-awkey

AND gjahr = tbl_cross-gjahr.

Is it good join statement or not ?

Why Iam doubt is in RSEG ebeln, ebelp are not the key fields

which are key fields in ekpo.

Please give ur suggestions.