Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Table for Sales Order BOM

former_member188001
Active Participant
0 Likes
13,915

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

1 ACCEPTED SOLUTION
Read only

Former Member
6,941

Hi

check the tables <b>STPO and STKO</b>

you may find the BOM number for sales order

also use the Table <b>KDST</b> to link the Sales order to BOM

and also use the table <b>MAST</b> 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

5 REPLIES 5
Read only

Former Member
6,942

Hi

check the tables <b>STPO and STKO</b>

you may find the BOM number for sales order

also use the Table <b>KDST</b> to link the Sales order to BOM

and also use the table <b>MAST</b> 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

Read only

0 Likes
6,941

Yes, table KDST has solved my problem.

Thanks Anji for the help.

Read only

Former Member
0 Likes
6,941

Hi Salil,

Check the following tables:

VBAP-STLNR

STKO

STPO

Reward points if helpful.

Ashvender

Read only

Former Member
0 Likes
6,941

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

Read only

0 Likes
6,941

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