Skip to Content
0
Former Member
Mar 02, 2009 at 07:05 AM

BOM Details

159 Views

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.