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?