3733465 - Error while creating Replication Flow without any further information (missing parameter I_HIER_FLATTENING)

• Importing objects in a Replication Flow fails with: “Number of objects that have been imported: 0. Number of objects that could not be imported:...”
• When selecting an ODP_SAPI extractor (for example 0MAT_UNIT_ATTR), the message can also appear as: “Number of objects that have been imported: 0. Number of objects that could not be imported: 1.”
• No detailed application logs are provided beyond the above messages.
• No missing authorizations detected (SU53, ST01 show no issues).
• Recording a network trace, following details are provided in the Response: 
  • "Getting dataset definition failed for /ODP_SAPI/xxxx.”
  • "Call of the function RODPS_REPL_ODP_GET_DETAIL failed; the formal parameter I_HIER_FLATTENING does not exist"
• All ODP_SAPI objects fail with the same error.

• SAP Datasphere
• SAP ERP

1. Go to Data Builder in SAP Datasphere.
2. Create a new Replication Flow.
3. Select the ABAP connection to the on-premise source system and choose the ODP_SAPI container.
4. Select an ODP_SAPI extractor (for example 0MAT_UNIT_ATTR).
5. Continue to import the selected objects.
6. Observe that the import fails with “Number of objects that have been imported: 0. Number of objects that could not be imported: ,” and backend errors as listed in the Symptoms.

• The ABAP source system’s ODP API does not contain the required hierarchy flattening enhancement. The function module RODPS_REPL_ODP_GET_DETAIL lacks the formal parameter I_HIER_FLATTENING, which causes metadata retrieval for ODP_SAPI objects to fail.

1. Implement the following SAP Notes in the ABAP source system:
   • 2841883 - Enable ODP API for flattened hierarchy loading.
   • 3069618 - Enable hierarchy flattening during metadata extraction of ODP objects in Data Intelligence.
   • 3398533 - ODP Hierarchy Flattening: Incorrect Key and Selection Fields.
   • 3429152 - ODP Hierarchy Flattening: Mandatory selection in hierarchy node.
2. If browsing or importing ODP metadata is affected by folder paths or special characters, implement also relevant SAP Note 3596322 - Data Integration ABAP – Enable ODP metadata filtering.

• KBA 3393498 - 'Call of the function RODPS_REPL_ODP_GET_DETAIL failed' occurred when viewing the Fact Sheet of ODP_SAPI objects - SAP DI.
• KBA 3405253 - How to collect network trace using “Developers Tools”.

replication flow, odp_sapi, I_HIER_FLATTENING, getcsndefinitionfailed, dataflowrequesterror, code 10002, rodps_repl_odp_get_detail, i_hier_flattening, dataset definition failed, 0 imported, import failed, abap odp_sapi, metadata retrieval, hierarchy flattening , KBA , DS-DI-RF , Replication Flow Runtime , DS-DI-RF-UI , Replication Flow editor, monitoring and deployment , Problem