cancel
Showing results for 
Search instead for 
Did you mean: 

Custom CDS-View: I_MfgOrderOperationWithStatus as a external API not working

RemoSchuepbach
Discoverer
0 Kudos
199

Hello,
I have a question on the key user extensibility / Custom CDS-Views of SAP S/4HANA Cloud Public Edition

To consume Information of Manufacturing Order Operations, we would like to generate an external API via Custom CDS-View Structure on the Data source: I_MfgOrderOperationWithStatus. When we consume the API (in Excel for example) the following runtime Error appears: RemoSchuepbach_0-1725008006888.png

When we select just the top ten results of the query, its working. But when we want to get more results, like 100 or 1000 the runtime error appears. Does anyone know what the problem could be?

Here I have some additional Information:
When I select the SAP View I_MfgOrderOperationWithStatus as the Main Data Source in the custom CDS-View the following Log Detail is shown:

RemoSchuepbach_1-1725008828378.png

Does this mean that we cannot use this data source in an external API scenario? And if it is, can you already see it somewhere in the view-browser on the data source descriptions? 

Thanks a lot for your help!
Best Regards 

OwenLiu
Product and Topic Expert
Product and Topic Expert
Added Manufacturing tag, please remove tag SAP S/4HANA Cloud Public Edition.
RemoSchuepbach
Discoverer
0 Kudos
I was able to solve it. The problem was on the datatype level. A calculated field had an inappropriate data type, which caused the problems. Then there is only one question left. Does anyone know, what the warnings in the 2nd screenshot mean?

Accepted Solutions (0)

Answers (1)

Answers (1)

Prabha_A
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @RemoSchuepbach,

Please refer the bleow SAP help portal for creating Custom CDS view as an External API,

https://help.sap.com/docs/SAP_S4HANA_CLOUD/0f69f8fb28ac4bf48d2b57b9637e81fa/99bb89d15ed74fe2aa7ceac2...

BR,

Prabha A