topic custom table in Application Development and Automation Discussions

custom table

Former Member — Mon, 07 May 2007 21:57:07 GMT

Hi experts,

anyone please tell me how to create custom table.please provide me step by step how to create custom table.

thanks and regards,

Deethya

Re: custom table

Former Member — Mon, 07 May 2007 21:58:15 GMT

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

Re: custom table

Former Member — Tue, 08 May 2007 06:01:07 GMT

Hi Deethya,

This link as given will give you a clear picture of how to proceed step by step in creating a custom Z or Y named table.

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

Reward graciously if found helpful.

Regards & Thanks,

Harish

Re: custom table

Former Member — Tue, 08 May 2007 06:17:37 GMT

Creating Custom Enumerations

Use

You use custom enumeration types to display a list of items in dropdown menus of selection fields in user interfaces.

Prerequisites

You have created a project in SAP NetWeaver Developer Studio and it is available in the Service Explorer. For more information, see Creating Development Component Projects.

Procedure

1. Create a custom data type of type string in the dictionary model. To do so, do the following:

a. Open the dictionary perspective with Window ® Open Perspective ® Other ®Dictionary.

b. In the Dictionary Explorer expand your project and go to Dictionaries ® Local Dictionary ® Data Types ® Simple Types.

c. With the secondary mouse button, choose Create Simple Type.

d. In the New Simple Type window, enter a name and choose Browse to select the customtypes package.

By specifying the customtypes package, you indicate that CAF should take the runtime enumeration definitions (these will be defined in step 3), not those defined in the dictionary model.

e. Choose Finish.

f. From the dropdown menu for Built-In Type, select the data type (for example, string) and define any length constraints.

g. In the Representations tab page, fill out the corresponding fields.

h. In the Dictionary Explorer, go to the custom type you just created (Dictionaries ® Local Dictionary ® Data Types ® Simple Types ®/caf ® Administrative Tools of the CAF Runtime Configurator to maintain the enumeration types with the Custom Type Editor.

a. Enter the custom type name you created in step 1 above in the field Type and choose Add.

For example, com.sap.carpool.customtypes.salutation.

b. From below the table, choose Add and maintain the enumeration selections in the columns Key and Value.

c. Choose Save.

Result

At runtime, the system will detect that this attribute is not based on a simple data type, but rather on an enumeration. This means a selection list, based on the entity service attribute you assigned it to, is generated in the UI.

Award points if this is helpful

Re: custom table

Former Member — Tue, 08 May 2007 13:13:07 GMT

Hi deethya.

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.

i think ur doubt will be cleard now.

Thanks

Senthil

Re: custom table

Former Member — Fri, 11 May 2007 11:06:19 GMT

if its solved problem reward points ya

bye