SAP BW .....all info @ one place
SAP BW relevant Information
Loading
Showing posts with label routines. Show all posts
Showing posts with label routines. Show all posts

1.Create an Infopackage 2. Go to selections tab and choose Type: 6 – ABAP Routine.You can see following available options(F4 Help).

3. Give disruption, and hit enter, now you will move to following screen. 4. Write Code between begin of Routine and End of Routine.

5. See below sample code to select date range from Previous 6 days to Current date.

6. L_T_Range table is of Type structure RSSDLRANGE.
a. RSSDLRANGE contains SIGN, OPTION, LOW, HIGH
We need to populate these fields to pass range dynamically.
Sample Code:
****$*$ begin of routine - insert your code only below this line *-*
Data: l_idx like sy-tabix.
Data: date_low like sy-datum.
Date_low = sy-datum – 6.”(To get 6 days back).
read table l_t_range with key
fieldname = 'CRDAT'.
l_idx = sy-tabix.
*** Pass Range values to L_T_Range Table.
Move date_low to L_T_Range -Low.
Move sy-datum to L_T_Range -High.
L_T_Range -Sign = ‘I’. *****(Here: I – Include, E – Exclude)
L_T_Range -Option = ‘BT’.****( Here: BT – Between )
modify l_t_range index l_idx.
p_subrc = 0.

***$*$ end of routine - insert your code only before this line *-*

7. Syntax check and Save.

 


Free ebooks download for free
-- You can download some ebooks for free from this website available for many technologies..
SAP BW : Step-By-Step (FU FU)
SAP BW Certification - by Catherine M Rose

SAP BW Interview Questions - download for free
-- Download ebook for free from this site.
Book is very good, covers all areas of BW(Extraction, Modeling, Reporting, infospokes, process chains, user exits, routines, sample codes, data load monitor: errors & fixing, all types of extraction.... etc...

All Articles on SAP NetWeaver Business Intelligence
-- Very Good One... contains Articles, eBooks etc.... on all areas of Business Intelligence..

Five Ways to Enhance SAP BI back end Functionality Using ABAP
-- It covers how to write field wise routines, start routines in Update Rules & Transfer Rules and infopackage routines.
-- It Covers how to enhance datasource, user exit variables, ABAP in Process Chains, etc....

BI Performance Tuning


-- Contains all information related to BI performance tuning.


Performance Tuning for SAP BW : pdf


Performance Tuning for Queries with Aggregates : pdf


BEx Front-End Performance: Performance Analyses of BEx Analyzer and Web Application in the Local and Wide Area Networks Environment : pdf


SAP BW Data Load Performance Analysis and Tuning : e learning


-- Need SDN User ID and Password to log-on.

 

How to Papers, related to BW direct download

Google
 

Recent Posts

SAP Jobs