topic Re: BAPI to get material details in Application Development and Automation Discussions

BAPI to get material details

former_member204556 — Fri, 08 Jan 2016 11:52:15 GMT

Hi all,

Is there any standard BAPI which takes only plant details as importing parameters and provides details of 'all' the materials within that single plant?

BAPI_MATERIAL_GET_DETAIL, BAPI_MATERIAL_GET_ALL etc., all these bapi's require material number also as a input parameter. I need only plant as importing parameter.

Thanks in advance,

Regards,

Shrusti

Re: BAPI to get material details

Former Member — Fri, 08 Jan 2016 12:46:51 GMT

Hi Shrusti,

I have not seen a bapi that would return the result set your looking for especially with the input parameter you mentioned.

Have you thought about trying something like running a sql query against the MARD table and getting all of the matnr for a specific werks and then you can run either of the two bapi's that you mentioned above and pass both the matnr and werks into them?

If you were wanting to do this type of call often then you could easily create a Z FM that performed this logic and return a table(s) of the FM results.

Hope this helps,

Geoffery

Re: BAPI to get material details

Flavio — Fri, 08 Jan 2016 13:12:55 GMT

Hi Shrusti,

I don't think there is a standard BAPI for this, but you can write your own report, selecting material codes by plant from MARC, and pass each of them to the mentioned BAPI.

BAPI result can be collected and returned as applicable.

Hope this could help.

Thanks and regards,

Flavio

Re: BAPI to get material details

RaymondGiuseppi — Fri, 08 Jan 2016 13:33:17 GMT

You have to call a first BAPI to get list of material reference:
- BAPI_MATERIAL_GETLIST,
- Generic Service BAPIs for Help Functions (F4 BAPI)
Then call another one in loop to get detail of those material references
- BAPI_MATERIAL_GET_DETAIL, etc.

Regards,
Raymond