topic Re: select in table COEP in Application Development and Automation Discussions

select in table COEP

Former Member — Thu, 14 Dec 2006 12:22:17 GMT

i have select-option : scr_pernr.

i'm making select from table coep, one of the condition is pernr in scr_pernr.

problem

if i have pernr-low = 5555

i get data

if i have pernr-low = 5555 and pernr-high = 5555

i get diffrent data.

i[b]nformation:

i make new index(z) for this selection.

thanks.

Re: select in table COEP

LucianoBentiveg — Thu, 14 Dec 2006 12:37:03 GMT

I think you have another condition in where clause, making that difference.

Check it,

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 12:44:18 GMT

what is the other condition

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 12:46:12 GMT

i mean: ther is other way then pernr in scr_pernr

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 12:47:35 GMT

HI use like this,

Ranges: r_pernr for coep-pernr occurs 1.

if scr_pernr not initial.

r_pernr-sign = 'I'.

r_pernr-option = 'EQ' "here make as BT if u want range

r_pernr-low = scr_pernr .

r_pernr-high = scr_pernr .

append r_pernr.

select pernr from coepe into corresponding fields of table <itab> where pernr IN r_pernr.

It will work

Regs

Manas Ranjan Panda

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 13:00:02 GMT

Hi,

Can you check the table 'scr_pernr' how it get populated in the debug....

I think you have give the other values also in the selection.

Regards,

Satya

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 13:02:25 GMT

in the screen i have field scr_pernr once i input low-5555 high-

other

low-5555 high-5555

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 13:03:16 GMT

the index that i create dont have ifluance on that situation.

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 13:04:38 GMT

U dont hv to specify the index name while data selection.

SAP will take care of which index to use.

Regs

Manas

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 13:34:12 GMT

O.K BUT THERE I CAN PUT ANY FIELD IN ANY ORDINARY, OR THERE IS A LOGIC ABOUT THIS

Re: select in table COEP

Former Member — Thu, 14 Dec 2006 13:38:12 GMT

Hi let me clear abt ur idea in Index.

We create index to make data selection faster.

Two types of index,

1.Primary index(by default will be created)

2.secondary index(we will create)

suppose u want to fetch 4 fields frm a table,so u will make one index with that 4 fields.

When u write select 4 fields name,then SAP will autometically use this index.

when we write select stmts,SAP will search for suitable index.

NB: Indexs will not store any data like views only used for searching.

Regs

Manas