topic Re: Query help needed. in Application Development and Automation Discussions

Query help needed.

Former Member — Tue, 10 Oct 2006 04:06:59 GMT

Hi,

Good morning.

I have a requirement where I need to extract all standard entries and custom entries starting with ZA*.

Suppose my tables contains the following data:-

ABC

EFG

A123

ZA1

ZA2

ZB1

ZB2

Output should be:-

ABC

EFG

A123

ZA1

ZA2

Any idea on this. It will be very useful.

Regards,

Eureka.

Former Member — Tue, 10 Oct 2006 05:06:14 GMT

Please try as below.

  select <fld1> <fld2> into table itab
         from <table>
         where not <fld1> like 'Z%'
         or <fld1> like 'ZA%'.

Hope this helps you.

Kind Regards

Eswar

Former Member — Tue, 10 Oct 2006 05:13:24 GMT

Hi Eureka,

As you have not mentioned table names, I am giving you one example.

Suppose I want to select Sales organizations extracting values which starts with "Z".

I can write a code like this:

DATA: BEGIN OF itab OCCURS 0.

DATA : vkorg LIKE vbak-vkorg.

DATA: END OF itab.

SELECT vkorg FROM tvko INTO TABLE itab.

SORT itab.

DELETE itab WHERE vkorg CP 'Z*'.

LOOP AT itab.

WRITE : / itab-vkorg.

ENDLOOP.

Hope it solves the problem.

Regards,

Dharitree