topic Re: Data selection from BSEG in Application Development and Automation Discussions

Data selection from BSEG

Former Member — Fri, 14 Dec 2007 05:42:20 GMT

Hi All.

My requirement is to fetch data from BSEG for whole fiscal year, now problem is that for a single fiscal year there are about 170000 records. Now when i try to select this , i got time exceed error. We also cant inner join or index for BSEG. Is there any way to solve this problem? can we set internally like it will select data inslot like 100000 records at a time? Please suggest me proper solurion..

Thanks.

Re: Data selection from BSEG

Former Member — Fri, 14 Dec 2007 05:43:42 GMT

Hi PKB,

Try adding the Package size for the internal table , so that only that many records will be fetched.

Reward if USeful..

Regards,

Chitra

Re: Data selection from BSEG

former_member386202 — Fri, 14 Dec 2007 05:45:25 GMT

Hi,

Use FOR ALL ENTRIES its performance wise better and pass all the keys.s

&----

*& Form sub_read_bseg

&----

text

----

--> p1 text
<-- p2 text

----

FORM sub_read_bseg.

IF NOT it_bsak[] IS INITIAL.

*--Select data from BSEG table

SELECT belnr

gjahr

shkzg

kostl

hkont

ebeln

ebelp

FROM bseg

INTO TABLE it_bseg

FOR ALL ENTRIES IN it_bsak

WHERE belnr EQ it_bsak-belnr

AND gjahr EQ it_bsak-gjahr

AND shkzg EQ 'S'.

IF sy-subrc EQ 0.

*--Sort table by accounting document

SORT it_bseg BY belnr.

ENDIF.

ENDFORM. " sub_read_bseg

Regards,

Prashant

Re: Data selection from BSEG

Former Member — Fri, 14 Dec 2007 05:45:41 GMT

make use of sy-index

Re: Data selection from BSEG

Former Member — Fri, 14 Dec 2007 05:48:11 GMT

Can u please tell me how to use sy-index.

Re: Data selection from BSEG

Former Member — Fri, 14 Dec 2007 05:49:52 GMT

Instead of BSEG, try to fetch data from BSAD/BSID