Accounts Receivable: Line Items 
Accounts Receivable: Line Items
Technical name: 0FI_AR_3
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).
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 ' ' |