Techincal settings

[Former Member]

Hi ,

which cases we use follwing thinks :

in techical settings , data class section

USER Customer data class

USER1 Customer data class

USER6 Customer data class, generated by SAPDBA

USER7 Customer data class, generated by SAPDBA

DDIM Dimension Tables in BW

DFACT Facts Table in BW

DODS ODS Tables in BW

And also size catagory , which size ( 0 to 8 ) , we need to give . based on which cases , we need to select size catagory .

Please.advise me

Regards ,

Kiran

[ThomasZloch]

Press F1 on those fields.

Thomas

[Former Member]

HI,

Search the SCN before posting the basic question.

[Former Member]

Hi Kiran,

refer the below links for your doubts..

the size catageory [size catagory refer link|http://help.sap.com/saphelp_46c/helpdata/en/cf/21ead2446011d189700000e8322d00/content.htm]

[data class section |http://help.sap.com/saphelp_46c/helpdata/en/cf/21eac5446011d189700000e8322d00/content.htm]

Regards,

Prabhudas

[Former Member]

Hi,

Dataclass is used to assign a place to table where to store in database

Sizecategory is used to define the space required for table

For more information check the following links

[Dataclass|http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eac5446011d189700000e8322d00/content.htm]

[sizecategory|http://help.sap.com/saphelp_nw04/helpdata/EN/cf/21ead2446011d189700000e8322d00/content.htm]

Hope this helps you.

Regards,

Rajani

[Former Member]

hi

when u are maintaining the Technical settings for a table

u should be aware whether the data that u r going to store in the Z table that u have

created is Master data or Transaction data

if Master data then select APPL0 for data class or if it is

transaction data then select APPL1 for data class field or if it is

custom data then u can select USER or USER1 or if it is custom data

generated by SAPDBA select USER6 or USER7 for data class field.

Based on the no of the records that the table is going to store select the

field Size Category.

Regards

[Former Member]

Hi,

check with f1 help of the data class and the size category of the particular field .

Regards,

Madhu

[Former Member]

This message was moderated.

[Former Member]

Hi Kumar ,

The technical setting is basically to define the table as per type of data stored ,like whether it's master data ( which won't change frequently like standard sap data ) or transparent data ( Which will change frequently - like any customer related data ) . in that user data is one type where user can have his transparent data .

Size is basically defines the number of entries can have the table .

Will give u more details later .

Thanks,

Arun .

[Former Member]

Hi,

We use technical settings for

1. Assigning the table to one of the table space available in the database. This we do in data class.

APPLO : here we are assigning our table to master data table space

APPL1 : here we are assigning our table to transaction data table space

APPL2: here we are assigning our table to organization data table space. These data are customizing data that are defined during the system is installed and it is very rarely changed.

The other data classes, USER and USER1, are provided for the customer. These are used to define user developments.

2. size category: size category identifies the amount of disk space needed for the particular table on the database when creating it. If the number of records in a table exceeds the original size category, then more space will automatically be allocated in the database

Regards,

Mani

[Former Member]

Dear,

Search SDN before posting any basic threads.

Cheers

fareed