Labels
- BW Architecture (1)
- BW Reporting (3)
- Data Loading issues (7)
- Datawarehousing (9)
- Extraction (3)
- General Maintainence (5)
- HANA (1)
Blog Archive
13 Oct 2008
Function module to make yellow request to RED
Use SE37, to execute the function module RSBM_GUI_CHANGE_USTATE.From the next screen, for I_REQUID enter that request ID and execute.From the next screen, select 'Status Erroneous' radiobutton and continue.This Function Module, change the status of request from Green / Yellow to RED.
Labels:
Data Loading issues
7 Oct 2008
ABAP routine in infopackage for Multiple Selections
Requirement : 0plant should be restricted in the infopackage level using routine picking only selective plants ( say under some country or region )
Following is the code, i tried and working fine.
Solution
data: l_idx like sy-tabix.
DATA : IT_PLANT LIKE TABLE OF /BI0/PPLANT.
data : it_plant_wa type /BI0/PPLANT.
read table l_t_range with key
fieldname = 'PLANT'.
l_idx = sy-tabix.
SELECT * FROM /BI0/PPLANT INTO TABLE IT_PLANT WHERE COUNTRY = 'BE'.
LOOP AT IT_PLANT INTO IT_PLANT_WA.
l_t_range-low = IT_PLANT_WA-PLANT.
l_t_range-SIGN = 'I'.
l_t_range-OPTION = 'EQ'.
append l_t_range.
ENDLOOP.
modify l_t_range index l_idx.
p_subrc = 0.
Following is the code, i tried and working fine.
Solution
data: l_idx like sy-tabix.
DATA : IT_PLANT LIKE TABLE OF /BI0/PPLANT.
data : it_plant_wa type /BI0/PPLANT.
read table l_t_range with key
fieldname = 'PLANT'.
l_idx = sy-tabix.
SELECT * FROM /BI0/PPLANT INTO TABLE IT_PLANT WHERE COUNTRY = 'BE'.
LOOP AT IT_PLANT INTO IT_PLANT_WA.
l_t_range-low = IT_PLANT_WA-PLANT.
l_t_range-SIGN = 'I'.
l_t_range-OPTION = 'EQ'.
append l_t_range.
ENDLOOP.
modify l_t_range index l_idx.
p_subrc = 0.
Labels:
Datawarehousing
Subscribe to:
Posts (Atom)