Skip to Content
avatar image
Former Member

BOM TABLES

Dear all,

Could you please let me know the tables where

finished product and all components store (BOM) (in a same table)

MDSB i am able to see the componets only MAST finished product only

regards

venu gopal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 31, 2008 at 06:44 AM

    Hi

    Use Tables

    STKO BOM Header

    STPO BOM item

    STPU BOM Subitem

    you need to use also the MAST Table, using the Field Value

    STLAN - BOM Usage

    STLNR - Bill of material

    you can retreive the BOM compnenets

    Create a query using the Tbale MAST & join the Tables STKO, STPO, STPU.

    Thanks & Regards

    Kishore

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 31, 2008 at 08:20 AM

    PLPLAN_PARAM BOM-dependent planning parameter

    SNUM BOM explosion number

    STAS BOMs - Item Selection

    STKO BOM Header

    STPN BOM Follow-Up Control

    STPO BOM item

    STPU BOM Subitem

    T415S BOM status

    T415T BOM Status Texts

    T416 BOM Usage - Item Statuses

    T416T BOM Usage Texts

    T618EM BOM of CAP material components

    TCS09 BOM Control Depending on Category and Usage

    TCS11 BOM Objects

    TCS15 BOMs with History Requirement

    TCS17 BOMs with History Requirement

    TCS19 BOM Item Object Types

    TCS21 BOM Item Object Types: internal > external

    TCS22 BOM Item Object Types: external > internal

    TCS31 BOM Field Selection - Usage (T416)

    TCS32 BOM to Plant Allocation - Field Selection

    TCS33 BOM Field Selection (SAP)

    TCS34 BOM Field Selection - Control Data (TCS03)

    Regards,

    Ashok

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 31, 2008 at 08:24 AM

    HI,

    CIF_IMMBOM IMod Reference Table for Material BOM's

    CIF_MD_CHANGES Changes to BOM, Routing and Production Version

    CLRK Recursiveness Info on Objects in Classes for BOM

    CLST Link class - BOM

    CONT02_STPO Container Table for BOM Item

    CONV_MATRICES Matrixes that must be checked into BOMs

    CUOBOM_CHANGE Manually Changed Items in the Order BOM

    CUPE Extension to BOM Item for Variants

    DOST Document to BOM Link

    EQST Equipment to BOM Link

    KDST Sales Order to BOM Link

    MAST Material to BOM Link

    MDHS Cluster Table BOMs Explosion (Shared Buffer)

    PLPLAN_PARAM BOM-dependent planning parameter

    PRST Project - BOM link

    SCEDECOMP Decomposition (BOM and so on)

    SCEHASPRT Components of Decomposition (BOM and so on)

    SCEPRTDEP Assignment of Dependencies to Components (of BOM)

    SNUM BOM explosion number

    STAS BOMs - Item Selection

    STKO BOM Header

    STPF Structure tree of the exploded BOM

    STPN BOM Follow-Up Control

    STPO BOM item

    STPU BOM Sub-Item

    STST Standard BOM Link

    STZU Permanent BOM data

    SUMS New key assignment: BOM explosion no.->New BOM explosion no.

    T415A Alternative BOM Determination

    T415M Material Types Allowed in BOM

    T415S BOM status

    T415T BOM Status Texts

    T416 BOM Usage - Item Statuses

    T416T BOM Usage Texts

    T416V Copy defaults for BOM usage - item statuses

    T618EM BOM of CAP material components

    TCLOI3 Usage Filter for BOM Selection

    TCLOI4 Status Filter for BOM Selection

    TCNIF Assembly item/WBS element assignment BOM transfer

    TCNIFP Profile for BOM transfer

    TCNIFPT Language Dependent Text for BOM Transfer Profile

    TCNIP01 Control stock/account assignment for interface EBOM/PS

    TCNRFP Reference Point for BOM transfer

    TCS03 Modification Parameters/Defaults for BOMs

    TCS05 Transaction-Specific Defaults for BOMs

    TCS07 Default Sort Sequence for BOM items

    TCS09 BOM Control Depending on Category and Usage

    TCS11 BOM Objects

    TCS13 Object Status for BOM Layout Variants

    TCS15 BOMs with History Requirement

    TCS17 BOMs with History Requirement

    TCS19 BOM Item Object Types

    TCS20 Texts for BOM Item Object Types

    TCS21 BOM Item Object Types: internal

    TCS22 BOM Item Object Types: external

    TCS31 BOM Field Selection - Usage (T416)

    TCS32 BOM to Plant Allocation - Field Selection

    TCS33 BOM Field Selection (SAP)

    TCS34 BOM Field Selection - Control Data (TCS03)

    TCS41 Automatic alternative BOM determination

    TCSFG Field group definition - BOMs

    TCSFGF Allocation of fields to field groups - BOMs

    TCSFGT Field group texts for BOMs

    TCSPR User Profile for BOMs

    TPST Functional Location - BOM Link

    Thanks & Regards,

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2008 at 06:46 AM

    hi,

    PALTID -iPPE alternative: time-independent ID and attributes

    PALTTX- iPPE alternative: texts

    /ISDFPS/PAMPOS - Component basic data

    /ISDFPS/PAMPO- User-defined texts for components

    /ISDFPS/PRMPOID

    : Component BOM

    /ISDFPS/PRMPO

    And other more tables are:

    http://help.sap.com/erp2005_ehp_03/helpdata/EN/92/58c3c8417011d189ec0000e81ddfac/frameset.htm

    Regards,

    Priyanka.P

    AWARD IF HELPFULL

    Edited by: Priyanka Paltanwale on Jul 31, 2008 8:48 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 31, 2008 at 06:47 AM

    Bill of Material

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 31, 2008 at 09:00 AM

    Hi

    These are stored in different tables only as the BOM Contains Header, Item & Sub Item level , they are not stored in a single table

    Thanks & Regards

    Kishore

    Add comment
    10|10000 characters needed characters exceeded