How to Write a Routine in DTP
Selection
Applies to:
SAP NetWeaver Business Warehouse (Formerly BI), Will also work on SAP BI 3.5. For more information,
visit the EDW homepage
Summary
This article gives clear picture about how to use a Routine for 0FISCPER in DTP Selection based on System
Date.
Author:
Surendra Kumar Reddy Koduru
Company: Accenture. (Bangalore/INDIA)
Created on: 13 July 2011
Author Bio
Surendra Kumar Reddy Koduru is a SAP BI Lead Consultant currently working with Accenture. He
has got rich experience and worked on various BW/BI Implementation/Support Projects and he is the
author for various Articles and Blogs (SAP-BW/BI) in SAP Community Network.
SAP COMMUNITY NETWOR
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
1
How to Write a Routine in DTP Selection
Table of Contents
Introduction: ........................................................................................................................................................ 3
Live Scenario: ..................................................................................................................................................... 3
InfoCube 0PC_C01 Data Flow: .......................................................................................................................... 3
DTP: .................................................................................................................................................................... 4
Code Window: .................................................................................................................................................... 8
Code before Change: ......................................................................................................................................... 9
Code after Change: .......................................................................................................................................... 10
Activate DTP: .................................................................................................................................................... 13
All Tabs of DTP: ................................................................................................................................................ 14
Data loading using above DTP: ........................................................................................................................ 15
Monitor Screen: ................................................................................................................................................ 16
PSA Data: ......................................................................................................................................................... 18
InfoCube Data: .................................................................................................................................................. 19
Related Content ................................................................................................................................................ 20
Disclaimer and Liability Notice .......................................................................................................................... 21
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
2
How to Write a Routine in DTP Selection
Introduction:
This article addresses the requirement of a Routine in DTP selection on 0FISCPER. Using this routine, I
need to load only that particular Fiscal Year Period into InfoCube and other data just ignore in PSA it self.
Live Scenario:
Some times when we are loading data from PSA into InfoCubes/DSO’s, we need some selections in DTP;
this is useful especially when you want to load using some selections from PSA. Here we need only Current
Fiscal Year Period i.e. 006.2011 (this is based on 06.2011 because I written this article on 27-06-2011 so as
per this date the Fiscal Year period is 006.2011, I used Fiscal Year Variant as K4)
We are loading data to 0PC_C01 InfoCube and using DataSource 0CO_PC_01, this DataSource supports
Full Load only so we need to restrict the data loads for Current Year using DTP from PSA. To load Current
Fiscal Year Period based on System Date we need to write the ABAP Routine in DTP selection.
InfoCube 0PC_C01 Data Flow:
See the below Screen.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
3
How to Write a Routine in DTP Selection
The above flow is in BI 7.X, and till PSA, we need to use InfoPackage and from PSA to InfoCube we need to
use DTP, in DTP we are going to write Routine.
DTP:
Create the DTP and then click on Filter button and see the see the Selection fields, if you won’t find your
selection field, then you need to click on Change Selection and then select you filed after that you see it in
selection screen.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
4
How to Write a Routine in DTP Selection
To see all fields then click on Change Selection Button.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
5
How to Write a Routine in DTP Selection
If you need any other fields, you just select it from list and then move to left side. After that you see you
selection fields in the actual selection screen like below…
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
6
How to Write a Routine in DTP Selection
In this scenario we want to write routine in Fiscal Year/Period i.e. to load data from PSA to InfoCube for
current Fiscal Year/Period based on System Date. Click on Routine button and then it will ask Name give
some name and continue, it will go to window code.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
7
How to Write a Routine in DTP Selection
Code Window:
Once you click on Editor Button, it will go to Code window like below.
In above screen you can see ABAP Code Editor; here we are going to write the ABAP code to load only
Current Fiscal Year Period Data based on SY-DATUM (System Date).
Eg: Today Date is 27-06-2011, as per this date the Fiscal Year Period is 006.2011. (I used Fiscal Year
Variant as K4).
So the data is loaded only for 006.2011 period using DTP from PSA.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
8
How to Write a Routine in DTP Selection
Code before Change:
*&---------------------------------------------------------------------*
*& Include
RSBC_SEL_ROUTINE_TPL
*&---------------------------------------------------------------------*
program conversion_routine.
* Type pools used by conversion program
type-pools: rsarc, rsarr, rssm.
tables: rssdlrange.
* Global code used by conversion rules
*$*$ begin of global - insert your declaration only below this line *-*
* TABLES: ...
* DATA:
...
*$*$ end of global - insert your declaration only before this line
*-*
* ------------------------------------------------------------------*
Fieldname
=
*
data type
=
*
length
= 000000
* ------------------------------------------------------------------form compute_
tables l_t_range structure rssdlrange
using i_r_request type ref to IF_RSBK_REQUEST_ADMINTAB_VIEW
i_fieldnm type RSFIELDNM
changing p_subrc like sy-subrc.
*
Insert source code to current selection field
*$*$ begin of routine - insert your code only below this line
*-*
data: l_idx like sy-tabix.
read table l_t_range with key
fieldname = ' '.
l_idx = sy-tabix.
*....
if l_idx <> 0.
modify l_t_range index l_idx.
else.
append l_t_range.
endif.
p_subrc = 0.
*$*$ end of routine - insert your code only before this line
endform.
SAP COMMUNITY NETWORK
© 2011 SAP AG
*-*
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
9
How to Write a Routine in DTP Selection
Code after Change:
Now we will write few lines of ABAP code to fulfill our requirement. See the below code. Once you write the
code, check the syntax error, if it is Ok then Save the routine.
The code which is written in above window is given in below page, so you can compare the code before and
after.
*&---------------------------------------------------------------------*
*& Include
RSBC_SEL_ROUTINE_TPL
*&---------------------------------------------------------------------*
program conversion_routine.
* Type pools used by conversion program
type-pools: rsarc, rsarr, rssm.
tables: rssdlrange.
* Global code used by conversion rules
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
10
How to Write a Routine in DTP Selection
*$*$ begin of global - insert your declaration only below this line *-*
* TABLES: ...
* DATA:
...
*$*$ end of global - insert your declaration only before this line
*-*
* ------------------------------------------------------------------*
Fieldname
=
*
data type
=
*
length
= 000000
* ------------------------------------------------------------------form compute_
tables l_t_range structure rssdlrange
using i_r_request type ref to IF_RSBK_REQUEST_ADMINTAB_VIEW
i_fieldnm type RSFIELDNM
changing p_subrc like sy-subrc.
*
Insert source code to current selection field
*$*$ begin of routine - insert your code only below this line
*-*
data: l_idx like sy-tabix.
read table l_t_range with key
fieldname = ' '.
l_idx = sy-tabix.
*....
*******Surendra Kumar Reddy Koduru******Begin******
data:
zdate LIKE sy-datum, " Data Declaration.
zbuper LIKE t009b-poper,
zbdatj LIKE t009b-bdatj,
zperiod(7) TYPE c.
zdate = sy-datum - 1.
*
*
*
*
*
*
*
*
CALL FUNCTION 'DATE_TO_PERIOD_CONVERT'
EXPORTING
i_date
= zdate
I_MONMIT
= 00
i_periv
= 'K4'
IMPORTING
e_buper
= zbuper
e_gjahr
= zbdatj.
EXCEPTIONS
INPUT_FALSE
= 1
T009_NOTFOUND
= 2
T009B_NOTFOUND
= 3
OTHERS
= 4
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
CONCATENATE zbdatj zbuper INTO zperiod.
l_t_range-fieldname = 'FISCPER'.
l_t_range-option = 'EQ'.
l_t_range-sign = 'I'.
l_t_range-low = zperiod.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
11
How to Write a Routine in DTP Selection
*******Surendra Kumar Reddy Koduru******End******
append l_t_range.
****You just comment the below IF condition.
* if l_idx <> 0.
*
modify l_t_range index l_idx.
* else.
*
append l_t_range.
* endif.
p_subrc = 0.
*$*$ end of routine - insert your code only before this line
endform.
"compute_
*-*
Once you write code and check it and save and come back then activate DTP
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
12
How to Write a Routine in DTP Selection
Activate DTP:
Once you close the above screen then you need to activate the DTP and then Version Icon shows in Green.
See the below screen after activation of DTP.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
13
How to Write a Routine in DTP Selection
All Tabs of DTP:
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
14
How to Write a Routine in DTP Selection
Data loading using above DTP:
Once you click on Execute Button, you can see the below dialog box, just click on Yes and see details in
Monitor.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
15
How to Write a Routine in DTP Selection
Monitor Screen:
See the below Monitor screen, you can find our selection also under Selection in right side and number of
records transferred.
See above screen, you can find only 6 records which are fulfilling our condition in DTP routine. Actuall in
PSA you can find more number of records.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
16
How to Write a Routine in DTP Selection
Click on Header Tab and see the details.
In above screen you can see the selection also i.e. FISCPER = 2011006, because this is calculated in DTP
routine based on System date (i.e. 27-06-2011).
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
17
How to Write a Routine in DTP Selection
PSA Data:
Right click on DataSource and then Manage and open PSA and select the request and click on Icon like
below to see the data in PSA.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
18
How to Write a Routine in DTP Selection
See in above screen, you can find 23986 records are loaded into PSA, and out of these we got only 6
records into our InfoCube for 006.2011 Period.
InfoCube Data:
In below screen you can see the Data in InfoCube, there are only 6 records.
So in this way we can use the DTP routines to restrict the unwanted data.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
19
How to Write a Routine in DTP Selection
Related Content
For all Articles and Blogs by Surendra Kumar Reddy, Please visit this URL
Using Customer Exit Variables in BW Reports Part - 1
Using Customer Exit Variables in BW Reports Part - 2
Using Customer Exit Variables in BW Reports Part - 3
Using Customer Exit Variables in BW Reports Part - 4
Using Customer Exit Variables in BW Reports Part - 5
Using Customer Exit Variables in BW Reports Part - 6
Using Customer Exit Variables in BW Reports: Part - 8
Using Customer Exit Variables in BW Reports: Part - 9
Using Customer Exit Variables in BW Reports: Part - 10
Using Customer Exit Variables in BW Reports: Part - 11
Using Customer Exit Variables in BW Reports: Part - 12
Using Customer Exit Variables in BW Reports: Part - 13
Using Customer Exit Variables in BW Reports: Part - 14
Using Customer Exit Variables in BW Reports: Part - 15
Using Customer Exit Variables in BW Reports: Part - 16
Using Customer Exit Variables in BW Reports: Part - 17
Using Customer Exit Variables in BW Reports: Part - 18
Inventory Management (0IC_C03) Part - 1
Inventory Management (0IC_C03) Part - 2
Inventory Management (0IC_C03) Part - 3
To Check the Files/Reports in Application Server and trigger mail alerts
Calculating the Ageing of the Materials
Using Selective Deletion in Process Chains
Triggering the Process Chains at Particular Date using Events
Analysis Process Designer (APD) Part - 1
Analysis Process Designer (APD) Part - 2
Analysis Process Designer (APD): Part - 3
Open Hub Destination: Part 1
Open Hub Destination: Part 2
InfoSpoke Part 1
InfoSpoke Part 2
Using Rule Group in SAP-BI Part - 1
For more information, visit the EDW homepage
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
20
How to Write a Routine in DTP Selection
Disclaimer and Liability Notice
This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not
supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.
SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document,
and anyone using these methods does so at his/her own risk.
SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or
code sample, including any liability resulting from incompatibility between the content within this document and the materials and
services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this
document.
SAP COMMUNITY NETWORK
© 2011 SAP AG
SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com | UAC - uac.sap.com
21