Accounts Payable: Line Items

Technical name: 0FI_AP_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	BSIK-SAKNR
0CLR_DOC_NO	Clearing document number	AUGBL	AUGBL	BSIK-AUGBL
0BLINE_DATE	Baseline date for due date calculation	DZFBDT	ZFBDT	BSIK-ZFBDT
0AC_DOC_TYP	Document type	BLART	BLART	BSIK-BLART
0DOC_DATE	Receipt date	BLDAT	BLDAT	BSIK-BLDAT
0AC_DOC_NO	Document number	BELNR_D	BELNR	BSIK-BELNR
0TXTLG	Description (long)	SGTXT	SGTXT	BSIK-SGTXT
0PSTNG_DATE	Posting date in the document	BUDAT	BUDAT	BSIK-BUDAT
0COMP_CODE	Company code	BUKRS	BUKRS	BSIK-BUKRS
0POST_KEY	Posting key	BSCHL	BSCHL	BSIK-BSCHL
0LAST_DUNN	Last dunned	MADAT	MADAT	BSIK-MADAT
0CLEAR_DATE	Clearing date	AUGDT	AUGDT	BSIK-AUGDT
0CREATEDON	Date the record was created	CPUDT	CPUDT	BSIK-CPUDT
0REASON_CDE	Reason code	RSTGR	RSTGR	BSIK-RSTGR
0FI_DSBITEM	Due date item number	UPOSZ	UPOSZ	BSIK-UPOSZ
0FI_XARCH	Indicator: Original document archived	XARCH	XARCH	BSIK-XARCH
0CHRT_ACCTS	Chart of accounts	KTOPL	KTOPL	T001-KTOPL
0ACCT_TYPE	Account type	KOART	KOART	fix `K´
0FI_SUBSID	Branch account number	FILKD	FILKD	BSIK-FILKD
0CREDITOR	Vendor	LIFNR	LIFNR	BSIK-LIFNR
0C_CTR_AREA	Credit control area	KKBER	KKBER	BSIK-KKBER
0COUNTRY	Country key	LAND1	LAND1	T001-LAND1
0DUNN_AREA	Dunning area	MABER	MABER	BSIK-MABER
0DUNN_KEY	Dunning key	MSCHL	MSCHL	BSIK-MSCHL
0DUNN_BLOCK	Dunning block	MANSP	MANSP	BSIK-MANSP
0DUNN_LEVEL	Dunning level	MAHNS_D	MANST	BSIK-MAHNS
0NETDUEDATE	Due date for net payment	NETDT	NETDT	calculated
0ITEM_NUM	Line item	BUZEI	BUZEI	BSIK-BUZEI
0FI_DOCSTAT	Item status	STATUSPS	STATUSPS	calculated
0INV_YEAR	Invoice year	REBZJ	REBZJ	BSIK-REBZJ
0INV_DOC_NO	Invoice number	REBZG	REBZG	BSIK-REBZG
0INV_ITEM	Invoice item	REBZZ	REBZZ	BSIK-REBZZ
0REF_DOC_NO	Reference document number	XBLNR	XBLNR	BSIK-XBLNR
0REF_KEY1	Reference key 1	XREF1	XREF1	BSIK-XREF1
0REF_KEY2	Reference key 2	XREF2	XREF2	BSIK-XREF2
0REF_KEY3	Reference key 3	XREF3	XREF3	BSIK-XREF3
0GL_ACCOUNT	Account number	SAKNR	HKONT	BSIK-HKONT
0PMNT_BLOCK	Payment block key	DZLSPR	ZLSPR	BSIK-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	BSIK-UMSKZ
0DOC_NUMBER	Sales document	VBELN	VBELN	BSIK-VBELN
0PMNTTRMS	Terms of payment key	DZTERM	ZTERM	BSIK-ZTERM
0PYMT_METH	Payment method	DZLSCH	ZLSCH	BSIK-ZLSCH

Time Characteristics

InfoObject

Description

Data Element

Field in Transfer Structure

Source

0FISCPER

Fiscal year/period

RSFISCPER

FISCPER

BSIK-GJAHR

BSIK-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	BSIK-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	BSIK-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	BSIK-ZBD1P
0DSCT_DAYS1	Cash discount days 1	DZBD1T	ZBD1T	BSIK-ZBD1T
0DSCT_PCT2	Cash discount percentage 2	DZBD2P	ZBD2P	BSIK-ZBD2P
0DSCT_DAYS2	Cash discount days 2	DZBD2T	ZBD2T	BSIK-ZBD2T
0DSC_AMT_DC	Cash discount amount	WSKTO	WSKTO	BSIK-WSKTO
0DSC_AMT_LC	Cash discount amount	SKNTO	SKNTO	BSIK- SKNTO
0DISC_BASE	Cash disc. base	SKFBT	SKFBT	BSIK-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 ' '