BW Infoprovider Design Specifications

BW InfoProvider Design Specifications

InfoProvider Identification
InfoProvider Name: / InfoCube: SCM-MMPUR: Purchasing Data - 0PUR_C01
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: / Rahul Easwar / 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

With the data of the InfoCube Purchasing Data, you can carry out analyses of material groups, vendors, and materials. This data enables you to find answers to the following questions, for example: "Which materials and how much of each have been ordered from a certain vendor?" "How many PO items are there for a certain material group?"

The InfoSources and DataSources are:

InfoSource / Description / DataSource
2LIS_02_SCL / Purchasing Data (Document Schedule Line Level) / 2LIS_02_SCL
2LIS_02_ITM / Purchasing Data (Document Item Level) / 2LIS_02_ITM

In combination with the InfoSources 2LIS_02_SCL and 2LIS_02_ITM supplies the basic data for analyses of purchasing documents.

Standard reports such as the following are available:

• Invoice Variances
• Goods Receipt Variances
• Ordering Activities
• Purchase Order Quantities
• Purchase Order Values
• Average Time Delivery Material
• Average Time Delivery Vendor

RICE Number / Description
<insert report names here >
…

ASSUMPTIONS:

1. Data Flow

1. Business Content Installation
2. R/3: Data Transfer to the SAP Business Information Warehouse
3. Classification:

Standard Business Content

Standard Business Content w/ ModificationsRefer to: ______

CustomRefer to: ______

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

DataSource: 2LIS_02_ITM and 2LIS_02_SCL

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/ ModificationsRefer to: ______

CustomRefer to: ______

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

Application Component(s): Materials Management

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

DataSourceInfoSource

2LIS_02_ITM2LIS_02_ITM

2LIS_02_SCL2LIS_02_SCL

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: 0PUR_C01

3.3.1.Classification:

Standard Business Content

Standard Business Content w/ ModificationsRefer to: ______

CustomRefer 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 CollectionRefer to: ______

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

Object: 0PUR_C01

3.3.2.4.Install

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

1. 
   Dimensional Model(Include InfoProvider, master data, related ODS, and related aggregated cubes)
2. SCM-MMPUR: Purchasing Data (0PUR_C01)

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
0MATERIAL__0DIVISION / Division / X / X
0MATERIAL__0IND_SECTOR / Industry / X / X
0MATERIAL__0MATL_GROUP / Material Group / X / X
0MATERIAL__0MATL_TYPE / Material Type / X / X
0VENDOR__0BPARTNER / Business Partner / X / X
0VENDOR__0COUNTRY / Country / X / X
0VENDOR__0DBDUNS_NUM / D-U-N-S Number / X / X
0VENDOR__0INDUSTRY / Industry / X / X
0VENDOR__0POSTAL_CD / Postal Code / X / X
0VENDOR__0REGION / Region / X / X

1. DataSource to InfoSource Mappings

5.1.DataSource 2LIS_02_ITM to Infosource 2LIS_02_ITM

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

5.2.DataSource 2LIS_02_SCL to Infosource 2LIS_02_SCL

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

1. Update Rules to Data Target

6.1.InfoSource 2LIS_02_SCL to Data Target ZPUR_O01

Note: Note: This Data Target mapping has been activated per standard business content. No modifications have been made.

6.2.InfoSource 2LIS_02_ITM to Data Target ZPUR_O01

Note: Note: This Data Target mapping has been activated per standard business content. No modifications have been made.

6.3.InfoSource ZPUR_O01 to Data Target 0PUR_C01

Note: Note: This Data Target mapping has been activated per standard business content. No modifications have been made.

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.

Options

/

Active?

BEx Reporting

ODS Object Type Standard

Unique Data Records

Check table for InfoObject

Set quality status to 'OK' automatically

Activate ODS object data automatically

Update data targets from ODS object automatically

InfoObject (Data Target) / Description / InfoObject (InfoSource) / Update Routine / Standard Business Content / Key Field / Custom / Reference Section
0DOC_NUM / BW: Document Number / N/A / X
0DOC_ITEM / BW: Document Line No / N/A / x
0MATERIAL / Material / N/A
0PLANT / Plant / N/A
0SCHED_LINE / Schedule Line / N/A / X
0VENDOR / Vendor / N/A
0BASE_UOM / Base Unit / N/A
0BATCH / Batch / N/A
0BEST_SCORE / Best score / N/A
0BWAPPLNM / Application comp. / N/A
0COMPL_DEL / Final Delivery / N/A
0CONT_ITEM / Item of Princ. Agmt. / N/A
0CONTRACT / Contract / N/A
0CPDEOGPVOC / Delta PO/GR CP / N/A
0CPDEOGQUOU / Delta PO/GR Order / N/A
0CPPVLC / BW: Purchase Value / N/A
0CPPVOC / Cost Value PurchCur. / N/A
0CPQUAOU / BW: Amount as OUn / N/A
0CPSTLC / Sales Val. Loc Curr. / N/A
0CPSVLC / BW: Sales Value LC / N/A
0CRIT_MAIN / Eval. criterion / N/A
0CURR_GRQTY / Current GR qty / N/A
0DEL_DEVTN / Delivery date var. / N/A
0DELIVERIES / Deliveries / N/A
0DENOMINTR / Denominator(divisor) / N/A
0DLV_COSTS / Delivery Costs / N/A
0DOC_CAT / Purch. doc. category / N/A
0DOC_DATE / Document Date / N/A
0DOC_TIME / Doc. creation date / N/A
0DOCTYPE / Purchasing doc. type / N/A
0ENTRY_DATE / Created on / N/A
0EVAL_R_S / Eval. Receipt Sett. / N/A
0EXCHG_RATE / Exchange rate / N/A
0FINAL_INV / Final Invoice / N/A
0FISCVARNT / Fiscal Year Variant / N/A
0GN_R3_SSY / Srce Syst. R/3 Entty / N/A
0GR_BASE_IV / GR-Based Inv. Verif. / N/A
0GR_RE_IND / Goods Receipt / N/A
0INV_PARTY / Invoicing party / N/A
0INV_PTY / Different inv. party / N/A
0INV_RE_IND / Invoice Receipt / N/A
0ITEM_COUNT / Item counter / N/A
0ITM_CAT / Item Category / N/A
0LOC_CURRCY / Local currency / N/A
0LOG_SYS / Logical System / N/A
0LOG_SYS_BE / Log. System Backend / N/A
0LOGSYS_PUR / Log. Proc. System / N/A
0MATL_GROUP / Material group / N/A
0MPN_MATNR / Manufacturer part / N/A
0NET_PO_VAL / Net order value / N/A
0NETPRICE / Net price / N/A
0NO_POS / Counter for items / N/A
0NO_QUAN / Counter for qties. / N/A
0NO_RMDRS / Number of expediters / N/A
0NO_SCL / Counter f. SAS lines / N/A
0NO_TIME / Counter f. date grid / N/A
0NUMERATOR / Numerator for / N/A
0ONT_DEL / Points f. o/t deliv. / N/A
0ORD_ADDR / Ordering address / N/A
0ORDER_CURR / PurchOrderCurrency / N/A
0ORDER_QUAN / Order quantity / N/A
0ORDER_VAL / Order value / N/A
0OUTAGTARGT / Target Value / N/A
0PARTNER / Partner vendor / N/A
0PO_STATUS / Purch. doc. status / N/A
0PO_UNIT / Order unit / N/A
0PRICE_UNIT / Price unit / N/A
0PROCESSKEY / BW: Transaction Key / N/A
0PROD_DESCR / Product Description / N/A
0PSTNG_DATE / Posting date / N/A
0PUR_GROUP / Purchasing group / N/A
0PUR_GROVAL / PO Value (OrderCrcy) / N/A
0PUR_REASON / Reason for Ordering / N/A
0PURCH_ORG / Purchasing org. / N/A
0QTY_DEV / Quantity variance / N/A
0QTY_REL / Quantity reliability / N/A
0QTY_VAR / Qty variance / N/A
0QUAN_INT / Interval for qties. / N/A
0RECORDMODE / Update Mode / N/A
0REQUESTER / Requester / N/A
0RT_PROMO / Promotion / N/A
0SCHED_DATE / Schedule line date / N/A
0SCHED_DEV / Date variance / N/A
0SCHED_TIME / Sch. line time-spot / N/A
0SCL_DELDAT / Sch. line del. date / N/A
0SHIP_NOT / Points: Ship. notif. / N/A
0SHP_INS / Compl.shipping inst. / N/A
0SMOOTH_DEL / Sm.fc.date var. / N/A
0SMOOTH_QTY / Sm.fact.qty.var / N/A
0SMOOTH_SHP / Smth.shipp.inst / N/A
0SR_SCENA / Technical Scenario / N/A
0SR_VE_VAL / Criteria Valuation / N/A
0SRV_QUAL / Service quality / N/A
0SRV_TIME / Service timeliness / N/A
0STAT_DATE / Statistics date / N/A
0STOR_LOC / Storage location / N/A
0STORNO / Reversal indicator / N/A
0SUBTOT_OC1 / Subtotal 1 / N/A
0SUBTOT_OC2 / Subtotal 2 / N/A
0SUBTOT_OC3 / Subtotal 3 / N/A
0SUBTOT_OC4 / Subtotal 4 / N/A
0SUBTOT_OC5 / Subtotal 5 / N/A
0SUBTOT_OC6 / Subtotal 6 / N/A
0SUP_PLANT / Supplying plant / N/A
0SUPP_PLANT / Supplying Plant / N/A
0SUPPL_VEND / Supplying vendor / N/A
0SUPPLIER / Goods supplier / N/A
0TARG_QTY / Target quantity / N/A
0TIME_INT / Interval for date / N/A
0TOTDELTIME / Total del.time / N/A
0VAL_END / Validity period end / N/A
0VAL_START / Validity Per. Start / N/A

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/04/2006 Page 1 of 17