cancel
Showing results for 
Search instead for 
Did you mean: 

Prompts not visible in model on S4HANA

vinayakgole
Active Participant
0 Kudos

Hi,

I am trying to build a model on S4HANA cds views. I have the odata enabled and I can use to cds view with a direct connection.

Now I want to use the view with a direct connection so the other features of SAC can be explored. However when I select the cds view, I get an error indicating that the data model failed. When I check the error, I get the error as:

The following error message comes from the external data service: status:400 body:{"error":{"code":"BW_BICS_EQ/123","message":{"lang":"en","value":"Mandatory filter Plant is missing"},"innererror":{"application":{"component_id":"MM-IM-VDM-SGM","service_namespace":"/SAP/","service_id":"C_STOCKQUANTITYVALUEBYTYPE_CDS","service_version":"0001"},"transactionid":"4C6D113292770050E005C2454DA875C2","timestamp":"","Error_Resolution":{"SAP_Transaction":"","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"code":"","message":"","propertyref":"","severity":"error","target":""},{"code":"BW_BICS_EQ/123","message":"Mandatory filter Plant is missing","propertyref":"","severity":"error","target":""}]}}}

So I see that the mandatory filter is missing. However, there is no option to enter the filter while building the data model as can be seen in the screenshot.

Please advise how I can input mandatory prompts into the query above. I get the option in direct connection but with import connection there is nothing.

Many thanks in advance

Regards,

Vinayak

View Entire Topic
0 Kudos

Hi

same problem for me with SAC business content (CDS : C_GLACCOUNTFLOW)

Any update ?

Thank you !