parallel cursor method

[pritam_baboo49]

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.

[abo]

You could search for previous questions and perhaps find an answer

[pritam_baboo49]

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

[Sandra_Rossi]

KONP-KNUMV doesn't exist?

[pritam_baboo49]

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.

[Sandra_Rossi]

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