Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Tables Actiaved in DD

Former Member
0 Kudos

Hi All,

What happens when a table is activated in DD?

Regards

Mitesh

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Mitesh,

A lot of things happen when you activate the table. But the most important, perhaps is the creation of the runtime object for that table. this runtime object will reside on the application server and will contain some crucial information about the table.

I will give you one example of what this runtime object can do. when you write an ABAP program with a select statement like this -

SELECT * 
FROM SPFLI
WHERE KUNNR = '1234567890'.

ENDSELECT.

you will obviously get an error which says that the field KUNNR is not present in the table SPFLI. Obviously, during the syntax check, the database server cannot be queried to verify whether all the fields in the SELECT statement are indeed present in the database. So, the run-time object gives this information.

You can run an ABAP program without activating it, but you cannot use a tale in your program without activating the table first (at least once), because the program will try to access this runtime object when it compiles the code.

Hope the explanation is clear. If not, get back.

Regards,

Anand Mandalika.

6 REPLIES 6

Former Member
0 Kudos

Hi,

When u activate a table in the Data Dictionary it will get created in the database .

Also look at this link

http://help.sap.com/saphelp_46c/helpdata/en/ea/e9a3c84c7211d189520000e829fbbd/frameset.htm

Thanks & Regards,

Judith.

Message was edited by: Judith Jessie Selvi

jayanthi_jayaraman
Active Contributor
0 Kudos

Hi Mitesh,

It is available for any insertion,modification and updation of records by any user.

Check this link.

http://help.sap.com/saphelp_40b/helpdata/en/cf/21f20b446011d189700000e8322d00/content.htm

Message was edited by: Jayanthi Jayaraman

Former Member
0 Kudos

Hi Mitesh,

When a table is activated in DD, a table with same name is

created in the underlying database, also only after activation you can use this table in your reports.

Get back if have doubts.

Regards,

Narinder Hartala

Former Member
0 Kudos

Hi Mitesh,

A lot of things happen when you activate the table. But the most important, perhaps is the creation of the runtime object for that table. this runtime object will reside on the application server and will contain some crucial information about the table.

I will give you one example of what this runtime object can do. when you write an ABAP program with a select statement like this -

SELECT * 
FROM SPFLI
WHERE KUNNR = '1234567890'.

ENDSELECT.

you will obviously get an error which says that the field KUNNR is not present in the table SPFLI. Obviously, during the syntax check, the database server cannot be queried to verify whether all the fields in the SELECT statement are indeed present in the database. So, the run-time object gives this information.

You can run an ABAP program without activating it, but you cannot use a tale in your program without activating the table first (at least once), because the program will try to access this runtime object when it compiles the code.

Hope the explanation is clear. If not, get back.

Regards,

Anand Mandalika.

Former Member
0 Kudos

Hi Mitesh,

<b>Activation</b> is a concept that is used for all repository objects in the SAP system (abaps, tables, data elements, SAPScripts, etc.)

When you activate something, what you are saying is that the version I am currently editing will be the one used during run time, when programs etc. are trying to access the object.

So, you can build a table with three fields and then activate it. When you view its contents in SE16, you will see your talble with three fields.

If you change this table by adding a field, but do not activate it, then you will still see only 3 fields in SE16.

If you activate your table again, however, you will now see 4 fields in SE16.

The same concept applies to abap programs, data elements, etc.

Cheers,

Brad

0 Kudos

Thanks all for replying to my query.

Regards

Mitesh