// API callback
relpostimgcuplik({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$blogger":"http://schemas.google.com/blogger/2008","xmlns$georss":"http://www.georss.org/georss","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$thr":"http://purl.org/syndication/thread/1.0","id":{"$t":"tag:blogger.com,1999:blog-3826368468004556615"},"updated":{"$t":"2023-12-26T13:46:15.660-08:00"},"category":[{"term":"sapui5"},{"term":"SAP ABAP"},{"term":"sap"},{"term":"ABAP Interview Questions"},{"term":"SAP Technical Interviews"},{"term":"Sap RAP"},{"term":"sap fiori"},{"term":"sap web ide"},{"term":"interview questions"},{"term":"custom sapui5 app extension"},{"term":"extending apps"},{"term":"odata"},{"term":"Navigation"},{"term":"Routing"},{"term":"SAP netweaver gateway"},{"term":"odata tutorial"},{"term":"ABAP"},{"term":"ABAP Coding Best Practices"},{"term":"ABAP Developer Tips"},{"term":"ABAP Development"},{"term":"ABAP Job Interview Insights"},{"term":"ABAP Job Preparation"},{"term":"Latest ABAP FAQs"},{"term":"SAP ABAP Certification"},{"term":"SAP Bussiness Application Studio"},{"term":"SAP CAP"},{"term":"node.js"},{"term":"sap capm"},{"term":"sap cloud platform"},{"term":"ABAP CDS Views"},{"term":"ABAP Code Examples"},{"term":"ABAP Data Modeling"},{"term":"ABAP HANA Integration"},{"term":"Answers"},{"term":"Developer Tips"},{"term":"HANA Development"},{"term":"HANA Modeling"},{"term":"HANA Performance Tuning."},{"term":"RAP Implementation"},{"term":"RAP Model"},{"term":"SAP ABAP on HANA"},{"term":"SAP HANA clould cockpit"},{"term":"SAP Interview Prep"},{"term":"SAP RAP Tutorial"},{"term":"cloud foundary"},{"term":"json"},{"term":"sap BTP CAPM"},{"term":"sap btp"},{"term":"CAP"},{"term":"CDS"},{"term":"HANA"},{"term":"MockSever"},{"term":"RAP"},{"term":"Routing in sapui5"},{"term":"associations"},{"term":"authentication"},{"term":"charts"},{"term":"cloud foundry"},{"term":"configuring destination in sap web ide"},{"term":"css"},{"term":"enterprise portal"},{"term":"import"},{"term":"introduction to sap web ide"},{"term":"odata v4"},{"term":"sap fiori portal site"},{"term":"sap mobile services"},{"term":"sap portal site"},{"term":"video tutorial on routing"},{"term":"Classical report"},{"term":"Cloud Application Programming Model"},{"term":"Interactive Reports"},{"term":"Internal Tables"},{"term":"Introduction"},{"term":"Introduction to sap enterprise portal"},{"term":"Mock data"},{"term":"SAP BAS"},{"term":"SAP Mobile cards"},{"term":"SEGW"},{"term":"Visual studio code"},{"term":"Web IDE"},{"term":"aggregation binding"},{"term":"android"},{"term":"app router"},{"term":"btp"},{"term":"capm"},{"term":"component preload"},{"term":"controller"},{"term":"controller extension"},{"term":"controls and views"},{"term":"create OData service"},{"term":"crud"},{"term":"csv"},{"term":"data binding"},{"term":"dataset"},{"term":"delete"},{"term":"extending sapui5 apps"},{"term":"fiori"},{"term":"formatter"},{"term":"git"},{"term":"github"},{"term":"google maps api"},{"term":"i18n"},{"term":"ios"},{"term":"list"},{"term":"manifest.json"},{"term":"mobile development kit"},{"term":"mta"},{"term":"mtar"},{"term":"multi target application"},{"term":"operations on internal table"},{"term":"properties"},{"term":"push a project in github"},{"term":"python"},{"term":"register odata service"},{"term":"routing in full application"},{"term":"sap cloud platform SDK"},{"term":"sap fiori enterprise portal"},{"term":"sapui5 github"},{"term":"search"},{"term":"setup sap bussiness application studio"},{"term":"sicf"},{"term":"sort"},{"term":"table"},{"term":"tables"},{"term":"video tutorial on nested views and fragments"},{"term":"xml"},{"term":"- SAP ABAP performance optimization\n\n- ABAP performance tuning\n\n- SAP ABAP best practices\n\n- SAP ABAP performance tips\n\n- ABAP performance optimization techniques\n\n- SAP ABAP performance improvements"},{"term":"ABAP 7.5"},{"term":"ABAP 7.6"},{"term":"ABAP Enhancements"},{"term":"ABAP Innovations"},{"term":"ABAP List Viewer"},{"term":"ABAP New Features"},{"term":"ABAP on HANA interview questions and answers"},{"term":"ALE"},{"term":"ALV Grid Report"},{"term":"ALV Grid Tutorial"},{"term":"ALV programming examples"},{"term":"ALV reports"},{"term":"Activate OData Service in SICF"},{"term":"Agile Development"},{"term":"BAS"},{"term":"BDC"},{"term":"Batch"},{"term":"Best practices"},{"term":"Binary Data Handling"},{"term":"Blobs in JavaScript"},{"term":"CAPM Apps"},{"term":"CDL"},{"term":"CLASSICAL REPORTS"},{"term":"CQL"},{"term":"CRUD operations"},{"term":"CSN"},{"term":"Cache"},{"term":"Cloud-Native Architecture"},{"term":"Configure Catalog and Groups in SAP Fiori Portal Sites"},{"term":"Configuring Fiori Tiles in sap portal sites"},{"term":"Custom Controls"},{"term":"Custom control to make a Radar Chart using Chart.js library in SAPUI5."},{"term":"DDIC"},{"term":"DPC"},{"term":"Data Storage"},{"term":"Data types"},{"term":"Debugging ABAP"},{"term":"Dev Tools"},{"term":"Development"},{"term":"Dialog sapui5"},{"term":"Environment variables"},{"term":"Event Handling"},{"term":"Field Catalog"},{"term":"File Manipulation"},{"term":"Fragment"},{"term":"Fragment in sapui5"},{"term":"Global sub routines"},{"term":"Globalization and localization"},{"term":"How to Change logon Page of Enterprise Portal"},{"term":"How to export SAP Web IDE Workspace projects"},{"term":"How to get Selected table index value?"},{"term":"Image Upload"},{"term":"Installation of sap ui5 plugin"},{"term":"Internal Table"},{"term":"Introduction and DDIC"},{"term":"Introduction to SAP portal sites"},{"term":"JDK"},{"term":"LOCAL SUB ROUTINES"},{"term":"Latest ABAP Updates"},{"term":"Logon Page in Enterprise Portal"},{"term":"Logon to SAP ABAP"},{"term":"MDK introduction"},{"term":"MPC"},{"term":"Mdk app"},{"term":"Microservices in SAP BTP"},{"term":"Module Pool"},{"term":"Most common examples in sap ui5"},{"term":"Mta yaml"},{"term":"Naming conventions"},{"term":"Navigation Properties"},{"term":"OData v2 benefits"},{"term":"OData v2 vs. OData v4"},{"term":"OData v4 advantages"},{"term":"OOPs Concepts"},{"term":"Offline app"},{"term":"Parts"},{"term":"Pass by reference"},{"term":"Pass by value (or) call by value"},{"term":"Pass by value and return"},{"term":"Plugin"},{"term":"Project structure"},{"term":"SAP ABAP Blog."},{"term":"SAP ABAP function modules"},{"term":"SAP ABAP video tutorials"},{"term":"SAP ABAP views"},{"term":"SAP Business Technology Platform"},{"term":"SAP Data Presentation"},{"term":"SAP Development"},{"term":"SAP ECC"},{"term":"SAP Fiori Configuration cockpit"},{"term":"SAP Fiori Launchpad Portal Site"},{"term":"SAP MTA"},{"term":"SAP NetWeaver Portal"},{"term":"SAP OData"},{"term":"SAP Programming"},{"term":"SAP S\/4HANA"},{"term":"SAP Tech Trends"},{"term":"SAP cloud solutions"},{"term":"SAP functional modules"},{"term":"SAP implementation."},{"term":"SAP modules"},{"term":"SAP overview"},{"term":"SAP technical modules"},{"term":"SAPUI5 data communication"},{"term":"SAPui5 application on SAP bussiness application studio"},{"term":"SUB ROUTINES"},{"term":"Sapui5 jobs"},{"term":"Scalable Applications"},{"term":"Search Help in DDIC"},{"term":"Security"},{"term":"Security Considerations"},{"term":"Setting Up an App Router in SAP CAPM Project on BTP: A Step-by-Step Guide"},{"term":"SmartForms"},{"term":"Sorting"},{"term":"Templates and Accelerators in SAP Portal sites"},{"term":"Transaction code"},{"term":"Transport Request Number"},{"term":"Tutorial series on SAP Enterpise Portal"},{"term":"Tutorials"},{"term":"UI5 Inspector"},{"term":"User Interaction"},{"term":"Web Application Development"},{"term":"XS-UAA"},{"term":"add"},{"term":"add and delete operation"},{"term":"admin cockpit sap cloud mobile services"},{"term":"aggregations"},{"term":"annotations"},{"term":"annotations in OData"},{"term":"api"},{"term":"appearance"},{"term":"append operation"},{"term":"application"},{"term":"apps"},{"term":"architecture of sap fiori"},{"term":"authorization"},{"term":"backend components"},{"term":"batch processing in OData"},{"term":"begin set"},{"term":"beginset"},{"term":"boolean"},{"term":"branding"},{"term":"cache buster"},{"term":"catalogs"},{"term":"changeset"},{"term":"chart.js"},{"term":"charts in sapui5"},{"term":"chrome"},{"term":"cluster"},{"term":"code quality"},{"term":"combo box"},{"term":"commit"},{"term":"component configuration"},{"term":"component.js"},{"term":"configure catalogs and groups"},{"term":"configuring tiles"},{"term":"containers"},{"term":"contrller"},{"term":"controller hooks"},{"term":"controller.js"},{"term":"create"},{"term":"create cloud foundary account"},{"term":"create destinations to connect mobile services from sap web ide"},{"term":"css folder"},{"term":"csv upload validation"},{"term":"custom control"},{"term":"custom fiori app"},{"term":"custom image"},{"term":"custom login page"},{"term":"data element"},{"term":"database views"},{"term":"debug files in production environment"},{"term":"debugging javascript files"},{"term":"deman pop-in"},{"term":"deploy to cloud foundry"},{"term":"design principles"},{"term":"distance"},{"term":"doalog"},{"term":"domain"},{"term":"drag and drop"},{"term":"dv"},{"term":"dynamic"},{"term":"edit"},{"term":"enable sap web ide"},{"term":"event"},{"term":"events"},{"term":"events in classical reports"},{"term":"example classical report example"},{"term":"example of CAP"},{"term":"examples"},{"term":"excel"},{"term":"export project"},{"term":"export sap projects"},{"term":"export sapui5 project"},{"term":"expression"},{"term":"external library"},{"term":"external style"},{"term":"file"},{"term":"file reader"},{"term":"filter"},{"term":"filtering"},{"term":"fiori app"},{"term":"fiori apps"},{"term":"fiori jobs"},{"term":"fiori launchpad"},{"term":"fiori tiles"},{"term":"formatters"},{"term":"frontend components"},{"term":"function"},{"term":"geocoder"},{"term":"get cursor"},{"term":"get expanded entity"},{"term":"get expanded entityset"},{"term":"globalization"},{"term":"google maps"},{"term":"grouping"},{"term":"groups"},{"term":"gulp"},{"term":"handling localized texts"},{"term":"hcp"},{"term":"header item relationship"},{"term":"hello world"},{"term":"hello world application"},{"term":"help views"},{"term":"hierarchial ALV"},{"term":"icf"},{"term":"implementing SAP Fiori"},{"term":"import project"},{"term":"index"},{"term":"index of list"},{"term":"inline expressions"},{"term":"inner join"},{"term":"interactive reports events"},{"term":"interactive reports example"},{"term":"internal style"},{"term":"interview tips"},{"term":"introduction to ERP"},{"term":"introduction to odata annotations"},{"term":"introduction to sap abap"},{"term":"introduction to sap fiori"},{"term":"introduction to sapui5"},{"term":"item"},{"term":"iwfnd"},{"term":"javascript"},{"term":"javascript code editor"},{"term":"job search"},{"term":"joins"},{"term":"js"},{"term":"json model"},{"term":"jwt token"},{"term":"large string"},{"term":"launchpad"},{"term":"launchpad configuration"},{"term":"layout"},{"term":"layouts"},{"term":"local development"},{"term":"local service"},{"term":"login"},{"term":"login configuration"},{"term":"logo"},{"term":"logon page"},{"term":"lpd_cust"},{"term":"maint_service"},{"term":"maintainability"},{"term":"maintainence view"},{"term":"margins"},{"term":"marker"},{"term":"mdk"},{"term":"metadata.xml"},{"term":"mfa"},{"term":"minScreenWidth"},{"term":"mobile services in cloud foundary"},{"term":"model folder"},{"term":"modules"},{"term":"multi cloud environment"},{"term":"nested view"},{"term":"npm"},{"term":"odat v4"},{"term":"odata deep structures"},{"term":"odata tutorial series"},{"term":"odata v2"},{"term":"offline capabilities"},{"term":"online training abap"},{"term":"openui5"},{"term":"optimization"},{"term":"outer join"},{"term":"package"},{"term":"padding"},{"term":"parameter"},{"term":"pass multiple values"},{"term":"path"},{"term":"pdf"},{"term":"pfcg"},{"term":"pool"},{"term":"portal"},{"term":"portal site"},{"term":"projection views"},{"term":"pull"},{"term":"pull a project"},{"term":"push"},{"term":"radar chart"},{"term":"re usability"},{"term":"read"},{"term":"read table"},{"term":"register cloud platform"},{"term":"reports"},{"term":"resource bundle"},{"term":"resources"},{"term":"responsive"},{"term":"responsive table"},{"term":"responsive table in sapui5"},{"term":"responsiveness"},{"term":"rest"},{"term":"roles"},{"term":"routing in split app"},{"term":"saml"},{"term":"sap MDK"},{"term":"sap abap tutorials"},{"term":"sap app"},{"term":"sap backend system"},{"term":"sap cloud foundary"},{"term":"sap cloud platform for portal sites"},{"term":"sap cloud platform mobile services"},{"term":"sap custom portal sites"},{"term":"sap enterprise portal"},{"term":"sap fiori application"},{"term":"sap fiori apps"},{"term":"sap fiori configuration cockpit portal sites"},{"term":"sap fiori elements"},{"term":"sap fiori enterprise portal sites"},{"term":"sap fiori jobs"},{"term":"sap fiori launchpad"},{"term":"sap fiori launchpad configuration"},{"term":"sap fiori tools"},{"term":"sap fiori tutorial"},{"term":"sap freestyle portal sites"},{"term":"sap mobile development kit"},{"term":"sap mobile services tutorial"},{"term":"sap mobility jobs"},{"term":"sap ui5"},{"term":"sap ui5 excel upload"},{"term":"sap viz frame"},{"term":"sap web IDE Workspace export"},{"term":"sap web ide deprecated"},{"term":"sap webide"},{"term":"sap.m.list"},{"term":"sap.m.table"},{"term":"sapui5 apps"},{"term":"sapui5 best practices"},{"term":"sapui5 code editor"},{"term":"sapui5 code validator"},{"term":"sapui5 csv file upload import"},{"term":"sapui5 diagnostics window"},{"term":"sapui5 excel import"},{"term":"sapui5 lint"},{"term":"sapui5 nested view"},{"term":"sapui5 project"},{"term":"sapui5 project structuring"},{"term":"sapui5 xml editor"},{"term":"scp"},{"term":"searching"},{"term":"selected"},{"term":"selected index"},{"term":"setup"},{"term":"sheet.js"},{"term":"smart table"},{"term":"smarttable"},{"term":"speech recognition"},{"term":"spider chart"},{"term":"split app"},{"term":"srv"},{"term":"stage"},{"term":"step by step process to create odata"},{"term":"string"},{"term":"submitbatch"},{"term":"system objects"},{"term":"tab"},{"term":"tag"},{"term":"technical interview questions"},{"term":"test Odata service"},{"term":"tiles"},{"term":"token"},{"term":"transparent"},{"term":"tree table"},{"term":"types of subroutines"},{"term":"types of tables"},{"term":"types of views"},{"term":"ui5"},{"term":"universal worklist"},{"term":"update"},{"term":"upload"},{"term":"use strict"},{"term":"user experience sap"},{"term":"util"},{"term":"v4"},{"term":"validate using headers"},{"term":"validation"},{"term":"value"},{"term":"variable names"},{"term":"version"},{"term":"video tutorial on formatter and inline expressions"},{"term":"video tutorial on globalization"},{"term":"view"},{"term":"view extension"},{"term":"view extensions"},{"term":"view modification"},{"term":"view replacement"},{"term":"viz charts"},{"term":"viz control"},{"term":"vizframe control"},{"term":"voice recognition"},{"term":"walkthrough admin cockpit"},{"term":"web dynpro"},{"term":"webIDE application"},{"term":"webapp"},{"term":"work Area"},{"term":"workflow"},{"term":"xls"},{"term":"xlsx"},{"term":"xml code editor"},{"term":"xml view"},{"term":"xs security"}],"title":{"type":"text","$t":"SAP Development: Mastering SAP UI5, BTP, Fiori, CAPM, RAP, ABAP; and More!"},"subtitle":{"type":"html","$t":"Welcome to the ultimate SAP UI5, BTP, Fiori, CAPM, RAP, ABAP blog! Explore comprehensive tutorials, interview questions, and real-world examples to master SAP development. Elevate your skills in creating stunning UI5 apps, harnessing the power of BTP, and building Fiori applications. Unlock the potential of CAPM, RAP, and ABAP, and learn to integrate seamlessly with the enterprise portal. Whether you're a beginner or an experienced developer, this blog is your go-to resource for SAP expertise!"},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"https:\/\/www.sapui5tutors.com\/feeds\/posts\/default"},{"rel":"self","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/3826368468004556615\/posts\/default\/-\/CQL?alt=json-in-script\u0026max-results=50"},{"rel":"alternate","type":"text/html","href":"https:\/\/www.sapui5tutors.com\/search\/label\/CQL"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"}],"author":[{"name":{"$t":"Sanjo Thomas"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/06687889588258406801"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"generator":{"version":"7.00","uri":"http://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"1"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"50"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-3826368468004556615.post-3222279360901356744"},"published":{"$t":"2021-05-03T03:56:00.003-07:00"},"updated":{"$t":"2021-05-03T03:56:49.895-07:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"CAP"},{"scheme":"http://www.blogger.com/atom/ns#","term":"CDL"},{"scheme":"http://www.blogger.com/atom/ns#","term":"CDS"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Cloud Application Programming Model"},{"scheme":"http://www.blogger.com/atom/ns#","term":"CQL"},{"scheme":"http://www.blogger.com/atom/ns#","term":"CSN"},{"scheme":"http://www.blogger.com/atom/ns#","term":"SAP CAP"}],"title":{"type":"text","$t":"CDS views in SAP Cloud Application Programming Model (CAP)"},"content":{"type":"html","$t":"\u003Cp\u003E\u0026nbsp;\u003C\/p\u003E\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EIn this blog, we will deep dive into \u003Cb\u003ECDS views\u003C\/b\u003E with respect\nto \u003Cb\u003ESAP Cloud Application Programming Model\u003C\/b\u003E \u003Cb\u003E(CAP).\u003C\/b\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003ECDS stands for Core Data Services, but what exactly is CDS? CDS is\na collection of Domain specific languages, helping developers to entirely focus\non specifically on business domain model.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003ECDS is base of the SAP Cloud Application programming Model.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EIt provides the means to express service definitions\u003C\/span\u003E and\ndata models, as well as queries, and expressions, all of this in plain\nJavaScript object notations. It can parse from a variety of source\nlanguages and to compile them into various target languages. \u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EThe CDS models are plain JavaScript objects\u003C\/span\u003E complying to\nthe Core Schema Notation, in short CSN, which is an open specification\nderived from JSON Schema.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-6-Ez4htOqfk\/YI_VTECdJ6I\/AAAAAAAAazY\/m6-HpbLNNq4pV08vu_PyqZLAdHaK79lQQCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"178\" data-original-width=\"374\" height=\"152\" src=\"https:\/\/lh3.googleusercontent.com\/-6-Ez4htOqfk\/YI_VTECdJ6I\/AAAAAAAAazY\/m6-HpbLNNq4pV08vu_PyqZLAdHaK79lQQCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EYou can easily create or interpret these models,\u003C\/span\u003E which\nfosters extensions by third-party contributions. Models are processed\ndynamically at runtime and can also be created dynamically.\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EDefinition Language\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/b\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003ECDL is a human-readable syntax for defining your models.\u003C\/span\u003E\nHere are some of the available definitions of this language.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpFirst\" style=\"mso-list: l1 level1 lfo1; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E1)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\n\u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003C!--[endif]--\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EEntities\u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E - Entities are structured types\nrepresenting sets\u003C\/span\u003E of persisted data that can be read and\nmanipulated using CRUD operations.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-l6rsYF-jg_w\/YI_VV2p960I\/AAAAAAAAazg\/WlPlz775J2klXAlue5yL9SFGIqzDd1v8ACLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"192\" data-original-width=\"353\" height=\"174\" src=\"https:\/\/lh3.googleusercontent.com\/-l6rsYF-jg_w\/YI_VV2p960I\/AAAAAAAAazg\/WlPlz775J2klXAlue5yL9SFGIqzDd1v8ACLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\" style=\"mso-list: l1 level1 lfo1; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E2)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EViews\u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E - Views are entities defined by\nprojection\u003C\/span\u003E on underlying entities or other views, like the views\nin SQL.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EThe element signatures are inferred from the\nprojection.\u003C\/span\u003E The projection can be any valid query.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-0T1lh-ClNuw\/YI_VYB0pCZI\/AAAAAAAAazk\/0chXyddGTkYslJ_q-hIn-zxY7Dw-L1EfgCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"90\" data-original-width=\"347\" height=\"83\" src=\"https:\/\/lh3.googleusercontent.com\/-0T1lh-ClNuw\/YI_VYB0pCZI\/AAAAAAAAazk\/0chXyddGTkYslJ_q-hIn-zxY7Dw-L1EfgCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\" style=\"mso-list: l1 level1 lfo1; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E3)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\n\u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003C!--[endif]--\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EAssociations\u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E -\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\n\u003C\/span\u003EAssociations capture relationships between entities.\u003C\/span\u003E They are\nlike forward-declared joins added to a table definition in SQL.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-MUa9u8DqrbE\/YI_VZr1TvTI\/AAAAAAAAazo\/mJTXRHDbFr8tzb3zp6bF5rqdo7Slvb3dACLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"136\" data-original-width=\"283\" height=\"154\" src=\"https:\/\/lh3.googleusercontent.com\/-MUa9u8DqrbE\/YI_VZr1TvTI\/AAAAAAAAazo\/mJTXRHDbFr8tzb3zp6bF5rqdo7Slvb3dACLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\" style=\"mso-list: l1 level1 lfo1; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E4)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\n\u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003C!--[endif]--\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EAspects\u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E - Aspects help to separate concerns\ninto partial definitions\u003C\/span\u003E and, in this way, to avoid polluting your\nstructure. They can be declared in the same or different files or\neven in different projects, \u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-jFFLPOrrns8\/YI_Va709nNI\/AAAAAAAAazw\/izea-b0YRD4Zy6QtQV-OT5bOuu-68DynACLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"143\" data-original-width=\"291\" height=\"157\" src=\"https:\/\/lh3.googleusercontent.com\/-jFFLPOrrns8\/YI_Va709nNI\/AAAAAAAAazw\/izea-b0YRD4Zy6QtQV-OT5bOuu-68DynACLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\" style=\"mso-list: l1 level1 lfo1; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E5)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\n\u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003C!--[endif]--\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003ETypes\u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E -\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\n\u003C\/span\u003EYou can declare custom types to reuse later on\u003C\/span\u003E for example for\nelements in entity definitions.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-rivLdxZuE4Y\/YI_VcCwAtcI\/AAAAAAAAaz0\/zWElbX-YT4sS9DpQtNntfV26eyq7-vGfQCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"151\" data-original-width=\"268\" height=\"180\" src=\"https:\/\/lh3.googleusercontent.com\/-rivLdxZuE4Y\/YI_VcCwAtcI\/AAAAAAAAaz0\/zWElbX-YT4sS9DpQtNntfV26eyq7-vGfQCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpLast\" style=\"mso-list: l1 level1 lfo1; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E6)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\n\u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003C!--[endif]--\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EService Definitions\u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E - Service\ndefinitions, service interfaces should be defined\u003C\/span\u003E as collections of\nexposed entities enclosed in a service block. A service could\nalso have, as members, actions and functions. \u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\" style=\"margin-left: .25in;\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-no-proof: yes;\"\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u003C\/span\u003E\u003C\/span\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-vfUypAaIz-c\/YI_Vd_w8rGI\/AAAAAAAAaz4\/ytpf842BFeIupDLxQJZPM9lLwUzDYsj6gCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"199\" data-original-width=\"364\" height=\"175\" src=\"https:\/\/lh3.googleusercontent.com\/-vfUypAaIz-c\/YI_Vd_w8rGI\/AAAAAAAAaz4\/ytpf842BFeIupDLxQJZPM9lLwUzDYsj6gCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-no-proof: yes;\"\u003ECore Scheme Notation(CSN)\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/b\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EThe next member of the languages set\u003C\/span\u003E we will take a look at\nis the CSN, or Core Schema Notation. It is notation for compact\nrepresentations of data and service models, of data and service\nmodels, to share and interpret models with minimal footprint and\ndependencies. \u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EIt is like JSON Schema but goes beyond it with the ability to\ncapture full- blown,\u003C\/span\u003E entity-relationship models and extensions. This\nability makes CSN models much more concise and closer to your conceptual\nthinking. \u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003ELet us see an example for the same.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-9BeHwqQTG9A\/YI_Vf_vCrYI\/AAAAAAAAaz8\/WxIRntlhMvAuD6AnhMRTli1s7i0I4nDqQCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"203\" data-original-width=\"624\" height=\"130\" src=\"https:\/\/lh3.googleusercontent.com\/-9BeHwqQTG9A\/YI_Vf_vCrYI\/AAAAAAAAaz8\/WxIRntlhMvAuD6AnhMRTli1s7i0I4nDqQCLcBGAsYHQ\/w400-h130\/image.png\" width=\"400\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EOn the slide's left-hand side, you can see\u003C\/span\u003E an entity Books\ndeclared in the human-readable definition language, and on the right\nside, you see the CSN representation.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EBoth are not lengthy, but still capture\u003C\/span\u003E all the needed\ninformation.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-75paje4F5jQ\/YI_Vg297j3I\/AAAAAAAAa0A\/TdSDL_R8ZfwfYfWYQruTkvnrDD36ePnYgCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"286\" data-original-width=\"624\" height=\"184\" src=\"https:\/\/lh3.googleusercontent.com\/-75paje4F5jQ\/YI_Vg297j3I\/AAAAAAAAa0A\/TdSDL_R8ZfwfYfWYQruTkvnrDD36ePnYgCLcBGAsYHQ\/w400-h184\/image.png\" width=\"400\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EIn the next example, on the left CDL snippet,\u003C\/span\u003E we see a\nservice definition with one unbound action as part of the service.\nOn the right side, the respective CSN representation, an easily\nprocessable JSON object.\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EQuery Language (CQL)\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/span\u003E\u003C\/b\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoNormal\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EThe next member of the group of languages\u003C\/span\u003E is the query\nlanguage, abbreviated as CQL or CDS QL. CDS QL is based on standard SQL,\nbut upgrades it with some really handy features, like postfix\nprojections, path expressions, CDL-style casts, and some more.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpFirst\" style=\"mso-list: l0 level1 lfo2; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E1)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\n\u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003C!--[endif]--\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EPostfix Projections - \u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003ECQL allows\nputting the SELECT clause\u003C\/span\u003E behind the FROM clause, enclosed in curly\nbraces. We see in the example that the elements list is put\nbehind the \"from Books\" part of the statement.\u003Cb\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/b\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EIn the postfix projections, the star operator\nqueries\u003C\/span\u003E in the postfix projections, the star operator queries compared\nto the plain SQL SELECT clauses. Queries like on the example here would\nresult in duplicate element effects for author in SQL, but in CDS\nQL, explicitly defined columns following the star will replace equally\nnamed columns.\u003Cb\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/b\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-8Kl-79iv-_w\/YI_VipqK4QI\/AAAAAAAAa0E\/58pZ-XxUdgwq0kajWCQnCSLFQvkc8lQVgCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"21\" data-original-width=\"323\" height=\"21\" src=\"https:\/\/lh3.googleusercontent.com\/-8Kl-79iv-_w\/YI_VipqK4QI\/AAAAAAAAa0E\/58pZ-XxUdgwq0kajWCQnCSLFQvkc8lQVgCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\" style=\"mso-list: l0 level1 lfo2; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E2)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\u0026nbsp;\n\u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003C!--[endif]--\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EPath Expressions -\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EOne should use path expressions\u003C\/span\u003E\nto navigate along associations and structured elements in any of the SQL\nclauses like FROM clauses, SELECT clauses, or WHERE clauses as is\nshown here in the example.\u003Cb\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/b\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-IhEMqlCID6s\/YI_Vj4ZePiI\/AAAAAAAAa0M\/XZiAm1DkJ_sU8Q8f6_Z5PqWtlNGZ_tbzwCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"116\" data-original-width=\"325\" height=\"114\" src=\"https:\/\/lh3.googleusercontent.com\/-IhEMqlCID6s\/YI_Vj4ZePiI\/AAAAAAAAa0M\/XZiAm1DkJ_sU8Q8f6_Z5PqWtlNGZ_tbzwCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003EPath expressions in FROM clauses allow to\nfetch only\u003C\/span\u003E those entries from a target entity that are associated\nto a parent entity. They unfold to semi-joins in plain SQL queries.\nThe path expressions in all other clauses are very much like standard\nSQL column expressions, with table aliases as single prefixes.\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\" style=\"mso-list: l0 level1 lfo2; text-indent: -.25in;\"\u003E\u003C!--[if !supportLists]--\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-bidi-theme-font: minor-latin;\"\u003E\u003Cspan style=\"mso-list: Ignore;\"\u003E3)\u003Cspan style=\"font: 7.0pt \u0026quot;Times New Roman\u0026quot;;\"\u003E\u0026nbsp; \u0026nbsp; \u0026nbsp; \u003C\/span\u003E\u003C\/span\u003E\u003C\/span\u003E\u003Cb\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003ECDL – style casts\u003C\/span\u003E\u003C\/b\u003E\u003Cspan style=\"mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;\"\u003E - As an\nalternative of the SQL-type casts,\u003C\/span\u003E you can use CDL-styled casts. This\nis done as in the element of an entity definition.\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp; \u003C\/span\u003E\u003Cspan style=\"mso-spacerun: yes;\"\u003E\u0026nbsp;\u003C\/span\u003E\u003Cb\u003E\u003Co:p\u003E\u003C\/o:p\u003E\u003C\/b\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-hWQbhhwrEU4\/YI_VlVZHviI\/AAAAAAAAa0U\/8L6Na1cdRYUFsVuPhV26avAPN1ddyWbsQCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"19\" data-original-width=\"329\" height=\"18\" src=\"https:\/\/lh3.googleusercontent.com\/-hWQbhhwrEU4\/YI_VlVZHviI\/AAAAAAAAa0U\/8L6Na1cdRYUFsVuPhV26avAPN1ddyWbsQCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Cb style=\"text-align: left; text-indent: -0.25in;\"\u003E4) Excluding clause - \u003C\/b\u003E\u003Cspan style=\"text-align: left; text-indent: -0.25in;\"\u003ETo exclude\nelements from your SELECT list,\u003C\/span\u003E\u003Cspan style=\"text-align: left; text-indent: -0.25in;\"\u003E the excluding clauses come to help.\nCombined with the SELECT star of all elements, it gives the chance to\nget rid of the elements listed in the curly braces.\u003C\/span\u003E\u003C\/div\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-9wrvcSxuVzs\/YI_VmjKlPlI\/AAAAAAAAa0Y\/FRenOsMaT7UtWj7ChqJNEbAquBSdNxqqwCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"24\" data-original-width=\"345\" height=\"22\" src=\"https:\/\/lh3.googleusercontent.com\/-9wrvcSxuVzs\/YI_VmjKlPlI\/AAAAAAAAa0Y\/FRenOsMaT7UtWj7ChqJNEbAquBSdNxqqwCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cb style=\"text-indent: -0.25in;\"\u003E5) Query – local mixins – \u003C\/b\u003E\u003Cspan style=\"text-indent: -0.25in;\"\u003EIt is used\nto logically add elements to the source of your query.\u003C\/span\u003E\u003Cspan style=\"text-indent: -0.25in;\"\u003E Later on, those\nelements can be used and propagated in the query's projection.\u003C\/span\u003E\u003Cp\u003E\u003C\/p\u003E\n\n\u003Cp class=\"MsoListParagraphCxSpMiddle\"\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-NSj7T4N7ZYM\/YI_Vn6gGs-I\/AAAAAAAAa0c\/TyD-eNJHKp8_6lPfgTMTwsKku6006s_vQCLcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg alt=\"\" data-original-height=\"131\" data-original-width=\"261\" height=\"161\" src=\"https:\/\/lh3.googleusercontent.com\/-NSj7T4N7ZYM\/YI_Vn6gGs-I\/AAAAAAAAa0c\/TyD-eNJHKp8_6lPfgTMTwsKku6006s_vQCLcBGAsYHQ\/image.png\" width=\"320\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EIn our \u003Ca href=\"http:\/\/www.sapui5tutors.com\/2021\/05\/what-is-sap-cloud-application.html\"\u003Eprevious blog\u003C\/a\u003E, we saw how to create a hello world project using CDS and node.js in\nSAP BAS.\u003Cp\u003E\u003C\/p\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https:\/\/www.sapui5tutors.com\/feeds\/3222279360901356744\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https:\/\/www.sapui5tutors.com\/2021\/05\/cds-views-in-sap-cloud-application.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/3826368468004556615\/posts\/default\/3222279360901356744"},{"rel":"self","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/3826368468004556615\/posts\/default\/3222279360901356744"},{"rel":"alternate","type":"text/html","href":"https:\/\/www.sapui5tutors.com\/2021\/05\/cds-views-in-sap-cloud-application.html","title":"CDS views in SAP Cloud Application Programming Model (CAP)"}],"author":[{"name":{"$t":"Sanjo Thomas"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/06687889588258406801"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https:\/\/lh3.googleusercontent.com\/-6-Ez4htOqfk\/YI_VTECdJ6I\/AAAAAAAAazY\/m6-HpbLNNq4pV08vu_PyqZLAdHaK79lQQCLcBGAsYHQ\/s72-c\/image.png","height":"72","width":"72"},"thr$total":{"$t":"0"}}]}});