Question Re: Rules Assignment for Sybase Tables in Technology Q&A

Rules Assignment for Sybase Tables

Former Member — Thu, 14 Apr 2016 05:41:01 GMT

Hi experts,

I have replicated a table "gg_color1" from sybase to HANA successfully. I can see data in HANA Studio.

Now I want to add a field "CHANGE_DATE" to the target table and give it the value SYSDATE.

First, I add table in Table Settings in LTRS. I can find the table "gg_color1" in the list,

But when I click YES, it popups a message showing the table not exists in the source system.

Anyway , I click Yes and the table is added with its table structure. I add a new field CHANGE_DATE. Then I want to create a new event-based rule to assign value to it. But it shows ABAP code contains syntax errors.

I check the syntax and it shows:

then I find that the table "gg_color" does not exist in HANA DB any longer. It seems to be deleted.

I use the same way as I deal with ECC tables, but it doesn't work anyway.

So what's the process to create a rule to assign value to a new added field for a sybase table?

Thank you for your any input!

Regards,

Chong

Re: Rules Assignment for Sybase Tables

Former Member — Thu, 14 Apr 2016 06:25:12 GMT

Hi all,

I found a post discussing about the same problem.

The note mentioned in the post is based on DMIS SP08,

but our SLT server is on DMIS SP10.

Regards,

Chong

Re: Rules Assignment for Sybase Tables

former_member252769 — Thu, 14 Apr 2016 08:30:04 GMT

Hi Chong,

You have to follow the same process as ECC.

- Add new field in structure and then do the transformation.

Along with that also check,

- If table is having same name in source as you are adding in "gg_color1".

- check if DD0* tables have any entries in HANA (they should have).

- Go through the SAP note 2125689

Regards

Re: Rules Assignment for Sybase Tables

Former Member — Fri, 15 Apr 2016 02:32:01 GMT

Hi BJ,

Once again I did it following the same process as ECC, but no luck.

The same error occurred when I change the rule status from New to Released.

update my check as you mentioned:
1. table name is just "gg_color1" in SYBASE database.

2. DD02L and DD02T has data about the tables' information in SYBASE.

3. I don't think this note is fitfor our system as we have higher version.

Regards,

Chong

Re: Rules Assignment for Sybase Tables

Former Member — Fri, 15 Apr 2016 02:32:34 GMT

Hi BJ,

Once again I did it following the same process as ECC, but no luck.

The same error occurred when I change the rule status from New to Released.

update my check as you mentioned:
1. table name is just "gg_color1" in SYBASE database.

2. DD02L and DD02T has data about the tables' information in SYBASE.

3. I don't think this note is fitfor our system as we have higher version.

Regards,

Chong

Re: Rules Assignment for Sybase Tables

Former Member — Mon, 18 Apr 2016 02:07:10 GMT

Hi BJ,

found the reason. It's about the letter upper/lower of tables' name in sybase.

If the table's name is lower case , it will fail.

SAP system treats it as upper case, so it pops up a message showing the table not exists in source.

But I still think this is a problem, as SYBASE is case sensitive. There must be some settings to handle it.

Anyway I will mark this thread as solved. Thank you for your attention.

Regards,

Chong