FI-CA: Open Items

DataStore object DataStore object: 0FC_DS01

This data store object allows you to analyze open, due, and overdue items. Since the dataset transferred to BW is determined by key date, all analyses must be carried out by key date.

As a chronological analysis period, you can group the open items by due date periods. The drilldown can take place according to business partner attributes, regional structure data, company code, business area, division or dunning procedure.

In order to restrict the dataset to the necessary level of detail, we recommend, for example, that you only transfer business partner data of company customers to BW since it only makes sense to analyze this data in great detail.

The data for this data store object is determined in OLTP by a mass activity (by key date) and loaded in the data store object using generic extraction. The DataSource is not capable of producing delta figures. This means that you must manually delete the legacy data in the data store object.

Structure

Delta Update

Delta update is not supported for this DataStore object.

Data Modeling

Key Fields

Object Type

Name

Technical Name

Characteristic

Business area

0BUS_AREA

Characteristic

Dunning Procedure

0CADUNN_PRC

Characteristic

Company code

0COMP_CODE

Characteristic

Division

0DIVISION

Characteristic

Date ID of Mass Activity

0FC_RUNDATE

Characteristic

ID of Mass Activity

0FC_RUN_ID

Characteristic

Due date for net payment

0NETDUEDATE

Data Fields

Object Type

Name

Technical Name

Unit of measurement

Currency Key for Local Currency

0CURKEY_LC

Key figure

Number of Document Items

0DOC_ITEMS

Characteristic

Key Date of Analysis

0FC_KEYDATE

Key figure

Open Item

0FC_OI

Data packet characteristic

BW Delta Process: Update Mode

0RECORDMODE