Accounts Payable

Accounts Payable Infocube ZFIAP_C03: FIAP: Line items BW Infoobject

BW Infoobject description

0CREDITOR

Account number of supplier/vendor

0FI_SUBSID

Account Number of the Branch

0ACCT_TYPE

Account type

ZACCUMBAL

Accumulated Balance in LC

0DEB_CRE_DC

Amount in document currency

0DEB_CRE_LC

Amount in local currency

0BLINE_DATE

Baseline Date For Due Date Calculation

0BUS_AREA

Business area

0CALDAY

Calendar Day

0CALYEAR

Calendar Year

0CALMONTH

Calendar Year/Month

0CALQUARTER

Calendar Year/Quarter

0CALWEEK

Calendar Year/Week

0DSC_AMT_DC

Cash discount amount in document currency

0DSC_AMT_LC

Cash discount amount in local currency

0DISC_BASE

Cash discount base in document currency

0CHRT_ACCTS

Chart of accounts

0CLEAR_DATE

Clearing date

0COMP_CODE

Company code

0COUNTRY

Country key

0CREDIT_DC

Credit amount in document currency

0CREDIT_LC

Credit amount in local currency

0DSCT_DAYS1

Days for First Cash Discount

0DSCT_DAYS2

Days for Second Cash Discount

0NETTERMS

Deadline for net conditions

0DEBIT_DC

Debit amount in document currency

0DEBIT_LC

Debit amount in local currency

0DOC_DATE

Document Date

0AC_DOC_TYP

Document type

0DSCT_DATE1

Due date for cash discount 1

0DSCT_DATE2

Due date for cash discount 2

0NETDUEDATE

Due date for net payment

0FI_DSBITEM

Due Date Item Number

0FISCYEAR

Fiscal year

0FISCPER

Fiscal year / period

0FISCVARNT

Fiscal year variant

0GL_ACCOUNT

G/L Account

0FI_DOCSTAT

Item Status

0PMNT_BLOCK

Payment block key

0PYMT_METH

Payment method

0DSCT_PCT1

Percentage for first cash discount

0DSCT_PCT2

Percentage for second cash discount

0PSTNG_DATE

Posting date in the document

0POST_KEY

Posting key

0REASON_CDE

Reason code for payments

0SP_GL_IND

Special G/L indicator

0PMNTTRMS

Terms of payment key

ODS Object ZFIAP_O3: FIAP: Line items BW Infoobject

BW Infoobject description

0AC_DOC_NO

Accounting document number

0ITEM_NUM

Number of line item within accounting document

0COMP_CODE

Company code

0CREDITOR

Account number of supplier/vendor

0FISCVARNT

Fiscal year variant

0FISCPER

Fiscal year / period

0PSTNG_DATE

Posting date in the document

0DOC_DATE

Document Date

0CREATEDON

Date on which the record was created

0FI_DOCSTAT

Item Status

0C_CTR_AREA

Credit Control Area

0BUS_AREA

Business area

0CHRT_ACCTS

Chart of accounts

0GL_ACCOUNT

G/L Account

0ACCT_TYPE

Account type

0COUNTRY

Country key

0SP_GL_IND

Special G/L indicator

0AC_DOC_TYP

Document type

0POST_KEY

Posting key

0SP_GL_TT

Special G/L Transaction Type

0ALLOC_NMBR

Allocation Number

0RC_ACCOUNT

Reconciliation Account

0FI_SUBSID

Account Number of the Branch

0CLEAR_DATE

Clearing date

0CLR_DOC_NO

Clearing Document Number

0NETDUEDATE

Due date for net payment

0DSCT_DATE1

Due date for cash discount 1

0DSCT_DATE2

Due date for cash discount 2

0BLINE_DATE

Baseline Date For Due Date Calculation

0FI_DSBITEM

Due Date Item Number

0PYMT_METH

Payment method

0PMNTTRMS

Terms of payment key

0PMNT_BLOCK

Payment block key

0REASON_CDE

Reason code for payments

0REF_DOC_NO

Reference document number

0REF_KEY1

Reference Key 1

0REF_KEY2

Reference Key 2

0REF_KEY3

Reference Key 3

0DOC_NUMBER

Sales document

0INV_DOC_NO

Invoice Number

0INV_ITEM

Invoice Item

0INV_YEAR

Invoice Year

0FI_XARCH

Indicator: Original Document Archived

0DEBIT_DC

Debit amount in document currency

0CREDIT_DC

Credit amount in document currency

0DEB_CRE_DC

Amount in document currency

0DSC_AMT_DC

Cash discount amount in document currency

0DISC_BASE

Cash discount base in document currency

0DOC_CURRCY

Document currency

0DEBIT_LC

Debit amount in local currency

0CREDIT_LC

Credit amount in local currency

0DEB_CRE_LC

Amount in local currency

0DSC_AMT_LC

Cash discount amount in local currency

0LOC_CURRCY

Local currency

0DSCT_DAYS1

Days for First Cash Discount

0DSCT_DAYS2

Days for Second Cash Discount

0DSCT_PCT1

Percentage for first cash discount

0DSCT_PCT2

Percentage for second cash discount

0NETTERMS

Deadline for net conditions

0CALYEAR

Calendar Year

0CALQUARTER

Calendar Year/Quarter

0CALMONTH

Calendar Year/Month

0FISCYEAR

Fiscal year

0CALWEEK

Calendar Year/Week

Mapping of BW Infoobjects to R3 fields - 0FI_AP_4 - Vendor Line items BW Infoobject 0FI_SUBSID 0CREDITOR 0ACCT_TYPE

BW Infoobject description Account Number of the Branch Account Number of Vendor or Creditor Account type

R3 field FILKD LIFNR KOART

0CREATEDON 0AC_DOC_NO 0DISC_BASE 0DEB_CRE_LC 0ALLOC_NMBR 0BLINE_DATE 0BUS_AREA 0REF_KEY1 0REF_KEY2 0RECORDMODE 0DSC_AMT_DC 0DSC_AMT_LC 0DSCT_PCT1 0DSCT_PCT2 0CHRT_ACCTS 0CLEAR_DATE 0COMP_CODE 0COUNTRY 0CREDIT_DC 0CREDIT_LC 0C_CTR_AREA 0DOC_CURRCY 0LOC_CURRCY 0DSCT_DAYS1 0DSCT_DAYS2 0DEBIT_DC 0DEBIT_LC 0DOC_DATE 0CLR_DOC_NO 0AC_DOC_TYP 0DSCT_DATE1 0DSCT_DATE2 0NETDUEDATE 0DUNN_AREA 0DUNN_BLOCK 0DUNN_KEY 0DUNN_LEVEL 0FISCPER 0INV_YEAR 0FISCVARNT 0DEB_CRE_DC 0RC_ACCOUNT 0GL_ACCOUNT 0FI_XARCH 0POSTXT 0LAST_DUNN 0INV_ITEM 0NETTERMS 0ITEM_NUM 0INV_DOC_NO 0PMNT_BLOCK 0PYMT_METH 0PSTNG_DATE 0POST_KEY 0REASON_CDE 0REF_DOC_NO 0REF_KEY3 0DOC_NUMBER 0SP_GL_IND 0SP_GL_TT 0FI_DOCSTAT 0FI_DSBITEM 0PMNTTRMS

Accounting Document Entry Date CPUDT Accounting Document Number BELNR Amount Eligible for Cash Discount in Document CurrenSKFBT Amount in Local Currency with +/- Signs DMSHB Assignment number ZUONR Baseline Date for Due Date Calculation ZFBDT Business Area ZZGSBER Business partner reference key XREF1 Business partner reference key XREF2 BW Delta Process: Record Mode UPDMOD Cash discount amount in document currency WSKTO Cash discount amount in local currency SKNTO Cash Discount Percentage 1 ZBD1P Cash Discount Percentage 2 ZBD2P Chart of Accounts KTOPL Clearing Date AUGDT Company Code BUKRS Country Key LAND1 Credit Amount in Document Currency WRHAB Credit Amount in Local Currency DMHAB Credit control area KKBER Currency Key WAERS Currency key of the local currency LCURR Days for First Cash Discount ZBD1T Days for Second Cash Discount ZBD2T Debit Amount in Document Currency WRSOL Debit Amount in Local Currency DMSOL Document Date in Document BLDAT Document Number of the Clearing Document AUGBL Document type BLART Due date according to cash discount terms 1 SK1DT Due date according to cash discount terms 2 SK2DT Due Date for Net Payment NETDT Dunning Area MABER Dunning block MANSP Dunning key MSCHL Dunning Level MANST Fiscal year / period FISCPER Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ Fiscal year variant FISCVAR Foreign Currency Amount with Signs (+/-) WRSHB G/L Account Number SAKNR General Ledger Account HKONT Indicator: Document already archived ? XARCH Item Text SGTXT Last dunned on MADAT Line Item in the Relevant Invoice REBZZ Net Payment Terms Period ZBD3T Number of Line Item Within Accounting Document BUZEI Number of the Invoice the Transaction Belongs to REBZG Payment Block Key ZLSPR Payment Method ZLSCH Posting Date in the Document BUDAT Posting Key BSCHL Reason Code for Payments RSTGR Reference Document Number XBLNR Reference key for line item XREF3 Sales and Distribution Document Number VBELN Special G/L Indicator UMSKZ Special G/L Transaction Type UMSKS Status of FI Item STATUSPS Sub-item number UPOSZ Terms of Payment Key ZTERM

R3 Transaction source tables: BSIK BSAK

Accounting: Secondary Index for Vendors (Open Items) Accounting: Secondary Index for Vendors (Cleared Items)

R3 Reports for reconciling: S_ALR_87012082 S_ALR_87012103 S_ALR_87012084 S_ALR_87012083 S_ALR_87012104

Vendor balances Vendor Line items Vendor due date forecast List of vendor open items List of vendor cleared items