topic Re: Select stmt in Application Development and Automation Discussions

Select stmt

Former Member — Thu, 29 May 2008 07:05:52 GMT

Hi All,

I am having a small doubt -

How to use PACKAGE SIZE in Select stmt....What are the things needed to be considered or maintained at the time of using this.

It will be a gr8 advantage if solution is with a small example....

Its urgent

Thanks.

Re: Select stmt

Former Member — Thu, 29 May 2008 07:08:03 GMT

Package size can be used if you for example only want to finish processing a limited amount of data at a time due to lack of memory.

The example below read 50 records at a time from VBAK into an internal table, and selects the corresponding entries from vbap into an internal table. Then the two internal tables can be processed, and the next 50 records from VBAk can be read. Remember to reinitialize tha tables before the next read.

REPORT z_test.

TYPES:

BEGIN OF t_vbak,

vbeln LIKE vbak-vbeln,

erdat LIKE vbak-erdat,

END OF t_vbak,

BEGIN OF t_vbap,

posnr LIKE vbap-posnr,

matnr LIKE vbap-matnr,

meins LIKE vbap-meins,

END OF t_vbap,

BEGIN OF t_report,

vbeln LIKE vbak-vbeln,

erdat LIKE vbak-erdat,

posnr LIKE vbap-posnr,

matnr LIKE vbap-matnr,

meins LIKE vbap-meins,

END OF t_report.

DATA:

li_vbak TYPE t_vbak OCCURS 0,

l_vbak TYPE t_vbak,

li_vbap TYPE t_vbap OCCURS 0,

l_vbap TYPE t_vbap,

li_report TYPE t_report OCCURS 0,

l_report TYPE t_report.

START-OF-SELECTION.

SELECT vbeln erdat

FROM vbak

INTO TABLE li_vbak PACKAGE SIZE 50.

SELECT posnr matnr meins

FROM vbap

INTO TABLE li_vbap

FOR ALL ENTRIES IN li_vbak

WHERE vbeln = li_vbak-vbeln.

IF sy-subrc = 0.

Now you have the two internal tables li_vbak and li_vbap filled
with data.
Do something with the data - remember to reinitialize internal
tables

ENDIF.

ENDSELECT.

*-- End of Program

Re: Select stmt

former_member673464 — Thu, 29 May 2008 07:09:34 GMT

hi,

If you use the PACKAGE SIZE addition, the lines of the selection are not written into the internal table at once, but in packets. You can define packets of <n> lines that are written one after the other into the internal table. If you use INTO, each packet replaces the preceding one. If you use APPENDING, the packets are inserted one after the other. This is only possible in a loop that ends with ENDSELECT. Outside the SELECT loop, the contents of the internal table are undetermined. You must process the selected lines within the loop.

Example:

DATA: WA TYPE SPFLI,

ITAB TYPE SORTED TABLE OF SPFLI

WITH UNIQUE KEY CARRID CONNID.

SELECT CARRID CONNID

FROM SPFLI

INTO CORRESPONDING FIELDS OF TABLE ITAB

PACKAGE SIZE 3.

LOOP AT ITAB INTO WA.

WRITE: / WA-CARRID, WA-CONNID.

ENDLOOP.

SKIP 1.

ENDSELECT.

Regards,

Veeresh

Re: Select stmt

Former Member — Thu, 29 May 2008 07:13:02 GMT

HI,

data: w_packsize TYPE i,

w_count_mast TYPE i,

parametres: p_pproc TYPE int2 OBLIGATORY,

Start-of-selection.

SELECT COUNT( DISTINCT matnr ) INTO w_count_mast

FROM w_mast.

w_packsize = CEIL( w_count_mast / p_pproc ).

SELECT matnr

werks

stlan

stlnr

stlal

aedat

FROM mast

INTO TABLE i_mast

PACKAGE SIZE w_packsize

WHERE scope = c_unipro

ORDER BY matnr.

*****************************

code as per the requirement

**************************

ENDSELECT.

Re: Select stmt

Former Member — Thu, 29 May 2008 07:34:50 GMT

Hi Jagadish,

INITIALIZE the internal table means .........I used REFRESH stmt after processing the data to the final internal table....but error coming like...table cant be initialized in the loop....

what can be done......

thanks.