topic Re: select query with package size in Application Development and Automation Discussions

select query with package size

Former Member — Wed, 13 Jun 2007 04:37:32 GMT

Hi ,

i am trying to use select qurey with package size , to limt the data fetching .

Can any one gives sqample code or idea select query using 'package size'.

Advance Thanks,

Regards

veera

Re: select query with package size

Former Member — Wed, 13 Jun 2007 04:39:28 GMT

Hi,

Check this link for a sample program

http://www.sap-img.com/abap/package-size.htm

Thanks,

Naren

Re: select query with package size

Former Member — Wed, 13 Jun 2007 04:45:29 GMT


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.

Girish

Re: select query with package size

Former Member — Wed, 13 Jun 2007 04:56:29 GMT

Hi,

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.

Hi i want to select only from vbeln ,ie single selct query only using pakage size.200,blocks in data base ..How ?

Regards

veera

Re: select query with package size

former_member186741 — Wed, 13 Jun 2007 05:13:38 GMT

types: begin of ty_in,

vbeln type vbak-vbeln,

end of ty_in.

data it_in type table of ty_in with header line.

SELECT vbeln FROM vbak

INTO TABLE it_in PACKAGE SIZE 200.

SELECT posnr matnr meins

FROM vbap

apppending TABLE li_vbap

FOR ALL ENTRIES IN it_in

WHERE vbeln = it_in-vbeln.

endselect.