1 of 55

SAP Plant Maintenance

​

ECC6 EhP7

Understanding Data Flow

in the BW system

3.x2 and 7.0 BW Data Flow

.a Multi-Provider Data Flow

and a Data Store example

2 of 55

  1. Data flow 3.x2.
  2. BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  3. BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  4. BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  5. BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  6. BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  7. BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  8. Data flow 7.0
  9. BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  10. Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  11. Data Store (RSA1).

3 of 55

Data flow 3.x2

4 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

5 of 55

use RSA1

to understand

the BW Info Cube Data Flow

6 of 55

Info cube

0PM_C01

Double-click

7 of 55

Info Cube Technical name

0PM_C01

“3 Green Triangles”

are Dimensions

In the Dimensions are the Characteristics

8 of 55

Key figures

9 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

10 of 55

Right click the

Info Cube

and select

“Display Data Flow”

11 of 55

Objects below the Info Cube

12 of 55

DATA SOURCE

SOURCE SYSTEM

INFO SOURCE

TRANSFER RULES

UPDATE RULES

INFO

PROVIDER

13 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

14 of 55

Double-click

the

DATA SOURCE

15 of 55

Source System in the ERP

16 of 55

Data Selection to be uploaded from Source System to the Info Provider

17 of 55

Data Load methods from ERP to the BW system

18 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

19 of 55

There are 3 components in the Source System

  • Extractor
  • Extraction Structure
  • Transfer Structure

There are 3 components in the Source System

  • Extractor
  • Extraction Structure
  • Transfer Structure

20 of 55

There are 3 components in the Source System

  • Extractor
  • Extraction Structure
  • Transfer Structure

21 of 55

There are 3 components in the Source System

  • Extractor
  • Extraction Structure
  • Transfer Structure

22 of 55

0_PM_OM_OPA_1

23 of 55

Goto the Contents to check the Extractor for 0_PM_OM_OPA_1

​

SE11

Database table

ROOSOURCE

​

24 of 55

check the Extractor for 0_PM_OM_OPA_1

​

PMEX_PM_GET_ORDCST

is

the EXTTRACTOR

25 of 55

PMEX_PM_GET_ORDCST

Function Module

in SE80

​

26 of 55

the Extractor PMEX_PM_GET_ORDCST

is

an ABAP program for Extracting data from Extraction Structure to the Transfer Structure

​

27 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

28 of 55

There are 3 components in the Source System

  • Extractor
  • Extraction Structure
  • Transfer Structure

29 of 55

The Extractor gets data from the Extraction Structure to the Transfer Structure

30 of 55

The Transfer Rule

Stage the Data

from the Transfer Structure to the

Communication Structure

in the INFO SOURCE

31 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

32 of 55

There are 2 components in the Info Source

  • Communication Structure
  • Update Rules

There are 2 components in the Info Source

  • Communication Structure
  • Update Rules

33 of 55

Communication Structure

Transfer Rules

Transfer Structure

Extractor

Extraction Structure

Data Source

34 of 55

35 of 55

36 of 55

There are 2 components in the Info Source

  • Communication Structure
  • Update Rules

There are 2 components in the Info Source

  • Communication Structure
  • Update Rules

37 of 55

UPDATE RULEs

An update rule specifies how data will be updated into a target which can be either the Info Cube or ODS Object

38 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

39 of 55

Data flow 7.0

40 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

41 of 55

0PM_C01

based on 3.x2 where

InfoSource is

MANDATORY

0PM_C13

based on 7.0 where

InfoSource is

OPTIONAL

42 of 55

0PM_C13

right-click

select “Display Data Flow”

43 of 55

Source System

Data Source

Update Rule

Notice there isn’t any INFO SOURCE

(or Communication Structure)

44 of 55

3.x2

InfoSource

is

Mandatory

7.0

InfoSource

is

Optional

45 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

46 of 55

0PM_MP04

is a Multi-Provider

47 of 55

the 0PM_MP04

is Multi-Provider

…

double-click

and the pop-up

indicate data is from 2 InfoCubes

48 of 55

Data for 2 Info Cubes

49 of 55

Multiple

Source System

Multiple

Info Source

50 of 55

the 0PM_MP04

Multi-Provider

also has

Characteristics, Key Figures, and Time Characteristics

51 of 55

  • Data flow 3.x2.
  • BW Data Flow 0PM_C01 (3.x2) - Info Cube (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Flow (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Source System (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Data Source (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Transfer Rule & Transfer Structure (RSA1).
  • BW Data Flow 0PM_C01 (3.x2) - Info Source’s Communication Structure (RSA1).
  • Data flow 7.0
  • BW Data Flow 0PM_C13 (7.0) - Data Flow (RSA1).
  • Data flow Multiple Provider 0PMMP04 - Data Flow (RSA1).
  • Data Store (RSA1).

52 of 55

the 0PM_DS02

is a Data STORE

53 of 55

the 0PM_C08

is a 3.x2 data flow info cube

it has a Data Model

with Dimensions (within it Characteristics)

the 0PM_MP04

is Data Store

it does not have a Data Model as the Data is FLAT (without DImensions)

54 of 55

0PM_DS01

is a Data STORE

0PM_DS02

is a Data STORE

INFO SOURCE

SOURCE SYSTEM

UPDATE RULE

from 0PM_DS01

to 0PM_DS02

UPDATE RULE

from InfoSource

to 0PM_DS01

TRANSFER RULE

55 of 55

A BW DataStore Object is the object which represents a flat physical table. In a dataflow, it is typically used as an Enterprise Data Warehouse layer, to store (historical) transactional data before it is transferred to the reporting layer.