2781481 - Unable to create model on OData service exposed by CDS view with parameters through Import S/4HANA connection in SAP Analytics Cloud (SAC)

• Unable to create model on OData service exposed by CDS view with parameters through Import S/4HANA connection in SAP Analytics Cloud (SAC) 
• Failed to upload data with error message:
  Error 1:
  ---------------
  status:500 body: {"error":{"code":"SY/530","message":{"lang":"en","value":"Unknown entity '$AE#CDS#<...>~*<...>' type 'SADL'"},
  "innererror":{"application":{"component_id":"BC-ESI-ESF-GW","service_namespace":"/SAP/","service_id":"<...>","service_version":"0001"},
  "transactionid":"<...>","timestamp":"<...>","Error_Resolution":{"SAP_Transaction":"For backend administrators: use ADT feed reader \"SAP Gateway Error Log\" or run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"code":"CX_SADL_UNKNOWN_ENTITY","message":"Unknown entity '$AE#CDS#<...>~*<...>' type 'SADL'","propertyref":"","severity":"error","target":""},{"code":"CX_SADL_CONTRACT_VIOLATION","message":"The entity '*<...>' was not found","propertyref":"","severity":"error","target":""},{"code":"/IWBEP/CX_MGW_TECH_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","target":""}]}}}
  ---------------
  
  Error 2:
  ---------------
  status:500 body:{"error":{"code":"SY/530","message":{"lang":"ja","value":"The entity '<...>' was not found"},"innererror":{"application":{"component_id":"FIN-FSCM-CLM","service_namespace":"/SAP/","service_id":"<...>","service_version":"0001"},"transactionid":"44E6640A04FD0120E005D08AA9BEF989","timestamp":"20190708034745.7331120","Error_Resolution":{"SAP_Transaction":"For backend administrators: run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"code":"CX_SADL_CONTRACT_VIOLATION","message":"The entity '<...>' was not found","propertyref":"","severity":"error","target":""},{"code":"/IWBEP/CX_MGW_MED_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","target":""}]}}}
  ---------------
  
  Error 3:
  ---------------
  status:500 body:{"error":{"code":"SY/530","message":{"lang":"ja","value":"The caller violated a precondition for a method call"},"innererror":{"application":{"component_id":"FIN-FSCM-CLM","service_namespace":"/SAP/","service_id":"<...>","service_version":"0001"},"transactionid":"44E6640A04FD0120E005D08AA9BEF98D","timestamp":"20190708034915.9854030","Error_Resolution":{"SAP_Transaction":"For backend administrators: run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"code":"LCX_MISSING_PARAMETER","message":"The caller violated a precondition for a method call","propertyref":"","severity":"error","target":""},{"code":"/IWBEP/CX_MGW_MED_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","target":""}]}}} 
  ---------------

• SAP Analytics Cloud Enterprise

1. Log on to SAC tenant.
2. Try to create a model based on Import S/4HANA connection.
3. Create a new query on the problematic custom CDS View.
4. Select all or partial objects and then click Create button.
   => Upload failed with error message.
   => Unable to create model on the specific Custom CDS View.

• This is limitation of Query Panel in current SAC product, which does not take any URL parameters when acquiring data from S/4HANA.

Note: 

• Please treat GRTransactionData and CnsldtnGrpJrnlItem as exception because we support these two services with mandatory parameters. See https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/4c002a6b954d43f18f3712cb10ac3cdc.html#sap-s/4hana

Please follow SAP KBA 2424376 to go to the SAP Analytics Cloud & SAP Digital Boardroom Customer Influence to create request a new feature, enhancement or improvement request that is not currently available in SAP Analytics Cloud (SAC).

Workaround-1: 

• Use Freehand query based on same Import S/4HANA connection to pass any parameter you'd like to the specific OData Service from S/4HANA:
• Example: <OData Service Name>/<EntitySet Name>(<Parameter 1 Name>='<WHATEVER-VALUE>',<Parameter 2 Name>='<WHATEVER-VALUE>')/<RESULTNAME>

Workaround-2:  Use OData Service connection with Freehand query to pass any parameter you'd like to the specific OData Service from S/4HANA. 

1. Create an OData Service connection in the SAC to URL of the specific OData Service exposed by CDS view with parameters.
   Example: https://<S/4HANA Host and port>/sap/opu/odata/sap/<OData Service Name>
2. Choose Freehand Query.
3. Enter query to include parameters
   => Example: <EntitySet Name>(<Parameter 1 Name>='<WHATEVER-VALUE>',<Parameter 2 Name>='<WHATEVER-VALUE>')/<RESULTNAME>
   => You can also test the query firstly using the completely URL in browser according to SAP KBA 2600276 and 2688637.
   
   

Note:

• EntitySet Name: Name of EntitySet with EntityType as <...>Parameters
• Find all parameters in EntityType <...>Parameters
• RESULTNAME: Name of NavigationProperty in EntityType <...>Parameters
• If the parameter has Type as Edm.DateTime (you can find it as Property in EntityType <...>Parameters), please specify the value in format datetime'yyyy-mm-ddThh:mm[:ss[.fffffff]]'  (example: datetime'2000-12-12T12:00'). See
  • SAP KBA 2982882
  • OData V2 data types

• How to find User Assistance for SAP Analytics Cloud?
• Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

Your feedback is important to help us improve our knowledge base.

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, S4, S4HC, S4HANA, Cloud, OData, CDS, Entity, service, model, query, custom, upload, failure, failed, SY/530, Unknown entity, SADL, CX_SADL_UNKNOWN_ENTITY, BC-ESI-ESF-GW, /IWFND/ERROR_LOG, parameter, Odata, URL, result, GRTransactionData, CnsldtnGrpJrnlItem , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Product Enhancement