Regarding BAPI_MATERIAL_GETLIST

[madhu_vadlamani]

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.

[mvoros]

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

[madhu_vadlamani]

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.

[mvoros]

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

Cheers

[madhu_vadlamani]

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.

[Former Member]

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

[madhu_vadlamani]

Dear Shelly,

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

Regards,

Madhu.

[Former Member]

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

[madhu_vadlamani]

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.

[Former Member]

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

[mvoros]

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

[mvoros]

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

Cheers

[Former Member]

Hai Thanks,

Yes it is Working fine.

Regards

Shelly Malik

[madhu_vadlamani]

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.

[madhu_vadlamani]

Dear Martin,Shelly,

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

Regards,

Madhu.

[madhu_vadlamani]

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

Regards,

Madhu.