topic bapi_material_get_all for multiple materials? in Application Development and Automation Discussions

bapi_material_get_all for multiple materials?

Former Member — Mon, 19 Nov 2012 14:13:23 GMT

Hi guys,

Is there any bapi that helps me read valuationdata for more than 1 material at a time?

I want to get the price and the valuation class for about 500 materials at a time.

Re: bapi_material_get_all for multiple materials?

former_member189779 — Mon, 19 Nov 2012 14:39:34 GMT

I dont think there is any BAPI which suits your need. may be you need to do it in LOOP ENDLOOP

Re: bapi_material_get_all for multiple materials?

Former Member — Mon, 19 Nov 2012 14:39:54 GMT

or can I pass multiple materials at once to bapi_material_get_all?

Re: bapi_material_get_all for multiple materials?

Former Member — Mon, 19 Nov 2012 14:41:01 GMT

That's what I did and it doesn't help me because it takes about 2 seconds/material... and I have more than 81.000

Re: bapi_material_get_all for multiple materials?

Former Member — Mon, 19 Nov 2012 14:45:55 GMT

There isn't something like in RFC_READ_TABLE where you can add more fields or options?

Set RfcCallTransaction = Functions.Add("RFC_READ_TABLE")
       Set strExport1 = RfcCallTransaction.exports("QUERY_TABLE")
       Set strExport2 = RfcCallTransaction.exports("DELIMITER")
       Set tbloptions = RfcCallTransaction.tables("OPTIONS")
       Set tblData = RfcCallTransaction.tables("DATA")
       Set tblFields = RfcCallTransaction.tables("FIELDS")

       strExport1.Value = "MARD"
       strExport2.Value = ";"

       tbloptions.Appendrow
       tbloptions(1, "TEXT") = "WERKS EQ '0001' AND LABST NE '0'"
       tbloptions.Appendrow
       tbloptions(2, "TEXT") = "OR UMLME NE '0' OR EINME NE '0'"
       tbloptions.Appendrow
       tbloptions(3, "TEXT") = "OR SPEME NE '0' OR RETME NE '0'"

       tblFields.Appendrow
       tblFields(1, "FIELDNAME") = "MATNR"
       tblFields.Appendrow
       tblFields(2, "FIELDNAME") = "LGORT"
       tblFields.Appendrow
       tblFields(3, "FIELDNAME") = "LABST"
       tblFields.Appendrow
       tblFields(4, "FIELDNAME") = "UMLME"
       tblFields.Appendrow
       tblFields(5, "FIELDNAME") = "INSME"
       tblFields.Appendrow
       tblFields(6, "FIELDNAME") = "EINME"
       tblFields.Appendrow
       tblFields(7, "FIELDNAME") = "SPEME"
       tblFields.Appendrow
       tblFields(8, "FIELDNAME") = "RETME"

There isn't something similar that works with BAPI_MATERIAL_GET_ALL?

Re: bapi_material_get_all for multiple materials?

former_member189779 — Mon, 19 Nov 2012 14:48:13 GMT

Did you tried selecting direclty from databse table MBEW using for all entries on your materials table?

Re: bapi_material_get_all for multiple materials?

Former Member — Mon, 19 Nov 2012 14:49:58 GMT

I don't have access to MBEW... that's why I was using bapi_material_get_all.

Re: bapi_material_get_all for multiple materials?

former_member189779 — Mon, 19 Nov 2012 14:53:25 GMT

May be you can ask to create a small custom function module to solve your purpose.

Re: bapi_material_get_all for multiple materials?

Former Member — Tue, 20 Nov 2012 08:55:55 GMT

So there is no way to check the valuation data for more than 1 material at a time?

Re: bapi_material_get_all for multiple materials?

anup_deshmukh4 — Tue, 20 Nov 2012 09:21:15 GMT

Hello Andrei,

I think You Could write a Wrapper Function module in Which you would call a bapi inside a loop and get your thing done.

You can try for MATERIAL_READ_MABW or check with MATERIAL_READ*

MATERIAL_PRE_READ_MBEW

Hope this helps,

Anup