Regarding CS03 transaction

[Former Member]

Hi friends,

I have a simple query regarding the transaction CS03. When I give the Material Number, Plant and BOM Usage as input, I would get the list of components for this material.

Inside the transaction, is a CHECKBOX field ASM - this Indicates that the component for this material has its own BOM or has further components).

Could anyone tell me in which SAP table this information is stored i.e. an indicator to tell us if the component/material has further BOM or not.

I checked MAST and STPO tables but could not figure out the right field.

Awaiting your valuable inputs.

Thank You.

Regards,

Gayathri.

[vinod_gunaware2]

Hi

use function module CS_BOM_EXPL_MAT_V2

use table mlgt mlgn

regards

vinod

[FredericGirod]

Hi,

the CS tables are : IBIN, IBIB, IBST, IBIBT, ...

Rgd

Frédéric

[Former Member]

HI gayathri

it will be in any of these tables

STPN BOMs - follow-up control

STPU BOM - sub-item

STZU Permanent BOM data

PLMZ Allocation of BOM - items to operations

wait i will let you know

regards

kishore

[Former Member]

Hi,

Use the function module

CS_BOM_EXPL_MAT_V2.

This will give you separete tables for each BOM.

not sure with the tables..

Hope this helps..

Regards,

Shashank

[Former Member]

just go through ST05 and check from which table it is coming ...

or

if u have authorisation to open transection se49 than enter the transection n see from which table it is coming .....

[Former Member]

Hello Gayathri,

The logic is when u enter the material number/plant/BOM usage in CS03. It get the records from MAST for the parent item. For each of the record fetched from MAST it gets first level of items from STPO. Using these records it tries to access MAST again and for each read successful it will set this indicator.

[Former Member]

hi gayathri,

1.

the bom can exist for HALB or FERT .

u can dimnish the material not having a bom on this category .

i.e to say material type 'RAW' dosent hav a bom .

2.

like check out for table "MVKE" (Sales Data for Material) and in here check the fields

MVKE-MTPOS (Item category group from material master)MVKE-DWERK(Delivering Plant).

now giv the material and execute for initially dont giv a plant , and execute .

proceed with parent-matrial in bom and execute ,

u'll see the list of materials assigned in a particular sales area now check for MTPOS status this will have a category called LUMF ( this u will hav only for parent)

now say that the parent have 4 child materials (say)of which one has subassemblies so as u said it will hav a ASM check box ticked in CS03, now take this material and goto mvke and repeat the procedure and check the MTPOS status this will have item category like 'NORM'

remember for parent it was 'LUMF'

now for child(having subass;les) we got'NORM'

now check for same which dosent have a subassemblies from the child items it will be like 'ZATP' or 'XXXX' but not LUMF or NORM. to tell that it dosent hav further bom.

generalise the conclusion for all the materials(parent childorphans)if found okay apply this logic.

second alternative is ,

check the transaxction cs12.

give BOm material and observe that the first field(dglvl) ...

it indicates the level of that material in thta BOM.

exact indiaction is whether it has sub assemblies in that Material is the

field (BOMFL) If it has sub assemblies then it will be' X'.

see if u can make any hit in the tables using this relation above

regards,

vijay.

[Former Member]

Hi friends,

Thank you very much for all your valuable inputs. It has been of great use !!

Thanks again!

Regards,

Gayathri.