‎2007 Sep 26 2:32 PM
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
‎2007 Sep 26 2:35 PM
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
‎2007 Sep 26 2:35 PM
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
‎2007 Sep 26 2:45 PM
Yes, table KDST has solved my problem.
Thanks Anji for the help.
‎2007 Sep 26 2:36 PM
Hi Salil,
Check the following tables:
VBAP-STLNR
STKO
STPO
Reward points if helpful.
Ashvender
‎2007 Sep 26 2:37 PM
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
‎2007 Sep 26 2:42 PM
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