link rbkp and bkpf table using inner join

[former_member366518]

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 .

[Sandra_Rossi · Accepted solution]

The answer is simply in the ABAP documentation.

sql_exp - sql_string_func and SELECT - JOIN : ... CROSS JOIN bkpf AS bk WHERE CONCAT( rb~belnr , rb~gjahr ) = bk~awkey

[former_member366518 · Accepted solution]

Hello Sandra,

Thanks for reply , Could you please explain in details.i am not able to find.

[Sandra_Rossi · Accepted solution]

sql_exp - sql_string_func and SELECT - JOIN : ... CROSS JOIN bkpf AS bk WHERE CONCAT( rb~belnr , rb~gjahr ) = bk~awkey