How to display Fat/Medium/Slow moving materials in Query

[former_member188325]

Hi All,

i have a requirement like this:

we have no of issues 0NO_VAL_ISS (KF).Now i need to display fast moving(F),slow moving (S) and non moving (N)materials in the report.

F:If a material is issued to prod at least one in each month over a period of last 12 months

S:If a material is issued to prod only on six different months over a period of past 12 months

N:if a material is not issued to prod as all over a period of past 12 months.

how can get this? any ideas?

regards

[Former Member · Accepted solution]

Hi,

Adding to what Anil has already stated.

I am really not sure why you would need a Multiprovider, as I understand the 0NO_VAL_ISS (KF) must be with reference to Material, so I guess 0Material should be available in the Cube. Correct me if I am wrong.

From the reporting aspect

Instead of restricting each column of the 12 columns by a period you could use a variable for Period and use offsetting in the rest of the 11 columns to make it more flexible. (for sure you would need 12 columns as Anil stated, and you can make them hidden)

You could have a formula column(hidden) in the report which count the number of issues

Formula = COUNT ( column1 ) + COUNT ( column2 ) + COUNT ( column3 ).....and so for the 12 periods

At the end you can have a three status column like

F represented by

(Formula >= 12 )

S represented by

(Formula >= 6 AND Formula <12)

N represented by

(Formula = 0 )

The above will again give you a status of 1 if the condition is satisfied, not sure how you can see F, N or S as the value.

If you do the above you can get all the Fast/slow/medium moving items in the same report.

Hope it helps.

Cheers

Anurag

Message was edited by: Anurag Khungar

[Former Member · Accepted solution]

Hi Anurag Khungar And CMD,

Muliprovider will be used to find the Non moved materials only.For other cases (Slow ,Fast) ,the MP is not required.

With rgds,

Anil Kumar Sharma .P

[former_member188325 · Accepted solution]

Hi anil & Anurog,

Thanks for u r suggestions.With small adjustments in the above mentioned logics,i have got F,S&N materials.For Non moving materials,i have restricted no of isues KF with a variable called LAST 12 MONTHS EXCLUDING CURRENT MONTH(0CALMONTH).So if its 0 then its non moving material.

regards

[Former Member · Accepted solution]

Hi CMD,

You should use MP for Non movabale Materials.

You will miss few materials in the result of the query defined as you mentioned in the previous thread.

Your approach Displays the materials which has atleast one record in the cube(i.e for any period), but do not have the movements in your restricted period.

So If a material is stocked in the plant, But Not yet has the movement from starting day to till date.That material will not displyed in your report. But actually it is a non moving material.

With rgds,

Anil Kumar Sharma .P

[former_member188325 · Accepted solution]

Hi Anil,

thanks for u r suggestion.Will propose the same for getting N materials.problem is Clinet needs everything in one report.

regards

Message was edited by: cmd

[Former Member]

Hi,

1) Define a Multi provider on 0MATERIAL and the cube ( which has 0NO_VAL_ISS (KF).).

http://help.sap.com/saphelp_bw32/helpdata/en/40/cb051118bd3549a9e39958561fdf8e/frameset.htm

2)Drag and drop 0MAterial in to the rows area. (there should be only one cahracterstic in the rows, and that is material).

3) Drag and drop the KF 0NO_VAL_ISS 12 times to columns area and restrict each one with separate Period.And hide them all.

say column1,column2,...column12.

4) Create a formula like this, and hide it :

(column1> 0 AND column2 > 0 AND column3 > 0 AND column4 > 0 ....column12 >0 )

5) Create a condition for the report as Formula = 1.

So this report display the all Fast moving materials .

Similarly we need to 2 more reports for displaying slow moving (S) and non moving (N)materials seperately.

I will Let you Know , if all are possible in a single report.

With rgds,

Anil Kumar Sharma .P

Message was edited by: Anil Kumar Sharma

[former_member188325]

Hi Anil,

Thnaks for u r reply.0MATERIAL is already available in the vube.So still i need to go for Multicube?i think its not required.AM i rght?

regards

[former_member188325]

Thnks for u r replies guys.I will try out and let u know.

regards