topic Re: Activating the Ztable without Technical Settings? in Application Development and Automation Discussions

Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 06:32:06 GMT

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.

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 06:56:48 GMT

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.

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 07:05:04 GMT

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,

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 07:12:06 GMT

Hello,

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

Re: Activating the Ztable without Technical Settings?

nabheetscn — Thu, 14 Nov 2013 07:18:04 GMT

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

Re: Activating the Ztable without Technical Settings?

former_member205645 — Thu, 14 Nov 2013 07:19:08 GMT

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.

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 07:19:28 GMT

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.

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 07:20:56 GMT

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

You should try debugging it.

Re: Activating the Ztable without Technical Settings?

former_member205645 — Thu, 14 Nov 2013 07:22:47 GMT

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

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 07:26:25 GMT

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.

Re: Activating the Ztable without Technical Settings?

former_member1716 — Thu, 14 Nov 2013 07:35:45 GMT

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.

Re: Activating the Ztable without Technical Settings?

former_member1716 — Thu, 14 Nov 2013 07:38:13 GMT

Hope this helps please let me know if it works.

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 07:41:05 GMT

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

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 14 Nov 2013 07:43:17 GMT

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.

Re: Activating the Ztable without Technical Settings?

faisalatsap — Thu, 14 Nov 2013 07:47:20 GMT

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

Re: Activating the Ztable without Technical Settings?

Former Member — Thu, 06 Mar 2014 02:13:53 GMT

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.