Show TOC

General Ledger Accounting: Line Items Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 0FI_GL_40

 

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 = '').

Technical Data

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

Data Modeling

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

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

Extractor Logic

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).