on 04-08-2016 8:14 AM
Hello, i am new to ABAP and i need your help.
I have requirement to read all open purchase orders, open deliveries and open purchase requisitions for some specific plant and material.
i think that all of this could be achieved over FM BAPI_MATERIAL_STOCK_REQ_LIST, but i am not completely sure how.
Open purchase order should be retrieved form structure type bapi_mrp_stock_detail - field rec_reqd_qty.
I am not sure how open deliveries and open purchase requisitions should be retrieved and i need your help with this.
Thank you in advance
Yes, you can use the mentioned BAPI to read these MRP elements.
Just run the BAPI using the material and plant as input parameters and you will find all the open MRP elements on the return table MRP_IND_LINES.
Here, you should filter the desired MRP elements using the field MRP_ELEMENT_IND. You can check the possible values for this field opening the domain DELKZ on transaction SE11 and checking the value range.
Regards
Caetano
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Caetano.
First of all - thank you for your reply.
Actually i am already using this BAPI and i have filtered desired MRP elements (i need values 'BE' and 'BA').
I have already successfully pulled value of open purchase order from field mrp_ind_lines-rec_reqd_qty.
Now i need to pull value of open deliveries but i don't know from which field (or more fields should be combined for this) - that is the main problem.
Best regards,
Tomislav
hi Tomislav,
once you create purchase order from open purchase req, the purchase req will be replaced by the purchase order in stock req list.
for purchase req status check table. - EBAN
for delivery header status - VBUK
for delivery item status - VBUP
if you want bapi - then check.
BAPI_REQUISITION_GETDETAIL Display Purchase Requisition Details
regards,
Solomon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Salomon,
Thank you for clarification.
For purchase requisition i have solved that with select on tables.
I still cannot find open deliveries (i need quantity), and i have only WERKS and MATNR.
I believe that this value can be found through BAPI_MATERIAL_STOCK_REQ_LIST (Tables mrp_ind_lines) but I'm not sure which field refers to opened deliveries.
Best regards,
Tomislav
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.