topic Re: Selec Statement. in Application Development and Automation Discussions

Selec Statement.

Former Member — Fri, 22 Jun 2007 17:47:50 GMT

Hi Guys,

Can't we use in Select stament Source as an Internal table?The select statement which i wrote is here.

SELECT * from il1_REGUP into table il_REGUP where ( BELNR = il_bkpf_header-BELNR ).

If not how to do?My requiremnt is i have to get data from SAP databse table and based on condition where BKPF-BELNR must be equal to REGUP-BELNR i have to get data into my Final Internal table.

Thanks,

Gopi.

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 17:51:57 GMT

HI,

First select BELNR'S from BKPF into an internal table say IT_BKPF for a condition, then you do a select ..

SELECT * from il1_REGUP

into table il_REGUP

for all entries in IT_BKPF

where ( BELNR = IT_BKPF-BELNR ).

Re: Selec Statement.

JayR — Fri, 22 Jun 2007 17:52:59 GMT

hi gopi,

Select * from bkpf into table it_bkpf.

if it_bkpf[] is not initial.

select * from regup into table it_regup for all entries in it_bkpf

where belnr = it_bkpf-belnr.

endif.

With Wishes

Jai

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 18:29:25 GMT

Hi Jai,

Does the logic what u told will get all the multiple entries of BELNR in REGUP table into my final REGUP Internal table?

Thanks,

Gopi.

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 18:47:28 GMT

Yes Gopi..you will get all the entries of BELNR in REGUP.

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 18:56:12 GMT

Hi Jai,

I wrote the logic what u told.But its taking more time like 15minutes still the program didnot get executed , i mean its still running ans also there are more records in BKPF like 650987 this may be the one of he reason for more time .

.Do u think this is the best logic?

Thanks,

Gopi.

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 19:14:09 GMT

You have to give it the company code (BKPF-BUKRS) as well, otherwise it can't use the index.

Rob

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 19:23:55 GMT

Like:




SELECT * FROM il1_regup
  INTO TABLE il_regup
  FOR ALL ENTRIES IN it_bkpf
  WHERE bukrs = it_bkpf-bukrs
    AND belnr = it_bkpf-belnr.

Rob

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 19:29:57 GMT

Gopi,

BKPF is huge generally...you have to use the combination of BUKRS, BELNR and GJAHR as key combination. It is highly recommended. Then search REGUP for all entries using the above fileds. This may help.

SELECT * FROM il1_regup

INTO TABLE il_regup

FOR ALL ENTRIES IN it_bkpf

WHERE bukrs = it_bkpf-bukrs

AND belnr = it_bkpf-belnr

and gjahr = it_bkpf-gjahr.

Rgds,

Naren

Message was edited by:

Naren Someneni

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 19:53:53 GMT

Hi Naren,

I am doing like that only now but it took already 20mins still the program is running.I am running in Foreground.I will wait and see and i kept another program in background with only one where condiion that to BELNR it took nearly 30 mins but the program didnot got yet completed its running

Just waiting how long it takes.

Thanks,

Gopi.

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 20:09:22 GMT

This table is not in our system. Are you sure that BUKRS, BELNR and GJAHR are part of an index?

Rob

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 21:08:03 GMT

Hi Rob,

I am running two job one in Backgrond and other one in Fore ground both are different programs.Background job doesn't have BUKRS and GJAHR in where condition but Foreground one have in where condition these 2 ields.For foreground it took nearly 1/2hr but no output but still running for background not yet completed still running since 2 hrs.

Thanks,

Gopi.

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 21:14:03 GMT

Gopi,

There is no index available on those 3 fields. For faster response create an index with the following fields

mandt, bukrs, belnr, gjahr.

From the functional point of view I told you to use all those 3 fields to avoid duplicates.

Good luck

Rgds,

Naren

Message was edited by:

Naren Someneni

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 21:34:32 GMT

Hi Naren,

can you tell me how to create Index?I dont know how to do?

Thanks,

Gopi

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 21:43:51 GMT

Gopi,

In se11 on the tool bar, there is a 'INDEXES' button besides 'TECHNICAL SETTINGS' button. Click on that and then there is an option there to create an index. Let me know if you need more help.

Rgds,

Naren

Message was edited by:

Naren Someneni

Re: Selec Statement.

Former Member — Fri, 22 Jun 2007 22:41:29 GMT

hi Naren,

In my system its not activated so what to do?

Thanks,

Gopi.

Re: Selec Statement.

Former Member — Sat, 23 Jun 2007 00:54:47 GMT

Gopi,

In which system r u trying? Hope its in development right? Are those buttons disabled in your system? Let me know.

Rgds,

Naren

Re: Selec Statement.

Former Member — Sat, 23 Jun 2007 01:13:29 GMT

Hi Naren,

Yes they are Disabled and i am in Development system.

Thanks,

Gopi.

Re: Selec Statement.

Former Member — Sat, 23 Jun 2007 01:17:07 GMT

Gopi,

Then that is an authorization issue. You need to talk to basis team about proper authorizations. They should be enabled.

Rgds,

Naren

Re: Selec Statement.

Former Member — Sat, 23 Jun 2007 01:23:36 GMT

Hi Naren,

Is there any alternative for the problem which i arised in this thread.Becoz the logic which i wrote is running till now.Its already 6 hrs but no output stil running?The problem is when i am running in Sand Box that logic i am getting records but in Development system its taking too long.Why like that i dontknow other than more no. of records for BKPF in Development system.

Thanks,

Gopi.