Question Re: Value help is displaying by using @Consumption.valueHelpDefinition: in Technology Q&A

Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Mon, 12 Apr 2021 09:05:25 GMT

Hi,

I am using Value help is displaying by using @Consumption.valueHelpDefinition: but it is not displaying and please find the below code.

1)I had created the below CDS View to get the list of Document Types

2)In the below CDS View i am using Annotation @Consumption.valueHelpDefinition: and given element and name(CDS View name)

3) As per the below screen still appearing as normal which should appear as valuehelp

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

mdcastle — Wed, 14 Apr 2021 08:00:04 GMT

Can you show how association to ZI_DOCUMENTTYPE_VH is defined in ZI_POSTINGS_R1V2?

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

mdcastle — Wed, 14 Apr 2021 08:06:35 GMT

Try something like this for your Value Help

@AbapCatalog.sqlViewName: 'ZVHSALESORDTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sales Order Types VH'
@ObjectModel.resultSet.sizeCategory: #XS
@Search.searchable: true
define view ZCDS_VH_SALES_ORDER_TYPES
  as select from tvakt


{
      @Search.defaultSearchElement: true
      @ObjectModel.text.element: ['SalesOrderDescription']
  key auart,
      @Semantics.text: true
      bezei as SalesOrderDescription


}
where
  spras = 'E'

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Wed, 14 Apr 2021 08:16:23 GMT

@mark_castle

Hi Mark,

Please find the below screen and i had not given any association between ZI_DOCUMENTTYPE_VH is defined in ZI_POSTINGS_R1V2.

But as per the below screen shot i had used for the ZI_COMPANYCODE_VH and it is displaying perfectly fine for the Cmpany Code

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Wed, 14 Apr 2021 08:20:00 GMT

@mark_castle

Hi Mark,

As you had asked me to do the change and i had done the change but still nothing is displaying.

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

mdcastle — Wed, 14 Apr 2021 08:21:57 GMT

Are you sure that the BUKRS Value Help isn't coming from the value help on the field from the database table, rather than ZI_COMPANYCODE_VH?

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Thu, 15 Apr 2021 07:16:36 GMT

@mark_castle

Hi,

I am getting those values in F4 which are there in the ZI_COMPANYCODE_VH. but i am not able to understand why it is not working for ZI_DOCUMENTTYPE_VH.

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Fri, 16 Apr 2021 08:14:32 GMT

@Mark Castle

Hi Mark,

I found out why for the ZI_COMPANYCODE_VH value is coming because for the field BUKRS there is search help and for the blart field there is no search help and can i know how to proceed.

but for field Blart there is not search help.

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

mdcastle — Fri, 16 Apr 2021 13:01:33 GMT

Create your value help e.g.

@AbapCatalog.sqlViewName: 'ZVHSALESORDTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sales Order Types VH'
@ObjectModel.resultSet.sizeCategory: #XS
@Search.searchable: true
define view ZCDS_VH_SALES_ORDER_TYPES
  as select from tvakt


{
      @Search.defaultSearchElement: true
      @ObjectModel.text.element: ['SalesOrderDescription']
  key auart,
      @Semantics.text: true
      bezei as SalesOrderDescription


}
where
  spras = 'E'

In your composite view

association [1]    to ZCDS_VH_SALES_ORDER_TYPES as _SalesOrderVH      on $projection.auart = _SalesOrderVH.auart
......
@ObjectModel.text.element: ['SalesOrderDescription']
auart,
@Semantics.text: true
@EndUserText.label: 'Sales Order Type'
_SalesOrderVH.SalesOrderDescription,
......
_SalesOrderVH,

In your consumption view

@Consumption.valueHelp: '_SalesOrderVH'
auart

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Wed, 21 Apr 2021 10:31:36 GMT

mark_castle

Hi Mark,

As per your instruction i had tried but still it is not displaying and please find the below screen shots in details.

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Wed, 21 Apr 2021 10:32:47 GMT

@mark_castle

Hi Mark,

But still it is same issue after following your instructions.

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

mdcastle — Wed, 21 Apr 2021 10:42:14 GMT

Post a screenshot of your OData service metadata showing the relevant fields and the association section. Also the local metadata.xml file in webapp->localService folder. Also, make sure that you have refreshed your Data Source in manifest (right click manifest.json -> Open Service Manager (if using BAS)).

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Thu, 22 Apr 2021 06:50:01 GMT

@mark_castle

Hi Mark,

please find the screen shot of ODATA Metadata.

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Thu, 22 Apr 2021 06:57:11 GMT

@Mark Castle

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Thu, 22 Apr 2021 06:59:10 GMT

@Mark Castle

local metadata.xml file in webapp->localService folder and also refreshed your Data Source in manifest (right click manifest.json -> Open Service Manager (if using BAS))

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Mon, 03 May 2021 06:28:55 GMT

@Mark Castle

Hi Mark,

Could you please help me on this as I had put all screen shots as you have requested.

Thanks

Durga Prasanth

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

mdcastle — Wed, 05 May 2021 15:38:11 GMT

Try adding

@ObjectModel.foreignKey.association: '_zi_doctype'

above blart in your Composite View.

However, looking at your OData service i would have expected to see an entry similar to the Company Code Value Help starting with

<EntityType Name="ZI_DOCUMENTTYPE_VH2"

so it looks like something is missing in the OData service. Have you tried re-publishing the OData service by activating the view with @Odata.publish: false, then re-activating with @OData.publish: true?

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Thu, 06 May 2021 07:07:28 GMT

mark_castle

Hi Mark,

As per your suggestion i had added the @ObjectModel.foreignKey.association:'_zi_doctype' and also done the @Odata.publish: false, then re-activating with @OData.publish: true. but still it is not appearing.

2)Please find the ODATA Service metadata

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

mdcastle — Thu, 06 May 2021 07:28:28 GMT

I’m out of ideas. The only thing I can think is that you’re seeing a cache issue in your browser, or the local metadata is out of sync.

Re: Value help is displaying by using @Consumption.valueHelpDefinition:

durgaprasanth_vemula — Mon, 17 May 2021 12:12:18 GMT

@Mark Castle

Hi Mark,

The metadata.xml file in the LocalService in the Business Application Studio is not getting refreshed and it is not sync and that is the reason Valuehelp is not working.

As per the below screen the changes are reflecting and could you please tell me how to sync.

Note:I found the below issue because when i again created a New Fiori App and fetch the ODATA service and Valuehelp is working.

Now my issue is how the metadata.xml will be sync in Business Application Studio?