on 11-27-2007 8:41 AM
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
Hi,
Please try with below fuction module
MD_STOCK_REQUIREMENTS_LIST_API
i hope this will solve your problem
regards
pradeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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.
Hi,
Check Table MDTB, field DAT00.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.