topic Re: Tables for BOM fields in Application Development and Automation Discussions

Tables for BOM fields

Former Member — Wed, 13 May 2009 13:58:36 GMT

Hi All,

From which tables should i fetch the following fields for a particular material in BOM:

KTEXT - Component Description

STLKZ - Indicator: Assembly

UPSKZ - Indicator: sub-item exist

DATUB - Valid to Date

DUMPS - Phantom item Indicator

FMENG - Fixed Quantity

LTXPO - Indicator: Long text exist for item

AENRA - Change Number To

Thanks in advance.

Regards,

Darpana.A

Re: Tables for BOM fields

naveen_inuganti2 — Wed, 13 May 2009 14:05:11 GMT

Hi,

STKO is the BOM header Table.

STPO is the BOM Items Table.

You can get these fields from these tables.

If required you can link above tables with MARA with help of MAST table.

MARA-MATNR ~~> MAST~~>STLNR ~~> STKO~~>STLNR

--Naveen.I

Re: Tables for BOM fields

Former Member — Wed, 13 May 2009 15:17:36 GMT

Hi Darpana ,

check the table -

RESB                             Reservation/dependent requirements
 STPO                             BOM item
 VSRESB_CN                        Version: Reservation/Dependent requirements

You require to use MAST , MARA , STKO , MAKT table also.

Regards

Pinaki

Re: Tables for BOM fields

Former Member — Wed, 13 May 2009 15:48:58 GMT

Hi Darpana,

Check My sample program, you will get all the details you need. everything available in STPO & STKO & MAST,, if you need extra fields, you modify accordingly.


TYPES : BEGIN OF TY_MAST,
MATNR TYPE MAST-MATNR, "Main Material (Parent)
WERKS TYPE MAST-WERKS,
STLAN TYPE MAST-STLAN,
STLNR TYPE MAST-STLNR,
STLAL TYPE MAST-STLAL,
END OF TY_MAST.
 
TYPES : BEGIN OF TY_STKO,
STLNR TYPE STKO-STLNR,
STLAL TYPE STKO-STLAL,
DATUV TYPE STKO-DATUV,
BMEIN TYPE STKO-BMEIN,
BMENG TYPE STKO-BMENG,
END OF TY_STKO.
 
TYPES : BEGIN OF TY_STPO,
STLNR TYPE STPO-STLNR,
DATUV TYPE STPO-DATUV,
IDNRK TYPE STPO-IDNRK, "Material Component (Child)
POSNR TYPE STPO-POSNR,
MEINS TYPE STPO-MEINS,
MENGE TYPE STPO-MENGE, "Bom Material Req Qty.
END OF TY_STPO.
 
TYPES : BEGIN OF TY_MAKT,
MATNR TYPE MAKT-MATNR,
MAKTX TYPE MAKT-MAKTX,
END OF TY_MAKT.
 
 
DATA : IT_MAST TYPE TABLE OF TY_MAST, WA_MAST LIKE LINE OF IT_MAST.
DATA : IT_MAKT TYPE TABLE OF TY_MAKT, WA_MAKT LIKE LINE OF IT_MAKT.
DATA : IT_STKO TYPE TABLE OF TY_STKO, WA_STKO LIKE LINE OF IT_STKO.
DATA : IT_STPO TYPE TABLE OF TY_STPO, WA_STPO LIKE LINE OF IT_STPO.
 
PARAMETERS : P_MATNR TYPE MARA-MATNR,
P_WERKS TYPE MSEG-WERKS.
 
SELECT MATNR WERKS STLAN STLNR STLAL
FROM MAST INTO TABLE IT_MAST
WHERE MATNR = P_MATNR AND
WERKS = P_WERKS AND
STLAN = '1'.
 
 
IF NOT IT_MAST IS INITIAL.
SELECT STLNR STLAL DATUV BMEIN BMENG
FROM STKO INTO TABLE IT_STKO
FOR ALL ENTRIES IN IT_MAST
WHERE STLNR = IT_MAST-STLNR AND
STLAL = IT_MAST-STLAL .
ENDIF.
 
IF NOT IT_STKO IS INITIAL.
SELECT STLNR DATUV IDNRK POSNR MEINS MENGE
FROM STPO INTO TABLE IT_STPO
FOR ALL ENTRIES IN IT_MAST
WHERE STLNR = IT_MAST-STLNR.
ENDIF.
 
IF NOT IT_STPO IS INITIAL.
SELECT MATNR MAKTX
FROM MAKT INTO TABLE IT_MAKT
FOR ALL ENTRIES IN IT_STPO
WHERE MATNR = IT_STPO-IDNRK AND
SPRAS = 'EN'.
ENDIF.

Thanks & Regards,

Dileep .C

Re: Tables for BOM fields

Former Member — Thu, 14 May 2009 05:05:32 GMT

STKO - BOM Header table -- Fetch BOM Value from this table

STPO -Item table --Pass the BOM value here and retreive all the item details

STPU BOM Sub Items (designators)

MAST BOM Group to Material

Re: Tables for BOM fields

Former Member — Thu, 14 May 2009 07:27:33 GMT

Hi,

Please check the following Tcodes for BOM Creation.

- CS01 : BOM create

- CS02: BOM Change

- CS03: BOM display

Please check which type of BOM.

1.Material BOM (or)

2.Equipment BOM (or). (Tcode : IE01,IE02,IE03)

Pre requisites are material master record for the materials.

What you have to keep in mind is:

1. BOM creation is through CS01 only.

2. When you have to create multilevel BOM, you have to carry craetion of BOM level by level.

3. First create BOM for assemblies (means materials which are produced inhouse, means materials with procurement type "E" in the material master MRP 2 view).

4. Finally create BOM for the finished product using these assemblies as components.

5. When you see the BOM of finished part after creation through CS03, you can find these assemblies with a tick mark in the field "Assembly". When you double click you can see the susequent BOM of these assemblies.

6. Example would be for a vehicle suppose engine, front wheel, back wheel are the "E"parts. Create BOM first for these engine, front wheel and backwheel with respective material components.

Then create BOM for vehicle with these three "E".

When you see the BOM of vehicle after creation, you can see a tick mark against these E parts which shows that they have BOM furtehr down and you can double click and see the components of these

Tables form BOM :

STKO - BOM header Table.

STPO - BOM Items Table.

MAST - BOM Group to Material

MARA-MATNR ~~> MAST~~>STLNR ~~> STKO~~>STLNR

EQUI-EQUNR --->

Regards

Pugazhenthi.P

Satyam Computer Services Ltd