Accounts Receivable

Accounts Receivable Infocube ZFIAR_C03: FIAR: Line items BW Infoobject

BW Infoobject description

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

0C_CTR_AREA

Credit Control Area

0DEBITOR

Customer number

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

0FISCYEAR

Fiscal year

0FISCPER

Fiscal year / period

0FISCVARNT

Fiscal year variant

0GL_ACCOUNT

G/L Account

0INT_CALC_1

Interest Calculation Numerator Days 1 (Agreed)

0INT_CALCT1

Interest Calculation Numerator Days 1 (Realized)

0INT_CALC_2

Interest calculation numerator days 2 (agreed)

0INT_CALCT2

Interest Calculation Numerator Days 2 (Realized)

0INT_CALC_N

Interest Calculation Numerator Net (Agreed)

0INT_CALCTN

Interest Calculation Numerator Net (Realized)

0FI_DOCSTAT

Item Status

0NETTAKEN

Net period used

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 ZFIAR_O3: FIAR: Line items BW Infoobject

BW Infoobject description

Accounting document number

0AC_DOC_NO

Document type

0AC_DOC_TYP

Account type

0ACCT_TYPE

Allocation Number

0ALLOC_NMBR

Baseline Date For Due Date Calculation 0BLINE_DATE Business area

0BUS_AREA

Credit Control Area

0C_CTR_AREA

Calendar Year/Month

0CALMONTH

Calendar Year/Quarter

0CALQUARTER

Calendar Year/Week

0CALWEEK

Calendar Year

0CALYEAR

Chart of accounts

0CHRT_ACCTS

Clearing date

0CLEAR_DATE

Clearing Document Number

0CLR_DOC_NO

Company code

0COMP_CODE

Country key

0COUNTRY

Date on which the record was created

0CREATEDON

Credit amount in document currency

0CREDIT_DC

Credit amount in local currency

0CREDIT_LC

Amount in document currency

0DEB_CRE_DC

Amount in local currency

0DEB_CRE_LC

Debit amount in document currency

0DEBIT_DC

Debit amount in local currency

0DEBIT_LC

Customer number

0DEBITOR

Cash discount base in document currenc0DISC_BASE Document currency

0DOC_CURRCY

Document Date

0DOC_DATE

Sales document

0DOC_NUMBER

Cash discount amount in document curr 0DSC_AMT_DC Cash discount amount in local currency 0DSC_AMT_LC Due date for cash discount 1

0DSCT_DATE1

Due date for cash discount 2

0DSCT_DATE2

Days for First Cash Discount

0DSCT_DAYS1

Days for Second Cash Discount

0DSCT_DAYS2

Percentage for first cash discount

0DSCT_PCT1

Percentage for second cash discount

0DSCT_PCT2

Dunning area

0DUNN_AREA

Dunning block

0DUNN_BLOCK

Dunning key

0DUNN_KEY

Dunning level

0DUNN_LEVEL

Item Status

0FI_DOCSTAT

Due Date Item Number

0FI_DSBITEM

Account Number of the Branch

0FI_SUBSID

Indicator: Original Document Archived

0FI_XARCH

Fiscal year / period

0FISCPER

Fiscal year variant

0FISCVARNT

Fiscal year

0FISCYEAR

G/L Account

0GL_ACCOUNT

Invoice Number

0INV_DOC_NO

Invoice Item

0INV_ITEM

Invoice Year

0INV_YEAR

Number of line item within accounting do0ITEM_NUM Date of last dunning notice

0LAST_DUNN

Local currency

0LOC_CURRCY

Due date for net payment

0NETDUEDATE

Deadline for net conditions

0NETTERMS

Payment block key

0PMNT_BLOCK

Terms of payment key

0PMNTTRMS

Posting key

0POST_KEY

Item Text

0POSTXT

Posting date in the document

0PSTNG_DATE

Payment method

0PYMT_METH

Reconciliation Account

0RC_ACCOUNT

Reason code for payments

0REASON_CDE

Reference document number

0REF_DOC_NO

Reference Key 1

0REF_KEY1

Reference Key 2

0REF_KEY2

Reference Key 3

0REF_KEY3

Special G/L indicator

0SP_GL_IND

Special G/L Transaction Type

0SP_GL_TT

Mapping of BW Infoobjects to R3 fields - 0FI_AR_4 - Customer Line items BW Infoobject 0ACCT_TYPE 0CREATEDON 0AC_DOC_NO 0DISC_BASE 0DISC_BASE 0DEB_CRE_LC 0DEB_CRE_LC 0ALLOC_NMBR 0BLINE_DATE 0BUS_AREA 0RECORDMODE 0DSC_AMT_DC 0DSC_AMT_DC 0DSC_AMT_LC 0DSC_AMT_LC 0DSCT_PCT1 0DSCT_PCT2 0CHRT_ACCTS 0CHRT_ACCTS 0CLEAR_DATE 0COMP_CODE 0COUNTRY 0CREDIT_DC 0CREDIT_DC 0CREDIT_LC 0CREDIT_LC 0C_CTR_AREA 0DOC_CURRCY 0DOC_CURRCY 0LOC_CURRCY 0LOC_CURRCY 0DEBITOR 0DSCT_DAYS1

BW Infoobject description Account type Accounting Document Entry Date Accounting Document Number Amount Eligible for Cash Discount in Document Currency Amount Eligible for Cash Discount in Document Currency Amount in Local Currency with +/- Signs Amount in Local Currency with +/- Signs Assignment number Baseline Date for Due Date Calculation Business Area BW Delta Process: Record Mode Cash discount amount in document currency Cash discount amount in document currency Cash discount amount in local currency Cash discount amount in local currency Cash Discount Percentage 1 Cash Discount Percentage 2 Chart of Accounts Chart of Accounts Clearing Date Company Code Country Key Credit Amount in Document Currency Credit Amount in Document Currency Credit Amount in Local Currency Credit Amount in Local Currency Credit control area Currency Key Currency Key Currency key of the local currency Currency key of the local currency Customer Number 1 Days for First Cash Discount

R3 field KOART CPUDT BELNR SKFBT SKFBT DMSHB DMSHB ZUONR ZFBDT ZZGSBER UPDMOD WSKTO WSKTO SKNTO SKNTO ZBD1P ZBD2P KTOPL KTOPL AUGDT BUKRS LAND1 WRHAB WRHAB DMHAB DMHAB KKBER WAERS WAERS LCURR LCURR KUNNR ZBD1T

0DSCT_DAYS2 0DEBIT_DC 0DEBIT_DC 0DEBIT_LC 0DEBIT_LC 0DOC_DATE 0AC_DOC_TYP 0DSCT_DATE1 0DSCT_DATE2 0NETDUEDATE 0DUNN_AREA 0DUNN_BLOCK 0DUNN_KEY 0DUNN_LEVEL 0FISCPER 0FISCVARNT 0DEB_CRE_DC 0DEB_CRE_DC 0FI_XARCH 0POSTXT 0LAST_DUNN 0NETTERMS 0ITEM_NUM 0PMNT_BLOCK 0PYMT_METH 0PSTNG_DATE 0POST_KEY 0REASON_CDE 0SP_GL_IND 0SP_GL_TT 0FI_DOCSTAT 0FI_DSBITEM 0PMNTTRMS

Days for Second Cash Discount Debit Amount in Document Currency Debit Amount in Document Currency Debit Amount in Local Currency Debit Amount in Local Currency Document Date in Document Document type Due date according to cash discount terms 1 Due date according to cash discount terms 2 Due Date for Net Payment Dunning Area Dunning block Dunning key Dunning Level Fiscal year / period Fiscal year variant Foreign Currency Amount with Signs (+/-) Foreign Currency Amount with Signs (+/-) Indicator: Document already archived ? Item Text Last dunned on Net Payment Terms Period Number of Line Item Within Accounting Document Payment Block Key Payment Method Posting Date in the Document Posting Key Reason Code for Payments Special G/L Indicator Special G/L Transaction Type Status of FI Item Sub-item number Terms of Payment Key

R3 Transaction source tables: BSID BSAD

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

R3 Reports for reconciling: S_ALR_87012172 S_ALR_87012197 S_ALR_87012175 S_ALR_87012174 S_ALR_87012177

Customer balances Customer Line items Customer due date forecast List of customer open items Customer payment history

ZBD2T WRSOL WRSOL DMSOL DMSOL BLDAT BLART SK1DT SK2DT NETDT MABER MANSP MSCHL MANST FISCPER FISCVAR WRSHB WRSHB XARCH SGTXT MADAT ZBD3T BUZEI ZLSPR ZLSCH BUDAT BSCHL RSTGR UMSKZ UMSKS STATUSPS UPOSZ ZTERM