topic Re: table in Application Development and Automation Discussions

table

Former Member — Wed, 13 Dec 2006 08:49:51 GMT

Hi,

i created a table zfrv_deliv_date. Now i want to create a transaction zfrv_lead_deliv_date and this transaction should open the table in display mode.

Please tell me how to create a transaction for a table and display it in display mode.

Re: table

Former Member — Wed, 13 Dec 2006 08:52:19 GMT

Hello,

There are two ways:

1) Try to create a maintenance view with only display permision.

2) Create an ALV report.

Hope this helps!!

Gabriel P.

Re: table

Former Member — Wed, 13 Dec 2006 08:53:54 GMT

1.First u have to create Table Maintainance for that table from se11.

2.Create Parameter Tcode .( this option u will get when u create a Tcode in SE93 ).

u have to give

Transaction SM30 and tick Skip first screen.

VIEWNAME YW2DEFBATCH(table name)

SHOW X

Regards

Prabhu

Re: table

Former Member — Wed, 13 Dec 2006 08:55:56 GMT

Hi shweta,

have you tried se93 ?.

goto tcode se93

select the first radio button program and screen.press enter and give the program name and screen number of the table in display mode that you have cretaed.

to find the program name and screen number ...goto system menu-status.

regards,

pankaj singh.

reward if it works

Re: table

Former Member — Wed, 13 Dec 2006 08:58:20 GMT

Hi Gabriel,

how to crete a table maitenance with only display permission.

Re: table

Former Member — Wed, 13 Dec 2006 09:01:04 GMT

1. go to se93

2. Create transaction of ( type with Parameter.)

3. Enter Transaction SM30 in the transaction , tick skip initial screen.

4. Then for eg. Enter the below values.

( the two parameters as below enter as default values ).

1. VIEWNAME V_TVAK ( Your table Name , it should have table maintenance allowed and also the table maintenance generated )

2.SHOW X

*-Reward if usefull.

Re: table

Former Member — Wed, 13 Dec 2006 09:06:01 GMT

Hi,

go to se 93

Give the transation name .

Give the description .

select the last option in the radio button.

Enter the necessary field .

tick the "skip the initial screen " .

VIEWNAME table name

SHOW X

null

Re: table

Former Member — Wed, 13 Dec 2006 09:22:37 GMT

hi shweta,

i can solve ur problem here.

In transaction SE11, in the attribute tab of your z table check table maintenance check box. Go to SM30 transaction, enter the ztable name and click on maintain button. Here you can enter new entries into the ztable .

You can create a PARAMETER TRANSACTION for the transaction for SM30 .

Follow these steps :

1. go to transaction SE93 , give your own transaction code say ztran_tab, for maintaining your ztable.

2. Click on create button and check the radio button Transaction with parameters (PARAMETER TRANSACTION) and click on the tick button.

3. In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

4. Scroll down you will find a table control for default values

Name of the screen field | value

VIEWNAME | your ztable name

SHOW | X

Save your work.

Now as you have created a custom transaction for maintaining your ztable this transaction can be called from any program with CALL transaction 'XXX'

I think it may help you.

with regards

magesh

Re: table

Former Member — Wed, 13 Dec 2006 09:48:20 GMT

Hi Pankaj,

I followed your suggestion but now the problem is the transaction is opening the table maintanance but what i need is it should display the table in display mode.

please tell me how to do.

Re: table

Former Member — Wed, 13 Dec 2006 10:16:28 GMT

Hi shwetha.

i tried the same and even i am facing some problem with the method i told you..

i can suggest you to go for table maintenance if you have rights ..

goto sm30... or you can follow prabhu's suggestion --

Transaction SM30 and tick Skip first screen.

VIEWNAME YW2DEFBATCH(table name)

SHOW X

regards,

pankaj singh

Re: table

Former Member — Wed, 13 Dec 2006 11:32:04 GMT

Hi Prabhu

the one which you suggested is working fine but what i need is i dont want to display the table maintanence just i want to display a table ( like when entred table name in se11 we get the table with fields) in display mode.

please suggest me to get that.

Re: table

former_member199581 — Wed, 13 Dec 2006 11:45:00 GMT

Take a look at transaction OB28 (for example): when you launch it, it shows directly table T001D.

You can simply copy this tcode in SE93, change the parameters that you want and save all.

Like this:

Skip first screen = 'X'

Default Values:

VIEWNAME: <your_view_name>

UPDATE: space

SHOW: X

Otherwise, if you don't want to use SM30 functionality, create a simple program that fetch data from your table and shows all in a ALV.

Link the program to a tcode and that's all.

Take a look to this snippet:

* Dummy screen for ALV Grid - Mandatory!
SELECTION-SCREEN BEGIN OF SCREEN 1001.
SELECTION-SCREEN END OF SCREEN.

DATA: fcat TYPE lvc_t_fcat,
layo TYPE lvc_s_layo,
itab TYPE TABLE OF <your_table>.
DATA: grid TYPE REF TO cl_gui_alv_grid.

SELECT * FROM <your_table> INTO TABLE itab.

CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'
EXPORTING
 I_STRUCTURE_NAME = <your_table>
CHANGING
 CT_FIELDCAT = fcat[].

layo-zebra = 'X'.
layo-cwidth_opt = 'X'.
layo-grid_title = 'MyTable'.

CREATE OBJECT grid EXPORTING I_PARENT = cl_gui_container=>screen0.

CALL METHOD grid->set_table_for_first_display
 EXPORTING
  is_layout = layo
 CHANGING
  it_outtab = itab[]
  it_fieldcatalog = fcat[].

CALL SELECTION-SCREEN 1001.

Hope this helps,

Re: table

Former Member — Fri, 15 Dec 2006 15:46:19 GMT

Thanks a lot to all and especially for Mangesh for such a detailed explanation