topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 05 Jan 2006 22:21:46 GMT

Friends,

I have 2 tables: MARA, STPO.

In a report all MATNR(material no.s) are displayed in the output as of now. Now i have to dispaly the BOM(STPO-IDNRK)for the corresponding MATNR.

So how to write the select statement for this.

plz help me.

Thanks a lot,

Venu

Former Member — Fri, 06 Jan 2006 05:23:45 GMT

Hi Venu,

Please check this link.

Regards,

Siva

P.S: Award points if you find this useful.

Former Member — Fri, 06 Jan 2006 05:37:32 GMT

HI~

You can use a 'Funtion Module' :

(ex)

CALL FUNCTION 'CSAP_MAT_BOM_ITEM_SELECT'

EXPORTING

material = p_material

plant = p_plant

bom_usage = p_bom_usage

alternative = p_alternative

fl_material_check = 'X'

fl_foreign_key_check = 'X'

TABLES

t_stpo = tbl_stpo

EXCEPTIONS

error = 1

OTHERS = 2 .

if you find a material header - (BOM Header)

then you can use above that.

make sure function parameters and

structure.

then... Bye... (Good Luck; GL) ^^