Skip to Content
Apr 23, 2020 at 07:47 AM

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


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.