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

Transactions

Transaction
Description
FPO1FI-CA: OI List per Key Date
FPO1POI List for Key Date (Parallel)
FPO1_ACCFI-CA Key Date-Specific OI List(Acc)
FPO2Reconciliation of OI’s in G/L
FPO2PReconciliation of OIs in G/L
FPO4Item Evaluation
FPO4POI List for Key Date (Parallel)
FPO6Evaluation of Report Totals
FPO7Analysis of Extracted Open Items
FPSELPSelections for Evaluations
FPSELP1Layout 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

OP0317641762FPO1P
OP0417669568FPO4P

FI-CA-Events

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

Technical information

Package

Package
Description
FKKBContract A/R & A/P: Central Objects

Function Groups / Programs

Function Group
Program
Description
FKK_SELPSAPLFKK_SELPMass Selections from Master Data
FKK_SELP_CUSTSAPLFKK_SELP_CUSTExtended Table Maintenance (Generated)
FKK_SELP_EXTSAPLFKK_SELP_EXTSelections – External Interface
FKK_SELP_OPSAPLFKK_SELP_OPFM Help for OI Report

Tables

Table
Description
TFKK_SELP_GRPSelection Types – Customizing Groups
TFKK_SELP_OPSelection Types for OI Reports
TFKK_SELP_TYPSelection Types – Customizing

Reports

Report
Description
Transaction
RFKKOP03FI-CA: Key Date-Based Open Item ListFPO1
RFKKOP03_ACCFI-CA: Key Date-Based Open Item ListFPO1_ACC
RFKKOP04Item ListFPO4
RFKKOP05FI-CA: Key Date-Based Open Item Listn/a
RFKKOP06Evaluation of Report TotalsFPO6
RFKKOP07Evaluation of Extracted Open ItemsFPO7

Function Modules

Function Module
Description
FKK_SELP_OP_LINE_GETRead line layout
FKK_SELP_OP_SEL_BPOpen Item Report –  Read partner (GPART)
FKK_SELP_OP_SEL_CAOpen Item Report –  Read contract account (VKONT)
FKK_SELP_SHOW_ERRORDisplay error message

Message Class

>A

Authorization Objects

  • F_KKKO_BUK
  • F_KKKO_GSB

Lock Objects

Lock Object
Description
Structure
EFKKOP03Interval of OI ReportFKK_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:

  1. Choose one of the following paths:

    • Role: Start of the navigation path Information System (SAP_FI_CA_INFOSYSTEM) Next navigation stepEvaluation of Open Items End of the navigation path

    • SAP Easy Access screen: Start of the navigation path Periodic Processing Next navigation stepEvaluation of Open Items Next navigation stepEvaluate End of the navigation path

  2. Enter the key date for which you want to select items.

  3. Under Master Data Selection/Selection of Open Items, enter the name of your predefined selection.

  4. Under Output Control, you can enter the name of your predefined line layout variant.

  5. Choose Execute.

    The list of open items is created.

For more information, see the report documentation.

To parallelize the evaluation:

  1. Choose one of the following paths:

    • Role: Start of the navigation path Information System (SAP_FI_CA_INFOSYSTEM) Next navigation stepPerform Open Item Evaluation in Parallel End of the navigation path

    • SAP Easy Access screen: Start of the navigation path Periodic Processing Next navigation stepEvaluation of Open Items Next navigation stepRun Evaluation (Mass Run) End of the navigation path

  2. Enter a date and an ID that you can use to identify the run later.

  3. 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 stepEvaluation 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 stepEvaluation 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 Start of the navigation path Closing Operations(SAP_FI_CA_CLOSING_OPERATIONS) Next navigation stepKey-Date-Based Open Item List End of the navigation path

  • SAP menu Start of the navigation path Periodic Processing Next navigation stepClosing Preparation Next navigation stepOpen Items at Key Date End of the navigation path

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 stepClosing 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 stepEvaluation 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.

 

Average Rating
5 out of 5 stars. 1 votes.
My Rating:

0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *