select query with package size

[Former Member]

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

[Former Member]

Hi,

Check this link for a sample program

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

Thanks,

Naren

[Former Member]

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

[Former Member]

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

[former_member186741]

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.