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'.