topic Re: Table Creation in Application Development and Automation Discussions

Table Creation

Former Member — Wed, 21 Feb 2007 18:43:22 GMT

Hi All,

I need to create a custom Table with 3 fields - custnum(kna1-kunnr(10)), custcode(char05) and sapcode(char05). Custnum, custcode are primary keys. Please help me to create the Table.

Thanks,

Veni.

Re: Table Creation

Former Member — Wed, 21 Feb 2007 18:46:54 GMT

Hi Veni,

Go to SE11.

1. Provide all necessary details about name and then details about it's description.

2. Add fields to the table which U have mentioned.

3. For Creating Key .. Press Key relationship tab and enter the value table there.

Your table is created... For more help u can refer to help.sap.com

Hope this will help u.

Darshan

Re: Table Creation

Former Member — Wed, 21 Feb 2007 18:54:30 GMT

Go to SE11, enter the table name you want to create, click on create button and give the attributes and technical settings and then enter your 3 fields in the fields tab and put a check mark on the primary key for the 2 fields you want to and enter the value table.

Mark this thread as answered if you got the answer rewarding points.

Re: Table Creation

amit_khare — Wed, 21 Feb 2007 18:58:12 GMT

Hi,

These two documents will give you step by step process to create table.

<a href="http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBDIC/BCDWBDIC.pdf">Table</a>

<a href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/6c/f2934259a5c66ae10000000a155106/frameset.htm">Table 1</a>

Regards,

Amit

Reward all helpful replies.

Re: Table Creation

Former Member — Wed, 21 Feb 2007 20:13:22 GMT

Hi,

Thank you.

What delivery class should I give and should I check 'Table maintenance allowed'.

I will appritiate your help.

Thanks,

Veni.

Re: Table Creation

amit_khare — Wed, 21 Feb 2007 20:15:43 GMT

Use Delivery Class A and check 'Table maintenance allowed'.

In technical settings use following -

Data class APPL0

Size category 0

Regards,

Amit

Re: Table Creation

Former Member — Wed, 21 Feb 2007 20:16:26 GMT

deliver class - 0 and tick on table maint.

Re: Table Creation

Former Member — Wed, 21 Feb 2007 20:16:42 GMT

Usually the data class is APPL0 and size is 1

Delivery class is A usually and 'Display/Maintenance allowed with Restrictions'.

All this depends on the requirement again.

Re: Table Creation

Former Member — Wed, 21 Feb 2007 20:50:24 GMT

hi,

Use Delivery Class A and check 'Table maintenance allowed'.And activate it,if not

you will not be able to insert the values.

Delivery class : means owner of the table

table maintenance : choose the second option ,then save it and activate.

In technical settings use following -

Data class APPL0 ( ie master data)

Size category 0 to 4 (choose 0,its for how much the data the table should hold).

award points if it is helpful.

sri

Re: Table Creation

Former Member — Wed, 21 Feb 2007 22:12:09 GMT

Thank you all!

Regards

Veni.