-Topic : InfoPackage Settings

-Presented By:

1
InfoPackage Settings

Topics

1 • Introduction

2 • Different tabs in Infopackage

3 • Data Selections in Infopackage

4 • External Data tab in Infopackage

5 • Processing modes

6 • Update Modes

7 • Error Handling

8 • Scheduling Of Infopackage

2
InfoPackage Settings

1 •Introduction

-InfoPackage is used to schedule the data loads.

-The properties of Infopackage will always be depending on the properties of

DataSource.
-Incase of BW3.x , Infopackage will extract data from Source System and updates
to Data Target.

-Incase of BI7.0, InfoPackage will extract data from Source System and load to PSA
only. It will not update to Data Target , to upload from PSA to Data Target we use
the concept called ‘DTP’.

3
InfoPackage Settings

2 •Different tabs in Infopackage

-Infopackage will have different tabs like

‘Data Selection’ , ‘Extraction’ , ’Processing’ , ‘Data Target’ , ‘Update’ , ‘Schedule’.

4
InfoPackage Settings

Note : In case of R/3 or DB Connect and Flat File one small change is there in Infopackage
observe it.

SAP R/3 or DB
Connect

Flat file

5
InfoPackage Settings

3 •Data Selections in Infopackage

We use ‘Data Selections’ to extract data from Source System selectively.

How to enable fields for Data Selections.

Different ways of Data Selections.
Fixed Data Selections.
Dynamic Selections.
- ABAP/4 Routine
- OLAP Variable

6
InfoPackage Settings

How to enable fields for Data Selections.

Enabling a field for data selection depends on “Source system” & “Data Flow
version (3.x or 7.x)”.

7
InfoPackage Settings

Source System SAP R/3 or ECC

Data Flow version 3.X and 7.x

In the Extract Structure of DataSource in Under Infopackage ‘Data selection’ tab in BW

R/3 or ECC select ‘Selection’ check box. Selections are enabled.

8
InfoPackage Settings

Source System Flat File

Data Flow version 3.X

In the Transfer Rules of DataSource in BW Under Infopackage ‘Data selection’ tab in

select the ‘Selection’ checkbox. BW
Selections are enabled

9
InfoPackage Settings

Source System Flat File

Data Flow version 7.x

Under the ‘Fields’ tab of DataSource , if Under Infopackage ‘Data selection’ tab in
Selection is ‘X’ BW
Selections are enabled

10
InfoPackage Settings

Source System DB Connect

Data Flow version 3.x

While Generating the DataSource , Select the Under Infopackage ‘Data selection’ tab in BW
‘Selection’ checkbox Selections are enabled

11
InfoPackage Settings

Source System DB Connect

Data Flow version 7.x

Under the ‘Fields’ tab of DataSource , if Under Infopackage ‘Data selection’ tab in BW
Selection is ‘X’ Selections are enabled

12
InfoPackage Settings

Different ways of Data Selections.

-We can pass single value to the field

-We can pass multiple single values to the field

13
InfoPackage Settings

-We can pass single Interval to the field

14
InfoPackage Settings

-We can pass multiple Intervals to the field

Note: In the Data selections ‘Exclude’ is not possible.

15
InfoPackage Settings

To pass multiple single values or multiple Intervals to the field , select that field
and click on ‘+’ icon in the ‘Data Selection’ tab

16
InfoPackage Settings

Fixed Data Selections.

If the Data in the Source System is as below

17
InfoPackage Settings

If you give selections for Customer number.

i.e Customer number = C10 TO C20

18
InfoPackage Settings

The Data in the Target is

19
InfoPackage Settings

Dynamic Selections.
- ABAP/4 Routine
- OLAP Variable
If you want to pass the values to the field Dynamically we use ABAP/4
Routine or OLAP Variable.

6-ABAP/4 Routine
7-OLAP Variable

20
InfoPackage Settings

ABAP/4 Routine : If you want to pass the value to the InfoObject by implementing
some logic we use ABAP/4 Routine.

Scenario: If you want extract current day data

21
InfoPackage Settings

In the Routine you will have one Internal Table with the name ‘L_T_RANGE’.
This Internal Table will have 6 columns(fields).

L_T_RANGE
IOBJNM FIELDNAME SIGN OPTION LOW HIGH

IOBJNM = Name of the InfoObject

FIELDNAME = The field name of that InfoObject
SIGN = Include(I)/Exclude(E)
OPTION = Equal to(EQ)/Not Equal To(NE)/Between(BT)/Not Between(NB)
LOW = Low value of that InfoObject
HIGH = High value of that InfoObject

22
InfoPackage Settings

Sample code:

L_T_RANGE-IOBJNM = '0CALDAY'.
L_T_RANGE-FIELDNAME = 'CALDAY'.
L_T_RANGE-SIGN = 'I'.
L_T_RANGE-OPTION = 'EQ'.
L_T_RANGE-LOW = SY-DATUM.
APPEND L_T_RANGE.

After the execution of above code the Table L_T_RANGE will have

L_T_RANGE
IOBJNM FIELDNAME SIGN OPTION LOW HIGH
0CALDAY CALDAY I EQ SY-DATUM

23
InfoPackage Settings

OLAP Variable:
If you want pass the value to the InfoObject by using any
‘Customer Exit’ Variable we use the type ‘OLAP Variable’.

24
InfoPackage Settings

4 •External Data tab in Infopackage

‘External Data’ tab will have all the parameters which are needed to extract
data form Source System.

-In case of Flat File Source System we will have the following parameters.

File Location(Client Server or Application Server)

Name of The File
File Type(ASCII or CSV file)
Data Separator ( ‘ , ‘ or ‘ ; ‘)
Escape Sign ( ‘ “ ‘ )
Separator for Thousands (By Default ‘Comma’( ‘ , ‘ ) )
Number of Header rows to be ignored……etc.

25
InfoPackage Settings

26
InfoPackage Settings

File Location:-

It will tell you the location of the File(Incase of Flat file extraction).

-If the file is in the Local System( i.e ‘C’ drive or ‘D’ drive of your computer) then select

Client Workstation
-If the file is in the Application Server( i.e in the BW Server) then select

Application Server

Name of the File:-

It will tell you the name of the file.

-If the file is in the Local System then give file path.
For Ex:- If the file is in ‘C’ drive and the file name is ‘SALES_V1.csv’ then
‘C:\Documents and Settings\Administrator\Desktop\SALES_V1.csv’

27
InfoPackage Settings

We use ABAP/4 Routine for dynamic file selections.

-In this Routine we will have one parameter with the name ‘P_filename’.
Just we need to pass our file path to this parameter..

For this click on the button ‘Create Routine’ , give the description and pass the
file path to ‘P_filename’ .

28
InfoPackage Settings

Sample code:-

DATA : lv_str1(100) TYPE C,

lv_str2(8) TYPE C,
lv_str3(4) TYPE C.

lv_str1 = 'D:\usr\sap\BI7\DVEBMGS07\work\Sales_'.
lv_str2 = Sy-Datum.
lv_str3 = '.csv'.

Concatenate lv_str1 lv_str2 lv_str3 Into P_filename.

29
InfoPackage Settings

In BI7.0 :-
In Infopackage ‘External’ Tab will become ‘Extraction’ Tab.
Here we will have the same options but slightly changed.

Adapter :-
It will tell you the type of the flat file like whether it is a Binary file(ASCII file) or
Text-type file(CSV file) and also Location of the file(Local Workstation/Application server).

30
InfoPackage Settings

For dynamic file selections here also we use ABAP/4 Routine.

Click on the Button which is marked with red color in the below screen shot.

31
InfoPackage Settings

Data Format:-
-If the file is Notepad then select ‘Fixed Length’.
-If the file is Excel Sheet then select ‘Separated with Separator’ .

32
InfoPackage Settings

File Type:-
It will tell you the Type of the Flat File like ASCII file or CSV file.
-If the file is ‘Note Pad’ then select
ASCII File
-If the file is ‘Comma separated value’( i.e. Excel file) then select
CSV File

Data Separator:-
It will tell you how the data is being separated field by field like by ‘Comma’(,) or
‘Colon’(;)

Escape Sign:-
This sign should always be ‘ “ ‘ .

33
InfoPackage Settings

Separator for Thousands:-

In order to make the number easier to understand we use this.

For Ex:-
If the number in the Source System is 9885664556 and if you use
Comma( ‘ , ‘ ) as ‘Separator for Thousands’ then this number will be loaded
to BW as 988,566,455,6.

Note: By default this will be comma( ‘ , ‘ ).

34
InfoPackage Settings

Number of Header rows to be Ignored:-

This is used to ignore first ‘n’ number of records in the Flat File.

For Ex:- Suppose if you have first record in the Flat file as header of the data
and if you don’t want to extract that record into BW then

Number of Header row to be ignored is 1.

Note:- If you won’t pass any value to this parameter then it will take default
value.
-Default value for this parameter is zero(‘0’).
In this case all the records will be extracted from flat file.

Note:- Maximum number we can pass for this parameter is 99.

i.e. System can ignore maximum 99 records from the first record of
flat file

35
InfoPackage Settings

5 •Processing modes

We have different Processing modes.

-PSA and then into Data Targets (Packet by Packet).

-PSA and Data Targets in Parallel (Packet by Packet).

-Only PSA Update Subsequently in Data Targets.

-Data Targets Only.

36
InfoPackage Settings

37
InfoPackage Settings

-PSA and then into Data Targets (Packet by Packet).

All the data will come to PSA first and then loaded to Data Targets
packet by packet.

-PSA and Data Targets in Parallel (Packet by Packet).

The data will come to PSA and then loaded to Data Targets
packet by packet parallelly.

( First packet will come to PSA and this packet will be updated to Data
Targets , second packet will come to PSA and this packet will be updated
to Data Targets…)

38
InfoPackage Settings

-Only PSA

All the data will be loaded to PSA only (It will not be updated to
further Data Targets).

If you check the check box

Update Subsequently in Data Targets

then all the data will be loaded from PSA to further Data Targets.

-Data Targets Only.

The data will be loaded to Data Targets directly (It will not be
loaded to PSA).

39
InfoPackage Settings

In BI7.0 , InfoPackage will load the data up to PSA only.

40
InfoPackage Settings

6 •Data Targets

In BW3.x , we need to select the required Data Targets.( i.e. To which Data
Target we need to load the data)

41
InfoPackage Settings

7 •Update Modes

In this tab we will specify required Update mode.

we will have different Update Modes.

-Full Update

-Delta Update

-Initialize Delta Process

-Initialization with Data Transfer
-Initialize with out Data Transfer

42
InfoPackage Settings

43
InfoPackage Settings

-Full Update
If you use ‘Full Update’ then your Infopackage will always bring all the data from
Source System.

For Ex:-
Assume that there are 100 records in the Source System , if run your Infopackage
with ‘Full Update’ then all 100 records will be loaded to BW.

Now if 20 more records are added to the Source , if you run the Infopackage
then all 120 records will be loaded to BW.

i.e. The No. of records in the Source = 100+20.

The No. of records in the Target = 100+120.

i.e. your are having duplicate of 100 records in the Target.

44
InfoPackage Settings

To over come this we will have 2 options.

One is we will delete previous Request in the Target and Second one is we should
bring only newly added 20 records.

To bring newly added 20 records from Source we should enable the DataSource for
‘Delta’.
To enable ‘Delta’ we must run ‘INIT’ Infopackage.

-Initialize Delta Process

-Initialization with Data Transfer
-Initialize with out Data Transfer

If you select ‘Initialize Delta Process’ and ‘Initialization with Data Transfer’ then
your Infopackage will bring all the available data as of now in the Source and
enables your DataSource for Delta.

If you select ‘Initialize Delta Process’ and ‘Initialize without Data Transfer’ then
your Infopackage will not bring any data from the Source but it enables your
DataSource for Delta.
45
InfoPackage Settings

Note :- With which ever Data Selections you run your ‘INIT’ Infopackage with those
Selections only your Delta Infopackage will work.

-Delta Update:-

We use ‘Delta Update’ to bring delta records or newly added records from the
Source.

For Ex:-
Assume that there are 100 records in the Source System , if run your Infopackage
with ‘Init with Data Transfer’ then all 100 records will be loaded to BW and your
DataSource will be enabled for Delta.

Now if 20 more records are added to the Source , if you run your Infopackage
with ‘Delta update’ then only 20 records will be loaded to BW.

i.e. The No. of records in the Source = 100+20.

The No. of records in the Target = 100+20.
46
InfoPackage Settings

In BW3.x we can do ‘Error Handling’ in this ‘Data Targets’ tab.

-No update , No reporting

-Valid records update , No reporting ( request red )
-Valid records update , Reporting possible ( request green)

47
InfoPackage Settings

-No update , No reporting

If the system finds any error record then all the records in that request will not
be updated to Data Target and reporting is not possible.

-Valid records update , No reporting ( request red )

If the system finds any error record then all the valid records in that request
will be updated to Data Target and reporting is not possible.

-Valid records update , Reporting possible ( request green)

If the system finds any error record then all the valid records in that request
will be updated to Data Target and reporting is possible.

48
InfoPackage Settings

8 •Scheduling options

We use this tab to Schedule the Infopackage in Fore ground or Back ground.

49
InfoPackage Settings

-Start Data Load Immediately :

If you select this option and if you click on ‘Start’ then your Infopackage will be run
in the Fore ground.

-Start Later in Background

If you select this option and if you click on ‘Start’ then your Infopackage will be run
in the Back ground.

We need to specify the Scheduling options like date and time , job , event etc..

50