WS Connection:

CustomerContacts(Model)
http://gw.esworkplace.sap.com/sap/opu/sdata/iwcnt/contact/ContactCollection?sap-client=800&$format=xml&$filter=SearchTerm%20eq%20%27*%27


View:

SAPContact
CREATE VIEW CustomerContactView AS
SELECT
		A."d:Value" AS "d:Value", A."d:FullName" AS "d:FullName", A."d:City" AS "d:City", A."d:CountryName" AS "d:CountryName", A."d:RegionName" AS "d:RegionName", A."d:TelephoneNumberWithExtension" AS "d:TelephoneNumberWithExtension", A."d:Email" AS "d:Email"
	FROM
		(EXEC CustomerContactsModel.invokeHttp('GET', null, 'http://gw.esworkplace.sap.com/sap/opu/sdata/iwcnt/contact/ContactCollection?sap-client=800&$format=xml&$filter=SearchTerm%20eq%20%27*%27')) AS f, XMLTABLE(XMLNAMESPACES('http://www.w3.org/2005/Atom' AS atom, 'http://www.sap.com/Protocols/SAPData' AS sap, 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/atom:feed/atom:entry/atom:content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:Value" string PATH 'd:Value/text()', "d:FullName" string PATH 'd:FullName/text()', "d:City" string PATH 'd:City/text()', "d:CountryName" string PATH 'd:CountryName/text()', "d:RegionName" string PATH 'd:RegionName/text()', "d:TelephoneNumberWithExtension" string PATH 'd:TelephoneNumberWithExtension/text()', "d:Email" string PATH 'd:Email/text()') AS A;

Query:

SELECT * FROM SAPContact.CustomerContactView