Activating the Ztable without Technical Settings?

[Former Member]

Dear Gurus,

                  Is there any thechnique available through which we can activate the Ztable without declaring the Technical Settings. I have a strange Program here in which Tables exist and those are activated as well but no technical settings has define for any of those tables. Is there a way through which we can activate a table wihout having techincal settings if not then how these tables are activated in the Dev.

when I press the Tehncial setting no technical setting is define and it is asking from me to defining the technical settings but the table activated. As you can see in the below snap shot the table is acitve and asking for dfining the technical settings.

[Former Member]

Hello,

Go to SE11, Enter your table name, then modifiy.

Click on goto --> Technical settings.

Then fill the data class with APPL0 if you have very little data to store else use APPL1 or APPL2.

Then set the size category to 0 for example or use the match code.

Save all and then activate.

It should work.

Thanks and Kind Regards,

Yovish.

[Former Member]

Dear |Youvish Bissessur,

               Read the Question Carefully this I know very well. Try to understand and look at the snaps.

some of the table in programe has been activated without technical settings how is it possible thats my Question. If someone has done it then how. That is my Question.

Regards,

[Former Member]

Hello,

Strange. Since without filling the tech details the table CANNOT be activated in my current system.

[nabheetscn]

Hi Zahid

One of thing which i can think of is bypassing the message in debugger  check inlcude LSDYYU09 line 205. You change the flag and bypass it.

Thanks

Nabheet

[former_member205645]

Hello Zahid,

could you take a look in the table DD09L to see if the Z table really doesn't have the technical settings defined? I just tried to activate a Z table wihout the technical settings but as I press activated it jumps directly in the settings dynpro . Maybe that is a bug and the settings are really there.

Regards,

Ioan.

[Former Member]

This is the name of the function module :RS_DD_CHECK_ACTIVATE in addition to what nabheet suggested.

You should try debugging it.

[Former Member]

I think it can be done though it is highly unrecommended.

Create the table using se11 without technical settings.

Go to se14 , adjust and activate table.

You have your active table without technical settings.

[Former Member]

Susmitha susan Thomas,

I have Tried, but it is I think untill or unless the table is not activated you will not get the activate and adjust table button on in the se14. it will give you message table not exist in the database.

[Former Member]

Well, I guess then it must have been created using Native SQL. These tables may not be known to ABAP dictionary, but would be created in the underlying Oracle database.

http://www.sapdb.org/7.4/htmhelp/6d/117c14d14811d2a97400a0c9449261/frameset.htm

EXEC SQL.

  CREATE TABLE AVERI_CLNT (

         CLIENT   CHAR(3)  NOT NULL,

         ARG1     CHAR(3)  NOT NULL,

         ARG2     CHAR(3)  NOT NULL,

         FUNCTION CHAR(10) NOT NULL,

         PRIMARY KEY (CLIENT, ARG1, ARG2)

                          )

ENDEXEC.

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/exec.htm

[former_member205645]

I don't think that bypassing the technical settings is a very good idea

[former_member1716]

Hi Zahid,

There are 2 ways w can create the table with out techinical Settings.

1. create all the table elements except techincal settings, now goto se14 and activate and adjust table. now you can see the table get activated.

2. As we are getting the information message, you can go by debugging and change error dialog value.

This will solves the probelm.

[former_member1716]

Hope this helps please let me know if it works.

[Former Member]

Thanx to all,

Hats off to one of my friend Faisal Altaf, He has given me the solution.

FM DDIF_TABL_ACTIVATE .

will activate the table without having any technical Setting.

I m closing the Thread.

[faisalatsap]

Dear Zahid,

Its a way that he might use to activate but please we all should be very clear that Its never advisable to activate with out technical setting.

Thanks and Best Regards,

Faisal

[Former Member]

Today I got a table without technical setting by accident.

1. I created a table Z* with technical setting and activated it in development system. The transport request used is A.

2. For some reason, I need to include table Z* in another transport request, say B.

3. So I delete all the entries related with table Z* from transport request A.

4. I modified table Z*, for example the table description, when I click Save, in the pop-up sreen, I select transport request B and activate it.

5. After transport request B is transported to Production system, I got table Z* without technical setting.