Table structure changes in ERP- SLT error

[former_member182537]

hi,

there are few structure related table chnages on ERP side and due to which SLT replictaion is failing. Our target is Oracle system hence not sure apart from doing init load agian - any other fix settings in SLT that can be used? Though I can see that new field added in ERP - is reflected in SLT as well.

Above are error messages-

We are on SLT SP009 - so advice if any ideas

thanks

[Former Member]

Hi Nilesh,

As far your inputs I see that you need to go for Load or Replication. This will drop the table in HANA and create a new table with latest metadata.

To increase the performance of initial load you can create an access plan in LTRC or LTRS tcodes.

Hope so this will helps you.

Thanks,

RK.

[former_member182537]

hi Ravi,

I am loking for fix withouting droppign tables in SLT as for biggers tables like BSEG /KONV its big impact/

Also note my target is not HANA - its Oracle and flow is

ERP->SLT->Oracle

[Former Member]

Hi Nilesh,

New field is reflected in to your target system because the DD0* tables are in Replication and they will bring the Metadata changes. But as the data is there in the target table so DDIC error is coming.

As far I know if the structure is changed the table need to be dropped and initialize the replication or Load to capture the data for enhanced structure.

Hope this will helps you.

Regards,

RK

[former_member182537]

hi,

I hav tried myself again getting below error after new field added in ERP. This error comes in SLT , so any idea how to handle this - we are on SP009 in SLT

is there way to avoid initi load again - I thought SLT should have some way to handle it?