Skip to Content
-1

Can we modify standard WBS Element (Attribute) master table in SAP BI ?

May 02, 2017 at 09:52 AM

49

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Matthew Billingham
May 02, 2017 at 10:31 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded