cancel
Showing results for 
Search instead for 
Did you mean: 

Open Item Report

Former Member
0 Kudos
363

Hi SAP Gurus!!

I have something in mind, i need your help guys. I want to make a report of all open items ( vendor ). I would like to customize a report for this. I want to:

1. Display all open items net of payments. Line item should display remaining balances only.

2. I would like also to display all MIGO transactions that have no Invoice receipt yet.

Requirements: I want to do this in a query, what are the sap tables should i use to make this report.

I already checked FBL1N and chose INVOICENET layout, but still i am not satisfied with that kind of report.

Please help me guys. I will assign maximum points to useful answers.

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

sridhar_muthekepalli3
Active Contributor
0 Kudos

Hi,

Check this SAP Standard report RFKEPL00 .Go to T.code se38 and enter the standard report RFKEPL00 ( Vendor open items) and execute.Check whether it meets your requirement or not.

To see the tables used in this report, Enter the program name and click on display.and click on INCLUDE fkepl00_top.It will show yo the tables used in the report.

In FBL1N changelayout (Ctrl + F8) , Select purchase document or other fields to meet your requirement.

Please let me know if you need more information.

Pelase let me know if you need more information.

Assign points if useful.

Regards

Sridhar M