topic Re: report in Application Development and Automation Discussions

report

Former Member — Wed, 23 Jan 2008 05:21:36 GMT

hi Experts

i have to keep this in a loop.

i am fetching the fields records for MATNR ,STLNR ,WERKS from the MAST table with the STLAN = 1 and STLAL = 01.

now i ahve to check above the material list with the STKO table with STLNR ,DATUV=SY-datum,LOEKZ NE X and STLST = 1.

plse help me how to do the checking.

with regards

aaryaa

Former Member — Wed, 23 Jan 2008 05:28:10 GMT

Hi,

Do as follows:

Select matnr stlnr werks

INTO CORRESPONDING FIELDS OF TABLE itab

FROM MAST

WHERE stlan = '1'

AND STLAL = '01'.

If you want to check whether itab data exist in STKO, and you want to delete the records of unavailable data from itab.

Loop at itab.

Select stlnr into g_f_stlnr

FROM STKO

WHERE stlnr = itab-stlnr

AND datuv = sy-datum

AND loekz <> 'X'

AND stlst = '1'.

If sy-subrc <> 0.

Delete itab.

endif.

Endloop.

Former Member — Wed, 23 Jan 2008 05:28:20 GMT

Hi,

select matnr werks stlnr from mast into table i_mast (using the where clause).

Now you can select data from STKO (Bom Header) using for all entries in i_mast.

check not i_mast[] is initial.

select (field list) from stko

into table i_stko

for all entries in i_mast

where stlty = 'M' (for material bom)

and stlnr = i_mast-stlnr.

*and any additional conditions.

Regards,

Shyam