General Ledger: Direct Line Items (SAP Library - DataSources in General Ledger Accounting)

General Ledger: Direct Line Items

Technical name: 0FI_GL_4

Technical Data

Type of DataSource	Transaction data (movement data)
Application Component	Financial Accounting: General Ledger Accounting (FI-GL)
Available from OLTP Release	4.0B
Available from Plug-In Release	2001.1
RemoteCube-Compatible

Use

This DataSource extracts General Ledger Accounting line items from tables BKPF and BSEG in the source system.

The extractor does not transfer any redundant fields to BW. This means that only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables) to the extract structure. In particular, the extract structure contains no fields from Accounts Receivable and Accounts Payable Accounting. This information is extracted separately (DataSources 0FI_AR_4 and 0FI_AP_4).

· Source structure: BKPF, BSEG

· Extractor: BWFID_GET_FIGL_ITEM

· Extract structure OLTP: DTFIGL_4

Delta Update

This DataSource is delta-compatible.

Origin Fields in the Extract Structure

Field in Extract Structure	Description of Field in Extract Structure	Table of Origin	Field in Table of Origin
BUKRS	Company code	BKPF	BKPF-BUKRS
FISCPER	Fiscal year/period	BKPF	BKPF-GJAHR, BKPF-MONAT
BELNR	Accounting document number	BKPF	BKPF-BELNR
BUZEI	Account document posting line	BSEG	BSEG-BUZEI
STATUSPS	Status of the FI item (O = open, C = cleared)	BKPF, BSEG	BKPF-BSTAT, BSEG-AUGDT
KTOPL	Chart of accounts	T001	T001-KTOPL
HKONT	General ledger account in G/L accounting.	BSEG	BSEG-HKONT
KOART	Account type	BSEG	BSEG-KOART
UMSKZ	Special G/L indicator	BSEG	BSEG-UMSKZ
BLART	Document type	BKPF	BKPF-BLART
BSCHL	Posting key	BSEG	BSEG-BSCHL
FISCVAR	Fiscal year variant	T001	T001-PERIV
BLDAT	Document date in document	BKPF	BKPF-BLDAT
BUDAT	Posting date in the document	BKPF	BKPF-BUDAT
CPUDT	Day on which accounting document was created	BKPF	BKPF-CPUDT
AUGDT	Clearing date	BSEG	BSEG-AUGDT
AUGBL	Clearing document number	BSEG	BSEG-AUGBL
KOKRS	Controlling area	BSEG	BSEG-KOKRS
KOSTL	Cost center	BSEG	BSEG-KOSTL
PRCTR	Profit center	BSEG	BSEG-PRCTR
AUFNR	Order number	BSEG	BSEG-AUFNR
PROJK	Work breakdown structure element	BSEG	BSEG-PROJK
WERKS	Plant	BSEG	BSEG-WERKS
GSBER	Business area	BSEG	BSEG-GSBER
FKBER	Functional area	BSEG	BSEG-FKBER
PPRCT	Partner profit center	BSEG	BSEG-PPRCT
PARGB	Business area of the business partner	BSEG	BSEG-PARGB
VBUND	Company ID of trading partner	BSEG	BSEG-VBUND
LCURR	Currency key of the local currency	T001	T001-WAERS
DMSOL	Debit amount in local currency	BSEG	BSEG-SHKZG, BSEG-DMBTR
DMHAB	Credit amount in local currency	BSEG	BSEG-SHKZG, BSEG-DMBTR
DMSHB	Local currency amount (+/-)	BSEG	BSEG-SHKZG, BSEG-DMBTR
WAERS	Currency key	BKPF	BKPF-WAERS
WRSOL	Debit amount in foreign currency	BSEG	BSEG-SHKZG, BSEG-WRBTR
WRHAB	Credit amount in foreign currency	BSEG	BSEG-SHKZG, BSEG-WRBTR
WRSHB	Foreign currency amount (+/-)	BSEG	BSEG-SHKZG, BSEG-WRBTR
CURT2	Currency type of the second local currency	T001A	See below 1)
HWAE2	Currency key of the second local currency	T001A	See below 1)
DMSO2	Debit amount in second local currency	BSEG	BSEG-SHKZG, BSEG-DMBE2
DMHA2	Credit amount in second local currency	BSEG	BSEG-SHKZG, BSEG-DMBE2
DMSH2	Amount in second local currency (+/-)	BSEG	BSEG-SHKZG, BSEG-DMBE2
CURT3	Currency type of the third local currency	T001A	See below 1)
HWAE3	Currency key of the third local currency	T001A	See below 1)
DMSO3	Debit amount in third local currency	BSEG	BSEG-SHKZG, BSEG-DMBE3
DMHA3	Credit amount in third local currency	BSEG	BSEG-SHKZG, BSEG-DMBE3
DMSH3	Amount in third local currency (+/-)	BSEG	BSEG-SHKZG, BSEG-DMBE3
XBLNR	Reference document number	BKPF	BKPF-XBLNR
XREF3	Reference key for the document items	BSEG	BSEG-XREF3
AWREF	Reference document number	BKPF	See below 2)
AWGJA	Document year for reference document number	BKPF	See below 2)
AWBUK	Company code for reference document number	BKPF	See below 2)
AWKOK	Controlling area for reference document number	BKPF	See below 2)
SGTXT	Item text	BSEG	BSEG-SGTXT
XNEGP	Flag: Negative Posting
UPMODE	BW delta process: Update mode
PS-POSID	Work Breakdown Structure Element (WBS Element)
ZUONR	Assignment number
.INCLUDE DTFIGL-WF	Extract structure: GL help fields
.INCLUDE CI_BSIS	Customer exits for extract structure DTFIGL_4		See below 3)

Notes on the calculated fields:

1) Currency types CURT2 and CURT3 and currency keys HWAE2 and HWAE3 for the second/third local currency are determined in the R/3 source system from the company code data using function module FI_CURRENCY_INFORMATION.

2) Fields AWREF, AWGJA, AWBUK and AWKOK for the source document are derived from BKPF-AWTYP and BKPF-AWKEY using function module BWFIU_GET_DOCUMENT_ORIGIN.

3) The procedure for customer exits is described in OSS note 410799.