Tuesday, December 14, 2004

[BW] Transactional ODS

Transactional ODS

1. Data store for external app like SAP SEM
2. Direct update via. API - no load processes
3. Data is available immediate
4. No change log- no delta update for connected targets....
5. Reporting only with Infoset
Example:
data:
"ODS table name
RECORDS type i,
ls_data type /BIC/AODSBPS9000,
lt_data type table of /BIC/AODSBPS9000 with default key.

clear ls_data.
ls_data-/BIC/BPSAREA = 'FBSA0001'.
ls_data-/BIC/BPSLOGD = sy-datum.
ls_data-/BIC/BPSLOGT = sy-uzeit.
ls_data-/BIC/BPSUSER = SY-UNAME.
ls_data-/BIC/BPSLOG1 = 'TEST'.

collect ls_data into lt_data.

CALL FUNCTION 'RSDRI_ODSO_INSERT'
EXPORTING
I_ODSOBJECT = 'ODSBPS90'
I_T_INSERT = lt_data
IMPORTING
E_RECORDS = RECORDS.

0 Comments:

Post a Comment

<< Home