topic Re: about bom table in Application Development and Automation Discussions

about bom table

Former Member — Thu, 30 Oct 2008 07:48:33 GMT

i am doing sd report its need the the material data ( previous ) , the bom transaction cs12 , what is the table for cs12.

Edited by: Julius Bussche on Oct 30, 2008 9:05 AM

Re: about bom table

GauthamV — Thu, 30 Oct 2008 07:50:52 GMT

hi,

use these tables.

STKO

MAST.

Re: about bom table

Former Member — Thu, 30 Oct 2008 07:51:36 GMT

use transaction ST05 to trace the SQL actions.

MAST, STKO, STPO, STAS, STZU are the most important ones, but there will be several others.

Re: about bom table

Former Member — Thu, 30 Oct 2008 07:54:03 GMT

Hi,

STPO BOM Item Details

STPU BOM Sub Items (designators)

STKO BOM Header Details

MAST BOM Group to Material

STZU BOM History Records

STAS BOM Item Selection

STPF BOM Explosion Structure

This Are the BOM tables U will get All details in those tables.

Reagards

Ranga

Re: about bom table

Former Member — Thu, 30 Oct 2008 07:56:00 GMT

Hi Ravi,

BOM tables

MAST represent for Material to BOM Link

STKO represent for BOM Header

STPO represent for BOM item

Cheers!!

VEnk@

Re: about bom table

former_member585060 — Thu, 30 Oct 2008 08:00:44 GMT

Hi,

These are the tables accessed by Tcode CS12

AENR,

MARC,

MTCOM,

MC29M,

MC29S,

MTCOR,

USR02,

RC29L,

T001W,

TC04,

TCS41,

TCC08,

TCS03,

TCSVL,

TCSPR.

Regards

Bala Krishna

Re: about bom table

Former Member — Thu, 30 Oct 2008 08:03:50 GMT

hi,

the transaction cs12 is generated by report SAPMC29L.

i have checked it and found that it is a module pool.

the internal tracking id for this report is 11236.

hope this will help u out:).

regards,

Alpa.

Re: about bom table

Former Member — Thu, 30 Oct 2008 08:07:41 GMT

Please put in a bit of effort to search before asking "what is the table" type questions.

Thanks,

Julius

Re: about bom table

Former Member — Fri, 05 Dec 2008 11:22:50 GMT

This message was moderated.

Re: about bom table

Former Member — Fri, 05 Dec 2008 11:23:28 GMT

Last warning to you and all your colleagues.

Your recent threads have been deleted, again....

Re: about bom table

Former Member — Fri, 05 Dec 2008 13:02:20 GMT

Hi,

Use the FM

CALL FUNCTION 'CS_BOM_EXPL_MAT_V2'

EXPORTING

capid =

datuv =

emeng =

mehrs =

mmaps =

mtnrv =

stlal =

stlan =

werks =

TABLES

stb =

matcat =

EXCEPTIONS

material_not_found = 1

OTHERS = 2.

and pass the following parameters u will get all related BOm materials and respective data.

Please try this.

Thanks

Eswar