topic Sort a View in Application Development and Automation Discussions

Sort a View

Former Member — Wed, 28 Mar 2007 08:45:17 GMT

Hi,

I want to sort a View with 4 fields in a program. I want to sort it before to write some registers in a internal table.

how i can do it?

thanks a lot

Re: Sort a View

Former Member — Wed, 28 Mar 2007 08:46:43 GMT

Hi Marc,

I did not get your actual scenario.

Can u explain a bit in detail?

Regards,

Tejas

Re: Sort a View

Former Member — Wed, 28 Mar 2007 08:53:00 GMT

I have a view : Z99BW69.

In a programa, I want to select some registers and insert into a internal table.

I had create the internal table with the same structure than the View.

But before insert the registers, I want to sort the view in 3 some fields. The reason is becase after that I want to use the instruction AT NEW, ENDAT.

Example:

REPORT Z99BW047.

tables : Z99BW69.

*sort z99BW69 by BUKRS MATNR POPER BLDAT BELNR.

DATA: begin of ITAB1 occurs 0.

INCLUDE STRUCTURE Z99BW69.

DATA: end of ITAB1.

sort Z99BW69 by ..... // I cant do it.

select *

from Z99BW69

INTO CORRESPONDING FIELDS OF TABLE itab1

where MATNR = 'P39161200'

*AND POPER = '2'

AND WAERS = 'EUR'

AND BELNR IN ('0070000020','0070000023','0070000021','0070000022').

Re: Sort a View

Former Member — Wed, 28 Mar 2007 09:08:09 GMT

statements like sort, append, insert, read, etc. are all commands that perform operations on internal tables...you can't use them on a database object...

if helpful, reward

Sathish. R