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
<td

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