Tcode for materials display created date wise

[Former Member]

Hi all,

Can I have a list display of materials created date wish and i should be able to take a printout of it for approval.

Eg. i have to get the list of materials created in a month.

Points will be rewarded

Thanks & Regards,

Reddy

[former_member335885 · Accepted solution]

Hi,

Try OIWB t.code

You will get what you wanted with date wise material creation.

Thanks & Regards,

Kiran

[Former Member · Accepted solution]

Hi,

Try OIW8.

Select Maintain field selection list and press enter.

Goto Settings from menu, select layout and choose current and select the created on field.

Regards,

Chandra

[Former Member]

hi

Goto MARA

there you will get list of material with date of creation

if u select the or keep curser on created on column and then to sort ascending press CtrlShiftF5 and to sort descending press CtrlShiftF6

You can download same to excel sheet

goto system at menu then select list -- save -- local file and select spddred sheet and save to required location

Regards

[Former Member]

Hi,

You can get list of mateiral with created date.

Goto T.code : SE16 and enter table MARA press enter.

In selection screen just press execute button.

You will get list of materials and created date and created by etc...

you can download this list, goto Edit from menu choose download and select spreadsheet give file name and save it .

Regards,

Chandra

Edited by: chandra sekhar S on Jun 5, 2008 12:09 PM

[Former Member]

Hi

Please check in table MARA, you can get the list of materials created in a specified duration.

Further you can make a Z - report for extracting the same using tables MARA, MARC, MBEW, MARD.... whcih you can print & submit for approval

[Garcia]

Hi Kiran,

Since you don't have that information in MM60... I sujest you create a simple query on table MARA ou MARC (if you want it dependable on material/plant).

Then you can simply print it (it's ALV like).

Do you want guidance on query generation?

Regards.

[Former Member]

Yes.. how is it may i know??

Regards,

Kiran

[Former Member]

Hi

In SE16 table MARA, give the created on date and created to date and execute.

U will get list of material created in between these dates.

Vishal...

[Former Member]

Hi,

The user does not have the authoisation for SE16 and he will not get the authoriation for it.

So is there any tcode ??

Thanks & regards,

Kiran

[Garcia]

Hi again,

A Query is a list of data taken from a table or several tables. You have SQ02, SQ01 and SQ03 to create user group, infoset and query (by the order).

In the end you have to ask for ABAP help to create a transaction SE93 for the report.

Go to http://www.easymarketplace.de/online-pdfs.php and download this manual: 'SAP Query (BC-SRV-QUE)'.

This will be quite useful to you. Put some effort on it!

Regards.

[Former Member]

Hi,

Try MM50 T.code. You get Material and created date and material type.

Reward if it is helpful

Regards,

Chandra