Friday, May 26, 2006

[BW] RFC enabled Event raise

SM62 - Maintain event
SM64 - trigger event
SM61 - event trace
============================================
BW:

FUNCTION Z_BW_EVENT_RAISE.
*"----------------------------------------------------------------------
*"*"Interface local:
*" IMPORTING
*" VALUE(EVENTID) LIKE TBTCO-EVENTID
*"----------------------------------------------------------------------

call function 'BP_EVENT_RAISE'
exporting
eventid = eventid
exceptions
bad_eventid = 1
eventid_does_not_exist = 2
eventid_missing = 3
raise_failed = 4
others = 5.

ENDFUNCTION.

R3:

REPORT ZBW_EVENT_RAISE .

call function 'Z_BW_EVENT_RAISE'
destination 'BW1001'
exporting
eventid = 'SAP_BW_TRIGGER_HR'.

Saturday, May 20, 2006

[BW] Set user Workbook template

&---------------------------------------------------------------------*
*& Report Z_SET_BEX_USER_TEMPLATE *
*& *
*&---------------------------------------------------------------------*
*& Program to update all user's default template *
*& *
*&---------------------------------------------------------------------*

REPORT Z_SET_BEX_USER_TEMPLATE.
parameter wbid like rsrwbindex-workbookid.
tables: rsrwbtemplate, usr01.
select * from usr01.
rsrwbtemplate-templateuser = usr01-bname.
rsrwbtemplate-workbookid = wbid.
update rsrwbtemplate.
if sy-subrc <> 0. insert rsrwbtemplate. endif.
endselect.

Sunday, May 14, 2006

[BW] Generating PSA as DataSource

Sunday, May 07, 2006

[BW] Composite Note on SAP R/3 inventory management in SAP BW

586163

[BW] Howto: Activate transaction key (PROCESSKEY)

blank bwapplnm in 2LIS*
note 353042

So that you can work in the above mentioned InfoSources, you MUST activate the determination of the process key. This is done with the help of Transaction MCB_ which you can find in the OLTP IMG for BW (Transaction SBIW)(under LO purchase - transaction key = mpvement type?) in your attached R/3 source system.

Here you can choose your industry sector. 'Standard' and 'Consumer products' are for R/3 standard customers, whereas 'Retail' is intended for customers with R/3 Retail only.


Wednesday, May 03, 2006

[BW] Popup table list and return user selection

DATA: field_desc TYPE TABLE OF rsvbfidesc.
DATA: l_nr LIKE sy-tabix.

CLEAR: field_desc, wa_field_desc.
wa_field_desc-fieldnum = 5. "ex: ZSBU 是在table的第五欄
wa_field_desc-display = 'X'.
APPEND wa_field_desc TO field_desc.

i_ods-/BIC/ZSBU = '1011'.
append i_ods.
i_ods-/BIC/ZSBU = '1012'.
append i_ods.
i_ods-/BIC/ZSBU = '1013'.
append i_ods.
i_ods-/BIC/ZSBU = '1014'.
append i_ods.
l_nr = 0.
CALL FUNCTION 'RS_VALUES_BOX'
EXPORTING
left_upper_col = 5
left_upper_row = 5
pagesize = 20
title = 'Select SBU'(sdc)
IMPORTING
linenumber = l_nr
TABLES
field_desc = field_desc
value_tab = I_ods
EXCEPTIONS
OTHERS = 1.
read table i_ods index l_nr.

Tuesday, May 02, 2006

[BW] Replicate datasource - time stamp not sync error

in BW : run report RS_TRANSTRU_ACTIVATE_ALL