cancel
Showing results for 
Search instead for 
Did you mean: 

Reorder point planned material

former_member700523
Participant
0 Kudos

Hi Experts,

I have a huge number of materials with mrp type = VB - Reorder point planning & with other related data.

When stock falls below reorder point, MRP generates PR. This is OK.

But my question is on monitoring.

Since there are large number of parts & even if I use MD04 - collective access, then I get a huge list even if I enter the MRP controller & MRP Type  = VB in the selection.

But in that list how can I find the part for which stock is below ROP & there is a PR. In output there are columns plant stock & ROP with proper values for each part. But it is not practically feasible to look upon those columns for each & every part.

Also for VB parts, we could not get the traffic light indications by which I can get the above said required indication.

I do not want safety stock to be used for those VB parts.

I want some identication in MD04 or any where else so that I can come to know that - those are the parts for which stock is below ROP (it is obviously assumed that MRP had already created PR for that OR will create in next MRP run)

Any help would be appreciated & rewarded.

Thank you,

MHP

Accepted Solutions (1)

Accepted Solutions (1)

former_member186193
Active Contributor
0 Kudos

Hi,

Make a report using SQVI.

You can use a quick table join between MARA, MARC and MBEW. Mara is for basic data and the material group. MARC is most of the plant level data (including safety stock level) and MBEW contains a summarized stock level (provided your system uses plant as the valuation level). MAKT (material description).

Hope this helps.

Regards,

Alok Tiwari

former_member700523
Participant
0 Kudos

Hi Experts,

Any other suggestions please, User exits, reports any thing related is welcome

Regards,

MHP

sjeevan
Active Contributor
0 Kudos

There is no report which would meet your requirement. MRP just doesn't see re-order level it also looks at lot sizing which in turn may look at demands like customer orders or manual reservations etc to generate purchase requisitions. The only way would be to write a custom report in ABAP or using SQ01/SQ02/SQVI using master data table like MBEW and MARC.

(or)

Use table EBAN to build a query for all the generated PRs. Joining EBAN and MARC and putting conditions like MARC-DISMM = VB this will pull up all the PRs generated for re-order point material which needs to be purchased and you set up a background job to run as soon as MRP job is completed and set it to email the list in HTML format or TXT format.

former_member700523
Participant
0 Kudos

Hi All,

Thank you for all the replies & points are given.

I am able to write the query & run it as the background job.

It is running OK, but I am not getting the email on the given mail id in spool spool recipient.

Can I get some help please ?

Regards,

MHP

sjeevan
Active Contributor
0 Kudos

Go to SO00 and give some subject line (title) and some body of text and enter your email address in the bottom fields of screen, it should automatically pick the address internet address when you hit enter. Send the email and see if you receive it.

If you don't receive it you have to go to either SBWP (Inbox normally contain failure message) or SOST and see where there error is. And then make sure the SMTP settings in SCOT are fine also make sure the ports are open of SAP to communicate with email exchange server and your company fire wall is not blocking it.

If you receive email (meaning Business Workplace is working fine) then, there must be no data in the report for selection criteria you executed.

Former Member
0 Kudos

Hi Manish,

Please check SCOT and SOST transactions.

Regards,

Senthil

former_member700523
Participant
0 Kudos

Hi All,

Thanks for all the suggestions. Points are given & then closed.

Regards,

MHP

Answers (0)