Open Items on Key Date 

Technical name: 0FC_OP_01

Technical Data

Type of DataSource	Transactional data (movement data)
Application Component	Contract Accounts Receivable and Payable (FI-CA)
Available from OLTP Release	FI-CA 4.63 (4.6C)
Available from Plug-In Release	DataSource is shipped with the OLTP release
RemoteCube Compatibility	No

Prerequisites

This DataSource must be adjusted using Customizing in OLTP. It is a generic DataSource that extracts the content of table DFKKOPBW in OLTP. The structure of this table is adjusted within the OLTP project. As a result, the DataSource must also be adjusted. Once this has been done, the DataSource must be replicated in BW, and the transfer and update rules must be set and generated.

Use

You use this DataSource to extract open items from the OLTP. In OLTP, open items are written in table DFKKOPBW by a mass activity (transaction code FPBW) and are normally pre-aggregated.

Delta Update

Delta update is not available. Delta occurs as a result of repeated mass activity in OLTP.

Fields of Origin in the Extraction Structure

Field in Extraction Structure	Description of Field in the Extraction Structure
ADDRNUMBER	Address number
BETRH	Amount in local currency (+/-)
BETRW	Amount in transaction currency (+/-)
BUKRS	Company code
COUNTRY	Country key
FAEDN	Net due date
GPART	Business partner number
GSBER	Business area
HWAER	Currency key in local currency
INTNR	Interval number in the variant
KEYDT	Key date for analysis of open items
LAUFD	Run date
LAUFI	Additional ID
MAHNV	Dunning procedure
MANDT	Client
POST_CODE1	Postal code
RECCOUNT	Number of summarized open items
RECNO	Record number
SPART	Division
VKONT	Contract account number
WAERS	Transaction currency

Features of the Extractor

The DataSource is only an example and must be adjusted for individual customer needs during the appropriate project.