Skip to Content
0
Former Member
Jul 31, 2006 at 11:10 PM

Urgent: Problems in Generic Deltas by Function Module

33 Views

Hi BW Experts,

My requirement is to extract text from CRM to BW using Zfunction module, copy of RSAX_BIW_GET_SIMPLE_DATA

which works fine for full loads but the problem arises only when i go for generic deltas. My code in FM for Deltas is:

LOOP AT s_s_if-t_select INTO l_s_select.

CASE l_s_select-fieldnm.

WHEN 'ZDATE'.

s_date_from = l_s_select-low.

s_date_to = l_s_select-high.

WHEN OTHERS.

ENDCASE.

ENDLOOP.

IF s_date_from IS INITIAL.

s_date_from = '20060401'.

ENDIF.

IF s_date_to IS INITIAL.

s_date_to = '99991231'.

ENDIF.

OPEN CURSOR WITH HOLD S_CURSOR FOR

SELECT * FROM STXH

WHERE TDOBJECT = 'CRM_ORDERH'

AND TDID = 'A002'

AND TDSPRAS = sy-langu

and TDLDATE between s_date_from and s_date_to

or tdfdate between s_date_from and s_date_to.

ENDIF.

FETCH NEXT CURSOR S_CURSOR

APPENDING CORRESPONDING FIELDS

OF TABLE wa_stxh

PACKAGE SIZE S_S_IF-MAXSIZE.

TDFDATE is creation date and TDLDATE is changed on

My extract structure contains Zdate(TDLDATE), Ztext1,2,3, Key field and langu in RSO2 I have selected calday in generic delta and Zdate as field Nm and upper limit as 1 and lower limit as space in settings and new status for changed records button.

Did I missed something because when i check in RSA7 i didnot see any changed records under totals column and i tried to load without it into BW than i didnot received single record evenafter changes.Would anyone suggest me the good solution for it I appreciate it in advance. I have seen lot of posts in SDN but I didnot find this type of secenario anywhere.

Thanks in advance

Regards

Kishore