‎2008 Oct 30 7:48 AM
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
‎2008 Oct 30 7:50 AM
‎2008 Oct 30 7:51 AM
use transaction ST05 to trace the SQL actions.
MAST, STKO, STPO, STAS, STZU are the most important ones, but there will be several others.
‎2008 Oct 30 7:54 AM
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
‎2008 Oct 30 7:56 AM
Hi Ravi,
BOM tables
MAST represent for Material to BOM Link
STKO represent for BOM Header
STPO represent for BOM item
Cheers!!
VEnk@
‎2008 Oct 30 8:00 AM
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
‎2008 Oct 30 8:03 AM
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.
‎2008 Oct 30 8:07 AM
Please put in a bit of effort to search before asking "what is the table" type questions.
Thanks,
Julius
‎2008 Dec 05 11:22 AM
‎2008 Dec 05 11:23 AM
Last warning to you and all your colleagues.
Your recent threads have been deleted, again....
‎2008 Dec 05 1:02 PM
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