94 - ABAP Dictionary - Enhancement Category Part1

[00:00:02]Hello everyone. Now we will start with a new topic as a part of a bad dictionary or data dictionary and that topic is enhancement category. One of the pending topic as a part of a bad dictionary or data dictionary and so many people ask about this particular topic. So now it's a turn to cover this pending topic also.

[00:00:31]Now this particular topic, yes, is a part of a bad dictionary or data dictionary and this playlist is at the starting level itself, yes. So it might be the case that whenever you will learn this particular topic, anyways, I will try my level best. You will not get the meaning of few terms. I'll try my level best to cover, but whenever you will proceed and move on to the future playlist, you will automatically get the more clear understanding. Suppose into this particular topic, we will go for character data type, numeric data type, we'll go for deep structure, flat structure. So it might be the case at this particular level, you might not get the detailed understanding, but these all things are in a bad programming part one playlist. So whenever you will move on to that playlist, you will get the more detailed understanding, but yes, I will try my level best that at this level itself, you will get the complete understanding.

[00:01:48]So what is enhancement category?

[00:01:52]Enhancement category specifies how SAP standard database tables or structure can be enhanced or extended.

[00:02:06]See, we are talking about SAP standard database table or structure. It means tables which are not starting with Z or Y. It means all those are standard tables or structure. And what is the meaning of enhancement or what is the meaning of extension? It means we are adding our own columns to the SAP standard database table. So, what is enhancement category? It specify how standard database table or structure can be enhanced or extended. Means how we can add the columns, how we can add the custom columns, means Z columns to the standard database tables. That always always decide by enhancement category.

[00:03:07]And the meaning of enhancement or extension in terms of table is adding your own columns to the standard database table. Suppose, if I will go for the example. Suppose, if I will go to SC11 transaction.

[00:03:25]And I have a table VBAK. You all know, this is SAP standard table. Yes, because name is starting with V. I will go to display mode. Suppose, into this particular table, if I want to add my own columns, yes? How it will decide? It will specify by enhancement category.

[00:03:51]How I can check the enhancement category? The If I will go to extras, I will go to enhancement category, and you will be able to see. Have you seen?

[00:04:04]This radio button is tick can be enhanced character like or numeric. It means if this table can be enhanced, I can add my own columns to this particular standard table. Because the enhancement category is can be enhanced.

[00:04:24]Anyways, we'll go into detail. Suppose, if I will show you another SAP table.

[00:04:30]Suppose, if I will go to T000 table.

[00:04:35]That is again SAP table. If I will display this table, if I will go to extras, enhancement category, and have you seen what is the radio button? Cannot be enhanced. It means I cannot add my own columns to this particular standard table. Many times people will say, "Yes, they are going to add the columns in the standard table using the append structure." Yes, anyways, we covered that topic append structure. At that time, I showed you, "Yes, in SAP tables, append structure is possible." Yes. So, whenever they are going to go Whenever they are going for append structure in SAP table, yes, at that time, they are not able to do because it always always decide by enhancement category. So, check the enhancement category at that point of time because based upon that only, you can add your own columns to the SAP standard tables or structure. So, as of now, what we covered? yes? Enhancement category specifies how a standard database table or structure can be enhanced or extended.

[00:05:58]How you can check the enhancement category? Extras, enhancement category.

[00:06:04]Now, what we will do? From the practical perspective, what we will do from the practical perspective? We will take a table. Yes, we will create that table, but we will treat that table as a standard table. See, we will not touch the standard table because if I will show the practical using the standard table, many people will hamper the system itself. So, what we will do from the practical perspective, I will just create a table. In that table, I will show you all the enhancement category option. Yes, so that we all can learn the practical also without hampering the system. And anyways, whenever you are getting the requirement in the project, you need to implement the same thing in the standard table. Yes, from the practical perspective, we all can do the practical, so that what we will do? I will take a table. Yes, we will create that table. If we will treat that table as a standard table, and we will learn all the enhancement category option. So, we will able to learn each and everything from the practical perspective also. And yes, it's a request to everyone. Whenever you are going for this topic, please please try in your own table. Do not try in the standard table. Yes, because of one mistake, it might hamper the system because our major target is to do the practical and we are doing the practical. Yes.

[00:07:45]Suppose I will go for the requirement.

[00:07:50]I will create a table. That table has two columns, project number and project name. Then I will add these columns to that table later. Yes. So firstly, I will create a table of two columns, project number and project name. Yes.

[00:08:09]You all know whenever you are creating table, you need to firstly create domain and data elements. Now it is totally your wish. You can use bottom-up approach or you can use top-down approach. In bottom-up approach, what?

[00:08:26]Create domain, create data element, then use in that table. Or what is top-down approach? Create table, in that table itself, create data element and then from there, you can create that domain.

[00:08:41]So it's totally your wish how you want to go. You want to go for top-down approach or you want to go for bottom-up approach. Suppose, I will go for top-down approach.

[00:08:53]Suppose, I will go for the creation of that table.

[00:09:01]Anyways, enhancement category is for standard table or structure, so you will not create that table, but yes, from the practical perspective, we can try each and every option. So we'll take our own table.

[00:09:15]Suppose, my name of that table is ZT PROJ.

[00:09:23]I'll just give the short description.

[00:09:26]Project details.

[00:09:30]I will choose that delivering class.

[00:09:32]Suppose, C customizing.

[00:09:35]Anyways, there's no need to space insert the data into this table. We'll go for display maintenance allowed.

[00:09:42]I will go for fields. M A N D T first field.

[00:09:47]Data element M A N D Suppose I will go for project number.

[00:09:54]Yes, it is a primary key. Now, I will go for data element. I'm using top-down approach. Table, data element, domain.

[00:10:02]You can go for bottom-up approach or bottom-up also.

[00:10:06]Domain, data element, then go for table.

[00:10:10]Suppose my name of that data element is Z D E P N O.

[00:10:18]I will double click.

[00:10:20]I will create this data element.

[00:10:25]I will go for local object.

[00:10:29]I will write project number.

[00:10:34]Now, I will go for domain.

[00:10:37]Suppose firstly I'll go for field label.

[00:10:40]You all know data element is for field label.

[00:10:44]Project N O.

[00:10:47]Project number.

[00:10:51]Project number project.

[00:10:54]I will activate that data element.

[00:10:58]I'll just go for domain. It will just give the error because we have not specified that domain.

[00:11:06]Z D P N O.

[00:11:11]I'll just create that domain.

[00:11:17]Project number.

[00:11:23]I will go for suppose project number numeric data.

[00:11:29]I will simply to activate.

[00:11:34]Now, domain is active.

[00:11:37]Data element is active.

[00:11:43]Now, we will go for table first field that.

[00:11:47]Now, I will go for second column of that table.

[00:11:51]I just wait once it is getting activated.

[00:11:56]It's done.

[00:11:59]Now, I will go for second column project name. It is not a primary key.

[00:12:05]ZTE P name.

[00:12:10]Okay, it already existing. I will just change.

[00:12:13]I will just write PR name project name. Okay.

[00:12:22]Yes, I will create.

[00:12:26]Project name.

[00:12:28]I'll go for domain ZD P name suppose.

[00:12:35]Yes, I will create.

[00:12:37]First, I'll go for field label.

[00:12:40]Project name.

[00:12:43]Project name project name project Now, I will go for domain creation.

[00:12:56]Project name.

[00:13:03]We'll go for suppose project name character 40.

[00:13:10]I will activate the domain.

[00:13:14]I will activate the data element.

[00:13:20]Now, table done. I will go for technical settings.

[00:13:24]I'll choose that data class A double P L 2 because that is for customizing data.

[00:13:31]I'll just put some test.

[00:13:34]You might not receive this.

[00:13:38]If you're getting, you can simply do something.

[00:13:44]I'll just go for activation of that.

[00:13:47]Click. Okay.

[00:13:48]Before going for activation of that table, yes. Now, I will go for enhancement category.

[00:13:56]I'll go to extras, enhancement category.

[00:14:01]Now, I'll firstly go for not classified.

[00:14:06]I'm choosing the enhancement category as not classified. Now, what is the meaning of not classified?

[00:14:15]Now, what is not classified? Term itself is suggesting. The object Object means our table. That table does not have an enhancement category. We are not going for any enhancement category. We are not specifying any enhancement category.

[00:14:36]Suppose, if I will choose not classified.

[00:14:41]This is not classified.

[00:14:43]I will go for copy.

[00:14:46]Now, whenever I will do the syntax check of this particular table, have you seen? I'm getting a warning.

[00:14:55]Enhancement category for table is missing. Many people can understand now, yes. Whenever they are doing the practical, at that time, if your enhancement category of that table is not classified, at that time, you will always always get this warning message.

[00:15:16]So, whenever our table enhancement category is not classified, we'll always get a warning message. But, if you are getting a warning message, does it stop your work? No, our work is never getting stopped. Yes, but it is just giving us a warning. Yes, enhancement category is not specified. It is not classified. So, whenever we will activate this particular table, yes, we'll get a warning message. If I will go for yes, have you seen? I'm getting a message enhancement category for table is missing. But, if I will simply go for activation, I do not want to see the warning. Just it is activated. And so many times, yes, whenever you are doing the practical and if your enhancement category is not classified, you're always always getting this message. Now, we will move on to our next particular enhancement category, and that is important. Now, we will simply simply treat this table as a SAP table now, standard table. If it is a standard table, can you change this particular table? You cannot change this table.

[00:16:35]Yes, we are going for a assumption that this is our standard table. If this is a standard table, I cannot directly change this table. I will simply add the columns to the append structure. You all know how you are going for append structure. This is our main base of that topic. Yes, when we'll treat this table as a standard table. Now, I will move on to next enhancement category.

[00:17:09]Cannot be enhanced. Cannot enhanced. So, what is the meaning of this term itself is suggesting that object cannot be enhanced. It means we cannot enhance this particular table. We cannot add our own columns to this particular table. No custom fields can be added. Suppose, I will simply simply go to X. Do not confuse that why I'm going put why I'm clicking on to change mode. See, if I want to choose the enhancement category, I need for change mode.

[00:17:47]Whenever I will add the columns, I will not directly add the columns now. I will add through append structure. Yes, because we are treating this table as a standard table so that we all can do the practical of the same. Suppose, I'm going for extras.

[00:18:07]I'm going for enhancement category.

[00:18:10]Now, I'm choosing the option cannot be enhanced. I'm going for copy and I'm activating this table.

[00:18:21]Now, you can see there's no warning.

[00:18:24]Previously, we have a warning that enhancement category not specified. Now, just see. Now, this is this is your SAP table. Now, you need to treat this table as a standard table. Now, suppose you got a requirement that you need to add these three columns to this particular table. Suppose, I'll go for one column.

[00:18:48]Suppose, you need to add project start date to this particular table to this particular table. Now, now this is your standard table. We are treating this as a standard table. It means I cannot click on to change mode. I cannot add the third column. How I will add the third column? Through append structure.

[00:19:13]So, I'll firstly click on to a pen structure.

[00:19:17]I will give some name to the a pen structure. And enhancement categories cannot be enhanced as see. I'm writing ZAP append _ST.

[00:19:31]Suppose I'm writing Z append_STR.

[00:19:35]I'll go for okay.

[00:19:38]And I'll just It is already existing.

[00:19:40]I'll just give some different name.

[00:19:42]ZAPP_STR.

[00:19:45]Suppose I will give this.

[00:19:47]I'll go for okay.

[00:19:49]It is also existing. Suppose I will write Z append structure for project.

[00:19:55]I'll give this thing.

[00:19:57]I will go for okay.

[00:19:59]And have you seen? Structure cannot be enhanced. Creation new fields is not possible. So, this see how you are getting this particular message. So, whenever you are going for any standard table or structure, yes, and you are getting this particular message. So, do not confuse at that point of time. Why why I'm not able to add the columns to this particular standard table or structure? Because SAP clearly told you cannot enhance this particular table.

[00:20:35]And this is because of that enhancement category. This is because of that. I'll just go to back button.

[00:20:42]I'll just cancel this.

[00:20:45]This is because of this particular enhancement category cannot be enhanced.

[00:20:51]Suppose if I'll show you this particular table T000.

[00:20:55]You can see in T000 cannot be enhanced.

[00:20:59]Suppose if I will try to go for a pen structure here. If I will go for any a pen structure here. Have you seen? I'm getting the same message here? Yes. Now, whenever people tried the append structure practical because in the same playlist when I explained the append structure at that time I I explained through this order header table. Yes.

[00:21:23]The at that time people are saying many times yes, they are not able to create the append structure. This is because of this only. Your enhancement category is cannot be enhanced. So yes, because of that only you are not able to go for append structure. So what is the summary of this particular video? Important video. I can say yes, it's a pending topic from the last so many days. Yes.

[00:21:51]Many people ask so it's a time to cover this topic.

[00:21:55]What is enhancement category? It specify how a standard table or structure can be enhanced or extended. Enhanced or extended means we are going for extension or enhancement means we are adding our own columns to that particular standard table.

[00:22:19]Yes, how you can check the enhancement category? Go for extras enhancement category and check what is the enhancement category radio button is there. I showed you in VBAK table it can be enhanced but T 000 cannot be enhanced. So whenever you are getting the message that enhancement is not possible, it is because of that enhancement category.

[00:22:46]Now, we need to do the practical. We need to learn each and every option. So we'll not touch any standard table.

[00:22:54]We'll simply create a table. We'll treat that table as a standard table so that we can go for exploration of each and every point. So firstly we covered not classified. Yes, I created that table.

[00:23:10]Two columns were there. Yes. So firstly we have chosen not classified. Not classified means we are not specifying any enhancement category. We are not going for any classification of the enhancement category. Yes, if you are going for this particular option, yes, whenever you will activate the table, you will get a warning message. And many times whenever you are creating your own table and if the enhancement category is not specified, you will get this warning.

[00:23:41]Now second, after that I have chosen the radio button cannot be enhanced. And then I tried to add the column using append structure. Yes, we need to go for append only. I cannot go for direct changes because I'm treating this table as a standard table. This is our main main part. Yes. So whenever I'm going for append structure, system is not allowing me to do because you that enhancement category is cannot be enhanced. And I showed you D3000 also.

[00:24:18]Now in the next video we'll simply explore the other enhancement category options also.

[00:24:26]So that's it in this video. Thank you.