How to perform OData CRUD operations in SAP UI5

[@rchan4823]

Hats off! I have gone through multiple blogs and other videos but this is the best of the best. Thanks a ton

[@myprojectideas]

Thankyou So Much For Your Appreciation! Means A lot. Keep Supporting Us and We Will Try To Improve The Quality of Content.

[@cutexangel5626]

Thank you, Brother after seeing a lot of videos your video worked for me, because I am totally new in sapui5

[@myprojectideas]

We are happy that you find our video helpful.

[@SohaleAhmed]

Excellent video. Very simple and easy to understand. Thanks a lot

[@Gvkrish52]

The best video saw, great explanation. Thanks 🙏

[@YamamotoKaedehara]

Thanks for your kindness sir!

[@HarshithaB_Gowda]

Excellent content !!! Well explained 👏👏

[@JyotiranjanKunda]

@8:05 You have written /Products as the path, but the entity type name is Product, so how it is working

[@myprojectideas]

Good question. If you relisten at point @4:15 you will hear Entity Product and Entity Set Products. We always use Entity Set names in binding. To know the difference between these two, you can check this video: kzbin.info/www/bejne/aKOoi6V8n5ebl6c&ab_channel=MyProjectIdeas

[@JyotiranjanKunda]

Thankyou@@myprojectideas

[@JagdeepSingh-ue1tm]

Good to see this, Thanks!

[@rchan4823]

The best video I have seen.

[@myprojectideas]

Glad it helped!

[@MaxMustermann-q7x]

Great Explanations !

[@Crazy_girl......]

how do you create record with add button and an save button to save it in the backend?

[@mohdjisan-k6c]

so good explanation. how to use capm service in our fiori project. throw destination set. suppose we have simple ui5 project . want to integrate capm service

[@myprojectideas]

Hi, To use CAPM just in UI5 project, does it mean that there is no HANA cloud DB? and you want to integrate the ABAP OData? => In this case, CAPM has no advantage. But, if you want to integrate CAPM in an existing UI5, then it might mean that there is a separate CAPM for backend and DB, and different UI5 project? => In this case, you can call the API that is deployed in BTP from your UI5 app via destination. Let me know if we were able to answer your query.

[@mohdjisan-k6c]

But, if you want to integrate CAPM in an existing UI5, then it might mean that there is a separate CAPM for backend and DB, and different UI5 project? => In this case, you can call the API that is deployed in BTP from your UI5 app via destination. yes i want to use this type . i have separate capm DB and backend and also have ui5 project. now i want to integrate capm services in my ui5 project

[@myprojectideas]

@@mohdjisan-k6c Whenever you deploy a service in CAPM, it appears over BTP within services. From there you can get API url. Now maintain this url in destination, and call that destination from UI5.

[@mohdjisan-k6c]

i need a blog or video tutorial for this,. @@myprojectideas

[@Gvkrish52]

could you please explain $batch call on oData v4 ?

[@myprojectideas]

Sure. Meanwhile you can read this: community.sap.com/t5/technology-blogs-by-sap/batch-operation-in-in-odata-v4-adapter-in-sap-cloud-integration/ba-p/13481079#:~:text=The%20OData%20V4%20adapter%20now,HTTP%20requests%20into%20one%20request.

[@alokeshdas-p5c]

Great explanation!! Could you please tell me how to edit rest of the columns, over here 'Rating' column is only editable. What should be added to edit rest of the columns.

[@heikkiladau6872]

thank for great video! Still, while working with exact same northwind, it returns a 404 for me, dont know why.

[@sigmaearth]

were you able to fix?

[@heikkiladau6872]

@@sigmaearth yeah, fixed it 😌

[@jafriayaan]

same issue can any one tell me the solution when i try to post data then i get error {code: "", message: {lang: "en-US", value: "Resource not found for the segment 'Product'."}}"

[@heikkiladau6872]

@@jafriayaan have you re-checked the service url and the connection?

[@heikkiladau6872]

How do you perform navigation, for example, from list to detail page with CRUD-operations?

[@myprojectideas]

To perform navigation from one page to another on List item click or from master to detail. You need to fetch the ID on click of the list item using bindingcontext, and then either do NavTo or open up the detail section. Read regarding navigation here: Master Detail with multiple views and multiple controllers for detail in SAP UI5: gocoding.org/master-detail-with-multiple-views-and-multiple-controllers-for-detail-in-sap-ui5/ Master Detail with multiple fragments for detail and single controller in SAP UI5: gocoding.org/master-detail-with-multiple-fragments-for-detail-and-single-controller-in-sap-ui5/ We will publish a new video very soon on this topic.

[@omega_sam]

Can you pls help me for hotel billing system, it says "getDate can't be relved for jpanel" pls I really want the help

[@souradeeppanja739]

I am very new to SAP, I have one query sir, before learning Fiori should I need to learn anything in SAP

[@myprojectideas]

Before SAP UI5/Fiori it is recomended to learn HTML, CSS, JavaScript.

[@salaizy]

All the function in controllers, "new sap.ui.model.Filter('Rating', 'EQ', '4')" and "new sap.ui.model.Sorter('Price', true)", don't work. That why can't progress in your tutorial.

[@myprojectideas]

What do you mean by don't work? Have you tried adding them in namespace? Ref: sapui5.hana.ondemand.com/sdk/#api/sap.ui.model.Filter

[@myprojectideas]

Let us know the detailed issue, we will help you out.

[@salaizy]

@@myprojectideas I follow your code and I don't know what i miss but this are my controller files. drive.google.com/file/d/1z-MuT1UjinVj16rKLDx5CImOLNp8di50/view?usp=sharing

[@mohdjisan-k6c]

need project download link .

[@myprojectideas]

gocoding.org/how-to-perform-odata-query-and-crud-operation-in-odata/

[@omega_sam]

pls guys its extremely urgent , i really want your help

[@meraJag1999]

Is it northwind odata?? if yes how can u do create update delete operation on northiwnd odata . as i heard its only readable

[@myprojectideas]

You can find both here: services.odata.org/

[@myprojectideas]

Again. important aspects is to get the idea of CRUD operation and learn implementation in real business scenariois, where OData can be via ERP or HANA.

[@meraJag1999]

So lets suppose we are doing create operation on this northwind service ,can we see our added record in this northwind service url afterwards ?

[@meraJag1999]

Please reply

[@myprojectideas]

@@meraJag1999 Certainly, it would reflect. Follow the url that I shared earlier, and you need to use the first service which supports CRUD. Alternative, create free OData on BTP using CAPM model: developers.sap.com/group.scp-8-odata-service.html