cancel
Showing results for 
Search instead for 
Did you mean: 

Query on running SMIGR_CREATE_DDL in source system

Appuru
Explorer
0 Kudos
73

Hi All,

We are planning to perform a heterogeneous system copy for the following environment:

Source System Details:

SAP NetWeaver Release (ECC system):
SAP NETWEAVER 7.5 04
EHP8 FOR SAP ERP 6.0 EHP8 FOR SAP ERP 6.0 03 (08/2016)

DB-SID: DEV
Database: Oracle 19.24.0.0.0
Operating System: AIX 7300-01-02-2320
Hostname: eccdev

Target System Details:
DB-SID: DEV
Database: SAP HANA 2.0 SP79.01
Operating System: SLES 15 SP5
Hostname: eccdev

Kindly provide clarification on my below query.

A) Should i execute the report SHDB_GROUP_TABLES_LOAD_BASED before running the SMIGR_CREATE_DDL report in production client of Soruce system

A) When executing SMIGR_CREATE_DDL under HANA options, should we select the following settings?

1.Table Classification
2.Estimated Table Size
3.SAP Business Suite on HANA

Or should we leave it as default ( 1.Table Classification and 2.Estimated Table Size) and proceed with executing the program? Or do we need to remove all the options when running SMIGR_CREATE_DDL

B)According to the system copy guide, could you please confirm if we need to implement the notes included in the attachment of SAP Note 1908075 (REQUIRED_CORRECTION_NOTES.zip)? My system version is SAP NW 7.5 SPS4 ECC instance.

2279106
2264053
2299268
2312217
2324379
2378341
2421685
2347004
2458360
2471909

When I review the notes, they all refer to SAP BW on HANA or BW/HANA, which caused my confusion. Could you please advise me, as my system is an ECC instance?

Regards
Appuru

View Entire Topic
JamesZ
Product and Topic Expert
Product and Topic Expert
0 Kudos

A) Should i execute the report SHDB_GROUP_TABLES_LOAD_BASED before running the SMIGR_CREATE_DDL report in production client of Soruce system

=> We can refer to SAP note 1850480 :
The report must be executed before the migration, in particular before running SMIGR_CREATE_DDL with the option "TO_DB".

A) When executing SMIGR_CREATE_DDL under HANA options, should we select the following settings? 1.Table Classification 2.Estimated Table Size 3.SAP Business Suite on HANA Or should we leave it as default ( 1.Table Classification and 2.Estimated Table Size) and proceed with executing the program? Or do we need to remove all the options when running SMIGR_CREATE_DDL

=> normally we leave as default if system guide or referring doc doesn't clearly mentioned to use any option.

B)According to the system copy guide, could you please confirm if we need to implement the notes included in the attachment of SAP Note 1908075 (REQUIRED_CORRECTION_NOTES.zip)? My system version is SAP NW 7.5 SPS4 ECC instance.
=> As long as the system version especially sap_basis allows, we can apply it.
Take note 2312217 as example, it fixed the issue during migrating to HANA.
So it should apply to the ECC system if the note version is suitable to ECC.

Best regards,
James