List of inhouse Materials without having routing

[Former Member]

Hi

SAP Buddy,

Please can any body tell me how to get a list of Inhouse procured material with Routing missing

Thanks in advance

Rgds

BV

Edited by: Brijesh Verma on Jan 15, 2009 4:02 PM

[Former Member · Accepted solution]

Hi,

Go to se16 and check table mapl. You will get the list.

Kindly revert back for further queries.

Regards,

satyajit

[Former Member · Accepted solution]

hi

actually MAPL gives details of existing Routing .. I want to know about the materials which are missing or without routing.. If some Standard transaction I will be thankfull..

Rgds

BV

[Former Member · Accepted solution]

Hi BV

There is no standard transaction available for this comparison.Just you CAn get the data from both tables MARC and MAPL and you can compare the datas.

You can write a Querry / Develop a report / Download it in Excel and using VLOOKUP comparing two sheets you can get the output.

Regards

Jayshankar.A

[Former Member]

Thanks you all ..

I am making it as answered

BV

[dhaval_choksi3]

Hi,

Go to CA02/CA03 and in Group Field press F4 and Search Using Material.You will find the report of Material Vs Routing.Download it by pressing Right key of Mouse.Then compare list with your material list.

Regards,

Dhaval

[Former Member]

This message was moderated.

[Former Member]

Hi Brijesh

You have to generate a report for this requirement .you dont have any standard report.

In MARC table you can get the Materials with Procurement type "E" the same can be compared in MAPL table.

in SQVI use table join and write a querry using the above mentioned tables.

Regards

Jayshankar.A

[Former Member]

thanks for your response ,.. becase it is required by user i need some standard transaction .. if so i will be thankfull

rgds

BV

[former_member184655]

Dear Brijesh Verma,

Since there's no standard T Code for obtaining this report,either you have to do it using your user id and

send to the user through mail or else create a query for the same and give the authorization for

executing a query along for SQ01.

Suppose if the user has got the list of In-house produced materials means,then you can go ahead as

suggested by Dhaval and compare using a V Lookup in Excle.

Check and revert back.

Regards

Mangalraj.S