topic Re: Table for Sales Order BOM in Application Development and Automation Discussions

Table for Sales Order BOM

former_member188001 — Wed, 26 Sep 2007 13:32:49 GMT

Hello Friends,

I would like to know the database table which stores Sales Order BOM details.

Actually I want to print the BOM Header Text in my output smartform. For this, I am using the below data.

Language : EN

Text Id : KZU

Text Object : BOM

Text name : Combination of SY-MANDT 'K' and BOM in transaction CS62.

I dont know from where should i pick up this BOM Number.

Thanks,

Salil

Re: Table for Sales Order BOM

Former Member — Wed, 26 Sep 2007 13:35:51 GMT

check the tables STPO and STKO

you may find the BOM number for sales order

also use the Table KDST to link the Sales order to BOM

and also use the table MAST to find the link to MATERIAL BOM by taking the sales order material

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Message was edited by:

Anji Reddy Vangala

Re: Table for Sales Order BOM

Former Member — Wed, 26 Sep 2007 13:36:59 GMT

Hi Salil,

Check the following tables:

VBAP-STLNR

STKO

STPO

Reward points if helpful.

Ashvender

Re: Table for Sales Order BOM

Former Member — Wed, 26 Sep 2007 13:37:25 GMT

hi,

STLAN ( 5 = Sales BOM ) field in the table MAST .

u can find the BOm number for the Material Number.

Reward Points if it is Useful.

Thanks,

Manjunath MS

Re: Table for Sales Order BOM

former_member188001 — Wed, 26 Sep 2007 13:42:14 GMT

Hi Manjunath,

Its not working, infact when I give STLAN = 5, it says no entries found.

But if i run the table just by MATNR, it gives me some entries having STLAN = 3.

But the thing is I want STLNR which appears in transaction CS62. Currently I am getting STLNR which is appearing in transaction CS02.

Regards,

Salil

Re: Table for Sales Order BOM

former_member188001 — Wed, 26 Sep 2007 13:45:16 GMT

Yes, table KDST has solved my problem.

Thanks Anji for the help.