GL Data Source 0FI_GL_4
Tables Used Financial Accounting document tables BKPF and BSEG
Mapping
Info Object Table(s) from R/3 and Field name
Description 0COMP_CODE BKPF-BUKRS
0AC_DOC_NO BKPF-BELNR
0ITEM_NUM BSEG-BUZEI 0FI_DOCSTAT BKPF-BSTAT,
BSEG-AUGDT
Open/Close status 0CHRT_ACCTS T001-KTOPL
0GL_ACCOUNT BSEG-HKONT
0ACCT_TYPE BSEG-KOART 0SP_GL_IND BSEG-UMSKZ 0AC_DOC_TYP BKPF-BLART
0POST_KEY BSEG-BSCHL 0DOC_DATE BKPF-BLDAT 0PSTNG_DATE BKPF-BUDAT
0CREATEDON BKPF-CPUDT 0CLEAR_DATE BSEG-AUGDT 0CLR_DOC_NO BSEG-AUGBL 0CO_AREA BSEG-KOKRS 0COSTCENTER BSEG-KOSTL 0PROFIT_CTR BSEG-PRCTR 0COORDER BSEG-AUFNR 0WBS_ELEMT BSEG-PROJK 0PLANT BSEG-WERKS 0BUS_AREA BSEG-GSBER 0FUNDS_CTR BSEG-FKBER 0PART_PRCTR BSEG-PPRCT 0PCOMPANY BSEG-VBUND 0PBUS_AREA BSEG-PARGB
0LOC_CURTP2 Uses function module
FI_CURRENCY_INFORMATION
0LOC_CURTP3 Uses function module
FI_CURRENCY_INFORMATION
___________________________________________________________________________
© Genie Press 2006 32
0REF_DOC_NO BKPF-XBLNR
0REF_KEY3 BSEG-XREF3 Reference key for the document items
0ORG_DOC_NO Uses function module
BWFIU_GET_DOCUMENT_ORIGIN 0ORG_DOC_YR Uses function module
BWFIU_GET_DOCUMENT_ORIGIN 0ORG_DOC_CC Uses function module
BWFIU_GET_DOCUMENT_ORIGIN 0ORG_DOC_CO Uses function module
BWFIU_GET_DOCUMENT_ORIGIN 0TXTLG BSEG-SGTXT
0FISCPER BKPF-GJAHR, BKPF-MONAT
0FISCVARNT T001-PERIV 0DEBIT_LC
BSEG- SHKZG,BSEG-DMBTR
0CREDIT_LC BSEG-SHKZG, BSEG-DMBTR 0DEB_CRE_LC BSEG-SHKZG,
BSEG-DMBTR 0DEBIT_DC BSEG-SHKZG,
BSEG-WRBTR 0CREDIT_DC BSEG-SHKZG, BSEG-WRBTR 0DEB_CRE_DC BSEG-SHKZG, BSEG-WRBTR 0DEBIT_LC2,
0CREDIT_LC2, 0DEB_CRE_L2
BSEG-SHKZG, BSEG-DMBE2 0DEBIT_LC3,
0CREDIT_LC3, 0DEB_CRE_L3
BSEG-SHKZG, BSEG-DMBE3
___________________________________________________________________________
© Genie Press 2006 33
AR Data Source 0FI_AR_4
Tables Used BSID (Open Items), BSAD (Closed Items)
Mapping
Info Object Table(s) from R/3 and Field name
Description
0RC_ACCOUNT BSID-SAKNR Reconciliation Account 0CLR_DOC_NO BSID-AUGBL
0BLINE_DATE BSID-ZFBDT 0AC_DOC_TYP BSID-BLART 0DOC_DATE BSID-BLDAT 0AC_DOC_NO BSID-BLNR 0TXTLG BSID-SGTXT 0PSTNG_DATE BSID-BUDAT 0COMP_CODE BSID-BUKRS
0POST_KEY BSID-BSCHL 0LAST_DUNN BSID-MADAT
0CLEAR_DATE BSID- AUGDT 0CREATEDON BSID-CPUDT 0REASON_CDE BSID-RSTGR 0FI_DSBITEM BSID-UPOSZ 0FI_XARCH BSID-XARCH 0CHRT_ACCTS T001-KTOPL 0ACCT_TYPE Fix value ‘D’
0FI_SUBSID BSID-FILKD
0DEBITOR BSID-KUNNR 0C_CTR_AREA BSID-KKBER
0COUNTRY T001-LAND1 0DUNN_AREA BSID-MABER
0DUNN_KEY BSID-MSCHL 0DUNN_BLOCK BSID-MANSP
0DUNN_LEVEL BSID-MAHNS 0NETDUEDATE Calculated 0ITEM_NUM BSID-BUZEI 0FI_DOCSTAT Calculated
0INV_YEAR BSID-REBZJ 0INV_DOC_NO BSID-REBZG
0INV_ITEM BSID-REBZZ 0REF_DOC_NO BSID-XBLNR
0REF_KEY1 BSID-XREF1 0REF_KEY2 BSID-XREF2 0REF_KEY3 BSID-XREF3
___________________________________________________________________________
© Genie Press 2006 34
0GL_ACCOUNT BSID-HKONT 0PMNT_BLOCK BSID-ZLSPR 0DSCT_DATE1 Calculated 0DSCT_DATE2 Calculated
0SP_GL_IND BSID-UMSKZ
0DOC_NUMBER BSID-VBELN Sales Document 0PMNTTRMS BSID-ZTERM
0PYMT_METH BSID-ZLSCH
0FISCPER BSID-GJAHR and BSID-MONAT
0FISCVARNT T001 – PERIV 0DEB_CRE_DC Calculated 0DEB_CRE_LC Calculated 0NETTERMS BSID-ZBD3T 0CREDIT_DC Calculated 0CREDIT_LC Calculated 0DSCT_PCT1 BSID-ZBD1P 0DSCT_DAYS1 BSID-ZBD1T 0DSCT_PCT2 BSID-ZBD2P 0DSCT_DAYS2 BSID-ZBD2T 0DSC_AMT_DC BSID- WSKTO 0DSC_AMT_LC BSID- SKNTO
0DISC_BASE BSID- SKFBT 0DEBIT_DC and
0DEBIT_LC
Calculated
___________________________________________________________________________
© Genie Press 2006 35
AP Data Source 0FI_AP_4
Tables Used BSIK (Open Items), BSAK (Closed Items)
Mapping
Info Object Table(s) from R/3 and Field name
Description
0RC_ACCOUNT BSIK-SAKNR Reconciliation Account 0CLR_DOC_NO BSIK-AUGBL
0BLINE_DATE BSIK-ZFBDT 0AC_DOC_TYP BSIK-BLART 0DOC_DATE BSIK-BLDAT 0AC_DOC_NO BSIK-BLNR 0TXTLG BSIK-SGTXT 0PSTNG_DATE BSIK-BUDAT 0COMP_CODE BSIK-BUKRS
0POST_KEY BSIK-BSCHL 0LAST_DUNN BSIK-MADAT
0CLEAR_DATE BSIK- AUGDT 0CREATEDON BSIK-CPUDT 0REASON_CDE BSIK-RSTGR 0FI_DSBITEM BSIK-UPOSZ 0FI_XARCH BSIK-XARCH 0CHRT_ACCTS T001-KTOPL 0ACCT_TYPE Fix value ‘K’
0FI_SUBSID BSIK-FILKD
0DEBITOR BSIK-KUNNR 0C_CTR_AREA BSIK-KKBER
0COUNTRY T001-LAND1 0DUNN_AREA BSIK-MABER
0DUNN_KEY BSIK-MSCHL 0DUNN_BLOCK BSIK-MANSP
0DUNN_LEVEL BSIK-MAHNS 0NETDUEDATE Calculated 0ITEM_NUM BSIK-BUZEI 0FI_DOCSTAT Calculated
0INV_YEAR BSIK-REBZJ 0INV_DOC_NO BSIK-REBZG
0INV_ITEM BSIK-REBZZ 0REF_DOC_NO BSIK-XBLNR
0REF_KEY1 BSIK-XREF1 0REF_KEY2 BSIK-XREF2 0REF_KEY3 BSIK-XREF3
___________________________________________________________________________
© Genie Press 2006 36
0GL_ACCOUNT BSIK-HKONT 0PMNT_BLOCK BSIK-ZLSPR 0DSCT_DATE1 Calculated 0DSCT_DATE2 Calculated
0SP_GL_IND BSIK-UMSKZ
0DOC_NUMBER BSIK-VBELN Sales Document 0PMNTTRMS BSIK-ZTERM
0PYMT_METH BSIK-ZLSCH
0FISCPER BSIK-GJAHR and BSIK-MONAT
0FISCVARNT T001 – PERIV 0DEB_CRE_DC Calculated 0DEB_CRE_LC Calculated 0NETTERMS BSIK-ZBD3T 0CREDIT_DC Calculated 0CREDIT_LC Calculated 0DSCT_PCT1 BSIK-ZBD1P 0DSCT_DAYS1 BSIK-ZBD1T 0DSCT_PCT2 BSIK-ZBD2P 0DSCT_DAYS2 BSIK-ZBD2T 0DSC_AMT_DC BSIK- WSKTO 0DSC_AMT_LC BSIK- SKNTO 0DISC_BASE BSIK- SKFBT 0DEBIT_DC and
0DEBIT_LC
Calculated
HR Data Source 0HR_PA_1 (Personnel Actions)
Tables Used PA0000, PA0302
Mapping
Info Object Table(s) from R/3 and Field name
Description 0EMPLSTATUS PA0000-STAT2
0ACTIONREAS MASSG from PA0000, PA0302 0ACTIONTYPE MASSN from
PA0000, PA0302 0EMPLOYEE PERNR from PA0000, PA0302
0CALDAY BEGDA from
PA0000, PA0302
___________________________________________________________________________
© Genie Press 2006 37
HR Data Source 0HR_PA_BN_1 (Benefits)
Tables Used Uses the function module
HR_BW_EXTRACT_IS_BENPLAN Mapping
Info Object Table(s) from R/3 and Field name
Description 0BEN_AREA PA0171-BAREA
0BEN_PLAN T5UBU-BPLAN 0DEPCVRG PA0167-BPCAT
0PRGM_GRP1 PA0171-BENGR First programming grouping 0HICOMP PA0375-HICMP Highly compensated employee 0PLANCATEG T5UB1-BPCAT Plan category
0BEN_OPTION PA0167 PA0168 PA0377 fields BOPTI
BCOVR LEVL1
0PLANTYPE T5UBA-PLTYP 0PRGM_GRP2 PA0171-BSTAT
HR Data Source 0HR_PY_1 (Payroll Data)
Tables Used Data is read from payroll cluster PCL2 and not from standard tables
Mapping
Info Object Table(s) from R/3 and Field name
Description 0BUS_AREA WPBP-GSBER 0COMP_CODE WPBP-BUKRS
0COUNTRY_ID VERSC-MOLGA 0EMPLGROUP WPBP-PERSG 0HRPOSITION WPBP-PLANS
0JOB WPBP-STELL 0MAST_CCTRW WPBP-KOSTL
0ORGUNIT WPBP-ORGEH 0PERS_AREA WPBP-WERKS
___________________________________________________________________________
© Genie Press 2006 38
0PERS_SAREA WPBP-BTRTL
0TIME_STAT WPBP-ZTERF 0WAGETYPE RT-LGART
0RTNUM RT-ANZHL 0AMOUNT RT-BETRG
Material Movements (Stock initialization) 2LIS_03_BX This replaces 2LIS_40_S278. it calculates valuated sales order stock.
Tables Used Filled only from stock tables and not from MSEG or BSEG
Mapping
Info Object Table(s) from R/3 and Field name
Description 0BATCH Stock table –
CHARG
0CUST_VEND From stock table (KUNNR)
0MATERIAL From stock table 0PLANT From stock table 0STOCKCAT Filled according to
stock
0STOCKTYPE Filled according to stock
0STOR_LOC Filled according to stock
0VAL_TYPE MCHA-BWTAR
Material Movements from Inventory Management 2LIS_03_BF This replaces 2LIS_40_S278. it calculates valuated sales order stock.
Tables Used MSEG, MBEW
Mapping
Info Object Table(s) from R/3 and Field name
Description
0RT_PROMO MSEG-AKTNR
0VAL_CLASS MBEW-BKLAS
0DOC_DATE MKPF-BLDAT
0STOCKTYPE Filled by LIS
0STOCKCAT Filled by LIS
___________________________________________________________________________
© Genie Press 2006 39
0PSTNG_DATE MKPF-BUDAT
0COMP_CODE MSEG-BUKRS
0BWAPPLNM BW customizing
0MOVETYPE MSEG-BWART
0STOCKRELEV BW customizing
0VAL_TYPE MSEG-BWTAR
0PROCESSKEY BW Customize
0BATCH MSEG-CHARG
0MATMREA MSEG-GRUND Reason for goods movement
0BUS_AREA MSEG-GSBER
0COSTCENTER MSEG-KOSTL
0SOLD_TO MSEG-KUNNR
0WHSE_NUM MSEG-LGNUM
0STOR_LOC MSEG-LGORT
0STRGE_BIN MSEG-LGPLA
0VENDOR MSEG-LIFNR
0MATERIAL MSEG-MATNR
0DOC_NUM MKPF-MBLNR
0DOC_YEAR MKPF-MJAHR
0PROFIT_CTR MSEG-PRCTR
0DCINDIC MSEG-SHKZG
0PLANT MSEG-WERKS
0CO_AREA MSEG-KOKRS
0DOC_ITEM MSEG-ZEILE
0COORDER MSEG-AUFNR
0MOVE_PLANT MSEG-UMWRK
0INDSPECSTK MSEG-KZBWS Valuation special stock
0CPPVLC BW Customizing
0CPSVLC BW Customizing
0CPSTLC BW Customizing
0CPQUABU BW Customizing
0VALUE_LC MSEG-DMBTR
0QUANT_B MSEG-MENGE