topic Re: creating Tcode for Table in Application Development and Automation Discussions

creating Tcode for Table

Former Member — Thu, 17 Jan 2008 06:21:46 GMT

hi Experts,

Can any one Help meplz, I'm Venkat,I have doubt in Dictionary .i.e how to create transaction code for database table .when i create Tcode for table in Se93 ,it asks abt progarm name,if i given that name as table name it is giveng run time error.

Re: creating Tcode for Table

Former Member — Thu, 17 Jan 2008 06:23:44 GMT

Hi ,

To manipulate a table , thenn you need to create table maintanence .

In the menu of SE11 , you will find table maintanence generator.

Please check it , if should help you.

Regards

Arun

Re: creating Tcode for Table

Former Member — Thu, 17 Jan 2008 06:25:43 GMT

You can create new Tcode from Tcode SE93

Fill all the attributes

Give your custom txn name 'ZTXN'.

Give the Short text for it .... (This short text will appear if u choose this txn as favourites on SAP Easy access)...

Select the Object type of your program from the 5 radiobuttons that come up..Select 2nd option if its a report program. Press Enter.

When you go to the next screen, Enter name of the Program(ZPROG) you are intending to make the transcation for ...

Save the Transaction.

Now you can type the transaction ... 'ZTXN' in the command bar that will take you to the selection screen of the program ZPROG...

Regards

Re: creating Tcode for Table

Former Member — Thu, 17 Jan 2008 06:27:09 GMT

hi ,

plz tell me abt how to create table maintanace gen and frorm that Tcode for table.

Re: creating Tcode for Table

Former Member — Thu, 17 Jan 2008 06:31:38 GMT

Hi ,

Go to SE11 and in the Utilities menu , there will be an option called Table Maintanence Generator , Click on it and in the next screen fill in the relevant fields.

Here is an e.g

http://allaboutsap.blogspot.com/2007/04/table-maintenance-in-sap-step-by-step.html

Regards

Arun

Re: creating Tcode for Table

Former Member — Thu, 17 Jan 2008 06:36:52 GMT

Hi Venkat

After creating table maintenance for the required table do as below.


1. Transaction: SE93
2. Enter Short Text
3. Select Radio button "Transaction with Parameters(Parameter Transaction)"
4. Next screen, give transaction as *SM30*
5. Check "Skip Initial Screen"
6. Under Detault Values tab give two rows
   a. VIEWNAME for screen field and <your table name> for value
   b. UPDATE for screen and 'X' as value
7. Save and Execute

Kind Regards

Eswar

Re: creating Tcode for Table

radhushankar — Thu, 17 Jan 2008 11:21:23 GMT

i did like this but i am getting a error like this the maintenence dialog for ekpo is incomplete or not defined.

Thanks and Regards,

Arun.J