Question Re: Table structure changes in ERP- SLT error in Technology Q&A

Table structure changes in ERP- SLT error

former_member182537 — Wed, 13 Jan 2016 12:23:00 GMT

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

Re: Table structure changes in ERP- SLT error

Former Member — Wed, 13 Jan 2016 14:24:10 GMT

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.

Re: Table structure changes in ERP- SLT error

former_member182537 — Wed, 13 Jan 2016 14:51:33 GMT

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

Re: Table structure changes in ERP- SLT error

Former Member — Wed, 13 Jan 2016 15:20:07 GMT

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,

Re: Table structure changes in ERP- SLT error

former_member182537 — Wed, 13 Jan 2016 21:59:29 GMT

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?