topic parallel cursor method in Application Development and Automation Discussions

parallel cursor method

pritam_baboo49 — Tue, 22 Mar 2022 06:40:04 GMT

I have to implement a report using parallel cursor method.

Fetch vbeln, vbtyp, knumv from vbrk.

fetch POSNR, FKIMG, MATNR from VBRP

Pass VBRK-KNUMV to KONP table, fetch KBETR (SUM of all KSCHL) based on KNUMV & KOPOS.

Display all the above fields in the ALV output.

plz help with code.

Re: parallel cursor method

abo — Tue, 22 Mar 2022 10:25:58 GMT

You could search for previous questions and perhaps find an answer

Re: parallel cursor method

pritam_baboo49 — Tue, 22 Mar 2022 11:02:09 GMT

can you guide me on how to pass vbrk-knumv to konp when there is no common field.

Re: parallel cursor method

Sandra_Rossi — Tue, 22 Mar 2022 14:43:28 GMT

KONP-KNUMV doesn't exist?

Re: parallel cursor method

pritam_baboo49 — Wed, 23 Mar 2022 06:54:59 GMT

Yes, I know. But my question was how to pass VBRK-KNUMV to KONP.

I did some thing like this:

select vbeln
       vbtyp
       knumv
       FROM vbrk
       INTO TABLE lt_vbrk
       WHERE vbeln in s_vbeln.


  SELECT vbeln
         posnr
         fkimg
         matnr
         FROM vbrp
         INTO TABLE lt_vbrp
         FOR ALL ENTRIES IN lt_vbrk
         WHERE vbeln = lt_vbrk-vbeln.

    SELECT knumh
           kbetr
           kopos
      from konp
      INTO TABLE lt_konp
      FOR ALL ENTRIES IN  lt_vbrk
      WHERE KNUMH = lt_vbrk-knumv.

Re: parallel cursor method

Sandra_Rossi — Wed, 23 Mar 2022 17:48:33 GMT

What is the issue with WHERE KNUMH = lt_vbrk-knumv?