cancel
Showing results for 
Search instead for 
Did you mean: 

MRP Dates

Former Member
0 Kudos

Hi,

We are developing a report in which I need to display the next demand date from MRP of a material. From which table can I get this?. I guess there is no data from MDTB.

I know that this date exists in MD04 report, but I need to specify the table name and field from which technical person needs to get the data.

Pls help me out.

Thanks and Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Please try with below fuction module

MD_STOCK_REQUIREMENTS_LIST_API

i hope this will solve your problem

regards

pradeep

Former Member
0 Kudos

Hi Pradeep,

Can you explain little in detail how to go about with this function module pls..?

Former Member
0 Kudos

Hi,

Goto t.code : SE37 , Give above function module and excute Single Test ( or Press F8)

This will go to " test function module:Initial screen" , Here assign value as follows,

MATNR=Your Header Material number

WERKS= PLANT

Then excute or press F8,

Now results will be populated in separate table in Result screen.

Now u can see results same as MD04 . See teh results in MDPSX table .

Same will be used for your report , plz try along with Abap`s.

regards

pradeep

Former Member
0 Kudos

Hi Pradeep,

Thank you for useful inputs. I guess, I am close to the solution with your valuable feedback.

I just did as per your instructions. But can I use MDPSX table to get the data to my report? If yes, How can I get the date field for the materials in a single plant when user enters a plant in selection screen..?

Pls do reply

Former Member
0 Kudos

Hi,

I think this FM works with plant specific since you are giving in the front screen (WERKS field ) .

what u have to do is, pass the Plant and Material Number from user input to FM module MATNRT,WERKS fieldS.

You have to create Zreport by using this FM, i hope this will be ,not an issue for your ABAP`rs

i hope ur problem is solved ifso plz reward and close the thread.

regards

pradeep

Former Member
0 Kudos

Hi Pradeep,

This was very useful to me...

My report should get only one earliest date of requirement from the list..not all the dates.

It should list Material, Plant, Next Date of Demand in Production.

User will give input only for the plant/MRP area/Warehouse

Former Member
0 Kudos

Hi,

i would suggest one way to develope report,

First create Material list with reference to plant/MRP Area/warehouse - For this u have to use any one of standard table.

Then pass the material list with plant number in that fuction module.

Now u ill get set of demands with different dates, select the next earliest date with reference to system date for each materials.

based on which u ill get required report output

regarsd

pradeep

Former Member
0 Kudos

Thank U pradeep, I will try out with your approach.

One last question, how could you find out the relavant Function Module for this. Is there any standard way through which I also can search for relavant FM?

I am rewarding you points here with

Thanks and Regards,

Former Member
0 Kudos

Pls do reply

Former Member
0 Kudos

Hi Pradeep,

I have a similer requirement here.

I would to sum up the requirements month wise and week wise.

Using the FM "MD_STOCK_REQUIREMENTS_LIST_API", it gives same as MD04 into the MDPSX.

Now my task is to get the requirements month & week wise.

Please let me know how can we get this data from "MD_STOCK_REQUIREMENTS_LIST_API"

Thanks in advance.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Check Table MDTB, field DAT00.

Former Member
0 Kudos

Hi Kannan

MDTB-DAT00 is not matching with the dates from MD04 list.

Former Member
0 Kudos

Hi,

It corrosponds to the requirements/ receipts date in MD04.

You can also try PCM02->DAT00.

If you need finish date of an order then try Table AFPO.