BW InfoProvider Design Specifications
InfoProvider IdentificationInfoProvider Name: / InfoCube: 0SD_C01 - Customers
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: / Craig Schneider / Date Created: / 03/31/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 contains costs, quantities and net values of sales orders by customer (sold-to). Costs, quantities and values of credit memos and returns are also provided. Open order details are also provided.
The InfoSources and DataSources are:
InfoSource / Description / DataSource2LIS_01_S001 / SD Customer / 2LIS_01_S001
The InfoSource 2LIS_01_S001 provides totals records for all those customers for whom sales documents have been created.
Standard reports such as the following are available:
· Sales Volume
· Top Customers
· Customer Returns
· Product Profitability Analysis
· Distribution Channel Analysis
RICE Number / Description<insert report names here >
…
ASSUMPTIONS:
· Summary Level Reports will be run at the InfoCube level.
· Drill through functionality will enable access to other related ODS objects
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
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_01_S001
Source System:
F Box (Development Client TBD)
G Box (Development Client TBD)
E Box (Development Client TBD)
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): Sales & Distribution
3.2.3. In each of the designated source systems, assign the following DataSource - InfoSource relationships:
DataSource InfoSource
2LIS_01_S001 2LIS_01_S001
Source System:
F Box (Development Client TBD)
G Box (Development Client TBD)
E Box (Development Client TBD)
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: 0SD_C01
3.3.1. Classification:
Standard Business Content
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
In Data Flow Afterwards
In Data Flow Before & Afterwards
3.3.2.2. Set ‘Collection Mode’ to:
Collect Autmatically
Start Manual Collection Refer to: ______
3.3.2.3. Insert the following object(s) for Collection:
Object: 0SD_C01
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. Customers (0SD_C01)
Note: This InfoCube is set to be activated per standard business content.
↔ Compound Key
» Navigational Attribute
Navigational AttributesInfoObject_NAV / Name for NAV / NAV turned on (yes=x) / Standard Business Content / Custom / Reference Section
0MATERIAL__0MATL_GROUP / Material Group / X / X
0MATERIAL__0MATL_TYPE / Material Type / X / X
0MATERIAL__0PROD_HIER / Product Hierarchy / X / X
0SOLD_TO__0BPARTNER / Business Partner Number for Sold / X / X
0SOLD_TO__0COUNTRY / Country of Sold-to Party / X / X
0SOLD_TO__0INDUSTRY / Industry of the sold-to party / X / X
5. DataSource to InfoSource Mappings
5.1. DataSource 2LIS_01_S001 to Infosource 2LIS_01_S001
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 / Reference0VERSION / Version / VRSIO / VRSIO / N/A / X
0VTYPE / Value type / RSVTYPE / WRTTP / N/A / X
0REVERSEDOC / Cancel / STORNO / STORNO / N/A / X
0SOLD_TO / Sold-to party / KUNAG / KUNNR / N/A / X
0SALESORG / Sales organization / VKORG / VKORG / N/A / X
0DISTR_CHAN / Distribution channel / VTWEG / VTWEG / N/A / X
0DIVISION / Division / SPART / SPART / N/A / X
0MATERIAL / Material / MATNR / MATNR / N/A / X
0FISCVARNT / Fiscal year variant / PERIV / PERIV / N/A / X
0FISCPER / Fiscal year/period / RSFISCPER / SPBUP / N/A / X
0CALWEEK / Calendar year/week / RSCALWEEK / SPWOC / N/A / X
0CALDAY / Calendar day / RSCALDAY / SPTAG / N/A / X
0CALMONTH / Cal. year/month / RSCALMONTH / SPMON / N/A / X
0BASE_UOM / Base unit of measure / MEINS / BASME / N/A / X
0STAT_CURR / Statistics currency / WAERS_V / STWAE / N/A / X
0OPORDQTYBM / Order quantity / MC_OAUME / N/A / X
0INVCD_QTY / Invoiced quantity / MC_UMMENGE / UMMENGE / N/A / X
0INCORDQTY / Incoming orders qty / MC_AEMENGE / AEMENGE / N/A / X
0CRMEM_VAL / Credit memos / MC_GUNETWR / GUNETWR / N/A / X
0RTNSVAL / Returns / MC_RENETWR / RENETWR / N/A / X
0OPORDVALSC / Open orders / MC_OAUWE / N/A / X
0INVCD_VAL / Invoiced sales / MC_UMNETWR / UMNETWR / N/A / X
0INCORDVAL / Incoming orders / MC_AENETWR / AENETWR / N/A / X
0CRMEM_CST / Credit memos: cost / MC_GUWAVWR / GUWAVWR / N/A / X
0RTNSCST / Returns: cost / MC_REWAVWR / REWAVWR / N/A / X
0INVCD_CST / Invoiced sls: cost / MC_UMWAVWR / UMWAVWR / N/A / X
0INCORDCST / Orders: cost / MC_AEWAVWR / AEWAVWR / N/A / X
0RTNSQTY / Returns qty / MC_REMENGE / REMENGE / N/A / X
0CRMEM_QTY / Credit memos qty / MC_GUMENGE / GUMENGE / N/A / X
0ORD_ITEMS / Order items / MC_ANZAUPO / ANZAUPOS / N/A / X
0RTNS_ITEMS / Returns items / MC_ANZREPO / ANZREPOS / N/A / X
6. Update Rules to Data Target
6.1. InfoSource 2LIS_01_S001 to Data Target 0SD_C01
Note: Note: This Data Target mapping has been activated per standard business content. No modifications have been made.
InfoObject (Data Target) / Description / InfoObject (InfoSource) / Update Routine / Standard Business Content / Custom / Reference Section0DISTR_CHAN / Distribution channel / 0CO_AREA / N/A / X
0DIVISION / Division / 0CO_DOC_NO / N/A / X
0MATERIAL / Material number / 0CO_ITEM_NO / N/A / X
0SALESORG / Sales organization / 0FISCVARNT / N/A / X
0SOLD_TO / Sold-to party / 0FISCPER / N/A / X
0VERSION / Version / 0COSTCENTER / N/A / X
0VTYPE / Value type for reporting / 0ACTTYPE / N/A / X
0CALDAY / Calendar day / 0CALDAY / N/A / X
0CALMONTH / Calendar year / month / 0CALMONTH / N/A / X
0CALWEEK / Calendar year / week / 0CALWEEK / N/A / X
0FISCPER / Fiscal year / period / 0FISCPER / N/A / X
0FISCVARNT / Fiscal year variant / 0FISCVARNT / N/A / X
0CRMEM_CST / Credit memo cost / 0CRMEM_CST / N/A / X
0CRMEM_QTY / Credit memo quantity / 0CRMEM_QTY / N/A / X
0CRMEM_VAL / Net value of credit memos / 0CRMEM_VAL / N/A / X
0INCORDCST / Cost of incoming orders / 0INCORDCST / N/A / X
0INCORDQTY / Quantity of incoming orders / 0INCORDQTY / N/A / X
0INCORDVAL / Net value of incoming orders / 0INCORDVAL / N/A / X
0INVCD_CST / Cost of invoiced sales / 0INVCD_CST / N/A / X
0INVCD_QTY / Invoiced quantity / 0INVCD_QTY / N/A / X
0INVCD_VAL / Net value of invoiced sales / 0INVCD_VAL / N/A / X
0OPORDQTYBM / Open orders quantity in base unit of measure / 0OPORDQTYBM / N/A / X
0OPORDVALSC / Net value of open orders / 0OPORDVALSC / N/A / X
0ORD_ITEMS / Number of order items / 0ORD_ITEMS / N/A / X
0RTNSCST / Cost of incoming returns / 0RTNSCST / N/A / X
0RTNSQTY / Returns quantity / 0RTNSQTY / N/A / X
0RTNSVAL / Net value of incoming returns / 0RTNSVAL / N/A / X
0RTNS_ITEMS / Number of returns items / 0RTNS_ITEMS / N/A / X
0STAT_CURR / Statistics currency / 0STAT_CURR / N/A / X
0BASE_UOM / Base unit of measure / 0BASE_UOM / N/A / X
7. Custom Data Mappings
N/A
8. Custom Table Definitions
N/A
9. Security Design (Authorization Objects)
TBD
10. Additional Design Specifications
There are no special design specifications for this cube.
A. Appendix
The following sections will explain in detail any customization that needs to be performed in the respective areas
I. InfoObjects
This section contains configuration settings required for custom / customized info objects.
II. DataSources
This section contains configuration settings required for custom / customized data sources.
III. InfoSources
This section contains configuration settings required for custom / customized info objects.
a. Transfer Rules
This section contains configuration settings required for custom / customized transfer rules.
b. Communication Structures
This section contains configuration settings required for custom / customized communication structures.
IV. ODS
This section contains configuration settings required for custom / customized ODS.
V. InfoCube
This section contains configuration settings required for custom / customized Info Cube.
VI. Update Rules
This section contains configuration settings required for custom / customized Update Rules.
a. Into ODS
This section contains configuration settings required for custom / customized update rules into ODS.
b. Into InfoCube
This section contains configuration settings required for custom / customized update rules into Info Cube.
Last modified: 04/03/2006 Page 9 of 16