Skip to Content
0
Former Member
May 26, 2008 at 06:31 AM

Really Urgent : Output problem in a report

26 Views

Hi,

I had made a report in whihc i have to display the vendor clear items .

I know there is tcode i.e. FBL1N which used to display all these but my client requierment it is and i have to display it.

I am using 3 tables i.e. MKPF ,BKPF and BSAK.

but problem is when i check the vendor in FBL1N it gives more account no as compared to my report.

plzz provide me some guidelines as how to perform it.

here is the code:-

TABLES : BKPF,BSAK.

DATA: BEGIN OF ITBSAK OCCURS 0,

MBLNR LIKE MKPF-MBLNR,

XBLNR LIKE MKPF-XBLNR,

BELNR LIKE BKPF-BELNR,

BUDAT LIKE BKPF-BUDAT,

GJAHR LIKE BKPF-GJAHR,

AWKEY LIKE BKPF-AWKEY,

BLART LIKE BSAK-BLART,

AUGBL LIKE BSAK-AUGBL,

AUGDT LIKE BSAK-AUGDT,

LIFNR LIKE BSAK-LIFNR,

WRBTR LIKE BSAK-WRBTR,

XREF3 LIKE BSAK-XREF3,

END OF ITBSAK.

SELECT-OPTIONS : P_BELNR FOR BKPF-BELNR.

SELECT-OPTIONS : P_LIFNR FOR BSAK-LIFNR.

SELECT AMBLNR AXBLNR BBELNR BBUDAT BGJAHR BAWKEY CBLART CAUGBL CAUGDT CLIFNR CWRBTR CXREF3 FROM MKPF AS A

INNER JOIN BKPF AS B ON BXBLNR = AXBLNR

INNER JOIN BSAK AS C ON CXBLNR = BXBLNR AND CGJAHR = BGJAHR

INTO TABLE ITBSAK WHERE AXBLNR > 0 AND BBELNR IN P_BELNR AND C~LIFNR IN P_LIFNR.

SORT ITBSAK BY MBLNR BELNR.

LOOP AT ITBSAK.

WRITE: / ITBSAK-MBLNR,ITBSAK-BELNR,ITBSAK-BUDAT,ITBSAK-BLART,ITBSAK-XBLNR,ITBSAK-AWKEY,ITBSAK-AUGBL,ITBSAK-AUGDT,ITBSAK-LIFNR,ITBSAK-WRBTR,ITBSAK-XREF3.

ENDLOOP.