Difference in order of columns in SAP HANA Application layer and background SAP HANA DB

[former_member1214752]

There is a mismatch in the order of fields in SAP SE11 table MARA and SAP HANA DB Table MARA. While inserting into values to a copy of MARA table using a select query in SAP HANA DB, its giving type mismatch error due to this column order issue as SQL considers only order of values while insert not column names as I have chosen select *

Why is that change in order of columns in SAP HANADB and Transparent table MARA in S/4 HANA.

[sumitjais]

Hi Parvathy,

This inconsistency issue has been quite popular for years.

There could be multiple reasons for the difference. SAP note 1248769 - Inconsistency between database and ABAP Dictionary talks in detail about the probable cause of the issue and resolution.

• The table was activated by illegal means and not adjusted to the database in the process.
• When the table was activated, a database error occurred that prevented the adjustment to the database and, for once, provided no return code.
• During an upgrade (and in particular in a shadow system) it may therefore be correct for a database object to be displayed as incorrect.

[former_member1214752]

Thanks Sumit!

Is there any solution then? Or is it a property of HANA. Can we make the field position and DB position of columns same.

[sumitjais]

Hi Parvathy,

This has nothing to do with HANA. The solution is mentioned in the same note.

Check the table - Run time and database level

Reconstruct the table

1. Log on as the user DDIC.
2. Call transaction SE14.
3. Enter the name of the table and choose "Edit".
4. In the menu, choose: "Table" -> "Reconstruct". ( this option is enabled only with DDIC)
5. Confirm the execution as an emergency repair.
6. The system outputs a log of the reconstruction as a list. Check that the reconstruction was successful.
7. Call transaction SE11.
8. Enter the name of the table and choose "Activate

Upon reconstruction and activation, you may 'Activate and adjust database ' for fixing inconsistency of index of the table.

[former_member1214752]

Thank You so much Sumit!

Will try this.

[sumitjais]

Sure, Do update me if it helps or not.