topic Re: problem with SELECT stmt in Application Development and Automation Discussions

problem with SELECT stmt

Former Member — Fri, 25 Apr 2008 04:21:56 GMT

Hi Experts,

in my report i ve writtern same logic in 2ways,

but the 1st is working, but 2nd is not working.

here my first logic:

IF NOT it_prps[] IS INITIAL.

SELECT * FROM rpsco

INTO CORRESPONDING FIELDS OF TABLE it_rpsco

FOR ALL ENTRIES IN it_prps

WHERE objnr EQ it_prps-objnr AND

versn IN ('000','021')

AND gjahr EQ p_year.

ENDIF.

SORT it_rpsco BY objnr.

DELETE ADJACENT DUPLICATES FROM it_rpsco COMPARING objnr.

its working fine .

for same purpose i did like below, but its giving dump error.

IF NOT it_prps[] IS INITIAL.

SELECT objnr

wrttp

versn

vorga

lednr

beltp

gjahr

twaer

wlp00

wlp01

wlp02

FROM rpsco

INTO TABLE it_rpsco

FOR ALL ENTRIES IN it_prps

WHERE objnr EQ it_prps-objnr

AND versn IN ('000','021')

AND gjahr EQ p_year.

ENDIF.

SORT it_rpsco BY objnr.

DELETE ADJACENT DUPLICATES FROM it_rpsco COMPARING objnr.

why this is nt working.

can anyone look this one.

Rgds,

sudha.

Re: problem with SELECT stmt

Former Member — Fri, 25 Apr 2008 04:25:12 GMT

Hi,

The intrenal table should have the following fields for the second select query

objnr

wrttp

versn

vorga

lednr

beltp

gjahr

twaer

wlp00

wlp01

wlp02

Otherwise u have to use into corresponding fileds with select query.

regards

Sheeba

Re: problem with SELECT stmt

Former Member — Fri, 25 Apr 2008 04:25:17 GMT

HI SUDARSHAN..

i think the table you declared not is as per the order u used in select statement....so that might has given u dump..

and just give correspoding fields..then also..dump comes let me know..

regards

sas

reward if usefull *

Re: problem with SELECT stmt

Former Member — Fri, 25 Apr 2008 04:25:18 GMT

Try this...

IF NOT it_prps[] IS INITIAL.

SELECT objnr

wrttp

versn

vorga

lednr

beltp

gjahr

twaer

wlp00

wlp01

wlp02

FROM rpsco

INTO CORRESPONDING FIELDS OF TABLE it_rpsco

FOR ALL ENTRIES IN it_prps

WHERE objnr EQ it_prps-objnr

AND versn IN ('000','021')

AND gjahr EQ p_year.

ENDIF.

SORT it_rpsco BY objnr.

DELETE ADJACENT DUPLICATES FROM it_rpsco COMPARING objnr.

Re: problem with SELECT stmt

Former Member — Fri, 25 Apr 2008 04:25:43 GMT

In the 2nd SELECT, u have to use INTO CORRESPONDING FIELDS OF TABLE. Bcoz, u have defined ur structure with all the fields of that table.

Reward if useful

Re: problem with SELECT stmt

Former Member — Fri, 25 Apr 2008 04:25:55 GMT

Hi,

Check if the order of selection of fields from rpsco table and the order of declaration of internal table it_rpsco are same.

I see no error other than this.

Regards,

Ramya

Re: problem with SELECT stmt

kiran_k8 — Fri, 25 Apr 2008 04:29:13 GMT

Sudharsan,

I guess there is problem with the internal table structure.Check the internal table structure.

Are you sure that FOR ALL ENTRIES is working fine with INTO CORRESPONDING in your first query?

K.Kiran.

Re: problem with SELECT stmt

Former Member — Fri, 25 Apr 2008 04:45:17 GMT

Hi Friends, Thank u very much for ur replays,

i ve declared table like this.

TYPES : BEGIN OF t_rpsco, " Project info database:

objnr LIKE rpsco-objnr, "Object number

wrttp LIKE rpsco-wrttp, "Value type

acpos LIKE rpsco-acpos, "Value category

vorga LIKE rpsco-vorga, "Budgeting/Planning

versn LIKE rpsco-versn, "Budgeting/Planning

abkat LIKE rpsco-abkat, "Category:

twaer LIKE rpsco-twaer, "Transaction currency

gjahr LIKE rpsco-gjahr, " Fiscal year

lednr LIKE rpsco-lednr, "Budget/Planning Ledger

beltp LIKE rpsco-beltp, "Debit type

wlp00 LIKE rpsco-wlp00, "Period value

wlp01 LIKE rpsco-wlp01, "Period value

wlp02 LIKE rpsco-wlp02, "Period value

wlp03 LIKE rpsco-wlp03, "Period value

wlp04 LIKE rpsco-wlp04, "Period value

wlp05 LIKE rpsco-wlp05, "Period value

wlp06 LIKE rpsco-wlp06, "Period value

wlp07 LIKE rpsco-wlp07, "Period value

wlp08 LIKE rpsco-wlp08, "Period value

wlp09 LIKE rpsco-wlp09, "Period value

wlp10 LIKE rpsco-wlp10, "Period value

wlp11 LIKE rpsco-wlp11, "Period value

wlp12 LIKE rpsco-wlp12, "Period value

wlp13 LIKE rpsco-wlp13, "Period value

wlp14 LIKE rpsco-wlp14, "Period value

wlp15 LIKE rpsco-wlp15, "Period value

wlp16 LIKE rpsco-wlp16, "Period value

END OF t_rpsco.

DATA : it_rpsco TYPE STANDARD TABLE OF t_rpsco WITH HEADER LINE,

wa_it_rpsco TYPE t_rpsco.

but am missing some fields in selection, from my table.

is it the problem.

Regards,

sudha.

Re: problem with SELECT stmt

Former Member — Fri, 25 Apr 2008 04:51:32 GMT

Hi friends, i fix the issue,

the problem is i am nt select 1 field from table .

thats why its gone 4 dump.

once again Very thanks to replay.

Rgds,

sudharsan.