Accounts payable: Line items
Technical name: 0FI_AP_4
Based on DataSource: Accounts payable: Line items (0FI_AP_4
)
This InfoSource shows the line items in Accounts Payable Accounting from tables BSIK (open items) and BSAK (cleared items) in the SAP ERP source system.
This InfoSource replaces the former InfoSource 0FI_AP_3
. It provides an adapted extraction method (reads the tables directly rather than capturing the records during update). The communication structures of the former InfoSource 0FI_AP_3
and the new InfoSource 0FI_AP_4
are identical. As a result, the update rules for the data targets (ODS tables) can be kept. The migration from the former InfoSource, 0FI_AP_3
, to the new one, 0FI_AP_4
, is described in SAP note 410797
.
For more information about the extraction method, see Financials: Procedure for Line Item Extraction.
Special Features of the InfoSource
You can load the DataSources 0FI_GL_4
, 0FI_AR_4
, 0FI_AP_4
and 0FI_TX_4
in any order. Moreover, you can use the 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 SAP 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 operations, the data requirement in delta mode of leading DataSource 0FI_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-capable. However, due to the delta method used (“after-image delta”), it is not suited for reading InfoCubes. An ODS object serves as the data target to determine the changes to individual data records when loading the delta data sets.
Characteristics
InfoObject | Description | Data element | Field in Transfer Structure | Source |
|---|---|---|---|---|
Reconciliation account | SAKNR | SAKNR | BSIK-SAKNR | |
Clearing document number | AUGBL | AUGBL | BSIK-AUGBL | |
Base date for determining the due date | DZFBDT | ZFBDT | BSIK-ZFBDT | |
Document type | BLART | BLART | BSIK-BLART | |
Document Date | BLDAT | BLDAT | BSIK-BLDAT | |
Document number | BELNR_D | BELNR | BSIK-BELNR | |
Long Description | SGTXT | SGTXT | BSIK-SGTXT | |
Posting date in the document | BUDAT | BUDAT | BSIK-BUDAT | |
Company code | BUKRS | BUKRS | BSIK-BUKRS | |
Posting key | BSCHL | BSCHL | BSIK-BSCHL | |
Last dunning | MADAT | MADAT | BSIK-MADAT | |
Clearing date | AUGDT | AUGDT | BSIK-AUGDT | |
Date on which the record was added | CPUDT | CPUDT | BSIK-CPUDT | |
Reson code | RSTGR | RSTGR | BSIK-RSTGR | |
Due date item number | UPOSZ | UPOSZ | fixed `0001´ | |
Indicator: Original document archived | XARCH | XARCH | BSIK-XARCH | |
Chart of accounts | KTOPL | KTOPL | T001-KTOPL | |
Account type | KOART | KOART | fixed `K´ | |
Account number of subsidiary | FILKD | FILKD | BSIK-FILKD | |
Vendor | LIFNR | LIFNR | BSIK-LIFNR | |
Credit control area | KKBER | KKBER | BSIK-KKBER | |
Country key | LAND1 | LAND1 | T001-LAND1 | |
Dunning area | MABER | MABER | BSIK-MABER | |
Dunning key | MSCHL | MSCHL | BSIK-MSCHL | |
Dunning block | MANSP | MANSP | BSIK-MANSP | |
Dunning level | MAHNS_D | MANST | BSIK-MAHNS | |
Due date for net payment | NETDT | NETDT | Calculated | |
Document Item | BUZEI | BUZEI | BSIK-BUZEI | |
Item status | STATUSPS | STATUSPS | Calculated | |
Invoice year | REBZJ | REBZJ | BSIK-REBZJ | |
Invoice number | REBZG | REBZG | BSIK-REBZG | |
Invoice item | REBZZ | REBZZ | BSIK-REBZZ | |
Reference document number | XBLNR | XBLNR | BSIK-XBLNR | |
Reference key 1 | XREF1 | XREF1 | BSIK-XREF1 | |
Reference key 2 | XREF2 | XREF2 | BSIK-XREF2 | |
Reference key 3 | XREF3 | XREF3 | BSIK-XREF3 | |
Account number | SAKNR | HKONT | BSIK-HKONT | |
Key for payment block | DZLSPR | ZLSPR | BSIK-ZLSPR | |
Cash discount 1 due date | SK1DT | SK1DT | Calculated | |
Cash discount 2 due date | SK2DT | SK2DT | Calculated | |
Special general ledger indicator | UMSKZ | UMSKZ | BSIK-UMSKZ | |
Sales document | VBELN | VBELN | BSIK-VBELN | |
Payment terms key | DZTERM | ZTERM | BSIK-ZTERM | |
Payment method | DZLSCH | ZLSCH | BSIK-ZLSCH | |
BW delta method: Update mode | RODMUPDMOD | UPDMOD | Fixed ' ' |
Time Characteristics
InfoObject | Description | Data element | Field in Transfer Structure | Source |
|---|---|---|---|---|
Fiscal Year / Period | RSFISCPER | FISCPER | BSIK-GJAHR BSIK-MONAT | |
Fiscal Year Variant | RSFISCVAR | FISCVAR | T001-PERIV |
Units
InfoObject | Description | Data element | Field in Transfer Structure | Source |
|---|---|---|---|---|
Local currency | LCURR | LCURR | T001-WAERS | |
Document Currency | WAERS | WAERS | BSIK-WAERS |
Key figures
InfoObject | Description | Data element | Field in Transfer Structure | Source |
|---|---|---|---|---|
Amount in foreign currency | WRSHB | WRSHB | Calculated | |
Amount in local currency | DMSHB | DMSHB | Calculated | |
Term for net conditions | DZBD3T | ZBD3T | BSIK-ZBD3T | |
Credit amount in foreign currency | WRHAB | WRHAB | Calculated | |
Credit amount in local currency | DMHAB | DMHAB | Calculated | |
Cash discount percentage 1 | DZBD1P | ZBD1P | BSIK-ZBD1P | |
Cash discount days 1 | DZBD1T | ZBD1T | BSIK-ZBD1T | |
Cash discount percentage 2 | DZBD2P | ZBD2P | BSIK-ZBD2P | |
Cash discount days 2 | DZBD2T | ZBD2T | BSIK-ZBD2T | |
Cash discount amount | WSKTO | WSKTO | BSIK- WSKTO | |
Cash discount amount | SKNTO | SKNTO | BSIK- SKNTO | |
Cash discount base | SKFBT | SKFBT | BSIK- SKFBT | |
Dedit amount in foreign currency | WRSOL | WRSOL | Calculated | |
Debit amount in local currency | DMSOL | DMSOL | Calculated |