Skip to Content
0
Former Member
Nov 29, 2007 at 11:29 AM

Report for Customer Condition Records

21 Views

Hello ABAPers,

I want to write ABAP report to list out Material,Customer,Tax type and Tax amount. The data is available in tables A005 and KONP and the joining condition would be A005-KNUMH and KONP-KNUMH.

But since A005 s a Pooled table am not able to write a correct join condition.

Can any one guide me on how we can write this join condition?

I tried with FOR ALL ENTRIES IN TABLE but the output was not reading the value of Amount(KONP-KBETR).The amount is coming as zero always.

The code i'm using is:

-


SELECT MATNR KUNNR VKORG VTWEG KSCHL KNUMH INTO TABLE ITAB_JEXP FROM A005 WHERE KSCHL = 'JEXP'.

IF NOT ITAB_JEXP IS INITIAL.

SELECT KNUMH KOPOS KSCHL KBETR INTO TABLE ITAB FROM KONP FOR ALL ENTRIES IN ITAB_JEXP

WHERE KNUMH = ITAB_JEXP-KNUMH AND KSCHL = ITAB_JEXP-KSCHL.

APPEND ITAB.

ENDIF.

LOOP AT ITAB_JEXP.

MOVE-CORRESPONDING ITAB_JEXP TO ITAB.

APPEND ITAB.

ENDLOOP.

Thanks,

B P Shah

Message was edited by:

Bhavin P Shah