CDS Table Function and AMDP framework Part 16 ABAP on HANA Course

[@shwethanarayanan8223]

Excellent!

[@SAPTECHNOMANIAC]

Thank You!

[@devg536]

Great work

[@SAPTECHNOMANIAC]

Thank you so much 😀

[@FarooqAhmed-bq2et]

Awesome

[@SAPTECHNOMANIAC]

😊

[@SAP_USER]

thankyou!!

[@SAPTECHNOMANIAC]

You are welcome!

[@aditisinghal2183]

nice 👍

[@SAPTECHNOMANIAC]

Thanks

[@AmrutaWagh-kb3yv]

thanks nice

[@SAPTECHNOMANIAC]

You're welcome! 😊

[@sreedevishine5822]

Hi, thank you for the amazing explanation! I have a curious question. Is it possible to use CDS Table Functions and AMDP to perform a SELECT operation from a dynamic data source? For example, we have a parameterized CDS view that accepts numbers from 1 to 3 as input. Based on the input value, different fields should be selected from different CDS views. Let's say the views are: ZVIEW1, ZVIEW2, and ZVIEW3. If the input is 1, the selection should be performed on ZVIEW1; if the input is 2, the selection should be performed on ZVIEW2, and so on. If it is possible, could you please cover it in a video? Thank you!

[@chaitu9339]

Hi. Do you have any blog to follow? Also, Is there any document to try the code . Presentation is in very detail. Thanks for the knowledge. Please to remind you a video on meshes concept and uses.

[@SAPTECHNOMANIAC]

Just do f1 you get SAP standard documentation that I follow . Once you go through my videos you will be able to understand all the things given in F1 help . Code sample I will upload in google blog there you can check currently uploading for all the example...

[@viaanas8528]

Great content , Can we use this Table function in the HANA Graphical View, as i am getting an error create scenario failed

[@SAPTECHNOMANIAC]

Ideally, we should not use ABAP Artifacts (CDS TF) created from the ABAP layer directly in database artifacts (HANA Graphical View,).

[@viaanas8528]

@@SAPTECHNOMANIAC Thanks for the clarification, so its a SAP limitation or not a recommended approach.

[@Mokshithkarthikeyaalladi]

Hi, Can't we save both CDS View, Table Function and AMDP Method in one TR?

[@ramniwasrinku]

We can save in one TR but if we save in diff TR, We should not move AMDP class before the CDS function. We have to treat same how we treat DDIC object along with Report .

[@SAPTECHNOMANIAC]

👍

[@devendrapatel6389]

Can we have one demo video for comparison of database procedure and database function?

[@ashar5407]

Hi. Thank you for sharing the knowledge. Till now I created all the CDS, which you have taught. When I opened the Hana studio, I got one pop up saying, 'The following packages do not exist anymore and have been removed from the favorites.'. Same thing happened with eclipse also. Don't know what to do next, I lost all the files. What could be reason for this.

[@SAPTECHNOMANIAC]

That package might have removed from favourite but it will be available in system.You can click on Ctrl+Shift+A and search for your package . Or you can check your individual object is available or not. If it is not available means you have to ask your system provider they might have removed it.

[@rajeshsirri3984]

I have created a cds view with parameters and can we consume this cds view in amdp. Reason I’m asking I’m getting error. If I use cds view without parameter in the amdp it’s fine if I use with parameter then there is issue. Let me know is there anything else or is it the limitations

[@SAPTECHNOMANIAC]

I don't think so there should be an issue as soon as you create CDS with/without parameter it create HANA DB view and that can be consumed in SQL script hence in AMDP as well ...

[@rajeshsirri3984]

@@SAPTECHNOMANIAC thanks for the reply brother.but somehow CDS with parameters having issue with AMDP. Getting an error as couldn’t find table/view “view name” in schema “schemaname”

[@shubhvaish2779]

@@rajeshsirri3984 if you have created ddic cds view then use sql view name instead of cds view name after using keyword.

[@CoconutIndia]

Wonderful . thanks . Are you providing job support?

[@SAPTECHNOMANIAC]

Yes if small works on weekends ...

[@CoconutIndia]

@@SAPTECHNOMANIAC ok thanks . how to contact?

[@pedrorios9489]

Hi Sr, thanks for sharing, very complete video, quick question, any idea why I cannot set a break point for "By Table Function", it actually works for "By Database Procedure" : This is the error message: "Unable to toggle breakpoint Reason: Breakpoint not supported for this language"

[@SAPTECHNOMANIAC]

In older version it is not supported .In new version you can debug CDS table function as well

[@githach]

While trying to create TABLE FUNCTION, am getting below error - could you please suggest how to overcome this E:SDDL_PARSER_MSG:101 ABAP Syntax Check Problem

[@SAPTECHNOMANIAC]

Check for your eclipse version and SAP netwear version they support CDS table function or not

[@pranalibhalekar6820]

I would like to know if this is correct...As we use keyword implemted by Method while defining CDS table function...i think we should first import that TR which contain AMDP class and method rather than this table function else it will show mesage as class/method not found...

[@shubhvaish2779]

+1