on 05-02-2017 10:52 AM
Hi Experts,
I have a requirement in BI that I need to modify master table (attribute table of wbs element) by implementing different conditions in start routine.
So Is it possible to update standard master table ? (/BI0/PWBS_ELEMT master table of WBS Element infoprovider)
I have a logic where I need to compare data from PSA to Infoprovider’s master table and if there is extra record in master table then I need to populate as ‘y’ in a new field.
I have written the logic in start routine between datasource (0WBS_ELEMT_ATTR) of wbs element and infoprovider related to wbs element (0WBS_ELEMT) but while executing infopackage the request remains in yellow (as it is SAP BI Version 3.5 so data is loaded in PSA and Infoprovider simultaneously)
Below mentioned is the code let me know if I am missing anything or if something needs to be changed or added.
DATA : it_element TYPE TABLE OF /BI0/PWBS_ELEMT,
wa_element TYPE /BI0/PWBS_ELEMT,
it_wbs_psa TYPE TABLE OF /BIC/B0000226000,
wa_wps_psa TYPE /BIC/B0000226000.
SELECT * from /BIC/B0000226000 into TABLE it_wbs_psa .
Select * from /BI0/PWBS_ELEMT INTO TABLE it_element.
SORT it_element by wbs_elemt.
sort it_wbs_psa by posid.
loop at it_element INTO wa_element.READ TABLE it_wbs_psa INTO wa_wps_psa with KEY POSID =
wa_element-wbs_elemt.
if sy-subrc <> '0'.
wa_element-/BIC/ZLOEVM = 'Y'.
MODIFY it_element FROM wa_element TRANSPORTING /BIC/ZLOEVM.
CLEAR : wa_element, wa_wps_psa.
endif.
ENDLOOP.
MODIFY /BI0/PWBS_ELEMT FROM TABLE it_element.
COMMIT WORK AND WAIT.
Never update the master data tables directly with ABAP. Always either do it via a proper BI data load, or using the FMs
RSNDI_MD_ATTRIBUTES_UPDATE
RSNDI_MD_TEXTS_UPDATE
RSDMD_MD_ACTIVATE
The first two function modules are documented. The last is not, but is pretty obvious. They are not released for customer use, and so their use isn't supported - but if you update tables directly, you're also not supported, and far more likely to run into disaster.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.