topic Re: Regarding BAPI_MATERIAL_GETLIST in Application Development and Automation Discussions

Regarding BAPI_MATERIAL_GETLIST

madhu_vadlamani — Fri, 12 Mar 2010 18:22:58 GMT

Dear all,

I am working with the bapi BAPI_MATERIAL_GETLIST. I am getting the all the material when i am executing this fm . Here there is a documentation given by sap for selection parameters. I read it but i am unable to pass it .

I want to get material depending on the selection parameter wise like

MATERIALSHORTDESCSEL

MANUFACTURERPARTNUMB

PLANTSELECTION

STORAGELOCATIONSELECT

SALESORGANISATIONSELECTION

DISTRIBUTIONCHANNELSELECTION

Here how to pass the selection parameters. Please share your ideas with me on this.

Regards,

Madhu.

Re: Regarding BAPI_MATERIAL_GETLIST

mvoros — Fri, 12 Mar 2010 23:33:25 GMT

Hi,

there is an example in documentation for this BAPI (SE37 -> button Function Module Documentation). It shows you how to select all materials from one plant and two storage location. This example is pretty straightforward. Basically, all tables except MATLIST and RETURN correspond to selection criteria for one field. If you understand what is selection option then the filling these tables is obvious. What don't you understand about this example?

Cheers

Re: Regarding BAPI_MATERIAL_GETLIST

madhu_vadlamani — Sat, 13 Mar 2010 02:44:34 GMT

Dear Martin,

Thank you for your reply. As you said it is correct. When i am passing data only for MATERIALSHORTDESCSEL table . I am not getting any data. If you have any idea on this please share your ideas with me .

Regards,

Madhu.

Re: Regarding BAPI_MATERIAL_GETLIST

mvoros — Sat, 13 Mar 2010 04:11:21 GMT

How do you fill this table? It works fine if you just fill the table MATERIALSHORTDESCSEL.

Cheers

Re: Regarding BAPI_MATERIAL_GETLIST

madhu_vadlamani — Sat, 13 Mar 2010 04:27:07 GMT

Dear Martin,

Once again thank you for your reply.

BAPI_MATERIAL_GETLIST -> MATERIALSHORTDESCSEL

In these table i passes the selection parameters in this way

MATERIALSHORTDESCSEL : SIGN = I

OPTION = 'CP

DESCR_LOW = 'c10*' our materials

DESCR_HIGH = ' '

In these pattern i passes the values. Only i am filing this table only . It is not working.

Regards,

Madhu.

Re: Regarding BAPI_MATERIAL_GETLIST

Former Member — Sat, 13 Mar 2010 04:47:47 GMT

Hello Madhu,

Use Sign E, Instead of I in MATNRSELECTION and pass other parameters same as u have passed in MATERIALSHORTDESCSEL Selection table and in MATERIALSHORTDESCSEL Just Pass sign E and Option CP, I hope u will get Some Result.

Regards

Shelly Malik

Re: Regarding BAPI_MATERIAL_GETLIST

madhu_vadlamani — Sat, 13 Mar 2010 04:53:00 GMT

Dear Shelly,

Thank you for your reply. I tried with that option it is not working.

Regards,

Madhu.

Re: Regarding BAPI_MATERIAL_GETLIST

Former Member — Sat, 13 Mar 2010 04:55:16 GMT

hai Madhu,

You are passing Parameters only in one table, Pass in Both MATNRSELECTION and MATERIALSHORTDESCSEL.

as given in Documentation:

MATNRSELECTION : 'I', 'CP', '*' , ' '

MATERIALSHORTDESCSEL : 'I', 'CP', 'XY*' , ' '

I hope it will Work.

Regards

Shelly Malik

Re: Regarding BAPI_MATERIAL_GETLIST

madhu_vadlamani — Sat, 13 Mar 2010 05:02:16 GMT

Dear Shelly,

Once again thanks to your reply. I tried with this option it is giving the total records instead of material starting with the specified description.

Regards,

Madhu.

Re: Regarding BAPI_MATERIAL_GETLIST

Former Member — Sat, 13 Mar 2010 05:29:56 GMT

Sorry Dear i forgot,

There are I means Include and E means Exclude

Do Like this in MATNRSELECTION:

S OP MATNR_LOW

I CP AD*

in MATERIALSHORTDESCSEL

S OP DESCR_LOW

I CP

U will Get Values:

Regards

Shelly Malik

Re: Regarding BAPI_MATERIAL_GETLIST

mvoros — Sat, 13 Mar 2010 05:37:58 GMT

Hi,

you only need to fill this table if you want to search for materials using short description. It's clearly written in documentation. It should be working with your values. So my questions is do you have any material with short description starting with C10 in your client? You can check it in MM03. Usually, development client does not have any data and there is another one for unit testing.

Cheers

Re: Regarding BAPI_MATERIAL_GETLIST

mvoros — Sat, 13 Mar 2010 05:38:59 GMT

Please read documentation carefully. It's not mandatory to fill both tables. It's written clearly in the documentation at the end.

Cheers

Re: Regarding BAPI_MATERIAL_GETLIST

Former Member — Sat, 13 Mar 2010 05:43:57 GMT

Hai Thanks,

Yes it is Working fine.

Regards

Shelly Malik

Re: Regarding BAPI_MATERIAL_GETLIST

madhu_vadlamani — Sat, 13 Mar 2010 05:59:53 GMT

Dear Martin,

Thank you for your reply. WE have material starting with that description . I passed the data only in one table in this passion.

MATERIALSHORTDESCSEL

'I', 'CP', 'our material description*' , ' ' -> in these high field i tried by passing some data and with out data simply keeping quotes. It is not giving any data .

Regards,

Madhu.

Re: Regarding BAPI_MATERIAL_GETLIST

madhu_vadlamani — Sat, 13 Mar 2010 06:11:03 GMT

Dear Martin,Shelly,

Now it is working with only selection of one table. Thanks a lot to both of you to involve .

Regards,

Madhu.

Re: Regarding BAPI_MATERIAL_GETLIST

madhu_vadlamani — Sat, 13 Mar 2010 06:12:27 GMT

This Thread was closed. Thank you for all those who are partcipated.

Regards,

Madhu.