topic Reg:S700 table in Application Development and Automation Discussions

Reg:S700 table

Former Member — Sat, 02 Jul 2011 13:15:31 GMT

Dear Experts,

I have a requirement, in which I need to take data from S700 table, But it takes so much time to fetch the data . It causes performance effect, Request you to please suggest me is there any function module available in order to fetch the data from S700 table .

Regards,

Suresh.

Re: Reg:S700 table

Former Member — Sun, 03 Jul 2011 18:28:46 GMT

hello,

i doubt that there is such FM (i do not have table S700 in my system ECC 6.0 so i can not do any researches). If you want to get valuable answer post your select maybe we could help you to improve the speed of your code. Several advices which could help:

1) select only required fields do not use

select * statement

if it is not mandatory;

do not use into corresponding fields of table

better use

into table

, but fields sequence in select and in yout internal table should be the same otherwise you will get dump during execution.

3) use primary key or index or define your new one (but defining new indexes willslow down insert update processes);

4) if you are using joins in you select try to split it into two sepatared ones (table types: hashed and standard).

data: lt_b type standard table of b,
        lt_a  type hashed table of a with unique key fieldname1 fieldname2,
        ls_b type b,
        lv_tabix type sytabix.

select A~fiendname1
          A~fiedname2
into table lt_A
from A
where (required clause).

select B~fieldname1
           b~fiedname2
          b~fieldname3
into table lt_B
from b
where (required clause).

loop at lt_b into ls_b.
  lv_tabix = sy-tabix.
  read table lt_a transporting no fields with table key fiedname1 = ls_b-fieldname1 fieldname2 = ls_b-fieldname2.

  check sy-subrc ne 0.
     delete table lt_b index lv_tabix.
endloop.

here you will find the main rules what is good and not (it could be valuable resource in your case):

http://abapteamforum.lefora.com/2009/05/06/steps-to-optimise-the-abap-code/

br,

Re: Reg:S700 table

Former Member — Tue, 05 Jul 2011 10:49:32 GMT

Hi,

If you are using select statement inside the loop then also create performance Issue and If your select statement is inside the inner loop (loop.....loop....select ....endloop...endloop.... ) then also create performance issue.

Regards,

Kunjan

Re: Reg:S700 table

Former Member — Tue, 05 Jul 2011 10:50:11 GMT

Hi,

Regards,

Kunjan

Re: Reg:S700 table

Former Member — Wed, 06 Jul 2011 06:20:32 GMT

Hi,

In SAP there is no table name as S700 table. Please tell me in which report you use this table.

Thanks,

Sanjeeb.

Re: Reg:S700 table

Former Member — Wed, 06 Jul 2011 19:52:12 GMT

Hello SureshVVS ,

Looks like the table that you are using is like a SIS related table. It will take more time for sure as it is the Sales information table .

No other way of controlling the select unless you use the correct primary key in your select query.

Hope this answers your question.

Thanks,

Greetson

Re: Reg:S700 table

Former Member — Thu, 07 Jul 2011 09:00:33 GMT

hi,

used hashed internal table to retrieve data.

that is sample how to use it :

http://www.sap-img.com/abap/what-is-use-of-using-hashed-table.htm

Re: Reg:S700 table

Former Member — Thu, 07 Jul 2011 09:05:29 GMT

Yes, It is related to SIS information data table.

Re: Reg:S700 table

Former Member — Thu, 07 Jul 2011 21:31:46 GMT

Hello SureshVVS ,

The only way is to use the correct key fields in your select. Another option to improve the performance is to create the secondary index for tht table fields that you are using in the select.

Thanks,

Greetson