In 30 seconds

What it is The functionality Open Item List gives you an overview of the receivables outstanding from your business partners. Transactions Transaction Description FPO1 FI-CA: OI List per Key Date FPO1P OI List for Key Date (Paralle

Guide covers Misc SAP FI-CA / Clearing

The functionality Open Item List gives you an overview of the receivables outstanding from your business partners.

Transactions

Transaction	Description
FPO1	FI-CA: OI List per Key Date
FPO1P	OI List for Key Date (Parallel)
FPO1_ACC	FI-CA Key Date-Specific OI List(Acc)
FPO2	Reconciliation of OI's in G/L
FPO2P	Reconciliation of OIs in G/L
FPO4	Item Evaluation
FPO4P	OI List for Key Date (Parallel)
FPO6	Evaluation of Report Totals
FPO7	Analysis of Extracted Open Items
FPSELP	Selections for Evaluations
FPSELP1	Layout for Evaluations

Mass activities

The open item list functionality has two mass activities. The following entries (table TFK090) are relevant:

AKTYP	EVE_ITVL	EVE_PARA	TCODE
OP03	1764	1762	FPO1P
OP04	1766	9568	FPO4P

FI-CA-Events

Event	Description
1762	MassAct: Evaluation of Open Items, Move Parameters
1764	Mass Activity: Evaluation of Open Items
1766	Mass Activity: Evaluation of Open Items OP04
9560	Open Item Evaluation: Fill Customer Fields
9561	Open Item Evaluation: Add Field in Layout
9562	Open Item Evaluation: Change Total Header Text
9565	Evaluation of Open Items: Simulated Clearing Items
9566	Evaluation of Open Items: Additional Authorization Check
9567	Evaluation of Open Items: Export of Items
9568	MassAct: Evaluation of Open Items FPO4P, Move Parameters

Technical information

Package

Package	Description
FKKB	Contract A/R & A/P: Central Objects

Function Groups / Programs

Function Group	Program	Description
FKK_SELP	SAPLFKK_SELP	Mass Selections from Master Data
FKK_SELP_CUST	SAPLFKK_SELP_CUST	Extended Table Maintenance (Generated)
FKK_SELP_EXT	SAPLFKK_SELP_EXT	Selections - External Interface
FKK_SELP_OP	SAPLFKK_SELP_OP	FM Help for OI Report

Tables

Table	Description
TFKK_SELP_GRP	Selection Types - Customizing Groups
TFKK_SELP_OP	Selection Types for OI Reports
TFKK_SELP_TYP	Selection Types - Customizing

Reports

Report	Description	Transaction
RFKKOP03	FI-CA: Key Date-Based Open Item List	FPO1
RFKKOP03_ACC	FI-CA: Key Date-Based Open Item List	FPO1_ACC
RFKKOP04	Item List	FPO4
RFKKOP05	FI-CA: Key Date-Based Open Item List	n/a
RFKKOP06	Evaluation of Report Totals	FPO6
RFKKOP07	Evaluation of Extracted Open Items	FPO7

Function Modules

Function Module	Description
FKK_SELP_OP_LINE_GET	Read line layout
FKK_SELP_OP_SEL_BP	Open Item Report - Read partner (GPART)
FKK_SELP_OP_SEL_CA	Open Item Report - Read contract account (VKONT)
FKK_SELP_SHOW_ERROR	Display error message

Message Class

Authorization Objects

F_KKKO_BUK
F_KKKO_GSB

Lock Objects

Lock Object	Description	Structure
EFKKOP03	Interval of OI Report	FKK_MAD_OP03_ENQ

Evaluating Open Items

By evaluating the open items in your system you can get an overview of the receivables outstanding from your business partners.

You can use the following functions to evaluate open items in FI-CA dependent on why you want to run the evaluation:

Key Date-Based Open Item List as Total List for Closing Preparation
Key Date-Based Open Item List as List with Individual Selections

Key-Date-Related Open Item List (Individual)

You can evaluate open items for selections of business partners, contract accounts, and contracts with the following transactions:

Item List (FPO4/report RFKKOP04)
OI List for Key Date (Parallel) (FPO4P)

To improve runtimes, the selection of business partners, contract accounts, and contracts has been separated from the selection and processing of open items.

You create variants for the selection of master data and use these when you start the programs. If you want to limit the selected items even further, such as only items belonging to a certain line of business or in a certain currency, you can create selection variants for these that you use when you start the report. For detailed information about creating selection variants, see Defining Preselections for Master Data.

You can also combine a predefined master data selection with direct selections.

By setting the Exclude Items from Selection indicator on the Selections tab under Selection of Open Items, you can remove a predefined selection of open items from being evaluated.

To output the selected data, you can make individual settings for line layout, sorting, and totaling (see Defining Layouts).

The transaction OI List for Key Date (Parallel) (FPO4P) provides a parallelized variant of the Item List(RFKKOP04) report. During the parallel execution, the program creates a list for every interval and a list with the totals records. You can output the list of items either in ALV format (ABAP List Viewer: short lists that are suitable for online processing), or in classic print format (better for long lists). Additional output in a dataset is possible.

For an evaluation using the transaction OI List for Key Date (Parallel) (FPO4P), you can group the spool requests into individual intervals.

In contrast to the transaction Open Items at Key Date (Parallel Processing) (FPO1P), the parallelization in the transaction OI List for Key Date (Parallel) (FPO4P) is only possible if the sorting of the layout corresponds to the parallelization object.

To evaluate open items with report RFKKOP04, proceed as follows:

Choose one of the following paths:
- Role: Information System (SAP_FI_CA_INFOSYSTEM) Evaluation of Open Items
- SAP Easy Access screen: Periodic Processing Evaluation of Open Items Evaluate
Enter the key date for which you want to select items.
Under Master Data Selection/Selection of Open Items, enter the name of your predefined selection.
Under Output Control, you can enter the name of your predefined line layout variant.
Choose Execute.

The list of open items is created.

For more information, see the report documentation.

To parallelize the evaluation:

Choose one of the following paths:
- Role: Information System (SAP_FI_CA_INFOSYSTEM) Perform Open Item Evaluation in Parallel
- SAP Easy Access screen: Periodic Processing Evaluation of Open Items Run Evaluation (Mass Run)
Enter a date and an ID that you can use to identify the run later.
Proceed as described above under points 2 to 4, and schedule the program run.

For more information about scheduling program runs, see the section Functions for Scheduling Program Runs.

When you output the selected items in a dataset, you can evaluate the data in the transaction Evaluation of Open Items from Dataset on the SAP Easy Access screen under Start of the navigation path Periodic Processing Next navigation step Evaluation of Extracted Data End of the navigation path .

Using the transaction Evaluation of Open Items of Non-Residents from Dataset in the menu under Start of the navigation path Periodic Processing Next navigation step Evaluation of Extracted Data End of the navigation path , you can output the data in the format required for foreign trade reporting Z5a if a dataset contains only items from foreign customers.

Key Date-Based Total List

You use key date-based open item lists in the form of totals lists for closing preparation (month, quarter, year) or for reconciliation purposes. You can use the following functions to output open items of individual business partners as a total list.

Report Key Date-Based Open Item List (RFKKOP03)
Transaction Open Item List for Key Date (Parallel) (FPO1P)

For detailed information about the report Key Date-Based Open Item List (RFKKOP03), see the documentation of the report.

With the transaction Open Item List for Key Date (Parallel) (FPO1P), you can use this report as a mass activity under the following paths:

Role Closing Operations(SAP_FI_CA_CLOSING_OPERATIONS) Key-Date-Based Open Item List
SAP menu Periodic Processing Closing Preparation Open Items at Key Date

You can output the selected data in text format with the report or the mass activity. You can process the list created outside of the SAP system.

For the evaluation of the transaction Open Items for Key Date (Parallel) (FPO1P), you can group the spool requests into individual intervals.

In contrast to the evaluations described below with individual selections in the transactions Item List (FPO4) andOpen Item List for Key Date (Parallel) (FPO4P), the layout of the output is defined by the report RFKKOP03 and the transaction Open Item List for Key Date (Parallel) (FPO1P).

In addition to details about open receivables, you can also use the functions to export the table of reclassifications. To do this, on the tab page Output Control , select the indicator Display Reclassifications . In order to be able to identify the data at a later data, specify a name for the export.When you save the reclassifications, you can then post them automatically in the transaction Post Reclassifications (SAP menu: Start of the navigation path Periodic Processing Next navigation step Closing Preparation End of the navigation path ).

However, if you enter a currency type on the tab page Output Control in the area Evaluation Control , the report replaces the first local currency with a currency with this currency type. If you also enter a valuation variant and a valuation key date, the report does not display the original amounts of the items; instead, it displays the amounts calculated by the currency valuation for the valuation key date.

If you set the Export Totals indicator on the Output Control tab page in the area Additional Output , you can export the totals and then evaluate them in the transaction Extended Evaluation of Report Totals in the SAP menu under Start of the navigation path Periodic Processing Next navigation step Evaluation of Extracted Data End of the navigation path . With activity 112 of authorization object F_KK_SOND, you can protect the access to the evaluation.