CDS BOPF Issue while Create Record

[Andre_Fischer]

HI All,

I Created a CDS View and Enabled BOPF and Trying to Post a Record.

But on Post am getting an error Message like KEY is Missing.

Please Kindly help mebopf-error.png to resolve this issue.

Please Kindly find the attached Screen shot for detailed error.

[Andre_Fischer]

Without knowing more details such as cds source code how do expect that someone will be able to help you?

[mantrishekar]

HI Andre Fisher,

Please find the below Code for CDS.

@AbapCatalog.sqlViewName: 'ZOFTCFLMEAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Flight Meals'
@OData.publish: true
@Metadata.allowExtensions: true
@ObjectModel :{
modelCategory : #BUSINESS_OBJECT,
compositionRoot : true,
transactionalProcessingEnabled: true,
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
writeActivePersistence: 'ZOFT_FLIGHT_MEAL'
}
define view ZOFT_C_FL_MEAL as select from zoft_flight_meal
association [1] to scarr as _Airline on $projection.carrid = _Airline.carrid
association [1] to sflight as _FlightInfo on $projection.carrid = _FlightInfo.carrid
and $projection.connid = _FlightInfo.connid
association [1] to smeal as _Meals on $projection.carrid = _Meals.carrid
and $projection.meal = _Meals.mealnumber

{
//zoft_flight_meal
key meal_id,
@ObjectModel.foreignKey.association: '_Airline'
carrid,
@ObjectModel.foreignKey.association: '_FlightInfo'
connid,
@ObjectModel.foreignKey.association: '_Meals'
meal,
total_seats,
status,
_Airline, // Make association public
_FlightInfo,
_Meals
}

[pmcfarling]

What is the data type of meal_id?

[mantrishekar]

Hi Paul,

Data type for meal_id is char 32.

Regards,

Shekar.