Question Re: Date format in FIORI Elements List Report using Local Annotations in Technology Q&A

Date format in FIORI Elements List Report using Local Annotations

prasad — Fri, 14 Dec 2018 06:43:43 GMT

Hi all,

we have a OData service generated for list report in which one of the field in metadata.xml is Edm.String which is maintained as in back end which is a 8 character field as below

<Property Name="Start_date" Type="Edm.String" MaxLength="8" sap:display-format="NonNegative"/><Property Name="End_date" Type="Edm.String" MaxLength="8" sap:display-format="NonNegative"/>

This field when used as a UI DataField in local annotations as below

<Record Type="UI.DataField">
<PropertyValue Property="Value" Path="voyage_start"/>
<PropertyValue Property="Label" String="Voyage Start"/>
</Record>

we are getting the format as string as below

Can we format the date string in Fiori list report from UI side .
Maintain the column width to accommodate more fields in UI as if we have more than 8 fields all the fields are displayed down .

Regards

Prasad

Re: Date format in FIORI Elements List Report using Local Annotations

maheshpalavalli — Fri, 14 Dec 2018 07:34:08 GMT

Hi Prasad,

I can see that the property metadata shows it is of type string. It ideally should of type date time then SAP will automatically converts it for you.

You can change the property type to datetime and check the output. But if you don't want to do that, then you have to do a column extension and do the formatting manually I guess so better update the property

BR,

Mahesh

Re: Date format in FIORI Elements List Report using Local Annotations

prasad — Fri, 14 Dec 2018 09:08:59 GMT

Hi Mahesh,

Thanks for the reply.

Can you share me the details for column extension example . would like to do at front end and also is there any way we can adjust the column width for the list report?

Regards

Prasad

Re: Date format in FIORI Elements List Report using Local Annotations

maheshpalavalli — Fri, 14 Dec 2018 09:12:43 GMT

https://ui5.sap.com/#/topic/28e95702b5854b938ac51c4bc2d078ab

You can generate extensions using webide as well.

Any reason they you don't want to change the type to date in odata service?

Mahesh

Re: Date format in FIORI Elements List Report using Local Annotations

maheshpalavalli — Wed, 06 Feb 2019 13:59:21 GMT

Hi Prasad,

Check the link below

https://answers.sap.com/questions/745501/change-data-format-edmdatetime-to-show-only-date-i.html

Mahesh