Hai All,
I am developing 1 report of BOM details.
In the below query, I am joining Marc and plpo table.
But no data is coming to i_final internal table.
I am not able to find out the reason. Please help me.
SELECT a~matnr
a~werks
a~basmg
a~bstmi
a~bstma
b~meinh
b~ltxa1
b~vgw01
b~vge01
b~vgw02
b~vge02
b~lifnr
b~istnr
INTO CORRESPONDING FIELDS OF TABLE i_final
FROM marc AS a INNER JOIN plpo AS b
ON aplnnr = bplnnr
FOR ALL ENTRIES IN i_stpo
WHERE a~matnr = i_stpo-idnrk.