Installment Plan Items

Technical Name: 0FC_IPL_ITEM_01

Technical Data

Type of DataSource

Transaction data

Application Component

Contract Accounts Receivable and Payable (FI-CA)

Available from OLTP release

4.71

Available from Plug-In release

RemoteCube-capable

No

Use

This DataSource extracts the items of installment plans.

Delta Update

The delta update is supported.

Source Fields of the Extraction Structure

Field in the Extraction Structure

Description of the Field in the Extraction Structure

Source Table

Field in the Source Table

OPBEL

Number for a document in Contract Accounts Receivable and Payable

DFKKOP

OPBEL

OPUPW

Repetition item in a document from Contract Accounts Receivable and Payable

DFKKOP

OPUPW

OPUPK

Item number in a document from Contract Accounts Receivable and Payable

DFKKOP

OPUPK

OPUPZ

Subitem for a partial clearing in the document

DFKKOP

OPUPZ

RECORDMODE

BW delta procedure: Update mode

BUKRS

Company code

DFKKOP

BUKRS

GSBER

Business area

DFKKOP

GSBER

GPART

Business partner number

DFKKOP

GPART

VKONT

Contract account number

DFKKOP

VKONT

SPART

Division

DFKKOP

SPART

BUDAT

Posting date in document

DFKKOP

BUDAT

FAEDN

Due date for net payment

DFKKOP

FAEDN

BETRW

Amount in transaction currency

DFKKOP

BETRW

WAERS

Transaction currency

DFKKOP

WAERS

BETRH

Amount in local currency

DFKKOP

BETRH

HWAER

Local currency

T001

HWAER

AUGDT

Clearing date

DFKKOP

AUGDT

AUGRD

Clearing reason

DFKKOP

AUGRD

Special Features of the Extractor

To support the delta update, the extractor saves the dataset in its own tables at the time of the last extraction. After the initialization in BW, you have to run the extraction completely once. To do this, set the indicator No Delta – Extract All in the extractor.