Oracle to HANA Database conversion will remove my custom tables?

[SMGOHIL]

Dear Expert,

I have a query if we replace our oracle database to HANA database will my custom tables and custom programs removed. Does it requires any activity to get back those custom table and programs?

Please guide.

Thanks & Regards,

Sweta Gohil.

[jgleichmann · Accepted solution]

Hi,

no, all data which are visible to the dictionary will be migrated. You just have to check which format (column or row store) is suitable for your custom tables. All reports are also migrated, but if they are working has to be checked. You have to check your coding via the ATC. There are several blogs, guides and documentation how to do this. Just search for your current scenario / release.

Regards,

Jens

[SMGOHIL · Accepted solution]

Dear Jens,

Thanks for the information. Also one more query if my standard table has some custom field what will happen to it. Will it be as it is or we need to make some mechanism to work for it?

Thanks & Regards,

Sweta Gohil.

[jgleichmann · Accepted solution]

Hi,

customer fields are also part of the dictionary which means they are also included as already mentioned. This means as far as the ABAP (SE11/SE14/DB02/DBACOCKPIT) is aware of this fields and the dictionary is consistent with the DB meta data, the data will all be migrated.

Regards,

Jens

[sunny_13]

Hi Sweta,

The query looks to be about concerns from ABAP report execution perspective, rather than database. As Jens has correctly mentioned -as long as your table and its data structure is visible and therefore supported in source, it will be moved over from Oracle to HANA database.

Since you have not clarified the type of customization, I can only assume its either :

1) The field has a "Z" or " Y" name to differentiate from a standard field when being called in an ABAP report.

2) The field has a different data structure ( usually length) compared to a similar standard field for a business-specific data entry requirement.

For case 1: No impact to your report, from DB perspective, its just another field in the table.

For case 2: Again should not be an issue, because HANA supports almost all standard data types as used in other RDBMS databases. However its always good to validate against help.sap.com/HANA SQL reference guide for the data type you are looking for.

Regards,

Subhrajit