how to construct a custom table as below

Former Member — Sun, 01 Jul 2007 07:33:29 GMT

Dear Friends

can any one please let me know hot to create a custom table as be

outpatient

My FO wants to enter in the SM30 as above ......i.e he wants to have spouse ,1st child one group........ So they want only Spouse and 1st child should be grouped under heading Outpatient . So i would like to how can i construct a custom table as above.

Please could any one tell is it possible.

regards

syamala...

Re: how to construct a custom table as below

Former Member — Sun, 01 Jul 2007 14:36:17 GMT

Create a Dataelement with single CHAR field with description OUTPATIENT and attach this data element to a DOMAIn with length 1 type CHAR and define the values for this domain as below

1 - Spouse

2 - 1st Child

3 -2nd Child

Now create a table with the following fields

Employee No - CHAR 8 or NUMC 8 data type

Outpatient -Single char

Rate -CURR field wih 15 length and 2 decimals

Amount - Curr field wih 15 length and 2 decimals

<b>Reward points for useful Answers</b>

Regards

Anji

Re: how to construct a custom table as below

Former Member — Mon, 02 Jul 2007 04:05:55 GMT

Steps to Creating domains, Data Elements, Tables

To give you the steps for creating table:.

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.

create 1 data element with Outpatient and its domain as Patient datatype Char DATA LENGTH 1. in the value table of the Domain enter as

1 SPouse .

2 Child .

so the table fields

<b>

Employeeno 8 digit (CHAR)

outpatient 1digit (C)-> Domian as 2 vaules

Rate 4digit (CURY)

Amount 15digit(CURR) referrnce Rate</b>.

Reward points if it is usefull .

Girish

topic Re: how to construct a custom table as below in Application Development and Automation Discussions

how to construct a custom table as below

Re: how to construct a custom table as below

Re: how to construct a custom table as below