ABAP reporting for Joining pool/cluster table example

[abumohammad_shoyeb]

Dear SAPian,

Please give me a simple example full ABAP report that will join pool/cluster table:

EKKO - PO Header

EKPO - PO Item Details  

KONV - PO Condition

EKBZ - MIRO done

I am very new for ABAP reporting.

Thanks for your advance-operation.

Thanks,

Best Regards,

Shoyeb

[former_member186491]

Hi Abu,

Try by yourself or else you would remain NEW - I'm afraid.

But, for the moment, please check Table relation between those Tables and work out on your own logic.

Please check this link for Table-Relation Doc -

http://www.recercat.cat/bitstream/handle/2072/5419/PFCLopezRuizAnnex3.pdf?sequence=4

I am sure you can come up with the code eventually - its not tough either.

Thanks.

Kumar Saurav.

[abumohammad_shoyeb]

Will you please tell me how do show this data in Grid.

DATA: BEGIN OF EKPO_INT OCCURS 0.

         INCLUDE STRUCTURE EKPO.

DATA: END   OF EKPO_INT.

DATA: BEGIN OF KONV_INT OCCURS 0.

         INCLUDE STRUCTURE KONV.

DATA: END   OF KONV_INT.

SELECT * FROM  EKPO

     INTO TABLE EKPO_INT.

   SELECT * FROM  KONV

     INTO TABLE KONV_INT

     FOR ALL ENTRIES IN EKPO_INT

          WHERE  KNUMV = EKPO_INT-INFNR.