Skip to Content
-1
May 15, 2020 at 11:06 AM

Splitting the Join condition

221 Views Last edit May 15, 2020 at 11:08 AM 2 rev

Hi experts,

I hope you are doing well. I have a requirement to break the below select query without using JOIN, could anyone help me to do this.

SELECT a~mblnr
a~mjahr
a~bldat
a~budat
a~xblnr
b~matnr
b~werks
b~lgort
b~erfmg
b~erfme
b~j_3asiz
b~j_4ksca FROM mkpf AS a JOIN mseg AS b ON ( a~mblnr EQ b~mblnrAND a~mjahr EQ b~mjahr ) INTO TABLE g_it_mkpf_mseg

FOR ALL ENTRIES IN g_it_sales

WHERE a~xblnr EQ g_it_sales-vbeln_dlv AND b~shkzg EQ 'S'.