App Extensibility: Manage Product Master via CDS Extension leads to Gateway Error

[mischarf]

Dear Experts,

I need to add the filed kzkup from the MARC Table to Manage Product Master App. The Field is available in the CDS View I_ProductPlantBasic with the name  IsCoProduct. Its not available in the views C_Productplant and I_ProductPlantWD. Therefore I want to bring it to these views via CDS Extension. Doing this leads to an internal server. 

C_Productplant is an extensible CDS view which is explicitly mentioned in the extensbilty help for the app:
https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/bc6b9325fedd4344a84412b2195064fa/ecb59556027ed75fe10...

Here is my coding for the extension of I_ProductPlantWD

@AbapCatalog.sqlViewAppendName: 'ZIPRDPLANTWD_EXT'
@EndUserText.label: 'Extension for I_ProductPlantWD'
extend view I_ProductPlantWD with ZI_ProductPlantWD_EXT
{
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
    Plant.IsCoProduct
}

Here is my coding for the extension of C_Productplant

@AbapCatalog.sqlViewAppendName: 'ZCPRDPLANT_EXT'
@EndUserText.label: 'Extension for C_Productplant_EXT'
extend view C_Productplant with ZC_Productplant_EXT
{
    @ObjectModel.readOnly: true
     Plant.IsCoProduct
}

This leads to the following error in the service sap/opu/odata/sap/MD_C_PRODUCT_MAINTAIN_SRV/ :

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code>0050569259751EE4BA9710043F8A5115</code>
<message xml:lang="en">In the context of Data Services an unknown internal server error occurred</message>
<innererror xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<transactionid>EE663C5CB30C01F0E00671163EABB58C</transactionid>
<timestamp>20241017192511.6704920</timestamp>
<Error_Resolution>
<SAP_Transaction>For backend administrators: use ADT feed reader "SAP Gateway Error Log" or run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details</SAP_Transaction>
<SAP_Note>See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)</SAP_Note>
</Error_Resolution>
</innererror>
</error>

/IWFND/ERROR_LOG shows:

<ERROR_CONTEXT>
<ERROR_INFO>Element ISCOPRODUCT missing in the entity PROD_PLANT (CORE)</ERROR_INFO>
<ERROR_RESOLUTION>
<SAP_NOTE>See SAP Note 1797736 for error analysis</SAP_NOTE>
<LINK_TO_SAP_NOTE>https://service.sap.com/sap/support/notes/1797736</LINK_TO_SAP_NOTE>
</ERROR_RESOLUTION>
<Exceptions>
<_-IWCOR_-CX_DS_INTERNAL_ERROR>
<Text>In the context of Data Services an unknown internal server error occurred</Text>
<Source>
<Program>SAPMHTTP</Program>
</Source>
</_-IWCOR_-CX_DS_INTERNAL_ERROR>
<LCX_PREPARATION_FAILED>
<Text>See previous in exception chain.</Text>
<Source>
<Program>CL_SADL_MDP_EXPOSURE==========CP</Program>
<Include>CL_SADL_MDP_EXPOSURE==========CM00B</Include>
<Line>53</Line>
</Source>
</LCX_PREPARATION_FAILED>
<CX_SADL_EXPOSURE_COMPILER>
<Text>Error in entity 'C_PRODUCTPLANT(CDS)': Element ISCOPRODUCT missing in the entity PROD_PLANT (CORE)</Text>
<Attributes>
<LIMIT>0</LIMIT>
<MESSAGE_TEXT>Element ISCOPRODUCT missing in the entity PROD_PLANT (CORE)</MESSAGE_TEXT>
<MSGV1>Element ISCOPRODUCT missing in the entity PROD_PLA</MSGV1>
<MSGV2>NT (CORE)</MSGV2>
<TYPED_ENTITY>C_PRODUCTPLANT(CDS)</TYPED_ENTITY>
</Attributes>
<Source>
<Program>CX_SADL_EXPOSURE_COMPILER=====CP</Program>
<Include>CX_SADL_EXPOSURE_COMPILER=====CM004</Include>
<Line>2</Line>
</Source>
</CX_SADL_EXPOSURE_COMPILER>
<CX_SADL_EC_ELEMENT_MISSING>
<Text>Element ISCOPRODUCT missing in the entity PROD_PLANT (CORE)</Text>
<Attributes>
<ELEMENT_NAME>ISCOPRODUCT</ELEMENT_NAME>
<ENTITY_FLAVOR>CORE</ENTITY_FLAVOR>
<ENTITY_NAME>PROD_PLANT</ENTITY_NAME>
</Attributes>
<Source>
<Program>CX_SADL_EC_ELEMENT_MISSING====CP</Program>
<Include>CX_SADL_EC_ELEMENT_MISSING====CM002</Include>
<Line>2</Line>
</Source>
</CX_SADL_EC_ELEMENT_MISSING>
</Exceptions>
<SERVICE_INFO>
<NAMESPACE>/SAP/</NAMESPACE>
<SERVICE_NAME>MD_C_PRODUCT_MAINTAIN_SRV</SERVICE_NAME>
<VERSION>0001</VERSION>
</SERVICE_INFO>
<SYSTEM_INFO>
<REQUEST_URI>/sap/opu/odata/sap/MD_C_PRODUCT_MAINTAIN_SRV/***Hide_due_to_secure_log_level***</REQUEST_URI>
<REMOTE_ADDRESS>#####</REMOTE_ADDRESS>
<APPLICATION_SERVER>######_00</APPLICATION_SERVER>
<HUB_VERSION_INFO>######, Rel. 7.58, SAP_GWFND SP01, GWHUB Version 031</HUB_VERSION_INFO>
<BEP_VERSION_INFO>not yet available</BEP_VERSION_INFO>
</SYSTEM_INFO>
</ERROR_CONTEXT>

What am I missing? Thanks for your feedback!

[Maciej__Galica]

Hi,

PROD_PLANT is the draft table and needs to be extended as well.

Please follow the steps in this blog:

Extending Transactional Fiori App based on Fiori E... - SAP Community

Best Regards

Maciej