Question Re: BOM extractor in Technology Q&A

BOM extractor

Former Member — Wed, 19 Sep 2007 22:47:45 GMT

Does anyone of you know the business content extractor for BOM table? We have a requirement to break down our SD key figures to the component level for device set and such extractor will be required to be able to report at that level.

Thank you in advance for any help!

Sharon

Re: BOM extractor

Former Member — Thu, 20 Sep 2007 04:12:16 GMT

Hi..

MAST Material BOM

STKO BOM Header

STPO BOM Positions (detail)

MAPL Assignment fo Task Lists to Materials

PLKO Routing Group Header

PLSO Routing Group Sequence

PLPO Routing Group Operations

AFKO Production Order Header

AFPO Production Order Position (details)

May be you can use the FM 'CSAP_MAT_BOM_READ' to read the BOM.

There are many tables used in TCode CS03. If you check by pressing F1 and then technical details, it will give the structure name only.

I am giving you set of tables, check them.

Also you can run ABAP Trace. the TCode is ST05. Don't forget to switch off trace once you are done. Otherwise it will reduce the system performance. In case doubt , let me know.

Run Transcation code SE30. then enter your transcation for which you would like to find out the database tables. then execute the complete cysle of the transcation then come back to the initial screen. clck on analyse button. then click on GOTO meno and select the 2nd option i.e. Object-centered Hit List and then select database table to find out the complete list of database table.

http://www.sapgenie.com/abap/tables_pp.htm

Message was edited by:

krish

Re: BOM extractor

Former Member — Thu, 20 Sep 2007 05:16:17 GMT

Hi,

As mentioned your requirement is shown below in thwe BOM tables such as:

STKO = BOM-Header

STPO = BOM-Item

STAS = BOM - Item selection

STPN = BOM - follow-up control

STPU = BOM -subitem

STZU = Permanent BOM data

PLAZ = Allocation of BOM - temd to operations

MAST = Materail to BOM links

KDST = Sales order to BOM link

your requirement for SD key figures, you can check the tables KDST, it has shown all SD relavant datas.

The T.codes for BOM is CS01, CS02, CS03.

let me know any clarifications,

Regards,

Mohan R

Re: BOM extractor

Former Member — Thu, 20 Sep 2007 10:31:45 GMT

Hi Sharon,

Use the estractor 2LIS_04_P_COMP (Component view)

Please assign points if this helps.

regards,

Vinay

Re: BOM extractor

Former Member — Thu, 20 Sep 2007 22:28:47 GMT

Hi Vinay!

I activated the extractor and run rsa3 at the source system but I didn't see any data. Do I need to run the setup table to be able to view the data in rsa3? If so, what application do I need to run the setup table?

Thanks,

Sharon