03-12-2010 6:22 PM
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.
03-12-2010 11:33 PM
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
03-13-2010 2:44 AM
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.
03-13-2010 4:11 AM
How do you fill this table? It works fine if you just fill the table MATERIALSHORTDESCSEL.
Cheers
03-13-2010 4:27 AM
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.
03-13-2010 4:47 AM
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
03-13-2010 4:53 AM
Dear Shelly,
Thank you for your reply. I tried with that option it is not working.
Regards,
Madhu.
03-13-2010 4:55 AM
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
03-13-2010 5:02 AM
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.
03-13-2010 5:29 AM
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
03-13-2010 5:37 AM
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
03-13-2010 5:38 AM
Please read documentation carefully. It's not mandatory to fill both tables. It's written clearly in the documentation at the end.
Cheers
03-13-2010 5:43 AM
03-13-2010 5:59 AM
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.
03-13-2010 6:11 AM
Dear Martin,Shelly,
Now it is working with only selection of one table. Thanks a lot to both of you to involve .
Regards,
Madhu.
03-13-2010 6:12 AM
This Thread was closed. Thank you for all those who are partcipated.
Regards,
Madhu.