101 - ABAP on HANA - CDS View - Types of Association - Exposed Association Part3

Added: 2026-05-12

[00:00:02]Hello everyone. We will continue that topic about on Hana and currently we are covering CDS view and in the last few videos we started with the concept of associations in CDS view. So firstly we understood what association is, what is the need of the association, what is the syntax of the association. We covered the types of association and in the last two videos we started with exposed association.

[00:00:40]Yes, exposed association is completely completely join on demand. We understood the meaning of each and every point of the exposed association and in the last video we started with the practical part of that same. And as a part of that we took two tables VBAK VBAP.

[00:01:07]The complete association, the entire association is added as a single element into the selection list or we can say element list. Then I simply executed this CDS view. We are able to see the output from VBAK table. The best part is in Eclipse ADT itself you can navigate to the association and I show you that part also. Now we will further dig down into that topic. I will go to SAP GUI.

[00:01:47]I will create a program. In that program firstly I will fetch the data or I will say I'll say I will go for that data of V B A K. See, here in this particular CDS view, yes, we have the columns of V B A K and V B A P is entirely exposed.

[00:02:10]We expose this association. So, in the first scenario, I will go for that data only of V B A K. Then, I will go for V B A K V B A P both and I will show you. In the first case, there is no join, but in the second case, there will be a join because it is join on demand. So, simple thing, you will further get a more detailed understanding how internally system is going for join on demand. So, I will create a program.

[00:02:48]I will go to SC38 transaction code.

[00:02:54]This is our demo eight program.

[00:02:58]Yes.

[00:03:02]I will go to create.

[00:03:08]I will give the title to the program.

[00:03:16]To display the sales order details.

[00:03:24]I'll go for type as executable program.

[00:03:30]I will save into package.

[00:03:39]I'll save into transport request.

[00:03:43]Now, I will write a select query.

[00:03:46]First scenario, I will only go for V B A K column so that I can show you that there is no join in that case.

[00:03:57]Because this is our base of that topic itself, join on demand.

[00:04:04]To overcome the limit to overcome that disadvantages of the join is we have a concept of association.

[00:04:14]I'm writing select. Suppose I will go for VBELN ERDAT. I'm going for two columns.

[00:04:24]From This is our name of the CDS view.

[00:04:30]We have only one artifact that is our actual CDS view.

[00:04:39]Into table.

[00:04:42]@data LT_DATA.

[00:04:47]You all know in new syntax the column names are separated by comma.

[00:04:53]Now, I will simply display.

[00:04:58]I will go to a back object patterns.

[00:05:03]Sorry, there is no instance.

[00:05:06]This is our class.

[00:05:08]And I will go for method display.

[00:05:17]Yes, I will simply uncomment.

[00:05:24]This is our internal table.

[00:05:28]I will activate this program.

[00:05:34]So, first scenario only VBAK column.

[00:05:38]Now, I will simply simply activate the SQL trace. You all know we have a transaction code ST05.

[00:05:49]If you do not have knowledge of the same, no problem. Whatever is required at this point of time, I will explain that part. If you want a more detailed understanding, you can learn from performance tools playlist.

[00:06:04]This is our ST05 transaction code.

[00:06:07]And the SQL trace check box is activated. I'm firstly activating that trace.

[00:06:16]So, I activated that trace.

[00:06:18]That trace is activated for my ID 920.

[00:06:23]Why I'm noting the name? So, if required, I can filter this based upon time.

[00:06:30]So, 920.

[00:06:31]I'm running this program. I activated that trace.

[00:06:36]Now, whatever I will do at this point of time, it will be simply simply traced by SAP. The trace will simply simply or capture all these things, whatever I'm doing.

[00:06:50]I'm going for run.

[00:06:52]And this SQL query, yes, system will capture.

[00:06:57]I'm running.

[00:06:59]Two columns, yes.

[00:07:01]Now, I'm deactivating that trace.

[00:07:05]So, in between this activate and deactivate, whatever the SQL queries are executed, system will simply will simply show me, yes.

[00:07:17]I will go for display trace.

[00:07:21]Yes, 920 to 921. Okay, we'll go for this time.

[00:07:27]And your system will show by default.

[00:07:30]Now, I will filter based upon program name because that is good because I need to check for my program.

[00:07:41]This is our I will go for okay.

[00:07:47]Now you can see this is our CDS view. We have a select query from the CDS view. But if I will show you the statement have you seen this no join at all? Yes.

[00:08:01]See, if you are going for association concept in the first scenario, we are only going for VBAK, then why why join should execute and it is performance effective. But if rather than association, you are going for join you are going for VBAK columns only, but still still system will show you the join here. Yes, because system will execute the join on multiple tables and performance will be limited at that point of time because CDS view will not give the desired result in less interval of time. Yes. So now you can see there's no join at all. Yes. Now we will go for next scenario and I will show you join on BP.

[00:08:51]Now. Now I will go for BPAP. Now you all know BPAP completely is exposed entire association is exposed. How you can refer to the columns of the exposed association? I mentioned in the slide also. How how? You have to go for backslash. It is mentioned. Yes.

[00:09:17]You have to go for backslash.

[00:09:19]backslash and what is the prefix?

[00:09:23]backslash Then you need to simply simply go for association name. What is our association name? We provide underscore B if you remember alias name underscore B.

[00:09:37]Is our association name S 4 V B A P.

[00:09:41]Now, suppose I want to go for post not column.

[00:09:46]Anyone can ask in that interview yes, this is one of the important question.

[00:09:51]Okay, you are saying you exposed the association, but how do you refer the columns of the exposed association while writing the SQL query? Simple answer is you have used backslash name of the association then hyphen whatever the column because we can refer to any column. Suppose now I will go for mat in our column.

[00:10:18]Suppose this is mat in our column.

[00:10:24]I will check the syntax.

[00:10:27]Now I will activate.

[00:10:33]Now you can see we are going for V B A K V B A P both both. Now join should trigger. Ideally it should trigger now.

[00:10:43]Yes, it should trigger because it is join on demand.

[00:10:47]Now I will go for the activation of that trace again.

[00:10:52]Because I need to go now activate that trace and deactivate.

[00:10:57]I'm activating that trace.

[00:10:59]Yes, 925 for my user ID.

[00:11:03]Now I'm running this particular program.

[00:11:09]Now you can see V B A P S post not mat in our.

[00:11:16]Now I will deactivate that trace.

[00:11:20]Now I will display that trace.

[00:11:23]Yes, 925 we'll go from there.

[00:11:30]I will filter based upon my program name.

[00:11:37]Now you can see we have the CDS view, yes.

[00:11:42]Now if I will show you this.

[00:11:47]Now you can see we have a join here now.

[00:11:50]You can see we are going for select VBELN ERDAT, POSNR, MATNR from this. Have you seen left outer join is mentioned, yes.

[00:12:03]This is join on demand, yes, and this is what we want, yes. This is what we want in terms of association. So what is the summary of this particular video? In this video we further dig down into that topic, yes. Firstly, I took the columns only for VBAK table. I activated that trace, I deactivated that trace, and I showed you we have only only single we only have that select query, but there is no join at all. We are have a select query for VBAK only in the CDS view, yes, we have VBAK, yes. After that, yes, what I did, I simply specified the columns of VBAK. How you will specify the columns of VBAK?

[00:12:55]backslash your association name, whatever the association you name you provided, yes.

[00:13:01]Hyphen what is the column name you want to take, yes. I specified two columns, I activated that trace, deactivated that trace, I run that program again, then I showed you we are able to see that join here, and this is completely completely a join on demand. Now in the next video we'll further dig down into this particular topic, and you can simply understand it is one of the topic in which interviewer can ask any number of questions based upon the answers which you are providing. Yes. So, that's it in this video. Thank you.