topic Re: ODATA Publish Failed in Application Development and Automation Discussions

ODATA Publish Failed

fikretsomay — Mon, 04 Feb 2019 16:10:29 GMT

Hi,

I ınstalled 7.50 developer sp02 on my computer. I got warnings when i want to activate Odata publish. I can see that view is created but service is not created, and I dont see my service on /IWFND/MAINT_SERVICE.

could you help me to fx this?

No access control for entity ZMARA_DDL. Create DCL or use annot. AccessControl [Access Control Management]
OData exposure failed due to missing key elements in 'ZMARA_DDL' [OData Exposure]
The service ZMARA_DDL_CDS does not exist [OData Exposure]

My code as follows:

@AbapCatalog.sqlViewName: 'ZMARA_V_002'
//@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'ZMARA_DDL'

@ObjectModel.semanticKey: ['matnr']
@OData.publish: true 
define view ZMARA_DDL as select from zmara 
    {
        matnr,
        maktx 
     }

Re: ODATA Publish Failed

maheshpalavalli — Mon, 04 Feb 2019 16:45:55 GMT

Hi Fikret,

Make one of the column as the key field and try to activate again.

BR,

Mahesh

Re: ODATA Publish Failed

fikretsomay — Mon, 04 Feb 2019 17:29:14 GMT

Matnr column is already key in main table Zmara. Did you mean that?

Re: ODATA Publish Failed

maheshpalavalli — Mon, 04 Feb 2019 17:53:21 GMT

No, you need to make a field in the CDS view as key field so that it generates the OData service and creates the entity for that.. Even if you manually create a odata service, it is required to mention atleast one of the field in the entity as the key field. So here also in the CDS view it is required to mark one as a key.. (It will not take key from zmara btw, you need to explicitly mention it)

define view ZMARA_DDL as select from zmara 
    {
        key matnr,
        maktx 
     }

BR,

Mahesh

Re: ODATA Publish Failed

fikretsomay — Mon, 04 Feb 2019 18:19:42 GMT

Thank you, that resolved my problem.

Re: ODATA Publish Failed

former_member697514 — Mon, 28 Dec 2020 10:06:12 GMT

Hi,

If you want to consume cds views in odata then rules should be meet are:

1. cds view should have at least one primary key in it.

2. no syntax error in ddl.

3 The length of cds view name should not be greater than 16

if above mentioned rules are fulfilled then in /IWFND/MAINT_SERVICE. we can find services.