Building hana-opensap-cloud-2020 Part 5: Cross Schema Access

We continue the series on the newly updated source code sample based upon the most recent HANA development openSAP course. This new sample includes the latest features from SAP HANA Cloud, SAP Cloud Application Programming Model, and SAPUI5.

0:00 Introduction
3:58 SFLIGHT Security Setup
9:28 Create User Provided Service
17:38 Service Replacements concept
21:16 hdbgrants
26:04 Synonyms
27:40 Bringing SFLIGHT Tables into CDS
39:24 Structured Privileges
50:10 Closing

[gautamkrishnan]

Hi Thomas, what's with the quoted identifier literals '![CARRID]'? What does it mean? Why is it used?

[ramonlee]

Processing "cfg/SFLIGHT.hdbgrants"...

Error: service ServiceName_1 not found; the service definition does not exist.

[ramonlee]

when i run cds deploy, it generates a default-env.json from the gen folder and losing the configurations

[binpath]

Hi Thomas, I did the CROSS ACCESS SCHEMA with VBAP replicated table, but trying to do CDS SERVE it gives me errors with OData property name: "/BEV1/SRFUND" must start with a letter or underscore, followed by at most 127 letters, underscores or digits (in The weird thing is that i haven't put in service.cds the entity to be exposed. What can i be doing wrong?

[FreshYoungLeaves]

It should provide way to "create user provided service" from artefact
Why didn't you create user provided service from single artefact without CF CLI?

[erikpalmen]

Hi Thomas great series. I wanted to create a Odata service in top of the Sflight views you created in this episode. But its seems Iam stuck with the following error.
<code>259</code>
<message>invalid table name: Could not find table/view SFLIGHT_SFLIGHTVIEW in schema line 1 col 306 (at pos 305)</message>

</error>
Could you give a hint or een example of the service.cds
thanks Erik

[ramonlee]

{
"ServiceName_1": {
"object_owner": {
"roles": [
"SFLIGHT_CONTAINER_ACCESS"
]
},
"application_user": {
"roles": [
"SFLIGHT_CONTAINER_ACCESS"
]
}
}
}

[ramonlee]

"SERVICE_REPLACEMENTS": [
{
"key": "ServiceName_1",
"service": "CROSS_SCHEMA_SFLIGHT"
},
{
"key": "hdi-user-service",
"service":
}
],