topic Re: component number in Application Development and Automation Discussions

component number

Former Member — Mon, 09 Oct 2006 10:24:57 GMT

hi everybody

I have to retrive the component numbe of a purchase order and sales order

i tried to look in the tables ekpo and vbap,but couldnt find it

does anybody know from wich tables or fm i can get the component number

Re: component number

Former Member — Mon, 09 Oct 2006 10:27:52 GMT

hi,

do u mean to say, item number..?

Re: component number

Former Member — Mon, 09 Oct 2006 10:28:59 GMT

no no, component number of a material

Re: component number

Former Member — Mon, 09 Oct 2006 10:30:13 GMT

Am not sure with your requirement...

With my guess it can be two ways...

1. Item referred as Component, then field will be VBAP-MATNR.

2. Incase of BOM Component, in this case also it will be VBAP-MATNR where NOT UEPOS is INITIAL and Highlevel item is BOM i.e NOT VBAP-STLNR is INITIAL where VBAP-POSNR = UEPOS from first condition.

Hope the above info helps you.

Kind Regards

Eswar

Re: component number

Former Member — Mon, 09 Oct 2006 10:31:15 GMT

Hi,

Do you mean BOM component?

if yes then look at STPO-IDNRK field.

Rgds,

Re: component number

Former Member — Mon, 09 Oct 2006 10:46:03 GMT

Maybe this query can help you simplify things incase of retereiving all BOM Components in Sales Order:

select matnr into table it_comp
       from vbap
       where vbeln in s_vbeln
       and   stlnr ne space
       and   uepos ne '00000'.

Kind Regards

Eswar