topic Re: creating a table in Application Development and Automation Discussions

creating a table

Former Member — Tue, 26 Feb 2008 12:10:50 GMT

Is there any requirment will be there to create a table in dataditionary are we use standard tables

Re: creating a table

Former Member — Tue, 26 Feb 2008 12:14:15 GMT

yes there are requirements to create a table in dataditionary according to clients need.

and

again yes standard tables are for use only

Re: creating a table

Former Member — Tue, 26 Feb 2008 12:51:48 GMT

hi,

yes we can create and that is depends on clients requirement.

To create a transparent database table, you must have the domains and data elements ready with you.

1.Go to transaction SE11 (by typing SE11 or /nSE11 in the command field).

2. Create a domain for every field of the table as follows:

Type in the domain name (beginning with z) and press ‘CREATE”.

Give a descriptive short text and key in the datatype, number of characters etc. for the definition of the domain.

Save the domain as a local object (development class = $TMP).

Activate the domain.

Create all the domains you need.

1.Now create a datatype for each domain created.

Key in a name for the datatype and press ‘CREATE’.

2.A popup comes up. Select ‘data element’ and press ‘ENTER’.

3.Give a descriptive short text. Give the name of the domain for which this data element is being created and press ‘ENTER’.

4.Click on the ‘FIELD LABEL’ tab and give an appropriate field label.

Save as local object and activate the data element.

1.To create the database table, enter the name of the table and click on ‘CREATE’.

Note that the table name must start with Z and must not have the underscore (_) character in the second or third place.

2.Now enter the following parameters on the screen that comes up:

Delivery Class: The delivery class controls the transport of table data when installing or upgrading, in a client copy and when transporting between customer systems. Give the delivery class As ‘C’ for customer tables (Customer table, data is maintained by the customer only.)

Table Maintenance: If this flag is set, the data in the table can be changed with the Data Browser (Transaction SE16) if the user has the necessary authorization. Keep the box checked.

Save the table. Now we shall see how to assign fields to the table.

3.First click on the ‘FIELDS’ tab and then on the ‘Data element/Direct type’ button.

Now enter MANDT in the ‘FIELDS’ column and MANDT in the ‘FIELD TYPE’ column. Press ‘ENTER’. The ‘DATA TYPE’, ‘LENGTH’ and ‘SHORT TEXT’ fields get populated automatically.

Enter ‘zd_hnk’ in the ‘FIELDS’ column and ‘ze_hnk’ in the ‘FIELD TYPE” column. If you want to set any of the fields as key fields, you can do so by checking the ‘KEY’ column for that field. Save the table.

4.Now click on the button on the application toolbar that says ‘TECHNICAL SETTINGS’.

Enter the data class and size category. Set the buffering parameters.

Save and return to the previous screen. Now, activate the table.

Re: creating a table

sreelatha_gullapalli — Wed, 27 Feb 2008 07:20:17 GMT

yes some times we need to create a tables in datadictionary those table are called ZTABLES.

this is the procedure to create Ztables

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb6e446011d189700000e8322d00/frameset.htm

1.Go to SE11 Transaction.

2.Give Table name starts with Z or Y letter -->click create.

3.Give short description & Delivery class as "A", & Data Browser as "Display/Maintenace Allowed".

4.Click Field tab,give MANDT in field & Data element, click primary key check box & initial values and give Enter on dataelement.

5. Give field name which u want, this s primary key field. so click key check box & initial values, give data element name starts with Z or Y double click on that data element,popwindow wil come, in that click yes, give ur package name>save, it wil ask to create data element, so click yes.Then give short description, in Data type tab click we can choose either Domain or Buil-in type.If u want domain,select domain give any name starts with Z or Y, double click on that>yes ~~>Save.It wil ask to Create domain~~>yes. Give short desc, give required data type, No.Chars & Output length -->Save --> Activate.

Note: We can use old domain values or we can create new domains.

6. In data element page, click Field label tab. Give short, medium, Long & Heading values ~~>save~~>Activate.

7.Go to main table page, Give other fields which u want, here no need to give primary key. Do the same steps as told previously.

7.Go to Technical Setting at the top of the page.Give the Data class "APPL0". Select Size category as 0 or anything which u want -->click Save button --> Go back.

8.Activate the main table -->Save.

9.Go to Utilities -->Table contents --> Create Entries. Then Create the Records.

Click on Utilities --> Table Maintainance Generator.

Authorization Group &NC&.

and provide function group for table maintainance ( u can create a function group in se37 )

click on Find Scr Number button.

select Propose Screen Number and Continue.

then Create...

Save and Back

Activate the table.

To create a TCODE for a custom table, follow the steps below:

1. Go to transaction SE93 ,

2.Give the name of ur tcode say zxxxx, for maintaining your ztable.

3. Click on create button,now a page opens.

4. Choose the radio button Transaction with parameters (PARAMETER TRANSACTION) .

5. In the next screen enter transaction as : SM30

7. Also check allthe three check boxes for the GUI support.

8. Scroll down you will find a table control for default values

Name of the screen field | value

___________________________________

VIEWNAME | your ztable name

UPDATE | X

Save your work. Thus ur Tcode is created.

hope it will help you

regards

sreelatha gullapalli

Re: creating a table

Former Member — Wed, 27 Feb 2008 09:21:49 GMT

Hi,

We can create Z tables using SE11. se11->create. After creating, maintain techinical settings in Se11. Go to Sm30. this is for table maintenance. We can add entries to the created z tables here.

Hope this clears ur doubt.

Regards,

Ramya

Re: creating a table

Former Member — Wed, 27 Feb 2008 10:51:16 GMT

Hi,

Yes we can creat table in dictionary according to the client requiremets for example if he ask to maitain separate address table then we need to create, mostly the standard tables are being used .

Regards,

kavitha

Re: creating a table

Former Member — Thu, 28 Feb 2008 07:10:43 GMT

Actually we use standard tables only.if client asked differenty then we have to create the tables in the data dictionary.

Re: creating a table

Former Member — Thu, 28 Feb 2008 07:46:42 GMT


> Is there any requirment will be there to create a table in dataditionary are we use standard tables

Hi,

Yes There may be a requirement to create a custom table at data dictionary level.because if you go for some companies which are having tin number,container number,like that there is no field existing in sap to fulfill this requirement.

so definitly we have to go for custom table to store this data.

Regards,

swami.

Re: creating a table

Former Member — Thu, 28 Feb 2008 10:54:16 GMT

Most of the casses we can use the standard tables, but very few times the standard tables are not suitable to our requirement at that time we need to create the user defined tables.

Re: creating a table

Former Member — Fri, 29 Feb 2008 09:12:04 GMT

HI,

Many times we use the STANDARD tables .

sometimes if there is any client requirement,then we need to create Tables.

Tables are created in SE11 transaction.

Regards ,

Vineela