topic ABAP reporting for Joining pool/cluster table example in Application Development and Automation Discussions

ABAP reporting for Joining pool/cluster table example

abumohammad_shoyeb — Tue, 17 Jul 2012 11:05:03 GMT

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 — Tue, 17 Jul 2012 14:03:51 GMT

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 -

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

Thanks.

Kumar Saurav.

abumohammad_shoyeb — Wed, 18 Jul 2012 10:49:18 GMT

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.