bw confguide en

SAP ECC 5.00 August 2006

English

BW-R/3 Customizing

SAP AGDietmarr-Hopp-Allee 1669190 WalldorfGermany

SAP Best Practices Retail Organization: Configuration Guide

Copyright

© Copyright 2006 SAP AG. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

Microsoft, Windows, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.

IBM, DB2, DB2 Universal Database, OS/2, Parallel Sysplex, MVS/ESA, AIX, S/390, AS/400, OS/390, OS/400, iSeries, pSeries, xSeries, zSeries, z/OS, AFP, Intelligent Miner, WebSphere, Netfinity, Tivoli, and Informix are trademarks or registered trademarks of IBM Corporation.

Oracle is a registered trademark of Oracle Corporation.

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.

HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

Java is a registered trademark of Sun Microsystems, Inc.

JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.

MaxDB is a trademark of MySQL AB, Sweden.

SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

© SAP AG of 43

Key:

<XXX> Variable entries

'XXX' Fixed entries

[XXX] Pushbutton


Icons

Icon Meaning

Caution

Example

Note or Tip

Recommendation

Syntax

Typographic Conventions

Type Style Description

Example text Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths and options.

Cross-references to other documentation.

Example text Emphasized words or phrases in body text, titles of graphics and tables.

EXAMPLE TEXT Names of elements in the system. These include report names, program names, transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE.

Example text Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools.

EXAMPLE TEXT Keys on the keyboard, for example, function keys (such as F2) or the ENTER key.

Example text Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.

<Example text> Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.

© SAP AG of 43


Table of Contents

1 Customizing Guide: BW Customizing in R3.............................................................................5

Introduction..................................................................................................................................... 5

1.1 Transfer Application Component Hierarchy......................................................................5

1.2 Transfer Business Content Data Source..........................................................................6

1.3 BW Update Methods........................................................................................................7

1.3.1 Full Update................................................................................................................8

1.3.2 Delta Init Process......................................................................................................8

1.3.3 Delta Method.............................................................................................................8

1.4 Settings for Application-Specific Data Sources (PI)..........................................................9

1.5 Activate Data Sources....................................................................................................12

1.6 Filling Set Up Tables......................................................................................................16

1.6.1 Restricted access to source system........................................................................16

1.6.2 Delete the content of the set up tables....................................................................16

1.7 Delta Init......................................................................................................................... 21

1.8 Job Control in LO Data Extraction: Customizing Cockpit................................................23

2 Connection between source system R/3 and BW..................................................................27

2.1 Basic Configurations in BW............................................................................................37

2.1.1 Replicate Data sources...........................................................................................42

© SAP AG of 43


1 Customizing Guide: BW Customizing in R3

IntroductionIn this document are the steps that need to be completed in order to customize in the source system R/3 to extract information to BW System. It shows how to activate the standard business content. Also the data sources that should be used for master data and transactional data and the special customizing for each application.

The modules that are shown in this document are: MM, SD, and Retail.

1.1 Transfer Application Component Hierarchy.Path: SBIW->Business Content Data Source-> Transfer Application Component Hierarchy.

The system shows the message “Do you want the component application Transfer Component Hierarchy“Choose YES

© SAP AG of 43


The following message appears: The application component hierarchy was transferred from the content

1.2 Transfer Business Content Data Source

Path: SBIW->Business Content Data Source-> Transfer Business Content Data Source.

© SAP AG of 43


During this activity extraction structures that will be used to send information from R3 to BW.

The transactional data that are related due to its nature are stored in the source system in Data Source. The Data sources are flat structures that have a list of fields. This structure is used to send information from R/3 to BW.

The Data Sources have their counterpart in BW as Info Sources.

The Data sources have the following classification:

Master Data

Transactional Data

Also the master data are divided in Attributes, Texts and Hierarchies.

The Data sources are grouped by module (FI, MM, SD, IS retail, etc.).

1.3 BW Update MethodsThe methods to extract information from info source system SAP R/3 to BW are: Full Update, Delta Process, and Repair Full Request.

1.3.1 Full Update

© SAP AG of 43


If the company needs that the historic information will be uploaded in BW system, it is necessary to use this method, as initial upload. This process is possible only if you already have executed the filling up set up process (see 1.5) because here is when the information is ready to be sent to BW.

You must be careful with FULL uploads because with this method it is not possible to control which information already was sent to BW. This could make that you have duplicated information in BW

1.3.2 Delta Init ProcessThis activity is required to delta method. The Delta Init process indicates to the source system the mark where the new information extraction to BW will begin. This delta init could happen with or without historical information upload.

1.3.3 Delta MethodWith this process the new information that is generated daily in the source system must be sent to BW. The principal reason fort this is the information volume that is imported to BW every day.

This information is stored en the delta queue (RSA7 Transaction). It is taken from here when BW asks for information to the source system. In the Delta Queue will only be the information that has not been sent to BW and the last request.

The Data sources that should be used are:

Master Data

0ARTICLE_ATTR

0ARTICLE_TEXT

0CUSTOMER_ATTR

0CUSTOMER_TEXT

0PLANT_ATTR

0PLANT_TEXT

0MATL_GROUP_TEXT

0MAT_VEND_ATTR

0VENDOR_ATTR

0VENDOR_TEXT

0SALESORG_ATTR

0SALESORG_TEXT

0SALES_DIST_TEXT

0SALES_GRP_TEXT

0SALES_OFF_TEXT

0SALESORG_ATTR

0SALESORG_TEXT

0SALES_DIST_TEXT

0SALES_GRP_TEXT

© SAP AG of 43


0SALES_OFF_TEXT

TRANSACTIONAL DATA

2LIS_02_SCL

2LIS_03_BF

2LIS_03_BX

2LIS_03_UM

2LIS_13_VDITM

2LIS_40_REVAL

In the screen Installation of Data Source from Business Content, you must mark the data source that you want to activate and select Activate Data Source.

1.4 Settings for Application-Specific Data Sources (PI)For Purchase transactional data sources Retail Industry Sector must be specified.

Path SBIW->Settings for Application-Specific Data Sources (PI) ->Logistics-> Settings: Purchasing->Determine Industry Sector.

© SAP AG of 43


In the Screen Change View „“Derivation maintenance for transfer into SAP BW“: Details you must mark Retail and press save.

© SAP AG of 43


These settings must be done also for Stocks data sources.

Path SBIW->Settings for Application-Specific Data Sources (PI)->Logistics-> Settings: Inventory Controlling->Determine Industry Sector.

In the Screen Change View „“Derivation maintenance for transfer into SAP BW“: Details you must mark Retail and press save.

© SAP AG of 43


1.5 Activate Data SourcesThis activity is needed for the extraction structure could receive information, also to schedule when the information will be sent to the delta queue.

Path SBIW->Settings for Application-Specific Data Sources (PI)->Logistics->Managing Extract Structures->Logistics Extraction Structure Customizing Cockpit

© SAP AG of 43


In the LO Data Extraction: Customizing Cockpit you have to choose the data sources that will be used to get information from R3 to BW. This activity only applies for transactional data.

© SAP AG of 43


In the column of Update for every data source to change the status from inactive to active.

The system will show the MCEX 146 message. It is important to read it because it explains the different methods of update. The update method that is recommended is Queued Delta.

© SAP AG of 43


Accept the message with intro. Once you have done this the status will change from Inactive to active and the traffic light will change from yellow to green.

© SAP AG of 43


1.6 Filling Set Up TablesIn this step the data sources are filled with the data that is needed in BW. This step must be executed for every data source.

This activity is necessary only if the company needs historic information. If not you can make delta init process.

The requirements to execute this process are the following:

1.6.1 Restricted access to source systemWhen the filling set up tables process is running, nobody should be working in the system, because it could make that the result of some transaction that occurs during this process may not be taken by the filling up process

1.6.2 Delete the content of the set up tables

As a previous step you must delete the content of the set up tables. This is necessary to avoid that the information in the set tables will be duplicated.

Path SBIW->Settings for Application-Specific Data Sources (PI)->Logistics->Managing Extract Structures->Initialization->Delete the content of the set up tables.

© SAP AG of 43


In the screen Deletion of Set up Data should select application, and execute F8

02 Purchasing

03 Inventory Controlling

13 SD Billing

40 Retailing

Once you have selected the application, the system will delete the data of all the data sources that belongs to this application.

© SAP AG of 43


When the process is completed the following message „“Data will be lost, do you want to delete the restructure tables“Choose Yes.

© SAP AG of 43


The system will send the message “Set up tables deleted successfully“

Filling In the set up tables

Path SBIW->Settings for Application-Specific Data Sources (PI)->Logistics->Managing Extract Structures->Initialization->Filling in the set up tables->Perform set up-Purchasing

© SAP AG of 43


Depending on the application (purchasing, billing, stocks) you can chose different parameters to select the information that must be set up. You can set up the information for one document or for a group of documents, as specific date or a store.

If the following message appears when you execute this process “No extraction structure active or no BW connected“

© SAP AG of 43


And you already have executed the process Activate Data source you must have the connection between SAP R3 and BW.

1.7 Delta Init

This activity must be done in BW System. Once you have made de Delta initialization for a data source it is shown in the Delta Queue of the source system

SBIW->General Settings->Check Delta Queue

© SAP AG of 43


BW Delta Queue Maintenance

© SAP AG of 43


1.8 Job Control in LO Data Extraction: Customizing Cockpit

After Delta Init it is necessary to make de setting for the job that will be sending information from the different transactions to the delta Queue to be extracted to BW.

Path

SBIW->Setting for Application-Specific Data Sources (PI)->Logistics->managing Extract Structures->Logistic Extraction Structures Customizing Cockpit

In the screen LO Data Extraction: Customizing Cockpit select Job Control

© SAP AG of 43


The system will show the screen to set up the parameters for the job. Select start date and set the hour and the date when the job must start. The Job must be a periodic Job

© SAP AG of 43


Then press print parameters

© SAP AG of 43


Set LP01 as the output device

© SAP AG of 43


Then press Schedule Job

2 Connection between source system R/3 and BW

Path Modeling->Administration Workbench: Modeling RSA1

© SAP AG of 43


In the Administration Workbench: Modeling screen I the modeling section select Source System.

© SAP AG of 43


In the screen Create SAP Source System you should enter the following information in the “or create new destination” section

Target Computer (Server): The name of the server where the source system is installed.

System ID (System Name): The identification of the source system (PRD, DEV)

System Number

Background user in source system: This is the user that the system uses to make the connection in background between R/3 and BW. The system suggests ALEREMOTE

Password for source system user.

Repeat password.

In the “connection of source system to BW” section

Background user in BW: The system suggests ALEREMOTE

Password for source system user.

Repeat password.

© SAP AG of 43


Pres enter and the system will send the following message “Please log on as an administrator in the following screen”

© SAP AG of 43


At this moment the connection between R/3 and BW is generated, so you need to log on to the source system with a user id and password of the source system.

© SAP AG of 43


In the RFC destination XXXXX you have to press save and then back

After doing this the system will send the message “Additional to activation replicate metadata?”

You should select “Replicate as well”

© SAP AG of 43


2.1 Basic Configurations in BW

With the source system created, the first activity you have to do is transfer the global settings from the source system to BW. The global settings are:

Currencies

Units of measurement

Fiscal years variants

Factory Calendar

Select the source system, press right button and select “transfer global settings”

© SAP AG of 43


In the screen transfer global settings: selection, mark:

Currencies

Units of measurement

Fiscal year variant

In the mode section mark: Update tables

Press execute

© SAP AG of 43


2.1.1 Replicate Data sources

To make BW able to detect the business content that is activated in the source system R/3 you must execute this step. Also is necessary when you make some changes in the data sources.

Select the source system and press right button, and select Replicate data sources.

© SAP AG of 43

bw confguide en

Documents