2LIS_06_INV - Datasource - Infosource Mappings

[former_member197610]

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