Skip to Content
avatar image
-2
Former Member

link rbkp and bkpf table using inner join

Hi Experts,

My problem is not able to link rbkp and bkpf without using 'for all entries' , currently am working on S4 HANA server if i check program using code inspector it showing error if i am using 'for all entries' . so i have to join both the table using inner join on

rbkp-belnr + rbkp-gjahr = bkpf-awkey . Is there any option to concatenate rbkp-belnr + rbkp-gjahr in inner join statement.

SELECT rb~belnr
rb~gjahr
rb~blart
rb~bldat
rb~budat
rb~xblnr
rb~bukrs
rb~lifnr
rb~waers
rb~wmwst1
rb~mwskz1
rb~bupla
rb~plc_sup
rs~buzei
rs~ebeln
rs~ebelp
rs~matnr
rs~werks
rs~wrbtr
rs~menge
rs~bstme
rs~xblnr
rs~lfbnr
rs~lifnr
lf~name1
lf~stcd3
INTO TABLE gt_rbkp FROM ( rbkp AS rb INNER JOIN rseg AS rs ON rb~belnr = rs~belnr
AND rb~gjahr = rs~gjahr )
INNER JOIN lfa1 AS lf ON lf~lifnr = rb~lifnr
WHERE rb~bukrs EQ scode
AND rb~gjahr EQ syear
AND rb~belnr IN sbelnr
AND rb~budat IN sbudat
AND rb~bupla IN sbupla
AND rb~lifnr IN slifnr .

for further query please reply

Thanks in advance .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 11, 2017 at 06:15 AM

    The answer is simply in the ABAP documentation.

    Add comment
    10|10000 characters needed characters exceeded