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.