topic Re: ABAP Code in Application Development and Automation Discussions

ABAP Code

Former Member — Tue, 29 Apr 2008 13:30:57 GMT

Hi,

How can I retrieve all entries EXCEPT 01, 03, 05 and 06 from table USRSYSACTT using ABAP assuming this (USRSYSACTT) table has the following entries:

AGR_NAME TEXT LANGU

01. ROLE1 XXX DE

02. ROLE1 XXX EN

03. ROLE1 XXX Z1

04. ROLE2 XXX EN

05. ROLE2 XXX RU

06. ROLE2 XXX JA

07. ROLE3 XXX DE

08. ROLE4 XXX FR

09. ROLE5 XXX EN

10. ROLE6 XXX Z1

Thanks,

Tarun

Re: ABAP Code

matt — Tue, 29 Apr 2008 13:40:57 GMT

Either

SELECT * FROM USRSYSACTT INTO lt_table
    WHERE AGR_NAME NE '01' AND AGR_NAME NE '03' AND AGR_NAME NE '05'
           AGR_NAME NE '06'.

SELECT * FROM USRSYSACTT INTO lt_table.
DELETE FROM lt_table WHERE AGR_NAME EQ '01'... etc.

The latter may be faster.

matt

Re: ABAP Code

Former Member — Tue, 29 Apr 2008 13:45:19 GMT

Hi,

And what if this (USRSYSACTT) table has thousands of such roles (AGR_NAME), etc.

Thanks,

Tarun

Re: ABAP Code

Former Member — Tue, 29 Apr 2008 13:45:48 GMT

Populate what ever values U don't want in a range ..

and use this in select ... as

if r_AGR_NAME is the range ...

R_AGR_NAME-sign = 'E'.

R_AGR_NAME-option = 'EQ'.

R_AGR_NAME-low = '01'.

append R_AGR_NAME.

similarly populate other values ...

select * from USRSYSACTT into table it_USRSYSACTT

where AGR_NAME in R_AGR_NAME.

Re: ABAP Code

Former Member — Tue, 29 Apr 2008 13:56:54 GMT

Hi,

Basically, I want all roles with LANGU as 'EN' except the dupilcate (AGR_NAME) ones and also, I want all the roles not having LANGU as 'EN' (except, of course, the duplicate ones)

For example, I want ROLE2 out of the following roles:

ROLE1 'DE'

ROLE1 'EN'

And I also want

ROLE2 'DE'

ROLE3 'FR'

Thanks,

Tarun