Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

"Automated" Schema Mapping

Dear experts,

whilst I quickly managed to map a schema manually I couldn't figure out a way to do it automatically.

The scenario is the following:

- We create quite a number of Hana systems fully automated where we have the ERP data in a different schema than SAP_ECC.

- We’d like to use SAP HANA Live functionality which requires the ERP data in SAP_ECC or alternatively an active schema mapping.

If anyone can provide a way to either conduct the schema mapping via sql statement or alternatively integrate the schema mapping in a delivery unit I'd be very thankful.

Looking forward to your answers,

Tobias

Tags:
replied

Hi Tobias,

You can use below sql statement for creating schema mapping,

insert into "_SYS_BI"."M_SCHEMA_MAPPING" values('AUTH_SCHEMA_NAME','PHYSICAL_SCHEMA_NAME')

Regards,

Rashmi

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question