not getting BOM value

Former Member — Mon, 29 Mar 2010 05:45:17 GMT

Hi all,

here i want to fetch BOM value for this i write code like below.


SELECT a~budat a~mblnr b~matnr b~menge b~bwart d~idnrk
INTO CORRESPONDING FIELDS OF TABLE it_rawmat
FROM ( ( mkpf as a inner join mseg as b on a~mblnr = b~mblnr )
* inner join mast as c on c~matnr = b~matnr )
inner join stpo as d on d~idnrk = b~matnr )
where b~bwart = '261' and b~werks in werks and b~matnr in matnr and a~budat in budat. "and d~idnrk in idnrk.

IF sy-subrc 0.
MESSAGE ' No Data For This Selection' TYPE 'I'.
SUBMIT ZPP_RAWMAT_CONSUMPTION VIA SELECTION-SCREEN.

ENDIF.

LOOP AT it_rawmat.

select single maktx
from makt
into it_rawmat-maktx
where matnr = it_rawmat-matnr.

select single matnr menge
from mseg
into (it_rawmat-matnr1, it_rawmat-menge1)
where mblnr = it_rawmat-mblnr AND bwart = '131'.



SELECT SINGLE maktx
from makt
into it_rawmat-maktx2
where matnr = it_rawmat-matnr1.

* SELECT single matnr stlnr
* from mast
* INTO (it_rawmat-matnr3, it_rawmat-stlnr)
* where matnr = it_rawmat-matnr1.

select SINGLE menge
from stpo
into it_rawmat-bomit
where idnrk = it_rawmat-matnr.

according to above code i get value of BOM filed in ALV which is previous ALV field value.

means BOM value and previous filed value both are same.

So can u please kindly help me out.

Thanks in Advance.

keyur

Re: not getting BOM value

Former Member — Mon, 29 Mar 2010 07:16:58 GMT

data is getting but ALV problem

topic Re: not getting BOM value in Application Development and Automation Discussions

not getting BOM value

Re: not getting BOM value