SAP Query -To get MRP information

[Former Member]

Crrently SAP query having 3 tables PBID PBIM MARC to get PIR data. I want MRP information(MRP AREA) for corresponding material and plant. PBID is another table that i want to add which contains MRP information. but on exeuting the query the data is coming inconsistent. Could you help me please ?

[Former Member]

Hi,

i think that if you want read MRP data you can use this Function Module:

MD_STOCK_REQUIREMENTS_LIST_API

Best Regards

Ivan

[Former Member]

HI,

Original Query was created using SQ01 transaction and I  have to update the same .

Best Regards,

Mayank Khandelwal

[former_member192971]

Hi ,

In PBID - you can see the fields MATNR(Material Number), WERKS(Plant) and BERID(MRP Area) and whereas MATNR,WERKS is also having in that PBIM table .

so write a query like ...

Select  BERID MATNR WERKS FROM PBID for all entries in PBIM WHERE MATNR = PBIM-MATNR AND WERKS = PBIM-WERKS.

[Former Member]

This message was moderated.