Accounts Receivable: Line Items (SAP Library - Customer / Vendor Analysis)

Accounts Receivable: Line Items

Technical name: 0FI_AR_4

Based on DataSource: 0FI_AR_4

Use

This DataSource provides Accounts Receivable Accounting line items from tables BSID (open items) and BSAD (cleared items) in the R/3 source system.

InfoSource 0FI_AR_4 replaces InfoSource 0FI_AR_3. It provides a modified extraction procedure (direct accessing of tables instead of accessing the records when updating). The communication structures of old InfoSource 0FI_AR_3 and new InfoSource 0FI_AR_4 are identical. This means that the updating rules for data targets (ODS tables) can be maintained. The migration from InfoSource 0FI_AR_3 to InfoSource 0FI_AR_4 is described in note 410797.

Here, you can find a detailed description of the extraction procedure.

Features of the InfoSource

As of PlugIn2002.2, it is no longer necessary to have DataSources linked. This means that you can now load 0FI_GL_4, 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 in any order. You also have the option of using DataSources 0FI_AR_4, 0FI_AP_4 and 0FI_TX_4 separately without 0FI_GL_4. The DataSources can then be used independently of one another (see note 551044).

Note

As soon as DataSource 0FI_GL_4 is loaded, it is the leading DataSource with regard to the time limits – such as maximum time (CPU date) – up to which data extraction is allowed.
Therefore, when the transition is made from having data requirements in Delta Init mode to having them in pure Delta operation, the data requirement in delta mode of leading DataSource (OFI_GL_4) must be processed first.

Linking of DataSources in the delta helps to ensure consistent extraction of FI data with regard to time limits. Consistency with regard to the data extracted has to be ensured via the init selection criteria.

Note

This InfoSource is delta-compatible. However, due to the Delta procedure used (after image Delta) it is not suitable for loading InfoCubes directly. An ODS object can be used as data target in order to identify the changes made to individual InfoObjects when loading Delta data.

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 Number	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
0RECORDMODE	BW delta procedure: update mode	RODMUPDMOD	UPDMOD	fix ' '

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