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.