topic Re: table creation in Application Development and Automation Discussions

table creation

Former Member — Thu, 02 Aug 2007 01:52:34 GMT

hi i want to create a table which needs to be maintain by user

i need to know the exact steps to create and process and steps for creation

step 1 i am ware of table creation and giving fields and primary keys and activation

my question is what is the important things needs to be taken care of so that table is allowed to be maintained by user

and we need to do sth from menu like table maintainence allowed li dont remeber exatly what steps i follwed last time so that the table works fine in production

regards

Arora

Re: table creation

gopi_narendra — Thu, 02 Aug 2007 01:56:22 GMT

As what i understood is that the table needed to be maintained by users. so just create a transaction for the table, follow these steps

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 all the 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

Regards

Gopi

Re: table creation

Former Member — Thu, 02 Aug 2007 02:10:33 GMT

Hi gopi

i followed all the steps in the last

step it is saying view 'name' not defined for the current screen

also help me to undersant why we chose tcode as sm30 to be put in that transaction

and on the errro do i neeed to define a view aslo for the table and if yes can u tell me the important steps to be followed for that

regards

Arora

Re: table creation

gopi_narendra — Thu, 02 Aug 2007 02:23:11 GMT

Have you created the table maintenance? The error meant that the table maintenance has not been generated or maintained.

In order to maintain the table maintenance follow these steps

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

3) Select standard recording routine radio in table table mainitainence generator to move table contents to quality and production by assigning it to request.

4) Select maintenance type as single step.

5) Maintainence screen as system generated numbers this dialog box appears when you click on create button.

6) Save and activate table.

The reason why you give SM30 as the tcode is because you maintain the table records using SM30 transaction and give the View name as the table name.

If you run the tcode SM30, you need to give the table name and then you can maintain entries, right? this is what you are stating while creating a tcode for a table

Regards

Gopi

Message was edited by:

Gopi Narendra

Re: table creation

Former Member — Thu, 02 Aug 2007 02:43:47 GMT

HI GOPI THANKS FOR QUICK REPLY

1 TABLE MAINTINENCE I CHECKED ALREAYD

2 WHILE DOING SECOND STEP

WHEN I AM ASSIGNEING A FUNCTION GROUP TO IT IT IS GIGIN ERROR NO FURTHER ENTRIES ARE FOUND I SUPPOSE THE FG IS INACTIVE HENCE THIS MESSAGE

I CREATED A FUNCINO GROUP ZFG IN SE37 BUT FROM WHRE TO ACTIVATE IT PLS TELL

ALSO FOR MAINTAINECE SCREEN IT IS GIVING MESSAGE SPECIFY THE NUMBER OF OVERVIEW SCREEN IT IS NOT BEING GENERATED AUTOMATICALLY?

PLS SUGGEST

REGARDS

ARORA

Re: table creation

gopi_narendra — Thu, 02 Aug 2007 02:47:03 GMT

goto SE80 and give in the fucntion group there by selecting the drop down as Function Group.

And right click on it and choose Activate.

This will activate your Function Group.

Regards

Gopi

Re: table creation

Former Member — Thu, 02 Aug 2007 03:10:03 GMT

hi gopi thanks for the clarification

still the same erro in se93

i created the table maintainence and it got activated

not again same error

ie i gave name of screen field value

ztestable (ie view name) ztesttable (table name)

got from table maintainence

whne press enter the errro comes

the field ztesttable does not exist in the called screen

in sm30 is checked the by giving view name

clieked on display

is displayed but no entries available there (even t hough i havecreated the table and givne a field shipto in it and activated it) still not showing any field in this view

pls suggest

regards

Aora

Re: table creation

gopi_narendra — Thu, 02 Aug 2007 03:13:54 GMT

Hi Arora,

Its just

VIEWNAME | <your tablename>

 "let VIEWNAME remain as it is

Name of the screen field | value 
___________________________________

VIEWNAME | ztesttable  " Which is ur table name
UPDATE | X

dont give your view name at the VIEWNAME.

It means you are mentionnig the View name as the table name VIEWNAME = <table view name>

Regards

Gopi

Re: table creation

Former Member — Thu, 02 Aug 2007 03:26:10 GMT

Check the below link :

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

please go throught below link ..... it was given with screen shots of the T.code Creating for the table after the maintaince view had been created ......

http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

Thanks

Seshu

Re: table creation

Former Member — Thu, 02 Aug 2007 03:39:52 GMT

HI GOPI

THANKS

GOT IT

BUT THE VIEW IS EMPTY NOT SHOWING THE FIELDS OF TABLE THE ONE FIELD I DEFINED CAN U SUGGEST ON THAT

HI SESU

THANKS FOR PROVIDING THE LINK

ALSO ONE IMPROTANT Q I WANT TO ASK THE REQUIRMENT IS AS BELOW NEED UR COMMENTS ON THAT

hi there is requriemen tto design as below kinldy help to understand hte feasiblity and what needs to be done for that it is module programming required for it?

THE ULTIMATE AAIM IS TO Once the shipment is shipped, an email notification will sent out the specific customer.

field type validation

Ship To Char 10 Validate the ship to code against SAP customer master table “KNA1”

Email Char 50 Validate standard email id format

party Name Char 35 Retrieve the name 1 value from customer master

(KNA1/NAME1) Avnet Singapore Ptd Ltd

2) aslo need to create a transacton for it to maintain by the users

3) allow sorting basis on all fields and to add new entry and delete existing

<b>please help me to understand the feasiblity what needs to be done for it

if table is created how to take care of validation for that do i need to use module pool programming?</b>

please suggest on the needfull to be done if module pool programiing is needed or not and how to proceed step by step

regards

Arora

Re: table creation

Former Member — Thu, 02 Aug 2007 04:12:18 GMT

Hi Arora,

It is easy task to perform by using table maintaince.

You get everything in table maintaince i mean deleting entries ,inserting entries ,modifying entries.

Only thing is validation against with standard table.

Check the below link for validation against on standard table,here you need to maintain events.

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

email id validation is important -

keep the validation like user@companyname.com

authrization part - once you created transaction code ,then basis or security guy will give the auth to users.

When you see your requirement ,no need to have module pool program.

I guess you got it.

Thanks

Seshu

Re: table creation

Former Member — Thu, 02 Aug 2007 04:18:09 GMT

hi sesu

thanks for the quick reply please sugest on

1) how to take care of sorting on all fields

2) email notification will be seleted from this table meanw we cna write a general report later on that right?

regards

Arora

Re: table creation

Former Member — Thu, 02 Aug 2007 07:04:13 GMT

hi Seshu

only thing left is icon of sorting on all fields pls suggest how to do it

regards

Arora

Re: table creation

Former Member — Thu, 02 Aug 2007 08:14:35 GMT

hi all

can anyone suggest way to bring sorting icon to table maintainence so as to sort on basis of table fields

regards

Arora

Re: table creation

Former Member — Thu, 02 Aug 2007 22:03:26 GMT

Hi Arora,

Sorry for late reply , It is difficult to add sort button into table maintaince.

but it is possible.

Check with below link - Do search like sort

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBCUSTMECA/BCDWBCUSTME.pdf

Thanks

Seshu

Re: table creation

Former Member — Fri, 03 Aug 2007 01:51:14 GMT

hi Seshu

waht is my purpose is to shoow sort button in that table mainainecne screen to user so that they can sort on basis of any field out of the three fields in the table.

the link didnt provide much info thanks for the link anyhow as it has got some other useful info

pls suggest how to add sort button in the screen

should we use module pool if yes how?

regards

Arora

Re: table creation

Former Member — Fri, 03 Aug 2007 05:58:20 GMT

hi Seshu

is it possible to add sort in display?

regards

Nishant

Re: table creation

Former Member — Fri, 03 Aug 2007 06:02:39 GMT

opened a new theread for it