How to select in table using *?

[Former Member]

Hi guys,

I need to retrieve all entries from table MARA where the material number starts with 1000. I know that in SE16N, we can just input 1000* in matnr field, but how do we do this via select statement in program?

Thanks!

[Former Member]

Hi guys,

I need to retrieve all entries from table MARA where the material number starts with 1000. I know that in SE16N, we can just input 1000* in matnr field, but how do we do this via select statement in program?

Thanks!

[ThomasZloch]

You can find out yourself with a little research, please do so next time before posting.

Thread locked.

Thomas