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.