SAP ABAP fico report for Vendor open items

This SAP fico report using ABAP code less report that is in build report lists the open items by vendor for a given period. The list of vendor open items offers dynamic sorting options ranging from the A/P reconciliation account to the country of the vendor to the accounting clerk who entered the item.

To run this ABAP report

One method is :Information systems → Accounting → Financial accounting
Accounts payable → Open items

And the second method is

Choose System → Services → Reporting and enter RFKOPO00 in the Program field.
Then, choose Execute to run the report.

In the Command field, enter transaction F.41 and choose Enter.

You must make certain that Open items at key date (system date is the default) is selected before running this report.

The selection screen of SAP ABAP report includes:
  1. Variants
  2. Dynamic selection options
  3. User variables
  4. Execution (and print) in background
The output of this sap finance and control (fico) report includes a listing of vendor open items, sorted by various criteria.

S-sort indicators for master data enable you to sort by:

Reconciliation account (default)
Group key
Consolidated company
Industry key
Accounting clerk
Account abbreviation (sort field)
Account number
P-sort indicators for line item data enable you to sort by:

Special G/L indicators (default)
Allocation number within the account number
Posting period
Posting date
Due date
Document date
According to cash discount 1 due date (With this sorting method, the cash discount 1 due date is issued in the list instead of the due date for net payment.)
Sample SAP FICO report with screen shots

Create a listing of all vendor open items for company 3000.

To access the first screen for this report, choose

Information systems → Accounting → Financial accounting
Accounts payable → Open items.

The input screen looks like this.
Each number of the screen is explained here.

1. Enter 3000 in Company code.

2. Enter 1998.11.12 in Open items at key date. The system selects all items that posted before the specified key date and are open for the given period.

3. Select Standard documents. This excludes sample documents, recurring entries, and statistical

4. Under Output control, enter 1 in S-Sort indicator to sort by the reconciliation account. Enter 1 in P-Sort indicator to sort by special G/L indicators.

5. Choose Execute.

The output of this ABAP report for sap finance is as shown below.

Each part of the output screen explains the following.

A The list of vendor open items for the selected company code and the sort sequence for this report
B The vendor C.E.B New York and its address information

C The posting date of 08/31/98 and the original document number 5100000001

D The credit amount of 9,750.00 displayed by currency

E The reconciliation account 160000 This screen shows the far right side of the List of Vendor Open Items report.

The second screen shows the far right side of the List of Vendor Open Items report.

You may be also interested in the following SAP Finance reports.

SAP Finance General Ledger report account balance
Finance general ledger line items SAP ABAP report
General ledger report SAP FINACNE
SAP FICO customer open items report
Customer balance in local currency for SAP FICO 
ABAP complete course

No comments :

Post a Comment