Skip to Content
0

Value list is not showing the any data

Feb 15, 2017 at 07:17 PM

90

avatar image

Hi Attila,

I am trying to create a value list for one of the property in my entityset and has a F4 help service\entity defined as part of same service. I am able to do this as part of annotation definition on gate way service builder and metadata shows-up with value list annotation term. Also smart filter shows the filter option with F4 help but when clicked on the F4 help table does not show any data also table has no columns too below is the screen shots for the same.

Metadatdata

<edmx:Edmx xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"xmlns:sap="http://www.sap.com/Protocols/SAPData" Version="1.0">"); vertical-align: bottom; height: 10px;"><edmx:Reference xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx" Uri="http://slonvdsapapp39-app.ad.adsinternal.com:8000/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/Vocabularies(TechnicalName='%2FIWBEP%2FVOC_UI',Version='0001',SAP__Origin='BACK_1')/$value"><edmx:Include Namespace="com.sap.vocabularies.UI.v1"/>
</edmx:Reference>
"); vertical-align: bottom; height: 10px;"><edmx:Reference xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx" Uri="http://slonvdsapapp39-app.ad.adsinternal.com:8000/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/Vocabularies(TechnicalName='%2FIWBEP%2FVOC_CORE',Version='0001',SAP__Origin='BACK_1')/$value"><edmx:Include Namespace="Org.OData.Core.V1"/>
</edmx:Reference>
"); vertical-align: bottom; height: 10px;"><edmx:Reference xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx" Uri="http://slonvdsapapp39-app.ad.adsinternal.com:8000/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/Vocabularies(TechnicalName='%2FIWBEP%2FVOC_COMMUNICATION',Version='0001',SAP__Origin='BACK_1')/$value"><edmx:Include Namespace="com.sap.vocabularies.Communication.v1"/>
</edmx:Reference>
"); vertical-align: bottom; height: 10px;"><edmx:Reference xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx" Uri="http://slonvdsapapp39-app.ad.adsinternal.com:8000/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/Vocabularies(TechnicalName='%2FIWBEP%2FVOC_COMMON',Version='0001',SAP__Origin='BACK_1')/$value"><edmx:Include Namespace="com.sap.vocabularies.Common.v1"/>
</edmx:Reference>
"); vertical-align: bottom; height: 10px;"><edmx:DataServices m:DataServiceVersion="2.0">"); vertical-align: bottom; height: 10px;"><Schema xmlns="http://schemas.microsoft.com/ado/2008/09/edm" Namespace="ZSMARTTABLE4_SRV" xml:lang="en" sap:schema-version="1">"); vertical-align: bottom; height: 10px;"><EntityType Name="SmartTable" sap:content-version="1">"); vertical-align: bottom; height: 10px;"><Key>
<PropertyRef Name="Pernr"/>
</Key>
<Property Name="Werks" Type="Edm.String" Nullable="false" MaxLength="4" sap:label="Plant"/>
<Property Name="Begda" Type="Edm.DateTime" Nullable="false" Precision="7" sap:label="Start Date"/>
<Property Name="Endda" Type="Edm.DateTime" Nullable="false" Precision="7" sap:label="End Date"/>
<Property Name="Pernr" Type="Edm.String" Nullable="false" MaxLength="8" sap:label="Personnel No."/>
<Property Name="Ename" Type="Edm.String" Nullable="false" MaxLength="40" sap:label="Empl./Appl.Name"/></EntityType>
"); vertical-align: bottom; height: 10px;"><EntityType Name="Team" sap:content-version="1">"); vertical-align: bottom; height: 10px;"><Key>
<PropertyRef Name="Zzteam"/>
</Key>
<Property Name="Pernr" Type="Edm.String" Nullable="false" MaxLength="8" sap:label="Personnel No."/>
<Property Name="Zzteam" Type="Edm.String" Nullable="false" MaxLength="4" sap:label="Fee Earner Team"/>
<Property Name="Zzdesc" Type="Edm.String" Nullable="false" MaxLength="60" sap:label="Description"/></EntityType>
"); vertical-align: bottom; height: 10px;"><EntityContainer Name="ZSMARTTABLE4_SRV_Entities" m:IsDefaultEntityContainer="true" sap:supported-formats="atom json xlsx"><EntitySet Name="SmartTableSet" EntityType="ZSMARTTABLE4_SRV.SmartTable" sap:content-version="1"/>
<EntitySet Name="TeamSet" EntityType="ZSMARTTABLE4_SRV.Team" sap:content-version="1"/>
</EntityContainer>
"); vertical-align: bottom; height: 10px;"><Annotations xmlns="http://docs.oasis-open.org/odata/ns/edm" Target="ZSMARTTABLE4_SRV.SmartTable/Werks">"); vertical-align: bottom; height: 10px;"><Annotation Term="com.sap.vocabularies.Common.v1.ValueList">"); vertical-align: bottom; height: 10px;"><Record Type="com.sap.vocabularies.Common.v1.ValueListType"><PropertyValue Property="Label" String="Billing office 1"/>
<PropertyValue Property="CollectionPath" String="TeamSet"/>
<PropertyValue Property="CollectionRoot" String=""/>
<PropertyValue Property="SearchSupported" Bool="true"/>"); vertical-align: bottom; height: 10px;"><PropertyValue Property="Parameters">"); vertical-align: bottom; height: 10px;"><Collection>
"); vertical-align: bottom; height: 10px;"><Record Type="com.sap.vocabularies.Common.v1.ValueListParameterIn"><PropertyValue Property="ValueListProperty" PropertyPath="Pernr"/>
<PropertyValue Property="LocalDataProperty" PropertyPath="Pernr"/>
</Record>
"); vertical-align: bottom; height: 10px;"><Record Type="com.sap.vocabularies.Common.v1.ValueListParameterDisplayOnly"><PropertyValue Property="ValueListProperty" PropertyPath="Zzteam"/>
</Record>
"); vertical-align: bottom; height: 10px;"><Record Type="com.sap.vocabularies.Common.v1.ValueListParameterDisplayOnly"><PropertyValue Property="ValueListProperty" PropertyPath="Zzdesc"/>
</Record>
</Collection>
</PropertyValue>
</Record>
</Annotation>
</Annotations>
"); vertical-align: bottom; height: 10px;"><Annotations xmlns="http://docs.oasis-open.org/odata/ns/edm" Target="ZSMARTTABLE4_SRV.SmartTable/Pernr">"); vertical-align: bottom; height: 10px;"><Annotation Term="com.sap.vocabularies.Common.v1.ValueList">"); vertical-align: bottom; height: 10px;"><Record Type="com.sap.vocabularies.Common.v1.ValueListType"><PropertyValue Property="Label" String="Perner Label"/>
<PropertyValue Property="CollectionPath" PropertyPath="TeamSet"/>
<PropertyValue Property="CollectionRoot" String=""/>
<PropertyValue Property="SearchSupported" Bool="false"/>"); vertical-align: bottom; height: 10px;"><PropertyValue Property="Parameters">"); vertical-align: bottom; height: 10px;"><Collection>
"); vertical-align: bottom; height: 10px;"><Record Type="com.sap.vocabularies.Common.v1.ValueListParameterDisplayOnly"><PropertyValue Property="ValueListProperty" String="Zzteam"/>
</Record>
"); vertical-align: bottom; height: 10px;"><Record Type="com.sap.vocabularies.Common.v1.ValueListParameterInOut"><PropertyValue Property="ValueListProperty" String="Pernr"/>
<PropertyValue Property="LocalDataProperty" PropertyPath="Pernr"/>
</Record>
</Collection>
</PropertyValue>
</Record>
</Annotation>
</Annotations>
<atom:link xmlns:atom="http://www.w3.org/2005/Atom" rel="self" href="http://slonvdsapapp39-app.ad.adsinternal.com:8000/sap/opu/odata/sap/ZSMARTTABLE4_SRV/$metadata"/>
<atom:link xmlns:atom="http://www.w3.org/2005/Atom" rel="latest-version" href="http://slonvdsapapp39-app.ad.adsinternal.com:8000/sap/opu/odata/sap/ZSMARTTABLE4_SRV/$metadata"/></Schema>
</edmx:DataServices>
</edmx:Edmx>

valuelist1.jpgvl2.jpg

valuelist1.jpg (70.8 kB)
vl2.jpg (86.5 kB)
valuelist1.jpg (70.8 kB)
vl2.jpg (86.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Veeraraghavan Narasimhan
Feb 16, 2017 at 04:05 PM
0

Hello ,

Without looking into exact code it is tough to troubleshoot. One thing i could sense is that there was something wrong about annotation or rather something did not feel right.

<Annotation Term="com.sap.vocabularies.Common.v1.ValueList">
                    <Record Type="com.sap.vocabularies.Common.v1.ValueListType">
                        <PropertyValue Property="Label" String="Perner Label"/>
                        <PropertyValue Property="CollectionPath" PropertyPath="TeamSet"/>
                        <PropertyValue Property="CollectionRoot" String=""/>
                        <PropertyValue Property="SearchSupported" Bool="false"/>
                        <PropertyValue Property="Parameters">
                            <Collection>


                                <Record Type="com.sap.vocabularies.Common.v1.ValueListParameterDisplayOnly">
                                    <PropertyValue Property="ValueListProperty" String="Zzteam"/>
                                </Record>


                                <Record Type="com.sap.vocabularies.Common.v1.ValueListParameterInOut">
                                    <PropertyValue Property="ValueListProperty" String="Pernr"/>
                                    <PropertyValue Property="LocalDataProperty" PropertyPath="Pernr"/>
                                </Record>
                            </Collection>
                        </PropertyValue>
                    </Record>
         

And i picked an example from SAP Help

<Annotations Target="com.sap.wt02.Product/CurrencyCode"
				xmlns="http://docs.oasis-open.org/odata/ns/edm">
<Annotation Term="com.sap.vocabularies.Common.v1.ValueList">
	<Record>
		<PropertyValue Property="Label" String="Currency"/>
		<PropertyValue Property="CollectionPath" String="Currency"/>
		<PropertyValue Property="SearchSupported" Bool="true"/>
		<PropertyValue Property="Parameters">
			<Collection>
<Record Type="com.sap.vocabularies.Common.v1.ValueListParameterOut">
					<PropertyValue Property="LocalDataProperty" PropertyPath="CurrencyCode" />
					<PropertyValue Property="ValueListProperty" String="CURR" />
				</Record>
				<Record Type="com.sap.vocabularies.Common.v1.ValueListParameterDisplayOnly">
					<PropertyValue Property="ValueListProperty" String="DESCR" />
				</Record>
			</Collection>
		</PropertyValue>
	</Record>
</Annotation>

I could see

<Record Type="com.sap.vocabularies.Common.v1.ValueListType">

This is standard example and i see for the term ValueList the record type is not mentioned. Maybe this is the issue . Can you check by correcting if it works.

<Record>
                        <PropertyValue Property="Label" String="Perner Label"/>
                        <PropertyValue Property="CollectionPath" PropertyPath="TeamSet"/>
                        <PropertyValue Property="CollectionRoot" String=""/>
                        <PropertyValue Property="SearchSupported" Bool="false"/>
                        <PropertyValue Property="Parameters">
                            <Collection>


                                <Record Type="com.sap.vocabularies.Common.v1.ValueListParameterDisplayOnly">
                                    <PropertyValue Property="ValueListProperty" String="Zzteam"/>
                                </Record>


                                <Record Type="com.sap.vocabularies.Common.v1.ValueListParameterInOut">
                                    <PropertyValue Property="ValueListProperty" String="Pernr"/>
                                    <PropertyValue Property="LocalDataProperty" PropertyPath="Pernr"/>
                                </Record>
                            </Collection>
                        </PropertyValue>
                    </Record>

Thanks and Regards,

Veera

Share
10 |10000 characters needed characters left characters exceeded