topic Re: Transperent table in Application Development and Automation Discussions

Transperent table

Former Member — Thu, 31 Jan 2008 07:58:08 GMT

How to Create a transparent table with the following fields:

a) Id - Primary key

b) Employee function - Primary key

c) Area

Re: Transperent table

Former Member — Thu, 31 Jan 2008 08:02:51 GMT

Hi,

Follow this link

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm

Regards,

Satish

Re: Transperent table

Former Member — Thu, 31 Jan 2008 08:07:10 GMT

Hi,

Goto se11 and give the table name in the table and press create and then give the short give delivery class as 'a' and give then goto fields and give your fields in the table control and check the key field for the ID and employee function.

then save technical settings give size category and required fields . save it and activate it.

PLzz reward points if it helps.

Re: Transperent table

Former Member — Thu, 31 Jan 2008 08:07:49 GMT

Hi Amren,

There are two approach in creating a table.

1. Bottom-up approach

2. Top-down approach.

Both are valid and you can choose which approach is suitable for you. I always use the bottom-up approach. Here are the steps to create the tables with this approach.

1. SE11 will take you to the DDIC and enter the name of the new table to be created. Let us say Zname. Click create.

2. Enter the short discription of the table and enter the field of the table. If it is primary key and you have to check the box.

3. Enter the data element and double click it, you will be asked to save and will take you to data element discription page. Enter the short discription of the data element and enter the information of domain like the length of field and type of field.

4. If you wanted to use the existing domain then its fine, or else, you have to create one. Enter the domain name in the data element page and double click it. Page will ask to save and jump to domain creation page.

5. In the domain page, you have to save the information which you have already given in the data elements page and check it. Before going to data element page, you have to activate the domain.

6. Go to data element page and save, check and activate.

7. Go to main table page and save, check, and activate.

8. Also, you have to save the technical settings of the table.

The table is now ready for operation. You can use it in your program or you can use it to enter information.

Check table: It is the table which will have all the information about the Foreign keys which are the primary keys in the check table.

It can be created by creating the foreign key from the main table. Click foreign key in the main table and it will take you to a page which will ask for table name and field to which foreign key relation has to be associated. Enter the information and you can create the check table automatically.

SM30 is used for maintenance of the table, that is to realease the errors occured during the creation of the table.

how to integrate the table with defferent R/3

Transport the Table to the another server/client/qas/prd

Reward if found helpfull,

Cheers,

Chaitanya.

Re: Transperent table

Former Member — Tue, 05 Feb 2008 06:34:44 GMT

Answer

How to Create a transparent table with the following fields:

goto SE11

selet database table, give any name starting with Z/Y

create

give short desc

Delivery Class A

Data Browser/Table View Maint.Alowed

fields TAB

mention ur fields

a) Id - Primary key

b) Employee function - Primary key

c) Area

go to tTechnical settings

specify delivery class

activate it

reward if useful

Narendra

Re: Transperent table

Former Member — Tue, 05 Feb 2008 07:21:19 GMT

Go to SE11

Give Z table name and create

give Short description of the table

give delivery class and data Browser/Table View Maint.

goto Fields tab

Give fieds one by one and for primary key check the check boxes Key and Initial

save

tehn click on technical settings

give data class and size catergory.

save and activate.