Need t-code for materials which doesn't have BOM

[Former Member]

Hi,

Is there any T-code to find out list of materials(fert) which doesn't have a BOM.

thanks/regards

vish

[rupesh_brahmankar3 · Accepted solution]

Hi,

Possibly, you can query the table" MAST" for the list of materials with Se16.

If you want to find details of individual materials:

Use transaction codes:

CS03 - Material BOM here you will get list of material haveing BOM by pressing F4.

Regards,

R.Brahmankar

[dhaval_choksi3]

Hy Vishwanath,

There is one uniq way is there which helps you to find our fert / Halb code without BOM.

Go to MD21 and select low level code 999 and execute.

try this one.

Regards

Dhaval choksi

[muthusamy_sankaran]

Hi,

There is no std tcode for this requirment, but you can create simple query for this (SQVI)

Using this t.code : SQVI you can create your own report without the help of ABAP.

you have to seelct a common field in both the table you join

you can create report using one table (or) you can join more tables

following are the steps given

1. Enter t.code : SQVI

2. Enter the name : TEST press the create button.

3.Enter the title & Comments

4.Select table to join

5.Select the second icon (INSERT TABLE)

6 enter table name : MARC

7.again insert table

8.enter table name : MAST

Note the table you are joining should have COMMON field

9. press green arrow button

10. Select the output parameters in table 1 - MARC

11 Select the output parameters in table 2 - MAST

12. select the layout

13 SAVE

The table you are joining should have the COMMON field this is mandatory

For more details, pls refer below link

Regards,

Sankaran

[Former Member]

Hi!,

I don't think there is any such transaction available. (But you can get the list of material who has a BOM from MM02 (F4 options). To get the required list you need to develop a small customized report. The logic may be like: Input plant code on input screen. Let system to check all the available materials in the MARC table for given plant. This list of materials(MATNR) to be supplied to MAST table and those materials which doesn't have corresponding STLNR (BOM No.) can be outputted as the desired list. I hope this will help in resolving the issue. Please revert back in case of any further clarification.

Regards,

Uday

[Former Member]

Hi Vishwanath,

there is not any specific t-code for finding the material which is not having BOM

You can maintian diferent material group and through that in MM60 u can find it according to the group and material type combination

Nilesh