topic Re: table without technical settings in Application Development and Automation Discussions

table without technical settings

Former Member — Mon, 30 Jun 2008 08:13:07 GMT

Hi everyone,

can anyone tell me how to suppress this message ......Message no. E2173....so i shall activate my table which dont have any technical setting...( i know that we can create the table without technical settings and i want solution)..

Thanks

Edited by: priya patil on Jun 30, 2008 10:13 AM

Re: table without technical settings

matt — Mon, 30 Jun 2008 08:16:32 GMT

Try creating it as a structure instead? Or modify the code so the error goes away?

To my knowledge, (and I'm happy to be corrected) all tables have to have technical settings. Why would you want one without?

Re: table without technical settings

Former Member — Mon, 30 Jun 2008 08:16:56 GMT

Priya,

I think you cannot create table without tec setting.

just refer:

http://help.sap.com/erp2005_ehp_02/helpdata/EN/cf/21eab8446011d189700000e8322d00/frameset.htm

Amit.

Re: table without technical settings

Former Member — Mon, 30 Jun 2008 08:17:02 GMT

No .

[http://help.sap.com/saphelp_erp2005vp/helpdata/EN/cf/21eab8446011d189700000e8322d00/frameset.htm|http://help.sap.com/saphelp_erp2005vp/helpdata/EN/cf/21eab8446011d189700000e8322d00/frameset.htm]

Re: table without technical settings

Former Member — Mon, 30 Jun 2008 08:26:32 GMT

because i have seen such types of tables which having records in data dictionary.....and i'm curious to know how we create without technical setting..

Re: table without technical settings

matt — Mon, 30 Jun 2008 08:38:03 GMT

Are they standard tables - which ones? Could be cluster tables, like RFBLG I suppose.

matt

Re: table without technical settings

bpawanchand — Mon, 30 Jun 2008 08:47:37 GMT

Yes Mathew is right might be they are cluster tables a transparent table cannot be created with out technical settings , I hope.. check out ..

Regards

Pavan

Re: table without technical settings

Former Member — Mon, 30 Jun 2008 08:47:53 GMT

they are not standard table...they are user defined one...like 'ZXXXXXXX'.....

Re: table without technical settings

Former Member — Mon, 30 Jun 2008 14:25:56 GMT

Hi priya,,

close all the threads that been answered

Regards,

bhumika

Re: table without technical settings

Former Member — Tue, 01 Jul 2008 04:37:35 GMT

y should i close all the threads????

Re: table without technical settings

Former Member — Tue, 01 Jul 2008 06:41:44 GMT

hi priya,

in my opinion table cannot be activated w/o technical settings...transparent tables..

u can check for cluster and hashed tables.

check this link also....

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=tablewithouttechnical+settings&cat=sdn_all

Re: table without technical settings

Former Member — Tue, 01 Jul 2008 09:41:43 GMT

hi,

it is not possible to create a table with out technical settings. but u can create a structure without tech settings.

i hope it is clear for u.

please reward points if it is helpful for u.

Rregards,

sravan.

Re: table without technical settings

Former Member — Tue, 01 Jul 2008 10:01:39 GMT

Hi Priya,

I'm very much sure that data cant be entered into a transparent table without activating it but if u've seen that unactivated tables are thr with data present then it means that data has been entered into them externally i.e directly thru dbms overriding the sap system

Re: table without technical settings

Former Member — Wed, 02 Jul 2008 03:55:49 GMT

Hi Kartik,

I'm not getting what you want to say??? please explain.....

Thanks..

Re: table without technical settings

Former Member — Wed, 02 Jul 2008 04:28:01 GMT

Hi Priya,

What i'm trying to say is that the tables which we create through SAP are stored in DBMS say for example Oracle, now data can be entered into those tables by directly giving SQL commands from oracle without using the sap system (though this is highly not recommended) but i feel this the only way by which data was present inside some of the tables without any technical settings.

Re: table without technical settings

Former Member — Wed, 02 Jul 2008 13:49:53 GMT

hi priya,

The technical settings of a table define how the table will be handled when it is created in the database, that is whether the table will be buffered and whether changes to data records of the table will be logged.

The most important parameters are:

Data class: The data class defines the physical area of the database (tablespace) in which the table should be created.

Size category: The size category defines the size of the extents created for the table.

When the table is created in the database, the required information about the memory area to be selected and the extent size is determined from the technical settings.

Buffering permission: The buffering permission defines whether the table may be buffered.

Buffering type: If the table may be buffered, you must define a buffering type (full, single-record, generic). The buffering type defines how many table records are loaded into the buffer when a table entry is accessed.

Logging: This parameter defines whether changes to the table entries should be logged. If logging is switched on, each change to a table record is recorded in a log table.

The Convert to transparent table flag ( transparent flag) is also displayed for pooled tables or for tables which were converted into transparent tables earlier on with this flag.

Now,the point is that table can't be maintained in the database without these above mentioned things.That's why answer to yr question is simple that we can't activate an table without techinacl settings.

Re: table without technical settings

Former Member — Fri, 04 Jul 2008 07:00:08 GMT

Hi Priya,

According to me a table cannot be activated without technical settings.

Re: table without technical settings

Former Member — Mon, 07 Jul 2008 06:36:27 GMT

Hi Priya,

You need to create technical settings (Data Class, Buffering and Size category)..you can't skip this step.

Re: table without technical settings

Former Member — Mon, 07 Jul 2008 08:53:42 GMT

http://help.sap.com/erp2005_ehp_02/helpdata/EN/cf/21eab8446011d189700000e8322d00/frameset.htm

Chk it

Re: table without technical settings

Former Member — Wed, 07 Jul 2010 11:00:33 GMT

Hi,

I too faced the same situation and find out the solution for the same.

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.

Thanks,

Raghu.