InfoProvider Identification
InfoProvider Name:	InfoCube: 0IC_C03 – Material Movements
Standard/Custom:	Standard Business Content			Std.Business Content w/ Modifications				Custom
Module(s):	CO	FI	HR		MM	PM	PP		SD	PS
	Other (specify):

Document History
Created By:		Rodrick Gary		Date Created:		04/03/2006
Approved by:				Date Approved:
Change History (To track changes to Request spec. after the specifications have been approved)
Date Modified	Modified by		Brief Description of Change		Approved by		Date Approved

1. Overview

This InfoCube allows you to evaluate stock inventory. This InfoCube contains valuated stock, consignment stock, stock in transit, blocked stock, and inspection stock. Also, this InfoCube contains the issue quantity and receipt quantity of valuated stock, inspection stock, consignment stock, blocked stock, and stock in transit.

The InfoSources and DataSources are:

InfoSource	Description	DataSource
2LIS_03_BX	Material Stocks	2LIS_03_BX
2LIS_03_BF	Material Movements From Inventory Mgmt	2LIS_03_BF
2LIS_03_UM	Revaluations In Inventory Management	2LIS_03_UM

The InfoSource 2LIS_03_BX allows you to transfer material stocks from an SAP R/3 system to SAP BW. The InfoSource allows you to set up stocks for stock InfoCubes.

The InfoSource 2LIS_03_BF delivers the data for material movements from MM Inventory Management (MM-IM).

The InfoSource 2LIS_03_UM delivers the data for revaluations from MM Inventory Management (MM-IM).

Standard reports such as the following are available:

· Stock Overview

· Stock In Transit

· Inventory Aging

· Vendor Consignment Stock

· Consignment Stock at Customer

RICE Number	Description
	<insert report names here >
	…

2. Data Flow

3. Business Content Installation

3.1. R/3: Data Transfer to the SAP Business Information Warehouse

3.1.1. Classification:

Standard Business Content X

Standard Business Content w/ Modifications __ Refer to: __________

Custom __ Refer to: __________

3.1.2. In each of the designated source systems, transfer the following DataSource(s):

DataSource: 2LIS_03_BX

DataSource: 2LIS_03_BF

DataSource: 2LIS_03_UM

Source System:

F Box (Development Client TBD) X

G Box (Development Client TBD) X

E Box (Development Client TBD) X

Note: This assignment has been activated per standard business content. No modifications have been made.

Use R/3 Menu Path:

Data Transfer to the SAP Business Information Warehouse à Business Content DataSources à Transfer Business Content DataSources

3.2. BW: Set up InfoSource / DataSource Assignment

3.2.1. Classification:

Standard Business Content

Standard Business Content w/ Modifications Refer to: __________

Custom Refer to: __________

3.2.2. Modeling: Source Systems: Replicate the DataSources of the following Application Components:

Application Component(s): Inventory Management

3.2.3. In each of the designated source systems, assign the following DataSource - InfoSource relationships:

DataSource InfoSource

2LIS_03_BX 2LIS_03_BX

2LIS_03_BF 2LIS_03_BF

2LIS_03_UM 2LIS_03_UM

Source System:

F Box (Development Client TBD) X

G Box (Development Client TBD) X

E Box (Development Client TBD) X

3.2.4. Install the Transfer Rules and Communication Structure.

Note: This assignment has been activated per standard business content. No modifications have been made.

3.3. Activate InfoCube: 0IC_C03

3.3.1. Classification:

Standard Business Content X

Standard Business Content w/ Modifications __ Refer to: __________

Custom __ Refer to: __________

3.3.2. From the Business Content area of the Administrator Workbench:

3.3.2.1. Set ‘Grouping’ to:

Only Necessary Objects __

In Data Flow Before X

In Data Flow Afterwards __

In Data Flow Before & Afterwards __

3.3.2.2. Set ‘Collection Mode’ to:

Collect Autmatically X

Start Manual Collection __ Refer to: __________

3.3.2.3. Insert the following object(s) for Collection:

Object: 0IC_C03

3.3.2.4. Install

Note: This object has been activated per standard business content. No modifications have been made.

4. Dimensional Model (Include InfoProvider, master data, related ODS, and related aggregated cubes)

4.1. Material Stocks/Movements (as of 3.0B) ( 0IC_C03 )

Note: This InfoCube is set to be activated per standard business content.

↔ ↔ Compound Key

» » Navigational Attribute

Navigational Attributes
InfoObject_NAV	Name for NAV	NAV turned on (yes=x)	Standard Business Content	Custom	Reference Section
0PLANT__0COUNTRY	Country Of Plant	X	X
0MATERIAL__0DIVISION	Division	X	X
0MATERIAL__0MATL_CAT	Material Category	X	X
0MATERIAL__0MATL_GROUP	Material Group	X	X
0MATERIAL__0MATL_TYPE	Material Type	X	X

5. DataSource to InfoSource Mappings

5.1. DataSource 2LIS_03_BX to Infosource 2LIS_03_BX

Note: This DataSource assignment has been activated per standard business content. No modifications have been made.

InfoObject (InfoSource)	Description	Data Element in R/3	Field in Transfer Structure	Transfer Routine	Standard Business Content	Custom	Reference
0BASE_UOM	Base Unit	MEINS	BASME	N/A	X
0BATCH	Batch	CHARG_D	CHARG	N/A	X
0BWAPPLNM	Application comp.	RSAPPLNM	BWAPPLNM	N/A	X
0CPPVLC	BW: Purchase Value	MCBW_GEO	BWGEO	N/A	X
0CPQUABU	BW: Amount in BUnitM	MCBW_MNG	BWMNG	N/A	X
0CPSTLC	Sales Val. Loc Curr.	MCBW_GVP	BWGVP	N/A	X
0CPSVLC	BW: Sales Value LC	MCBW_GVO	BWGVO	N/A	X
0INDSPECSTK	Valn of Spec. Stock	KZBWS	KZBWS	N/A	X
0LOC_CURRCY	Local currency	HWAER	HWAER	N/A	X
0MATERIAL	Material	MATNR	MATNR	N/A	X
0PLANT	Plant	WERKS_D	WERKS	N/A	X
0PSTNG_DATE	Posting date	BUDAT	BUDAT	N/A	X
0SOLD_TO	Sold-to party	WEMPF	WEMPF	N/A	X
0STOCKCAT	Stock Category	BSTTYP	BSTTYP	N/A	X
0STOCKTYPE	Stock type	MCBW_BAUS	BSTAUS	N/A	X
0STOR_LOC	Storage location	LGORT_D	LGORT	N/A	X
0VAL_TYPE	Valuation type	BWTAR_D	BWTAR	N/A	X
0VENDOR	Vendor	LIFNR	ELIFN	N/A	X

5.2. DataSource 2LIS_03_BF to Infosource 2LIS_03_BF

Note: This DataSource assignment has been activated per standard business content. No

InfoObject (InfoSource)	Description	Data Element in R/3	Field in Transfer Structure	Transfer Routine	Standard Business Content	Custom	Reference
0STORNO	Reversal indicator	STORNO	STORNO	N/A	X
0RT_PROMO	Promotion	WAKTION	AKTNR	N/A	X
0VAL_CLASS	Valuation class	BKLAS	BKLAS	N/A	X
0DOC_DATE	Document Date	BLDAT	BLDAT	N/A	X
0STOCKTYPE	Stock type	BSTAUS	BSTAUS	N/A	X
0STOCKCAT	Stock Category	BSTTYP	BSTTYP	N/A	X
0PSTNG_DATE	Posting date	BUDAT	BUDAT	N/A	X
0COMP_CODE	Company code	BUKRS	BUKRS	N/A	X
0BWAPPLNM	Application comp.	BWAPPLNM	RSAPPLNM	N/A	X
0MOVETYPE	Movement Type	BWART	BWART	N/A	X
0STOCKRELEV	BW: Stock Relevance	BWBREL	MCBW_BREL	N/A	X
0CPPVLC	BW: Purchase Value	BWGEO	MCBW_GEO	N/A	X
0CPSVLC	BW: Sales Value LC	BWGVO	MCBW_GVO	N/A	X
0CPSTLC	Sales Val. Loc Curr.	BWGVP	MCBW_GVP	N/A	X
0CPQUABU	BW: Amount in BUnitM	BWMNG	MCBW_MNG	N/A	X
0VAL_TYPE	Valuation type	BWTAR	BWTAR_D	N/A	X
0PROCESSKEY	BW: Transaction Key	BWVORG	MCW_BWVORG	N/A	X
0BATCH	Batch	CHARG	CHARG_D	N/A	X
0MATMREA	Reason for Mvt.	GRUND	MB_GRUND	N/A	X
0BUS_AREA	Business area	GSBER	GSBER	N/A	X
0COSTCENTER	Cost Center	KOSTL	KOSTL	N/A	X
0SOLD_TO	Sold-to party	WEMPF	WEMPF	N/A	X
0WHSE_NUM	Warehouse number	LGNUM	LGNUM	N/A	X
0STOR_LOC	Storage location	LGORT	LGORT_D	N/A	X
0STRGE_BIN	Storage bin	LGPLA	LGPLA	N/A	X
0STRGE_TYPE	Storage type	LGTYP	LGTYP	N/A	X
0VENDOR	Vendor	LIFNR	ELIFN	N/A	X
0MATERIAL	Material	MATNR	MATNR	N/A	X
0DOC_NUM	BW: Document Number	KDAUF	KDAUF	N/A	X
0BASE_UOM	Base Unit	MEINS	MEINS	N/A	X
0DOC_YEAR	BW: Document Year	MJAHR	MJAHR	N/A	X
0PROFIT_CTR	Profit Center	PRCTR	PRCTR	N/A	X
0DCINDIC	Debit/Credit	SHKZG	SHKZG	N/A	X
0LOC_CURRCY	Local currency	WAERS	HWAER	N/A	X
0PLANT	Plant	WERKS	WERKS_D	N/A	X
0FISCVARNT	Fiscal Year Variant	NOPOS	MC_NOPOS	N/A	X
0CPNOITEMS	BW: Number	PERIV	PERIV	N/A	X
0CO_AREA	Controlling area	KOKRS	KOKRS	N/A	X
0DOC_ITEM	BW: Document Line No	ZEILE	MBLPO	N/A	X
0VALUE_LC	Amt. in local curr.	DMBTR	MC_DMBTR	N/A	X
0COORDER	Order	AUFNR	AUFNR	N/A	X
0QUANT_B	Qty in Base UoM	MENGE	MC_MENG	N/A	X
0MOVE_PLANT	Receiving Plant	UMWRK	UMWRK	N/A	X
0RECORDMODE	Update Mode	ROCANCEL	ROCANCEL	N/A	X
0RT_RMAPIDA	RMA Phys.Invent.Date			N/A	X
0BWCOUNTER	Counter	BWCOUNTER	MCBW_COUNTER	N/A	X
0INDSPECSTK	Valn of Spec. Stock	KZBWS	KZBWS	N/A	X

5.3. DataSource 2LIS_03_UM to Infosource 2LIS_03_UM

Note: This DataSource assignment has been activated per standard business content. No modifications have been made.

InfoObject (InfoSource)	Description	Data Element in R/3	Field in Transfer Structure	Transfer Routine	Standard Business Content	Custom	Reference
0STORNO	Reversal indicator	STORNO	STORNO	N/A	X
0RT_PROMO	Promotion	WAKTION	AKTNR	N/A	X
0VAL_CLASS	Valuation class	BKLAS	BKLAS	N/A	X
0DOC_DATE	Document Date	BLDAT	BLDAT	N/A	X
0COMP_CODE	Company code	BUKRS	BUKRS	N/A	X
0BWAPPLNM	Application comp.	BWAPPLNM	RSAPPLNM	N/A	X
0MOVETYPE	Movement Type	BWART	BWART	N/A	X
0CPPVLC	BW: Purchase Value	BWGEO	MCBW_GEO	N/A	X
0CPQUABU	BW: Amount in BUnitM	BWMNG	MCBW_MNG	N/A	X
0PROCESSKEY	BW: Transaction Key	BWVORG	MCW_BWVORG	N/A	X
0FISCYEAR	Fiscal year			N/A	X
0BUS_AREA	Business area	GSBER	GSBER	N/A	X
0SOLD_TO	Sold-to party	WEMPF	WEMPF	N/A	X
0DCINDIC	Debit/Credit	SHKZG	SHKZG	N/A	X
0FISCVARNT	Fiscal Year Variant	NOPOS	MC_NOPOS	N/A	X
0CPNOITEMS	BW: Number	PERIV	PERIV	N/A	X
0LOC_CURRCY	Local currency	WAERS	HWAER	N/A	X
0BASE_UOM	Base Unit	MEINS	MEINS	N/A	X
0COSTCENTER	Cost Center	KOSTL	KOSTL	N/A	X
0CO_AREA	Controlling area	KOKRS	KOKRS	N/A	X
0DOC_NUM	BW: Document Number	KDAUF	KDAUF	N/A	X
0MATERIAL	Material	MATNR	MATNR	N/A	X
0PSTNG_DATE	Posting date	BUDAT	BUDAT	N/A	X
0VENDOR	Vendor	LIFNR	ELIFN	N/A	X
0PLANT	Plant	WERKS	WERKS_D	N/A	X
0QUANT_B	Qty in Base UoM	MENGE	MC_MENG	N/A	X
0VALUE_LC	Amt. in local curr.	DMBTR	MC_DMBTR	N/A	X
0RECORDMODE	Update Mode	ROCANCEL	ROCANCEL	N/A	X
0STOCKCAT	Stock Category	ROCANCEL	ROCANCEL	N/A	X
0STOCKTYPE	Stock type	BSTAUS	BSTAUS	N/A	X
0INDSPECSTK	Valn of Spec. Stock	KZBWS	KZBWS	N/A	X

6. Update Rules to Data Target

6.1. InfoSource 2LIS_03_BF to Data Target Z0IC_ODS1