Customer Line Items

DataSource Transactional Data: 0FI_AR_30

This DataSource provides customer line items (tables BSID (open items) and BSAD (cleared items) of subledger accounting.

Technical Data

Application Component	Financial Accounting: Customers (FI-AR)
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	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Delta Update

After Images via delta queue (for example, FI-AP/AR)

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
`BUKRS`	Company code	`BSID, BSAD`	`BUKRS`
`FISCPER`	Fiscal year/period	`BSID, BSAD`	`GJAHR / MONAT`
`BELNR`	Accounting document number	`BSID, BSAD`	`BELNR`
`BUZEI`	Number of the line item within the accounting document	`BSID, BSAD`	`BUZEI`
`UPOSZ`	Subitem number	`-`	`= 0001`
`STATUSPS`	Status of FI item	`BSID, BSAD`	`BSTAT, AUGDT`
`KUNNR`	Customer number 1	`BSID, BSAD`	`KUNNR`
`KKBER`	Credit control area	`BSID, BSAD, T001`	`BSID-KKBER, BSAD-KKBER, T001-KKBER`
`MABER`	Dunning area	`BSID, BSAD`	`MABER`
`KOART`	Account type	`-`	`= K`
`UMSKZ`	Special G/L indicator	`BSID, BSAD`	`UMSKZ`
`BLART`	Document type	`BSID, BSAD`	`BLART`
`BSCHL`	Posting key	`BSID, BSAD`	`BSCHL`
`FISCVAR`	Fiscal year variant	`T001`	`PERIV`
`BLDAT`	Document date in document	`BSID, BSAD`	`BLDAT`
`BUDAT`	Posting date in document	`BSID, BSAD`	`BUDAT`
`CPUDT`	Entry date of the accounting document	`BSID, BSAD`	`CPUDT`
`AUGDT`	Clearing date	`BSID, BSAD`	`AUGDT`
`MADAT`	Date of last dunning notice	`BSID, BSAD`	`MADAT`
`NETDT`	Net due date	`BSID, BSAD`	`*¹`
`SK1DT`	Due date according to cash discount terms 1	`BSID, BSAD`	`*¹`
`SK2DT`	Due date according to cash discount terms 2	`BSID, BSAD`	`*¹`
`ZFBDT`	Baseline date for due date calculation	`BSID, BSAD`	`ZFBDT`
`ZBD1T`	Cash discount days 1	`BSID, BSAD`	`ZBD1T`
`ZBD2T`	Cash discount days 2	`BSID, BSAD`	`ZBD2T`
`ZBD3T`	Deadline for terms of payment net	`BSID, BSAD`	`ZBD3T`
`ZBD1P`	Cash discount percentage 1	`BSID, BSAD`	`ZBD1P`
`ZBD2P`	Cash discount percentage 2	`BSID, BSAD`	`ZBD2P`
`LAND1`	Country key	`T001`	`LAND1`
`ZLSCH`	Payment method	`BSID, BSAD`	`ZLSCH`
`ZTERM`	Terms of payment key	`BSID, BSAD`	`ZTERM`
`ZLSPR`	Payment lock key	`BSID, BSAD`	`ZLSPR`
`RSTGR`	Reason code for payments	`BSID, BSAD`	`RSTGR`
`MANSP`	Dunning lock	`BSID, BSAD`	`MANSP`
`MSCHL`	Dunning key	`BSID, BSAD`	`MSCHL`
`MANST`	Dunning level	`BSID, BSAD`	`MANST`
`LCURR`	Currency key of the local currency	`T001`	`WAERS`
`DMSOL`	Debit amount in local currency	`BSID, BSAD`	`SHKZG, DMBTR`
`DMHAB`	Credit amount in local currency	`BSID, BSAD`	`SHKZG, DMBTR`
`DMSHB`	Amount in local currency with +/- sign	`BSID, BSAD`	`SHKZG, DMBTR`
`SKNTO`	Cash discount amount in local currency	`BSID, BSAD`	`SKNTO`
`WAERS`	Currency key	`BSID, BSAD`	`WAERS`
`WRSOL`	Debit amount in document currency	`BSID, BSAD`	`SHKZG, WRBTR`
`WRHAB`	Credit amount in document currency	`BSID, BSAD`	`SHKZG, WRBTR`
`WRSHB`	Foreign currency amount (+/-)	`BSID, BSAD`	`SHKZG, WRBTR`
`SKFBT`	Amount eligible for cash discount in document currency	`BSID, BSAD`	`SKFBT`
`WSKTO`	Cash discount amount in document currency	`BSID, BSAD`	`WSKTO`
`KTOPL`	Chart of accounts	`T001`	`KTOPL`
`HKONT`	G/L account in general ledger accounting	`BSID, BSAD`	`HKONT`
`SAKNR`	G/L account number	`BSID, BSAD`	`SAKNR`
`FILKD`	Branch account number	`BSID, BSAD`	`FILKD`
`AUGBL`	Clearing document number	`BSID, BSAD`	`AUGBL`
`XBLNR`	Reference document number	`BSID, BSAD`	`XBLNR`
`REBZG`	Document number of the invoice to which the transaction belongs	`BSID, BSAD`	`REBZG`
`REBZJ`	Fiscal year of corresponding invoice (for credit memo)	`BSID, BSAD`	`REBZJ`
`REBZZ`	Posting item in the relevant invoice	`BSID, BSAD`	`REBZZ`
`VBELN`	Sales document number
`XREF1`	Reference key of the business partner	`BSID, BSAD`	`XREF1`
`XREF2`	Reference key of the business partner	`BSID, BSAD`	`XREF2`
`XREF3`	Reference key for the document items	`BSID, BSAD`	`XREF3`
`SGTXT`	Item text	`BSID, BSAD`	`SGTXT`
`XNEGP`	Indicator: Negative posting	`BSID, BSAD`	`XNEGP`
`XARCH`	Indicator: Amount already in archive?	`BSID, BSAD`	`XARCH`
`UMSKS`	Transaction class special general ledger	`BSID, BSAD`	`UMSKS`
`UPDMOD`	BW delta procedure: Record mode	`-`	`-`
`ZUONR`	Assignment number	`BSID, BSAD`	`ZUONR`
`AWTYP`	Reference transaction
`AWKEY`	Reference key
`BSTAT`	Document status	`BSID, BSAD`	`BSTAT`
`DMBTR`	Amount in local currency	`BSID, BSAD`	`DMBTR`
`DMBE2`	Amount in second local currency	`BSID, BSAD`	`DMBE2`
`DMBE3`	Amount in third local currency	`BSID, BSAD`	`DMBE3`
`GJAHR`	Fiscal year	`BSID, BSAD`	`GJAHR`
`HWAE2`	Currency key of the second local currency
`HWAE3`	Currency key of the third local currency
`MONAT`	Fiscal period	`BSID, BSAD`	`MONAT`
`PROJK`	WBS elements	`BSID, BSAD`	`PROJK`
`SHKZG`	Debit/credit indicator	`BSID, BSAD`	`SHKZG`
`WRBTR`	Amount in document currency	`BSID, BSAD`	`WRBTR`

Extractor Logic

Information on the “Field in the Table of Origin”:

*¹: The extract structure fields for the due date for net payment (NETDT, SK1DT, SK2DT) are mapped using the function module DETERMINE_DUE_DATE from the fields ZFBDT, ZBD1T, ZBD2T, ZBD3T, BLDAT, KOART, REBZG, REBZT, SHKZG of tables BSID and BSAD.

For more information, see section “Features of Extractor” in the documentation for the DataSource Customers: Line items (0FI_AR_4).