Material List Report

[Former Member]

Hi Gurus,

We are looking for a report where it gives us information about maintanence status for example in our organisation we have materials maintained in 4 plants,

some materials have sales views and some does not have. i have generated a query using MARA, MVKE and MARC tables.

when i run that query if a material does not have sales views it is not giving the information of those materials. i need a report where it gives me all information of all materials even though materials sales views are not maintained. what i mean is if a material has no sales view it should display blank in those fields and give information of views it has maintained.

i will give an example as well,

material X maintained for Purchasing view only.

Material X1 maintained for purchasing and sales view and accounting views.

Material X3 maintained for sales, Purchasing and Accounting views.

when i select all 3 materials in my query, only X1 and X3 are displayed because it has sales view. iam missing X here.

Can some one please throw some light on this, how i can achive this.

Thank you gurus in advance,

Regards,

Nathan.

[Former Member · Accepted solution]

Hi Nathan,

You can use MRAC-PSTAT for above purpose

By looking at value in PSTAT you can arrive at maintenance status of a material

Following are the abbreviations used in PSTAT feild.

User department Maintenance status

Work scheduling A

Accounting B

Classification C

MRP D

Purchasing E

Production resources/tools F

Costing G

Basic data K

Storage L

Forecasting P

Quality management Q

Warehouse management S

Sales V

Plant stocks X

Storage location stocks Z

Regards

[Former Member · Accepted solution]

hi ali,

It helps in informing status, but still in that query if i use mvke table it does not give any info of that material if it does not have sales views.

iam looking for a report which it gives purchasing data atleast even if it does not have sales data.

Thanks,

Nathan.

[Former Member · Accepted solution]

Hi Nathan,

I guess you're query is using SQVI or SQ01, if it is so, then do not have an inner join on MVKE table, change the join to left outer join, it should work.

Regards,

Vivek

[Former Member · Accepted solution]

Hi Vivek,

That sounds very interesting as i have not tried that one, can you please explain a bit step by step please like where do i go to select that in join conditions.

Thanks a lot in advance,

regards,

Nathan

[Former Member · Accepted solution]

Hi Vivek,

I had tried to join by left outer join as well, but still iam missing the data in my query.

Can you please elaborate if i had missed anything.

Thanks in advance,

Nathan.

[Former Member · Accepted solution]

Hi,

It would be helpful if you let us know which tables you have used & what are the join conditions you have specified.

Regards,

Vivek

[Former Member · Accepted solution]

Hi vivek,

I have used MARA, MVKE and MARC tables.

Joined the Tables with Material number in 3 tables. First it was default join and after your suggestion i wrote another query with same tables and joined the MARA to MVKE by left outer join.

iam getting the same result again. there is no change in output. iam missing the details which are not maintained for sales views.

Thanks,

Nathan.

[Former Member · Accepted solution]

Which is the primary table in your join condition is it MARA or MVKE? Please insert MARA as your primary table & then do a left outer join on MVKE with field MATNR. Also if you need the plant details, then do a inner-join between MARA & MARC with field MATNR.

Check & revert if it meets your need.