Transfer Routine Problem

[Former Member]

Hi Experts,

I'm writing a Transfer Routine for one of my InfoObject calles ZCRM_ESCLT. When I debug my routine, the routine gives the correct result but I when check in the data target,the field is empty,meaning that the routine does not store the result. Here is my code.Please help.

Data: zusername(20) TYPE c.

CLEAR result.

SELECT SINGLE /bic/zcrm_unam INTO zusername

FROM /bic/azsrvhist00

WHERE /bic/zoguid = tran_structure-guid

AND /bic/zobj_id = tran_structure-object_id.

IF zusername = tran_structure-usnam.

result ='1'.

ENDIF.

returncode = 0.

Full points will be rewarded if the problem is solved.

Thanks and Regards,

Azimah

[Former Member · Accepted solution]

Hi Azimah,

What kind of data field are you updating in the ODS? A key figure or a characteristic? I guess this is a key figure as the target value is 1. But please confirm.

Now, what is the update method of the key figure? Addition or overwrite? Because if this is overwrite, then depending on the business key of the ODS (surely not guid and object_id), the same figure may swap from 1 to 0 from a row to another row, for the same key fields and so the previous 1 is overwritten by 0 .

Please check,

Laurent

[Former Member · Accepted solution]

Hi Laurent,

Thanks for your reply.The data field I'm updating in the ODS is a characteristics. And also my update method for the characteristics is set to 'No Update'.

Any idea why it is does not displaying the result.

Thanks in advance.

Azimah

[Former Member · Accepted solution]

here comes the problem

change it to 'overwrite' from 'No Update'

if it is set to no update how do u expect it to be populated?

hope it works...

Regards,

Pradhiba

*helpful answers deserve some points*

[Former Member · Accepted solution]

whether it is overwrite or no update it doesn't a matter if u r trigger the load if it is no update also the data comes to new data table when u activating the ODS it moves from New dat table to Active data table and change log table auto matically with out over write the previous value

[Former Member · Accepted solution]

Hi all,

I managed to find a solution whereby I created an Internal Table in update rules Start Routine and I have done the comparison in Update Routine and it works.

Thanks for your effort of helping me out.

Regards,

Azimah

[Former Member]

Hi Azimah

I am assuming this code is the routine you have in the update rule. Can you check if your code has the following statement as the last statement before ENDFORM.

ABORT = 0.

If ABORT is not equal to 0, then the update process will be canceled.

Thanks

Uma

[Former Member]

1) Check the update rules and see if the field value is being cleared there.

2) When you debug, check the box to debug update rules also. Then verify if the value is still set in update rules.

3) Is your data target an InfoObject? If yes, have you run the attribute change run?

[Former Member]

if ur data target is an ODS, check after activating..

[Former Member]

Hi Pradhiba,

Thanks for your reply.I tried ur solution but doesnt work.Any other suggestion?

Azimah.