Skip to Content
0
Sep 28, 2016 at 12:45 PM

SAP FIORI OVP tutorial with cds : numbers not displayed.

333 Views

Hello all (gurus and others)...

I have followed the excellent blog from Jamie Cawley at :http://scn.sap.com/community/developer-center/front-end/blog/2016/07/05/creating-a-fiori-ovp-application-with-cds-view-annotations--part-1

everything is working perfectly, except that when i run the app I do not get the numbers displayed :


My CDS View is defined as :

@AbapCatalog.sqlViewName: 'zovpdemo1'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'OVP Demo App on Gateway'

@OData.publish: true

define view Z_Ovp_Demo1 as select from sepm_cds_sales_order as so {

key so.sales_order_key,

@UI.selectionField: [{ position: 10 }]

@UI.lineItem: { position: 10, qualifier:'ordOverView', label: 'Sales Order' }

so.sales_order_id,

so.created_by,

so.created_at,

so.changed_by,

so.changed_at,

so.note_guid,

so.currency_code,

so.gross_amount,

@UI.lineItem: { position: 30, qualifier:'ordOverView', label: 'Net Amount'}

so.net_amount,

so.tax_amount,

so.lifecycle_status,

so.billing_status,

so.delivery_status,

so.buyer_guid,

/* Associations */

so.customer,

so.items,

@UI.selectionField: [ { position: 20 } ]

@UI.lineItem: { position: 20, qualifier:'ordOverView', label: 'Customer' }

so.customer.company_name

}

My manisfest.json :

"sap.ovp": {

"_version": "1.1.0",

"globalFilterModel": "Z_OVP_DEMO1_CDS",

"globalFilterEntityType": "Z_Ovp_Demo1Type",

"cards": {

"com.demo_card00": {

"model": "Z_OVP_DEMO1_CDS",

"template": "sap.ovp.cards.table",

"settings": {

"title": "{{com.demo_card00_title}}",

"subTitle": "{{com.demo_card00_subTitle}}",

"entitySet": "Z_Ovp_Demo1",

"addODataSelect": "false",

"annotationPath": "com.sap.vocabularies.UI.v1.LineItem#ordOverView"

}

}

}

},

my metadata.xml includes :

<EntityType Name="Z_Ovp_Demo1Type" sap:label="OVP Demo App on Gateway" sap:content-version="1">

<Key>

<PropertyRef Name="sales_order_key"/>

</Key>

<Property Name="sales_order_key" Type="Edm.Guid" Nullable="false" sap:label="Node Key"/>

<Property Name="sales_order_id" Type="Edm.String" MaxLength="10" sap:display-format="UpperCase" sap:label="Sales Order ID"/>

<Property Name="created_by" Type="Edm.Guid" sap:label="Node Key"/>

<Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7" sap:label="Created At"/>

<Property Name="changed_by" Type="Edm.Guid" sap:label="Node Key"/>

<Property Name="changed_at" Type="Edm.DateTimeOffset" Precision="7" sap:label="Changed At"/>

<Property Name="note_guid" Type="Edm.Guid" sap:label="Node Key"/>

<Property Name="currency_code" Type="Edm.String" MaxLength="5" sap:label="Currency Code" sap:semantics="currency-code"/>

<Property Name="gross_amount" Type="Edm.Decimal" Precision="16" Scale="3" sap:unit="currency_code" sap:label="Gross Amount"/>

<Property Name="net_amount" Type="Edm.Decimal" Precision="16" Scale="3" sap:unit="currency_code" sap:label="Net Amount"/>

<Property Name="tax_amount" Type="Edm.Decimal" Precision="16" Scale="3" sap:unit="currency_code" sap:label="Tax Amount"/>

<Property Name="lifecycle_status" Type="Edm.String" MaxLength="1" sap:display-format="UpperCase" sap:label="Lifecycle Status"/>

<Property Name="billing_status" Type="Edm.String" MaxLength="1" sap:display-format="UpperCase" sap:label="Confirmation Status"/>

<Property Name="delivery_status" Type="Edm.String" MaxLength="1" sap:display-format="UpperCase" sap:label="Ordering Status"/>

<Property Name="buyer_guid" Type="Edm.Guid" sap:label="Node Key"/>

<Property Name="company_name" Type="Edm.String" MaxLength="80" sap:label="Company"/>

<NavigationProperty Name="tocustomer" Relationship="Z_OVP_DEMO1_CDS.assoc_0CFA20832D9A6542392C03D99CAB657E" FromRole="FromRole_assoc_0CFA20832D9A6542392C03D99CAB657E" ToRole="ToRole_assoc_0CFA20832D9A6542392C03D99CAB657E"/>

<NavigationProperty Name="toitems" Relationship="Z_OVP_DEMO1_CDS.assoc_676F199F5B5CA567005EB30EEDE7C6C0" FromRole="FromRole_assoc_676F199F5B5CA567005EB30EEDE7C6C0" ToRole="ToRole_assoc_676F199F5B5CA567005EB30EEDE7C6C0"/>

</EntityType>

my annotation file includes :

<Schema

xmlns="http://docs.oasis-open.org/odata/ns/edm" Namespace="z_ovp_demo1_cds_van.v1">

<Annotations Target="sap.com.cds_z_ovp_demo1.Z_Ovp_Demo1Type">

<Annotation Term="UI.LineItem" Qualifier="ordOverView">

<Collection>

<Record Type="UI.DataField">

<PropertyValue Property="Label" String="Sales Order"/>

<PropertyValue Property="Value" Path="sales_order_id"/>

</Record>

<Record Type="UI.DataField">-->

<PropertyValue Property="Label" String="Net Amount"/>

<PropertyValue Property="Value" Path="net_amount"/>

</Record>

<Record Type="UI.DataField">

<PropertyValue Property="Label" String="Customer"/>

<PropertyValue Property="Value" Path="company_name"/>

</Record>

</Collection>

</Annotation>

<Annotation Term="UI.SelectionFields">

<Collection>

<PropertyPath>sales_order_id</PropertyPath>

<PropertyPath>company_name</PropertyPath>

</Collection>

</Annotation>

</Annotations>

</Schema>

Could someone help to figure out where is the error/bugs ?

Thanks.