General Ledger Accounting (New): Line Items of Any Ledger (Generated)

DataSource Transactional Data: 3FI_GL_XX_SI

This DataSource extracts the line items from a specified ledger in new General Ledger Accounting. The ledger specified can be the leading ledger or any other ledger.

No Content is delivered in BI for the generic DataSources.

Technical Data

Application Component	Financial Accounting: General Ledger Accounting (FI-GL)
Available as of Release	SAP Enhancement Package 3 for SAP ERP 6.0
Shipment	SAP NetWeaver 7.0 BI Content Add-On 3 Support Package 08
Content Versions	1.0; 703
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Prerequisites

In Customizing of the OLTP system, you have activated new General Ledger Accounting under Financial Accounting Financial Accounting Global Settings .

The generated extractors use extract structure FAGLPOSBW.

Activities

In the OLTP system, start transaction FAGLBW03.

All ledgers are listed.
In the row with the ledger for which you want to generate the DataSource, double-click the Line Item DataSource field.

The Assign DataSource dialog box appears. You can change the name in the DataSource field. However, you cannot change the initial 3, which appears as the first character.

Recommendation
As the system default name applies the above-mentioned naming convention, we recommend that you do not change this name.

End of the recommendation.
Choose Continue.
The DataSource: Edit Customer Version screen appears. In this screen, you can exclude individual fields of the underlying extraction structure from the selection or from the data transfer.
Configure the DataSource and save your settings.

You have now created a DataSource for extracting data to BI for the selected ledger.

Data Modeling

Delta Update

After images with deletion indicator using extractor (FI-GL/AP/AR): The DataSource uses the delta method to transfer each new status of the changed line item. For this reason, it is not possible to update the InfoCube directly. The InfoCube can only be deleted via the DataStore object (update with MOVE). The delta method works with a lower safety interval of an hour (standard setting). This means that the system transfers all postings that were made from an hour preceding the last delta load up to the current time. The overlapping of each first hour of a delta load when the after image method is used with the update MOVE causes any data records that were extracted twice to be overwritten. In this way, the method guarantees gap-free data consistency in BI.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`ANLN1`	Main asset number	`BSEG`	`ANLN1`
`ANLN2`	Asset subnumber - new, four-digit	`BSEG`	`ANLN2`
`AUFNR`	Order number	`BSEG`	`AUFNR`
`AUGBL`	Clearing document number	`BSEG`	`AUGBL`
`AUGDT`	Clearing date	`BSEG`	`AUGDT`
`BELNR`	Accounting document number	`FAGLFLEXA`	`BELNR`
`BLART`	Document type	`BKPF`	`BLART`
`BLDAT`	Document date in document	`BKPF`	`BLDAT`
`BSCHL`	Posting key	`FAGLFLEXA`	`BSCHL`
`BSTAT`	Document status	`FAGLFLEXA`	`BSTAT`
`BUDAT`	Posting date in document	`FAGLFLEXA`	`BUDAT`
`BUKRS`	Company code	`FAGLFLEXA`	`RBUKRS`
`BUZEI`	Number of the line item within the accounting document	`FAGLFLEXA`	`BUZEI`
`DMSHB`	Amount in local currency with +/- sign	`BSEG`	`DMBTR *¹`
`HWAER`	Local currency		`RBUKRS*¹`
`DMBE2`	Amount in second local currency	`BSEG`	`DMBE2`
`HWAE2`	Currency key of the second local currency		`RLDNR*¹`
`DMBE3`	Amount in third local currency	`BSEG`	`DMBE3`
`HWAE3`	Currency key of the third local currency		`RLDNR*¹`
`EBELN`	Purchasing document number	`BSEG`	`EBELN`
`EBELP`	Item number of purchasing document	`BSEG`	`EBELP`
`ETEN2`	Schedule number	`BSEG`	`ETEN2`
`FAEDT`	Net due date	`BSEG`	`ZFBDT`
`FILKD`	Branch account number	`BSEG`	`FILKD`
`GJAHR`	Fiscal year	`FAGLFLEXA`	`GJAHR`
`GSBER`	Business area	`FAGLFLEXA`	`RBUSA`
`JAMON`	Fiscal year/posting period from posting date	`BKPF`	`GJAHR¹ / MONAT¹`
`KOART`	Account type	`BSEG`	`KOART`
`KOSTL`	Cost center	`FAGLFLEXA`	`RCNTR`
`MABER`	Dunning area	`BSEG`	`MABER`
`MADAT`	Date of last dunning notice	`BSEG`	`MADAT`
`MANSP`	Dunning lock	`BSEG`	`MANSP`
`MANST`	Dunning level	`BSEG`	`MANST`
`MONAT`	Fiscal period	`BKPF`	`MONAT`
`MSCHL`	Dunning key	`BSEG`	`MSCHL`
`MWSKZ`	Tax on sales/purchases code	`BSEG`	`MWSKZ`
`POSN2`	Sales document item	`BSEG`	`POSN2`
`PRCTR`	Profit center	`FAGLFLEXA`	`PRCTR`
`QBSHB`	Withholding tax amount in document currency	`BSEG`	`QBSHB¹ / WRBTR¹`
`QSFBT`	Withholding tax exempt amount in document currency	`BSEG`	`QSFBT¹ / WRBTR¹`
`QSSHB`	Withholding tax base amount in document currency	`BSEG`	`QSSHB¹ / WRBTR¹`
`REBZG`	Document number of the invoice to which the transaction belongs	`BSEG`	`REBZG`
`SAMNR`	Invoice list number	`BSEG`	`SAMNR`
`SGTXT`	Item text	`BSEG`	`SGTXT`
`SHKZG`	Debit/credit indicator	`FAGLFLEXA / BSEG`	`DRCRK¹ / XNEGP¹`
`SKFBT`	Amount eligible for cash discount in document currency	`BSEG`	`SKFBT¹ / WRBTR¹`
`WSKTO`	Cash discount amount in document currency	`BSSEG`	`WSKTO¹ / WRBTR¹`
`SKNTO`	Cash discount amount in local currency	`BSEG`	`SKNTO¹ / DMBTR¹`
`UMSKS`	Transaction class special general ledger	`BSEG`	`UMSKS`
`UMSKZ`	Special G/L indicator	`BSEG`	`UMSKZ`
`UZAWE`	Additional payment method	`BSEG`	`UZAWE`
`VALUT`	Value date	`BSEG`	`VALUT`
`VBEL2`	Sales document	`BSEG`	`VBEL2`
`VBELN`	Billing	`BSEG`	`VBELN`
`VBEWA`	Flow type	`BSEG`	`VBEWA`
`VBUND`	Company ID of trading partner	`FAGLFLEXA`	`RASSC`
`VERTN`	Contract Number	`BSEG`	`VERTN`
`VERTT`	Contract type	`BSEG`	`VERTT`
`WERKS`	Plant	`BSEG`	`WERKS`
`WRSHB`	Amount in document currency (foreign currency)	`BSEG`	`WRBTR*¹`
`WAERS`	Document currency (key)	`FAGLFLEXA`	`RWCUR`
`WVERW`	Type of bill of exchange usage	`BSEG`	`WVERW`
`XBLNR`	Reference document number	`BKPF`	`XBLNR`
`XZAHL`	Indicator: Is this is a payment transaction ?	`BSEG`	`XZAHL`
`ZBD1P`	Cash discount percentage 1	`BSEG`	`ZBD1P`
`ZBD1T`	Cash discount days 1	`BSEG`	`ZBD1T`
`ZBD2P`	Cash discount percentage 2	`BSEG`	`ZBD2P`
`ZBD2T`	Cash discount days 2	`BSEG`	`ZBD2T`
`ZBD3T`	Deadline for terms of payment net	`BSEG`	`ZBD3T`
`ZFBDT`	Baseline date for due date calculation	`BSEG`	`ZFBDT`
`ZLSCH`	Payment method	`BSEG`	`ZLSCH`
`ZLSPR`	Payment lock key	`BSEG`	`ZLSPR`
`ZTERM`	Terms of payment key	`BSEG`	`ZTERM`
`ZUONR`	Assignment number	`BSEG`	`ZUONR`
`XREF1`	Reference key of the business partner	`BSEG`	`XREF1`
`XREF2`	Reference key of the business partner	`BSEG`	`XREF2`
`XARCH`	Indicator: Amount already in archive?	`BSEG`	`XARCH`
`RSTGR`	Reason code for payments	`BSEG`	`RSTGR`
`ASKTO`	Current cash discount amount in document currency	`BSEG`	`SKFBT¹ / WRBTR¹`
`KURSE`	Effective exchange rate in line item	`BKPF`	`KURSF`
`REBZT`	Type of follow-on document	`BSEG`	`REBZT`
`PSWSL`	Update currency for general ledger transaction figures	`BSEG`	`PSWSL`
`PSWBT`	Amount for general ledger update (absolute)	`BSEG`	`PSWBT`
`HKONT`	G/L account in General Ledger Accounting	`FAGLFLEXA`	`RACCT`
`XNEGP`	Indicator: Negative posting	`BSEG`	`XNEGP`
`ZBFIX`	Fixed payment condition	`BSEG`	`ZBFIX`
`RFZEI`	Payment card item	`BSEG`	`RFZEI`
`CCBTC`	Payment cards: Settlement run	`BSEG`	`CCBTC`
`KKBER`	Credit control area	`BSEG`	`KKBER`
`XREF3`	Reference key for the document items	`BSEG`	`XREF3`
`DTWS1`	Instruction 1	`BSEG`	`DTWS1`
`DTWS2`	Instruction 2	`BSEG`	`DTWS2`
`DTWS3`	Instruction 3	`BSEG`	`DTWS3`
`DTWS4`	Instruction 4	`BSEG`	`DTWS4`
`ABSBT`	Credit Management: Guaranteed amount (absolute)	`BSEG`	`ABSBT¹ / WRBTR¹`
`KKBWR`	Currency of credit controlling area		`KKBER*¹`
`PROJK`	WBS element in external format	`BSEG`	`PROJK`
`XPYPR`	Indicator: Payment order exists for this item	`BSEG`	`XPYPR`
`KIDNO`	Payment reference	`BSEG`	`KIDNO`
`BUPLA`	Business place	`BSEG`	`BUPLA`
`SECCO`	Withholding tax section	`BSEG`	`SECCO`
`PYCUR`	Currency for automatic payment	`BSEG`	`PYCUR`
`PYAMT`	Amount in currency for automatic payment (absolute)	`BSEG`	`PYAMT¹ / WRBTR¹`
`XRAGL`	Indicator: Clearing was undone	`BSEG`	`XRAGL`
`CESSION_KZ`	Accounts receivable pledging indicator	`BSEG`	`CESSION_KZ`
`BUZID`	Identification of posting line	`BSEG`	`BUZID`
`AUGGJ`	Fiscal year of clearing document	`BSEG`	`AUGGJ`
`AGZEI`	Clearing item	`BSEG`	`AGZEI`
`AWSYS`	Logical system	`FAGLFLEXA`	`LOGSYS`
`AWTYP`	Reference transaction	`FAGLFLEXA`	`AWTYP`
`BDIFF`	Valuation difference	`BSEG`	`BDIFF¹ / DMBTR¹`
`BDIF2`	Valuation difference for the second local currency	`BSEG`	`BDIF2¹ / DMBE2¹`
`BDIF3`	Valuation difference for the third local currency	`BSEG`	`BDIF3 /DMBE3`
`BEWAR`	Flow type	`FAGLFLEXA`	`RMVCT`
`DABRZ`	Asset value date for billing	`BSEG`	`DABRZ`
`DMBTR`	Amount in local currency	`BSEG`	`DMBTR`
`DOCNR`	Document number of general ledger document	`FAGLFLEXA`	`DOCNR`
`DOCLN`	Six-digit line item for ledger	`FAGLFLEXA`	`DOCLN`
`FKBER`	Functional area	`BSEG`	`FKBER`
`FKBER_LONG`	Functional area	`FAGLFLEXA`	`RFAREA`
`GLVOR`	Business transaction	`FAGLFLEXA`	`ACTIV`
`IMKEY`	Internal key for Real Estate object	`BSEG`	`IMKEY`
`KOKRS`	Controlling area	`FAGLFLEXA`	`KOKRS`
`KSTAR`	Cost element	`BSEG`	`COST_ELEM`
`KUNNR`	Customer number 1	`BSEG`	`KUNNR`
`LIFNR`	Account number of vendor	`BSEG`	`LIFNR`
`MEINS`	Base unit of measure	`FAGLFLEXA`	`RUNIT`
`MENGE`	Quantity	`BSEG`	`MENGE¹ / WRBTR¹`
`PARGB`	Business area of the business partner	`FAGLFLEXA`	`SBUSA`
`PERIO`	Period/year	`FAGLFLEXA`	`RYEAR¹ / POPER¹`
`PFKBER`	Functional area of partner	`FAGLFLEXA`	`SFAREA`
`PKOSTL`	Partner cost center	`FAGLFLEXA`	`SCNTR`
`POPER`	Posting period	`FAGLFLEXA`	`POPER`
`PPRCT`	Partner profit center	`FAGLFLEXA`	`PPRCTR`
`PSEGMENT`	Partner segment for segment reporting	`FAGLFLEXA`	`PSEGMENT`
`PS_PSP_PNR`	WBS elements	`BSEG`	`SAKNR`
`RLDNR`	Ledger	`FAGLFLEXA`	`RLDNR`
`RYEAR`	Fiscal year of the general ledger	`FAGLFLEXA`	`RYEAR`
`SAKNR`	G/L account number	`BSEG`	`SAKNR`
`SEGMENT`	Segment for segment reporting	`FAGLFLEXA`	`SEGMENT`
`WRBTR`	Amount in document currency	`BSEG`	`WRBTR`
`XOPVW`	Indicator: Open Item Management?	`BSEG`	`XOPVW`
`LDGRP`	Ledger group	`BKPF`	`LDGRP`
`XLGCLR`	Clearing specific to ledger groups	`BSEG`	`XLGCLR`
`CPUDT`	Entry date of the accounting document	`BKPF`	`CPUDT`
`TIMESTAMP`	UTC time stamp in short form (YYYYMMDDhhmmss)	`FAGLFLEXA`	`TIMESTAMP`
`.APPEND`	Public Sector fields for reading data of General Ledger line items
`MANDT`	Client		`*²`
`UPMOD`	BW delta procedure: Record mode		`*²`
`RRCTY`	Record type		`*²`
`RVERS`	Version		`*²`
`FISCVAR`	Fiscal year variant		`RBUKRS*¹`
`FISCPER`	Fiscal year/period	`BKPF`	`GJAHR¹ / MONAT¹`
`RFISCVAR`	Fiscal year variant		`RLDNR*¹`
`RFISCPER`	Fiscal year/period	`FAGLFLEXA`	`RYEAR¹ / POPER¹`
`KTOPL`	Chart of accounts		`RLDNR*¹`
`PS_POSID`	WBS elements	`BSEG`	`PROJK*¹`
`CURT2`	Currency type of the second local currency		`RLDNR*¹`
`CURT3`	Currency type of the third local currency		`RLDNR*¹`
`DMHAB`	Credit amount in local currency	`BSEG`	`DMBTR*¹`
`DMHA2`	Credit amount in second local currency	`BSEG`	`DMBE2*¹`
`DMHA3`	Credit amount in third local currency	`BSEG`	`DMBE3*¹`
`DMSOL`	Debit amount in local currency	`BSEG`	`DMBTR*¹`
`DMSO2`	Debit amount in second local currency	`BSEG`	`DMBE2*¹`
`DMSO3`	Debit amount in third local currency	`BSEG`	`DMBE3*¹`
`DMSH2`	Amount in second local currency with +/- sign	`BSEG`	`DMBE2*¹`
`DMSH3`	Amount in third local currency with +/- sign	`BSEG`	`DMBE3*¹`
`WRHAB`	Credit amount in document currency	`BSEG`	`WRBTR*¹`
`WRSOL`	Debit amount in document currency	`BSEG`	`WRBTR*¹`

Extractor Logic

Information on the “Field in the Origin Table”:

*¹: The values are determined from the specified fields.

*²: The values are determined from different sources.

Extraction method: F1 (function module (complete interface))

Extractor: FAGL_GET_SI_DATA

The extractor considers all data from the tables FAGLFLEXA (or similar customer tables), BKPF, BSEG, and BSEG_ADD.

Extraction structure: FAGLPOSBW