Accounts Receivable: Line Items

Technical name: 0FI_AR_3

Note Note

Since Release 3.0A (BW PlugIn 2001.1), BW offers consistent data extraction to the BW system in the Delta update procedure for line items from General Ledger Accounting (FI-GL), Accounts Receivable Accounting and Accounts Payable Accounting (FI-AP).

For information on how to start using this new procedure, see OSS note 410797. This explains how to convert from using the old extraction procedure (DataSources 0FI_AP_3 and 0FI_AR_3) to the new one (DataSources 0FI_GL_4, 0FI_AP_4 and 0FI_AR_4).

As a prerequisite for using this note, you must have been using the old DataSources (FI_AP_3 and FI_AR_3) and intend to replace them with the new ones (0FI_GL_4, 0FI_AP_4 and 0FI_AR_4).

End of the note.

Characteristics

InfoObject	Description	Data Element	Field in transfer structure	Source
0RC_ACCOUNT	Reconciliation account	SAKNR	SAKNR	BSID-SAKNR
0CLR_DOC_NO	Clearing document number	AUGBL	AUGBL	BSID-AUGBL
0BLINE_DATE	Baseline date for due date calculation	DZFBDT	ZFBDT	BSID-ZFBDT
0AC_DOC_TYP	Document type	BLART	BLART	BSID-BLART
0DOC_DATE	Document date	BLDAT	BLDAT	BSID-BLDAT
0AC_DOC_NO	Document number	BELNR_D	BELNR	BSID-BLNR
0TXTLG	Description (long)	SGTXT	SGTXT	BSID-SGTXT
0PSTNG_DATE	Posting date in the document	BUDAT	BUDAT	BSID-BUDAT
0COMP_CODE	Company code	BUKRS	BUKRS	BSID-BUKRS
0POST_KEY	Posting key	BSCHL	BSCHL	BSID-BSCHL
0LAST_DUNN	Last dunning date	MADAT	MADAT	BSID-MADAT
0CLEAR_DATE	Clearing date	AUGDT	AUGDT	BSID- AUGDT
0CREATEDON	Date the record was created	CPUDT	CPUDT	BSID-CPUDT
0REASON_CDE	Reason code	RSTGR	RSTGR	BSID-RSTGR
0FI_DSBITEM	Due date item number	UPOSZ	UPOSZ	BSID-UPOSZ
0FI_XARCH	Indicator: Original document archived	XARCH	XARCH	BSID-XARCH
0CHRT_ACCTS	Chart of accounts	KTOPL	KTOPL	T001-KTOPL
0ACCT_TYPE	Account type	KOART	KOART	fix `D´
0FI_SUBSID	Branch account number	FILKD	FILKD	BSID-FILKD
0DEBITOR	Customer	KUNNR	KUNNR	BSID-KUNNR
0C_CTR_AREA	Credit control area	KKBER	KKBER	BSID-KKBER
0COUNTRY	Country key	LAND1	LAND1	T001-LAND1
0DUNN_AREA	Dunning area	MABER	MABER	BSID-MABER
0DUNN_KEY	Dunning key	MSCHL	MSCHL	BSID-MSCHL
0DUNN_BLOCK	Dunning block	MANSP	MANSP	BSID-MANSP
0DUNN_LEVEL	Dunning level	MAHNS_D	MANST	BSID-MAHNS
0NETDUEDATE	Due date for net payment	NETDT	NETDT	calculated
0ITEM_NUM	Line item	BUZEI	BUZEI	BSID-BUZEI
0FI_DOCSTAT	Item status	STATUSPS	STATUSPS	calculated
0INV_YEAR	Invoice year	REBZJ	REBZJ	BSID-REBZJ
0INV_DOC_NO	Invoice number	REBZG	REBZG	BSID-REBZG
0INV_ITEM	Invoice item	REBZZ	REBZZ	BSID-REBZZ
0REF_DOC_NO	Reference document number	XBLNR	XBLNR	BSID-XBLNR
0REF_KEY1	Reference key 1	XREF1	XREF1	BSID-XREF1
0REF_KEY2	Reference key 2	XREF2	XREF2	BSID-XREF2
0REF_KEY3	Reference key 3	XREF3	XREF3	BSID-XREF3
0GL_ACCOUNT	Account number	SAKNR	HKONT	BSID-HKONT
0PMNT_BLOCK	Payment block key	DZLSPR	ZLSPR	BSID-ZLSPR
0DSCT_DATE1	Due date for cash discount 1	SK1DT	SK1DT	calculated
0DSCT_DATE2	Due date for cash discount 2	SK2DT	SK2DT	calculated
0SP_GL_IND	Special G/L indicator	UMSKZ	UMSKZ	BSID-UMSKZ
0DOC_NUMBER	Sales document	VBELN	VBELN	BSID-VBELN
0PMNTTRMS	Terms of payment key	DZTERM	ZTERM	BSID-ZTERM
0PYMT_METH	Payment method	DZLSCH	ZLSCH	BSID-ZLSCH

Time Characteristics

InfoObject

Description

Data Element

Field in Transfer Structure

Source

0FISCPER

Fiscal year/period

RSFISCPER

FISCPER

BSID-GJAHR

BSID-MONAT

0FISCVARNT

Fiscal year variant

RSFISCVAR

FISCVAR

T001 - PERIV

Units

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0LOC_CURRCY	Local currency	LCURR	LCURR	T001-WAERS
0DOC_CURRCY	Document currency	WAERS	WAERS	BSID-WAERS

Key Figures

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0DEB_CRE_DC	Amount in foreign currency	WRSHB	WRSHB	calculated
0DEB_CRE_LC	Amount in local currency	DMSHB	DMSHB	calculated
0NETTERMS	Net payment terms period	DZBD3T	ZBD3T	BSID-ZBD3T
0CREDIT_DC	Credit amount in foreign currency	WRHAB	WRHAB	calculated
0CREDIT_LC	Credit amount in local currency	DMHAB	DMHAB	calculated
0DSCT_PCT1	Cash discount percentage 1	DZBD1P	ZBD1P	BSID-ZBD1P
0DSCT_DAYS1	Cash discount days 1	DZBD1T	ZBD1T	BSID-ZBD1T
0DSCT_PCT2	Cash discount percentage 2	DZBD2P	ZBD2P	BSID-ZBD2P
0DSCT_DAYS2	Cash discount days 2	DZBD2T	ZBD2T	BSID-ZBD2T
0DSC_AMT_DC	Cash discount amount	WSKTO	WSKTO	BSID- WSKTO
0DSC_AMT_LC	Cash discount amount	SKNTO	SKNTO	BSID- SKNTO
0DISC_BASE	Cash disc. base	SKFBT	SKFBT	BSID- SKFBT
0DEBIT_DC	Debit amount in foreign currency	WRSOL	WRSOL	calculated
0DEBIT_LC	Debit amount in local currency	DMSOL	DMSOL	calculated

Other Fields

InfoObject	Description	Data Element	Field in Transfer Structure	Source
0RECORDMODE	BW delta procedure: Update mode	RODMUPDMOD	UPDMOD	fix ' '