This DataSource provides the line items in General Ledger Accounting from tables BKPF, BSEG, FAGLFLEXA, .BSIS, BSAS, BSID, BSAD; BSIK, BSAK, FAGLBSIS, FAGLBSAS and VBSEGS. Line items can be requested in the general ledger view and in the entry view. Which view is applied depends on the ledger selected: Enter the desired ledger for the general ledger view, and enter a restriction to the initial value for the entry view (RLDNR = '').
Application Component | General Ledger Accounting (FI-GL) |
|---|---|
Available as of Release | SAP enhancement package 3 for SAP ERP 6.0, business function Reporting Financials (FIN_REP_SIMPL_1) |
Shipment | SAP NetWeaver 7.0 BI Content Add-On 3 Support Package 08 |
Content Versions | 603 |
RemoteCube-Capable | Yes |
Delta-Capable | No |
Extraction from Archives | Yes |
Verifiable | No |
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 |
|
ANLN2 |
Asset subnumber - new, four-digit |
BSEG |
|
AUFNR |
Order number |
BSEG |
|
AUGBL |
Clearing document number |
BSEG |
|
AUGDT |
Clearing date |
BSEG |
|
BELNR |
Accounting document number |
BSEG |
|
BLART |
Document type |
BSEG |
|
BLDAT |
Document date in document |
BSEG |
|
BSCHL |
Posting key |
BSEG |
|
BSTAT |
Document status |
BSEG |
|
BUDAT |
Posting date in document |
BSEG |
|
BUKRS |
Company code |
BSEG |
|
BUZEI |
Number of the line item within the accounting document |
BSEG |
|
DMSHB |
Amount in local currency with +/- sign |
BSEG |
|
HWAER |
Local currency |
BSEG |
|
HWAE2 |
Currency key of the second local currency |
BSEG |
|
HWAE3 |
Currency key of the third local currency |
BSEG |
|
EBELN |
Purchasing document number |
BSEG |
|
EBELP |
Item number of purchasing document |
BSEG |
|
ETEN2 |
Schedule number |
BSEG |
|
FAEDT |
Net due date |
BSEG |
|
FILKD |
Branch account number |
BSEG |
|
GJAHR |
Fiscal year |
BSEG |
|
GSBER |
Business area |
BSEG |
|
KOART |
Account type |
BSEG |
|
KONTO |
Account number |
BSEG |
|
KOSTL |
Cost center |
BSEG |
|
MABER |
Dunning area |
BSEG |
|
MADAT |
Date of last dunning notice |
BSEG |
|
MANSP |
Dunning lock |
BSEG |
|
MANST |
Dunning level |
BSEG |
|
MONAT |
Fiscal period |
BSEG |
|
MSCHL |
Dunning key |
BSEG |
|
MWSKZ |
Tax on sales/purchases code |
BSEG |
|
POSN2 |
Sales document item |
BSEG |
|
PRCTR |
Profit center |
BSEG |
|
QBSHB |
Withholding tax amount in document currency |
BSEG |
|
QSFBT |
Withholding tax exempt amount in document currency |
BSEG |
|
QSSHB |
Withholding tax base amount in document currency |
BSEG |
|
REBZG |
Document number of the invoice to which the transaction belongs |
BSEG |
|
SAMNR |
Invoice list number |
BSEG |
|
SGTXT |
Item text |
BSEG |
|
SHKZG |
Debit/credit indicator |
BSEG |
|
SKFBT |
Amount eligible for cash discount in document currency |
BSEG |
|
WSKTO |
Cash discount amount in document currency |
BSEG |
|
SKNTO |
Cash discount amount in local currency |
BSEG |
|
STAKZ |
Indicator: Statistical document? |
BSEG |
|
UMSKS |
Transaction class special general ledger |
BSEG |
|
UMSKZ |
Special G/L indicator |
BSEG |
|
UZAWE |
Additional payment method |
BSEG |
|
VALUT |
Value date |
BSEG |
|
VBEL2 |
Sales document |
BSEG |
|
VBELN |
Billing |
BSEG |
|
VBEWA |
Flow type |
BSEG |
|
VBUND |
Company ID of trading partner |
BSEG |
|
VERTN |
Contract Number |
BSEG |
|
VERTT |
Contract type |
BSEG |
|
VERZ1 |
Days in arrears according to cash discount terms 1 |
BSEG |
|
VERZN |
Days in arrears according to due date for net payment |
BSEG |
|
WERKS |
Plant |
BSEG |
|
WRSHB |
Amount in document currency (foreign currency) |
BSEG |
|
WAERS |
Document currency (key) |
BSEG |
|
WVERW |
Type of bill of exchange usage |
BSEG |
|
XBLNR |
Reference document number |
BSEG |
|
XSTRP |
Indicator: Disputed item? |
BSEG |
|
ZALDT |
Expected payment date (cash discount-1 due) |
BSEG |
|
ZBD1P |
Cash discount percentage 1 |
BSEG |
|
ZBD1T |
Cash discount days 1 |
BSEG |
|
ZBD2P |
Cash discount percentage 2 |
BSEG |
|
ZBD2T |
Cash discount days 2 |
BSEG |
|
ZBD3T |
Deadline for terms of payment net |
BSEG |
|
ZFBDT |
Baseline date for due date calculation |
BSEG |
|
ZINSZ |
Interest calculation numerator (days in arrears * amount) |
BSEG |
|
ZLSCH |
Payment method |
BSEG |
|
ZLSPR |
Payment lock key |
BSEG |
|
ZTERM |
Terms of payment key |
BSEG |
|
ZUONR |
Assignment number |
BSEG |
|
XREF1 |
Reference key of the business partner |
BSEG |
|
XREF2 |
Reference key of the business partner |
BSEG |
|
RSTGR |
Reason code for payments |
BSEG |
|
ASKTO |
Current cash discount amount in document currency |
BSEG |
|
KURSE |
Effective exchange rate in line item |
BSEG |
|
REBZT |
Type of follow-on document |
BSEG |
|
PSWSL |
Update currency for general ledger transaction figures |
BSEG |
|
PSWBT |
Amount for general ledger update (absolute) |
BSEG |
|
HKONT |
G/L account in General Ledger Accounting |
BSEG |
|
XNEGP |
Indicator: Negative posting |
BSEG |
|
ZBFIX |
Fixed payment condition |
BSEG |
|
RFZEI |
Payment card item |
BSEG |
|
CCBTC |
Payment cards: Settlement run |
BSEG |
|
KKBER |
Credit control area |
BSEG |
|
XREF3 |
Reference key for the document items |
BSEG |
|
DTWS1 |
Instruction 1 |
BSEG |
|
DTWS2 |
Instruction 2 |
BSEG |
|
DTWS3 |
Instruction 3 |
BSEG |
|
DTWS4 |
Instruction 4 |
BSEG |
|
ABSBT |
Credit Management: Guaranteed amount (absolute) |
BSEG |
|
PROJK |
WBS element in external format |
BSEG |
|
XPYPR |
Indicator: Payment order exists for this item |
BSEG |
|
KIDNO |
Payment reference |
BSEG |
|
BUPLA |
Business place |
BSEG |
|
SECCO |
Withholding tax section |
BSEG |
|
PYCUR |
Currency for automatic payment |
BSEG |
|
PYAMT |
Amount in currency for automatic payment (absolute) |
BSEG |
|
PYORD |
Payment order |
BSEG |
|
XRAGL |
Indicator: Clearing was undone |
BSEG |
|
CESSION_KZ |
Accounts receivable pledging indicator |
BSEG |
|
BUZID |
Identification of posting line |
BSEG |
|
AUGGJ |
Fiscal year of clearing document |
BSEG |
|
AGZEI |
Clearing item |
BSEG |
|
AWSYS |
Logical system |
BSEG |
|
AWTYP |
Reference transaction |
BSEG |
|
BDIFF |
Valuation difference |
BSEG |
|
BDIF2 |
Valuation difference for the second local currency |
BSEG |
|
BDIF3 |
Valuation difference for the third local currency |
BSEG |
|
BEWAR |
Flow type |
BSEG |
|
DABRZ |
Asset value date for billing |
BSEG |
|
DMBTR |
Amount in local currency |
BSEG |
|
DOCNR |
Document number of general ledger document |
FAGLFLEXA |
|
DOCLN |
Six-digit line item for ledger |
FAGLFLEXA |
|
FKBER_LONG |
Functional area |
BSEG |
|
GLVOR |
Business transaction |
BSEG |
|
IMKEY |
Internal key for Real Estate object |
BSEG |
|
KOKRS |
Controlling area |
BSEG |
|
KSTAR |
Cost element |
BSEG |
|
KUNNR |
Customer number 1 |
BSEG |
|
LIFNR |
Account number of vendor |
BSEG |
|
MEINS |
Base unit of measure |
BSEG |
|
MENGE |
Quantity |
BSEG |
|
PARGB |
Business area of the business partner |
BSEG |
|
PFKBER |
Functional area of partner |
BSEG |
|
PKOSTL |
Partner cost center |
BSEG |
|
POPER |
Posting period |
FAGLFLEXA |
|
PPRCT |
Partner profit center |
BSEG |
|
PSEGMENT |
Partner segment for segment reporting |
BSEG |
|
PS_PSP_PNR |
WBS elements |
BSEG |
|
RLDNR |
Ledger |
FAGLFLEXA |
|
RYEAR |
Fiscal year of the general ledger |
FAGLFLEXA |
|
SAKNR |
G/L account number |
BSEG |
|
SEGMENT |
Segment for segment reporting |
BSEG |
|
XOPVW |
Indicator: Open Item Management? |
BSEG |
|
LDGRP |
Ledger group |
BSEG |
|
XLGCLR |
Clearing specific to ledger groups |
BSEG |
|
AWKEY |
Reference key |
BSEG |
|
CPUDT |
Entry date of the accounting document |
BSEG |
|
UPMOD |
BW delta procedure: Record mode |
BSEG |
|
RRCTY |
Record type |
BSEG |
|
RVERS |
Version |
BSEG |
|
FISCVAR |
Fiscal year variant |
BSEG |
|
RFISCVAR |
Fiscal year variant |
FAGLFLEXA |
|
RFISCPER |
Fiscal year/period |
FAGLFLEXA |
|
KTOPL |
Chart of accounts |
BSEG |
|
PS_POSID |
WBS elements |
BSEG |
|
CURT2 |
Currency type of the second local currency |
BSEG |
|
CURT3 |
Currency type of the third local currency |
BSEG |
|
DMHAB |
Credit amount in local currency |
BSEG |
|
DMHA2 |
Credit amount in second local currency |
BSEG |
|
DMHA3 |
Credit amount in third local currency |
BSEG |
|
DMSOL |
Debit amount in local currency |
BSEG |
|
DMSO2 |
Debit amount in second local currency |
BSEG |
|
DMSO3 |
Debit amount in third local currency |
BSEG |
|
DMSH2 |
Amount in second local currency with +/- sign |
BSEG |
|
DMSH3 |
Amount in third local currency with +/- sign |
BSEG |
|
WRHAB |
Credit amount in document currency |
BSEG |
|
WRSOL |
Debit amount in document currency |
BSEG |
|
AUGST |
Clearing status of the line item |
BSEG |
|
BSTAT_S |
Document status |
BSEG |
|
BWSHB |
Valuated amount in local currency with +/- sign |
BSEG |
|
BWSH2 |
Valuated amount in second local currency with +/- sign |
BSEG |
|
BWSH3 |
Valuated amount in third currency with +/- sign |
BSEG |
|
USNAM |
Name of user |
BKPF |
|
STBLG |
Document number of reversal document |
BKPF |
|
STJAH |
Fiscal year of the reversal document |
BKPF |
|
BKTXT |
Document header text |
BKPF |
|
KOTXT |
Account Name |
BSEG |
In the entry view, the values of characteristics DOCNR, DOCLN, RFISCVAR, RYEAR and POPER are not defined because no posting has been made to a ledger in General Ledger Accounting. To simplify the analysis in this case, the values are taken from the corresponding fields in the entry view (DOCNR from BELNR, DOCLN from BUZEI, RFISCVAR from FISCVAR, RYEAR from GJAHR, and POPER from MONAT). Accordingly, restrictions on the general ledger-specific characteristics are interpreted as restrictions on the corresponding entry characteristics when the data is read in the entry view.
The DataSource can read open items. To restrict the selection to customer accounts, vendor accounts, or G/L accounts, you can use the characteristic Account Type (KOART). For the key date selection, you can use the characteristics Clearing Status (AUGST), Clearing Date (AUGDT), and Posting Date (BUDAT).
The DataSource can also read line item that have not yet been posted (such as noted items). To restrict the selection to items with a specific status, you can use the characteristic Document Status (BSTAT_S).