Skip to Content

Hi All,

I was recently working in  Invoice data extraction from ECC to BW.I was implementing the standard BC objects of 2LIS_06_INV however there is no mappings available between the Datasource and the Infosource from the standard contents. I tried in lot of SDN threads and many SAP help portals but i couldn’t find the mappings between them and i saw some threads this BC is incomplete.Finally i found the answer and i thought it would be helpful for our folks who is searching for these mapping details now or in near future.

These mappings to the Infosource is based on the DSO – 0LIV_DS01; but still we can use this mappings and the data flow to get the Invoice details for the SRM standard DSO 0SRIV_D3 ( This is method will be applicable to the Extended Classic Scenario in SRM )

Content Source DataSource  2LIS_06_INV
SAP Target InfoSource  2LIS_06_INV

Source Field Name Description Data Type Length Rule Type Target InfoObject Description InfoObjTyp Length
KOART Account Type CHAR 1 [DIRECT] 0ACCT_TYPE Account type CHAR 1
VORNR Oper./Act. CHAR 4 [DIRECT] 0ACTIVITY Network Activity CHAR 4
LSTAR Activity Type CHAR 6 [DIRECT] 0ACTTYPE Activity Type CHAR 6
ANLN2 Subnumber CHAR 4 [DIRECT] 0ASSET Asset Sub-number CHAR 4
ANLN1 Asset CHAR 12 [DIRECT] 0ASSET_MAIN Main Asset Number CHAR 12
BASME Base unit UNIT 3 [DIRECT] 0BASE_UOM Base Unit of Measure UNIT 3
KNTTP Acct Assgt Cat. CHAR 1 [DIRECT] 0BBP_ACCCAT Account Assignment Category CHAR 5
COBL_NR Seq. no. NUMC 4 [DIRECT] 0BBP_ACC_NO Sequential Number of Account Assignment NUMC 4
LFPOS Ref. Doc. Item NUMC 4 [DIRECT] 0BBP_COITEM Item Number in Confirmation Document NUMC 10
LFBNR Reference Doc. CHAR 10 [DIRECT] 0BBP_CON_ID Confirmation Number CHAR 10
KONNR Agreement CHAR 10 [DIRECT] 0BBP_CTC_ID Contract ID CHAR 10
KTPNR Agreement Item NUMC 5 [DIRECT] 0BBP_CTITEM Item Number in Contract NUMC 10
XBLNR Reference CHAR 16 [DIRECT] 0BBP_DELREF Vendor Document Number CHAR 16
BKTXT Doc.Header Text CHAR 25 [DIRECT] 0BBP_DESCR Name of Document CHAR 40
EREKZ Final Invoice CHAR 1 [DIRECT] 0BBP_FININ2 Final Invoice Indicator 2 CHAR 1
MWSKZ_BNK Tax Code CHAR 2 [DIRECT] 0BBP_FRTCOD Freight Tax Indicator CHAR 2
BUZEI Item NUMC 6 [DIRECT] 0BBP_INITEM Item Number in Invoice NUMC 10
IVTYP IV category CHAR 1 [DIRECT] 0BBP_INPTYP Creation Indicator CHAR 1
BELNR Document Number CHAR 10 [DIRECT] 0BBP_INV_ID Invoice Number CHAR 10
EBELP Item NUMC 5 [DIRECT] 0BBP_POITEM Item Number in Order Document NUMC 10
EBELN Purchasing Doc. CHAR 10 [DIRECT] 0BBP_PO_ID Number of Purchase Order CHAR 10
XRECH Invoice CHAR 1 [DIRECT] 0BBP_SUBTYP Document Characteristics CHAR 2
SPGRS Blkg Reas. Amount CHAR 1 [DIRECT] 0BLCKRSN_AM Blocking Reason: Amount CHAR 1
SPGRT Bl. Reason Date CHAR 1 [DIRECT] 0BLCKRSN_DT Blocking Reason: Date CHAR 1
ZLSPR Pmnt Block CHAR 1 [DIRECT] 0BLCKRSN_HM Blocking Reason: Manual (Header) CHAR 1
MRM_ZLSPR Log. payt block CHAR 1 [DIRECT] 0BLCKRSN_HS Blocking Reason: Statistical (Header) CHAR 1
SPGRQ Man.Block.Reasn CHAR 1 [DIRECT] 0BLCKRSN_MN Blocking Reason: Manual (Item) CHAR 1
SPGRV Block.reas:proj CHAR 1 [DIRECT] 0BLCKRSN_PJ Blocking Reason: Project Budget CHAR 1
SPGRG Block.reas: OPQ CHAR 1 [DIRECT] 0BLCKRSN_PQ Blocking Reason: Purchase Order Price Quantity CHAR 1
SPGRP Block.reas.Pr. CHAR 1 [DIRECT] 0BLCKRSN_PR Blocking Reason: Price CHAR 1
SPGRC Block: quality CHAR 1 [DIRECT] 0BLCKRSN_QL Blocking Reason: Quality CHAR 1
SPGRM Block.reas.:qty CHAR 1 [DIRECT] 0BLCKRSN_QN Blocking Reason: Quantity CHAR 1
GSBER Business Area CHAR 4 [DIRECT] 0BUS_AREA Business area CHAR 4
BLDAT Document Date DATS 8 [TIME] 0CALDAY Calendar Day DATS 8
KTOPL Chart of Accts CHAR 4 [DIRECT] 0CHRT_ACCTS Chart of accounts CHAR 4
FIPOS Commitment Item CHAR 14 [DIRECT] 0CMMT_ITEM Commitment item CHAR 24
BUKRS Company Code CHAR 4 [DIRECT] 0COMP_CODE Company code CHAR 4
AUFNR Order CHAR 12 [DIRECT] 0COORDER Order Number CHAR 12
KOSTL Cost Center CHAR 10 [DIRECT] 0COSTCENTER Cost Center CHAR 10
KOKRS CO Area CHAR 4 [DIRECT] 0CO_AREA Controlling area CHAR 4
UMREN Denominator DEC 5 [DIRECT] 0DENOMIN_SU Denominator for Converting BaseUoM into Sales Unit INT4 4
BPUMN Qty Conversion DEC 5 [DIRECT] 0DENOMI_UC Denominator for Conversion of OUn into OPUn DEC 9
GJAHR Fiscal Year NUMC 4 [TIME] 0FISCYEAR Fiscal year NUMC 4
FIKRS FM Area CHAR 4 [DIRECT] 0FM_AREA Financial Management Area CHAR 4
FKBER Functional Area CHAR 16 [DIRECT] 0FUNC_AREA Functional area CHAR 16
GEBER Fund CHAR 10 [DIRECT] 0FUND Fund CHAR 20
FISTL Funds Center CHAR 16 [DIRECT] 0FUNDS_CTR Funds Center CHAR 16
SAKNR G/L Account CHAR 10 [DIRECT] 0GL_ACCOUNT G/L Account CHAR 10
WEPOS Goods Receipt CHAR 1 [DIRECT] 0GR_INDIC Goods Receipt Indicator CHAR 1
WEUNB GR Non-Valuated CHAR 1 [DIRECT] 0GR_NONVAL Goods Receipt, Non-Valuated CHAR 1
WAERS Currency CUKY 5 [DIRECT] 0INV_CURR Currency of Invoice CUKY 5
LIFNR Invoicing Pty CHAR 10 [DIRECT] 0INV_PTY Different invoicing party CHAR 10
RBSTAT Inv. status CHAR 1 [DIRECT] 0INV_STAT Invoice Status CHAR 1
PSTYP Item Category CHAR 1 [DIRECT] 0ITM_CAT Item Category in Purchasing Document CHAR 1
ARKUEN Inv. reduction CURR 13 [DIRECT] 0LIV_AUIVR Automatic Invoice Reduction Amount (Net) CURR 9
ARKUEMW Tax inv. red. CURR 13 [DIRECT] 0LIV_AUIVRT Tax for Automatic Invoice Reduction Amount CURR 9
AREWR GR/IR clr.value CURR 13 [DIRECT] 0LIV_GRIRLC Clearing Value GR/IR Account in Local Currency CURR 9
BPWEM GR Qty in OPUn QUAN 13 [DIRECT] 0LIV_GRQEPU Goods Receipt Quantity in Purchase Order Price Unit QUAN 9
WEMNG Received QUAN 13 [DIRECT] 0LIV_GRQHOU Goods Receipt Quantity in Purchase Order Unit QUAN 9
WEWWR GR val.(FCurr.) CURR 13 [DIRECT] 0LIV_GRVHIC Goods Receipt Value in Invoice Currency CURR 9
DIFFN IV Difference CURR 13 [DIRECT] 0LIV_IVDFF Total-Based Accepted Invoice Difference (Net) CURR 9
DIFFMW Tax difference CURR 13 [DIRECT] 0LIV_IVDFFT Tax for Total-Based Accepted Invoice Difference CURR 9
RMWWR Gross inv. amnt CURR 13 [DIRECT] 0LIV_IVGAIC Gross Invoice Amount in Invoice Currency CURR 9
MENGE Quantity QUAN 13 [DIRECT] 0LIV_IVQEOU Invoice Quantity in Purchase Order Unit QUAN 9
BPMNG Qty in OPUn QUAN 13 [DIRECT] 0LIV_IVQEPU Invoice Quantity in Purchase Order Price Unit QUAN 9
REMNG Invoice qty QUAN 13 [DIRECT] 0LIV_IVQHOU Invoice Quantity History in Purchase Order Unit QUAN 9
BPREM IR quantity QUAN 13 [DIRECT] 0LIV_IVQHPU Invoice Quantity History in Purchase Order Price Unit QUAN 9
RBMNG Inv. doc. qty QUAN 13 [DIRECT] 0LIV_IVQVOU Invoice Quantity According to Vendor in Purchase Order Unit QUAN 9
BPRBM InvQty POunit QUAN 13 [DIRECT] 0LIV_IVQVPU Invoice Quantity Acc. to Vendor in Purchase Order Price Unit QUAN 9
REFWR Inv.value in FC CURR 13 [DIRECT] 0LIV_IVVEFC Invoice Value Entered in Foreign Currency CURR 9
REWWR FC invoice amnt CURR 13 [DIRECT] 0LIV_IVVHIC Invoice Value History in Invoice Currency CURR 9
RBWWR Inv.amnt FC CURR 13 [DIRECT] 0LIV_IVVVIC Invoice Value According to Vendor in Invoice Currency CURR 9
MAKZN ManAccpdNetAmnt CURR 13 [DIRECT] 0LIV_MNIVD Manually Accepted Difference Amount (Net) CURR 9
MAKZMW Tax accptd man. CURR 13 [DIRECT] 0LIV_MNIVDT Tax for Manually Accepted Difference Amount CURR 9
BSMNG PO Quantity QUAN 13 [DIRECT] 0LIV_ORQTOU Purchase Order Quantity in Order Unit QUAN 9
NETWR Net Value CURR 15 [DIRECT] 0LIV_ORVTIC Purchase Order Value in Invoice Currency CURR 9
WENWR Net value in FC CURR 13 [DIRECT] 0LIV_SRVNFC Accepted Service Value Net in Foreign Currency CURR 9
LIEFFN Vend.error(net) CURR 13 [DIRECT] 0LIV_VDERR Vendor Error (Net) CURR 9
LIEFFMW Tax, vend.error CURR 13 [DIRECT] 0LIV_VDERRT Tax for Vendor Error CURR 9
HWAER Currency CUKY 5 [DIRECT] 0LOC_CURRCY Local currency CUKY 5
LOGSYS Logical system CHAR 10 [DIRECT] 0LOGSYS_PUR Logical Procurement System CHAR 10
MATNR Material CHAR 18 [DIRECT] 0MATERIAL Material CHAR 18
MATKL Material Group CHAR 9 [DIRECT] 0MATL_GROUP Material group CHAR 9
NETPR Net Price CURR 11 [DIRECT] 0NETPRICE Net price CURR 9
NPLNR Network CHAR 12 [DIRECT] 0NETWORK Network CHAR 12
NOQUANTITY No quantity CHAR 1 [DIRECT] 0NOQUANTITY Document Item Without Quantity CHAR 1
UMREZ Counter DEC 5 [DIRECT] 0NUMERAT_SU Numerator for Converting Base UoM into Sales Unit INT4 4
BPUMZ Qty Conversion DEC 5 [DIRECT] 0NUMERA_UC Counter for Conversion of OUn into OPUn DEC 9
BEWAE Order currency CUKY 5 [DIRECT] 0ORDER_CURR Purchase Order Currency CUKY 5
WERKS Plant CHAR 4 [DIRECT] 0PLANT Plant CHAR 4
BPRME PO Price Unit UNIT 3 [DIRECT] 0PO_PR_UNIT Order price unit (purchasing) UNIT 3
MEINS Base Unit UNIT 3 [DIRECT] 0PO_UNIT Order unit UNIT 3
PEINH Price Unit DEC 5 [DIRECT] 0PRICE_UNIT Price unit DEC 9
TXZ01 Short Text CHAR 40 [DIRECT] 0PROD_DESCR Product Description CHAR 40
PRCTR Profit Center CHAR 10 [DIRECT] 0PROFIT_CTR Profit Center CHAR 10
PAOBJNR Profit. segment NUMC 10 [DIRECT] 0PROFTB_SEG Number for Profitability Segments (CO-PA) NUMC 10
BUDAT Posting Date DATS 8 [DIRECT] 0PSTNG_DATE Posting date in the document DATS 8
EKORG Purchasing Org. CHAR 4 [DIRECT] 0PURCH_ORG Purchasing organization CHAR 4
EKGRP Purch. Group CHAR 3 [DIRECT] 0PUR_GROUP Purchasing Group CHAR 3
ROCANCEL Rec. Type Extract. CHAR 1 [DIRECT] 0RECORDMODE BW Delta Process: Update Mode CHAR 1
LFGJA Year cur.period NUMC 4 [DIRECT] 0REF_DOC_FY Fiscal Year of Reference Document NUMC 4
AFNAM Requisitioner CHAR 12 [ROUTINE] 0REQUESTER Requester CHAR 10

Routine Code for Rule

… “insert your code here                                                                                                                                                         

Data : lv_RECORD_NO LIKE SY-TABIX,                                                                                                                                                              

ls_minfo TYPE rssm_s_minfo,                                                                                                                                                               

ls_monitor TYPE rsmonitor,                                                                                                                                                  

lt_ERRORLOG TYPE rssm_t_errorlog_int,                                                                                                                                                           

lv_RESULT type /BI0/OIREQUESTER,                                                                                                                                                 

ls_errorlog TYPE rssm_s_errorlog_int,                                                                                                                                                  

l_rc type i.                                                                                                                                                              

DATA: l_s_errorlog TYPE rssm_s_errorlog_int,                                                                                                                                                    

l_text TYPE string.                                                                                                                                                

perform bbp_get_requester using SOURCE_FIELDS-AFNAM                                                                                                                                                 

lv_RECORD_NO                                                                                                                                                    

ls_minfo                                                                                                                                                 

changing lv_RESULT                                                                                                                                                             

lt_errorlog                                                                                                                                                              

l_rc.                                                                                                                                                        

IF l_rc <> 0.                                                                                                                                                            

loop at lt_errorlog into ls_errorlog.                                                                                                                                                        

MOVE-CORRESPONDING ls_errorlog TO ls_monitor.                                                                                                                                                          

APPEND ls_monitor TO MONITOR.                                                                                                                                                    

End Loop.                                                                                                                                                               

RAISE EXCEPTION TYPE cx_rsrout_skip_val.                                                                                                                                                    

ELSE.                                                                                                                                                     

RESULT = lv_result.                                                                                                                                                               

ENDIF.                                                                                                                                                   

                                                                                                         

RETPO Returns Item CHAR 1 [DIRECT] 0RET_ITM Returns Item CHAR 1
STJAH Year NUMC 4 [DIRECT] 0REV_DOC_FY Fiscal Year of Reversal Document NUMC 4
STBLG Reversed by CHAR 10 [DIRECT] 0REV_DOC_NO Reversal Document Number CHAR 10
BEZNK Unpl. del. csts CURR 13 [DIRECT] 0SR_FREIGIC Freight Costs in Invoice in Invoice Currency CURR 9
WRBTR Amount CURR 13 [DIRECT] 0SR_IVVIC Net Invoiced Value in Invoice Currency CURR 9
TBTKZ Sub. deb./cred. CHAR 1 [DIRECT] 0SR_SCRED Subsequent credit / debit CHAR 1
WMWST1 Value-Added Tax CURR 13 [DIRECT] 0SR_TAXESIC Tax Amount of Invoice in Invoice Currency CURR 9
LIFNR2 Vendor CHAR 10 [DIRECT] 0VENDOR Vendor CHAR 10
PS_PSP_PNR WBS Element NUMC 8 [DIRECT] 0WBS_ELEMT Work Breakdown Structure Element (WBS Element) CHAR 24
BUKRS Company Code CHAR 4 [ROUTINE] 0FISCVARNT Fiscal year variant CHAR 2

Routine Code for Rule


* Update the fiscal year variant based on the company code                                                                                                                 

* delivered in the source data of 2LIS_06_INV                                                                                                                       

DATA: ls_comp_code TYPE /rtf/_s_comp_code,                                                                                                                   

lc_error TYPE REF TO /rtf/cx_root.                                                                                                               

* Determine the details of the company code                                                                                                                

CALL METHOD /rtf/cl_comp_code=>single_read                                                                                                                 

EXPORTING                                                                                                             

i_comp_code = SOURCE_FIELDS-bukrs                                                                                                                  

IMPORTING                                                                                                             

es_comp_code = ls_comp_code.                                                                                                                    

CATCH /rtf/cx_comp_code INTO lc_error.                                                                                                                

CALL METHOD lc_error->conv_2_msgline                                                                                                               

CHANGING                                                                                                              

xs_msg = monitor_rec.                                                                                                            

RAISE EXCEPTION TYPE CX_RSROUT_ABORT.                                                                                                                       

* Update the Fiscalyear Variant                                                                                                                       

RESULT = ls_comp_code-fiscvarnt.                                                                                                               

[NO_UPDATE] 0GN_R3_SSY Source System for R/3 Entity CHAR 2
[NO_UPDATE] 0BBP_SYS_BE Logical Backend System CHAR 2
[NO_UPDATE] 0RT_PRDIFF Price Difference (Local Currency) CURR 9

Hope this Helps ……

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply