Data integration in ABAP Cloud - sufiyan63/SAP-Hana-Cloud GitHub Wiki
DATACONSUMPTIONVIACDSEXTERNALENTITIES
Outbound SQL access
CDS external entities to model the structure of remote views/tables – Dynamic Access
@EndUserText.label: 'Sports school'
define external entity ZEE_SPORTSCHOOL external name SPORTSSCHOOL //same as virtual table name
{
key SchoolUuid : abap.char(16) external name SCHOOLUUID;
SchoolId : abap.char(16) external name SCHOOLID;
SchoolName : abap.char(100) external name SCHOOLNAME;
SchoolLocation : abap.char(40) external name SCHOOLLOCATION;
SchoolCountry : abap.char(40) external name SCHOOLCOUNTRY;
} with federated data
provided at runtime
SPORTSSCHOOL ⇒ //same as virtual table name in our Hana data source
SQL access via ABAPSQL
Select .. from MyView provided by myRemote
Logical external schema as a pointer to a remote system