BOM TABLES

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[former_member335885]

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

[former_member192897]

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

[Former Member]

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

[former_member581212]

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