topic Re: Material Number Report in Application Development and Automation Discussions

Material Number Report

Former Member — Wed, 26 Nov 2008 21:22:35 GMT

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

Re: Material Number Report

Former Member — Wed, 26 Nov 2008 21:31:17 GMT

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

Re: Material Number Report

Former Member — Wed, 26 Nov 2008 21:36:47 GMT

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

Thanks any way

Re: Material Number Report

Former Member — Wed, 26 Nov 2008 21:38:05 GMT

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

Re: Material Number Report

Former Member — Wed, 26 Nov 2008 21:39:28 GMT

This is awfully basic. Press F1 on SELECT WHERE

Rob

Re: Material Number Report

Former Member — Wed, 26 Nov 2008 21:44:59 GMT

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

Re: Material Number Report

Former Member — Wed, 26 Nov 2008 21:56:15 GMT

Use a SELECT OPTION or RANGE table and:

DELETE ITAB WHERE FIELD1 IN S_OPT.

Rob

Re: Material Number Report

matt — Thu, 27 Nov 2008 06:53:16 GMT


> 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.