Transaction For Table

[Former Member]

Hai SDNs,

Please help me for creating Transaction For Table( i.e. to update table fields using bdc).

Thanks in advance,

Reagards,

aravind

[Former Member]

Hai SDNs,

Please help me for creating Transaction For Table( i.e. to update table fields using bdc).

Thanks in advance,

Reagards,

aravind

[Former Member]

A separate transaction for this table maintenance,

transaction SM30 is not open for normal users because of authorisation.

Is there a possibility of maintaining this Z-table in the same way SM30 does, but without creating your own Z-dialog program.

But you can easily create a ZTCODE ( transaction in SE93) affiliated with a ZABAP ( prog ).

And in your zabap you just have to put the following code :

 Report ZABAP.
call function 'VIEW_MAINTENANCE_CALL'   
   exporting     
     action        
         = 'u'       
   view_name       = 'ZTABLE'         
  check_ddic_mainflag    = 'X'   
   exceptions         
 foreign_lock           = 2        
   no_tvdir_entry         = 8.

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

[Former Member]

HI,

1. you need generate the table maintenance using the Menu Utilities->Table maintenance generator

2. give the authorization group, package, function group, overview screen number etc.

3.create the table maintenance

4. now go to se93

5. give custom tcode and say create

then enter description , and then

choose the radio button Transaction with parameters

6. now enter tcode as SM30 and check the check box skip intial screen

7. Check all gui support buttons

8. now go down and enter VIEWNAME from F4 help and value as table name

9. and add UPDATE(choose it from F4) and value as 'X'.

VIEWNAME ZTABLE

UPDATE X

and save it, now check the Tcode.

Regards

Sudheer

[Former Member]

Hi,

First you need to create table maintenance generator for that table. Then create a view for that table and then you can assign a tcode for that view.

TCode can be created using transaction SE93. Use the last option 'Transaction with Parameters). Specify Transaction as SM30 and in the default values give field name as VIEWNAME and value as your DB table name.

Save and activate.

Now you can use this new TCode.

U can follow the below steps

1.SE11.

2.CHOOSE TABLE.

3.UTILITIES--->TABLE MAINT GENERATOR.

4.AUTH GRP : W/O AUTH.

5.FUNCTION GRP: PROJ DEPENDENT (SEE CREATE FUNC GROUP).

6.MAINT TYPE : 2 STEP.

7.MAINT. SCR NO. : CLICK APPL BUTTON | FIND SCR. NUMBER(S) |

8.CHOOSE PROPOSE SCREEN NO FROM POPUP.

9.REMEMBER OVERVIEW SCR NO.

10.CLICK CREATE BUTTON ON APPL TOOL BAR.

11.CLICK SAVE ON FUNC TOOL BAR.

12.GO TO SE93. TO CREATE TRANSACTION CODE.

13.WRITE SUTIABLE TRAN NAME..CLICK CREATE

14.CHOOSE TRANSACTION WITH PARAMETERS(LAST).

15.FILL SHORT TEXT.

16.OK

17.TRANSACTION : SM30.

18.CHECK SKIP INITAL SCREEN CHKBOX

19.SCREEN NO : FROM STEP 9.

20.IN TABLE BELOW

NAME OF SCREEN FIELD VALUE.

VIEWNAME [TABLENAME]

UPDATE X

21.SAVE

22.RUN TRAN CODE IN COMMAND BOX.

After creating the Transaction code, create the BDC for that one

[Former Member]

Thanks gurus