Skip to Content
0
Former Member
Sep 13, 2007 at 06:15 AM

AP cleared Item Report

458 Views

Hi,

I am use SAP query to build a AP cleared Item report. The report is similar as we can get from FBL1n, but I need a column as group key, which can not be found in FBL1n report.

My questions is:

1. When using SAP query, I use table LFA1 and BSAK, everything is ok, except I could only get the uncleared Item in the table. Like for one item have both Credit and Debit, I could find them in my report. What shall I do?

The field used in the report:

Company Code: BSAK-BUKRS

Vendor Code: BSAK-LIFNR

Vendor Name: LFA1-NAME1

Payment Type(Group Key):

Posting Date: BSAK-BUDAT

Clearing Date: BSAK-AUGDT

Document Type: BSAK-BLART

Fiscal Period: BSAK-MONAT

Fiscal Year: BSAK-GJAHR

2. Or if I just need to have a report like FBL1n, but have group key on the report, any other report I could use?