topic Re: Package size in Select query.. in Application Development and Automation Discussions

Package size in Select query..

Former Member — Thu, 10 Jan 2008 09:41:01 GMT

Dear Friend,

I have doubts in Package Size using select query..Could u tell me What is the use of it nad y we r using...Plz suggest me.

Regards,

Dhanush.S.T

Re: Package size in Select query..

Former Member — Thu, 10 Jan 2008 09:43:00 GMT

Hi Dhanush,

Here is brief explanation of packet size..

Package size can be used to retreive a spcific number of records at a time. This can be used if you for example only want tofinish processing a limited amount of data at a time due to lack of memory.

The exampel 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. remeber to reinitialize tha tables before the next read.

PACKAGE SIZE n

Works like ... INTO wa, except that the selected data is not placed in the internal table itab line by line, but in packets of n lines. The old contents of itab are overwritten.

n <= 0 causes a runtime error.

Internally, n is placed in a type I field. Here, the usual conversion rules apply (see MOVE).

After leaving the processing loop, the contents of the internal table itab are undefined.

If the result of the selection is a table, the data is retrieved in a processing loop introduced by SELECT and concluded by ENDSELECT. The processing passes through the loop once for each line 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.

Reward if helpful.

Thankyou,

Regards.

Re: Package size in Select query..

Former Member — Thu, 10 Jan 2008 09:53:04 GMT

Dhanush,

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.

EX; Suppose you are extracting 100000 records from a table which is going dump because of long time(say 60 minutes.) extraction.

Assume basis person setted seeion time 15 minutes.

when extraction crosses 15 minutes it will go dump.

That situation use package size

assume 15000 which takes 14 min.

select records package 15000 into appending internal table.

till 15000 records comes statement exexutes and append the internal table.Like wise you can extract data without dump..

Don't forget to reward if useful....

Re: Package size in Select query..

Former Member — Thu, 10 Jan 2008 09:53:29 GMT

PACKAGE SIZE in the Select Query is used to fix the number of records we want to fetch from the Table for each Iteration.

We have to use it with SELECT .. ENDSELECT.

awrd points if useful

Bhupal

Re: Package size in Select query..

Former Member — Thu, 10 Jan 2008 09:54:03 GMT

Hi Dhanush,

Package size is used when you have to process a large chunk of records.

When you will use package size in your select command, the select command will process that much of records in lots that your are passing in package size. For example if you have mentioned 10000 in package size then the select command will process 10000 records in lots.

In this case you will not get run time error due to time limit exceed error.

regards,

mukesh kumar

Re: Package size in Select query..

Former Member — Thu, 10 Jan 2008 09:54:45 GMT

PACKAGE SIZE n

Works like ... INTO wa, except that the selected data is not placed in the internal table itab line by line, but in packets of n lines. The old contents of itab are overwritten.

n <= 0 causes a runtime error.

Internally, n is placed in a type I field. Here, the usual conversion rules apply (see MOVE).

After leaving the processing loop, the contents of the internal table itab are undefined.

If the result of the selection is a table, the data is retrieved in a processing loop introduced by SELECT and concluded by ENDSELECT. The processing passes through the loop once for each line read.

Example

Output a list of all airlines (with short description and name):

DATA: itab TYPE STANDARD TABLE OF SCARR WITH NON-UNIQUE

DEFAULT KEY INITIAL SIZE 10.

FIELD-SYMBOLS: <FS> TYPE scarr.

SELECT * INTO TABLE itab PACKAGE SIZE 20 FROM scarr.

LOOP AT itab ASSIGNING <FS>.

WRITE: / <FS>-carrid, <FS>-carrname.

ENDLOOP.

ENDSELECT.

example 2

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.

Regards.

Re: Package size in Select query..

Former Member — Thu, 10 Jan 2008 09:54:48 GMT

Hi,

Package Size

If you want to process messages with quality of service EO (Exactly Once) in packages, you must specify a package size. This specifies the number of messages above which a package is to be scheduled for processing.

Once the specified package size is reached, a package can be processed immediately. If you want to do this, specify this in the corresponding field.

Message packages can only be sent to a unique receiver. This must be either an IDoc receiver or an IDoc system as a receiver of ALE audits that are returned as acknowledgments by an IDoc receiver.

Due to performance reasons, you can only process small messages in packages. Therefore, you must also specify a corresponding message size.

Regards,

Renjith Michael.

Re: Package size in Select query..

Former Member — Thu, 10 Jan 2008 09:59:17 GMT

Hi Dhanush,

What's the purpose of using PACKAGE SIZE in select statement?

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.

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

Package:

This specifies a quantity of data records from the archiving object master table that is clearly defined by package limits. A package is an indivisible unit (in terms of the distribution between parallel jobs) used for the parallel processing of mass data, meaning that it is processed by precisely one job.

Package limits:

These specify the quantity of data contained in a package. Package limits consist of one upper and one lower restrictive value for the package formation attributes. They are used as selection criteria for the data retrieval of the process phases that have run in parallel.

Package size:

This specifies the number of data records in a package.

Package formation attributes:

These specify one or more fields from the archiving object master table, used by the system to define package limits. Check which fields you select as package formation attributes in the Archiving Workbench step Create External Parallel Processing Key. For more information, refer to the documentation on this activity.

Package profile:

This specifies a quantity of package limits formed by the system during the pre-step process. The package profile is used to divide up the whole value range of package formation attributes. Package limits must never overlap.

Package formation strategy:

This is the algorithm used to form package profiles. The aim of this algorithm is to form a package profile in such a way that the parallel processing tool can form packages of an approximately equal size. The Archiving Workbench does not set the characteristic values of this algorithm; you or your customer must do this. The decision as to which algorithm is the most suitable depends on the conditions of the archiving object in question. The algorithm must be implemented by a function module registered by a corresponding Customizing entry for the archiving object in IMG activity Maintain Global Control of Archiving.

HOPE THIS HELPS U

reward if useful

thanks and regards

suma