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
>A
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
/reportRFKKOP04
) -
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 Periodic Processing
Evaluation of Extracted Data
.
Using the transaction Evaluation of Open Items of Non-Residents from Dataset
in the menu under Periodic Processing
Evaluation of Extracted Data
, 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: Periodic Processing
Closing Preparation
).
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 Periodic Processing
Evaluation of Extracted Data
. With activity 112 of authorization object F_KK_SOND, you can protect the access to the evaluation.
