BOM related

[Former Member]

Dear all , we have requriement at our client that

List of BOMs with 'Inactive ' status along with the reason should be made available.

pls reply .

prerna Verma

[Former Member]

Hi,

In SAP standard report I do not think their is any T code which will give you such list

But you extract data from tables.

In table MAST put input plant & then take all BOM number avalable in plant.

Put this BOM number in table STKO give inputs all BOM number got from MAST table & also deletion flag X in input screen of STKO.

Run the transaction you will get allBOMs whchi are inactive status.

Normally t code SE16 ( For tables search )we never gives to user so better you give them extracted data.

I think this will help you.

Regards

SANIL

[Former Member]

Can we manage it with Query report ?

[Former Member]

Join table MAST & STKO in SQVI

[Former Member]

Dear , After using given table where we get the Reason ..means at which transaction or new z transaction?

[Former Member]

Also SQVI is not valid table

[Former Member]

For you info, SQVI is a transaction code, not a table.- through wichi you can develop your own query. Sujitha suggesting you to use SQVI to build a query - joining the tables MAST & STKO.

[Former Member]

Thnx Ravi for explaning my query .

As per you and sujit i am going to work on that ...and revert you son ..

Regards ,

Prerna Verma