select statement

[Former Member]

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]

Hi Venu,

Please check this link.

Regards,

Siva

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

[Former Member]

HI~

You can use a 'Funtion Module' :

(ex)

CALL FUNCTION 'CSAP_MAT_BOM_ITEM_SELECT'

EXPORTING

• I_STPO =

material = p_material

plant = p_plant

bom_usage = p_bom_usage

alternative = p_alternative

• VALID_FROM =

• VALID_TO =

fl_material_check = 'X'

fl_foreign_key_check = 'X'

• IMPORTING

• FL_WARNING =

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) ^^