Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Material Number Report

Former Member
0 Likes
932

How to find out all the material numbers which ends with VEND

000002323233VEND

232233222VEND

AAAAAAAAAAVEND

How to list all the materials which ends with VEND

Thanks in advance

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
909

se11>MARA>display>display contents>Give MATNR as *VEND>execute

How to find out all the material numbers which ends with VEND

000002323233VEND

232233222VEND

AAAAAAAAAAVEND

How to list all the materials which ends with VEND

Thanks in advance

7 REPLIES 7
Read only

Former Member
0 Likes
910

se11>MARA>display>display contents>Give MATNR as *VEND>execute

Read only

0 Likes
909

Thanks and I would like to how it can be done in programming..

Thanks any way

Read only

0 Likes
909

select * from mara into table <internal table> where matnr like %VEND.

Read only

0 Likes
909

This is awfully basic. Press F1 on SELECT WHERE

Rob

Read only

0 Likes
909

Thanks, I'm not a ABAP Programmer. I have an internal table (ITAB) which have all materials. I would like to DELETE certain patterns from it like VEND.

DELETE ITAB WHERE FIELD1 LIKE %VEND

How can I achieve this..... Thanks in advance

Read only

0 Likes
909

Use a SELECT OPTION or RANGE table and:

DELETE ITAB WHERE FIELD1 IN S_OPT.

Rob

Read only

matt
Active Contributor
0 Likes
909

>

> Thanks, I'm not a ABAP Programmer. ...

Learning to press F1 on ABAP keywords to find out how they work doesn't need programming ability.