Showing results for 
Search instead for 
Did you mean: 

Prompts not visible in model on S4HANA

Active Participant
0 Kudos


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 ("},"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



View Entire Topic
0 Kudos


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

Any update ?

Thank you !