Table maintenence

Former Member — Fri, 17 Apr 2009 20:22:18 GMT

Hi !

I have a custom table for which the table maintenence is maintanied. Now I would like to wipe of the coplete data fropm this table so that I can upload it with fresh new data . When I go through SM30 and prints the table name and click maintain , it takes me intio runtime error. I would like to clean up the table for new records to be inserted . How do i go about cleaning the old data in teh table . SM30 is not working for me , it given em runtime error.

 Program............. "SAPLZWELL"
 Screen.............. "SAPLZWELL 0001"
 Screen line......... 6



ormation on where terminated
 Termination occurred in the ABAP program "SAPLZWELL" - in "LISTE_SHOW_LISTE"
 The main program was "SAPMSVMA ".

 In the source code you have the termination point in line 248
 of the (Include) program "LSVIMOXX".



rce Code Extract

e  SourceCde

18       screen-intensified = 1. vim_modify_screen = 'X'.
19     ENDIF.
20     IF vim_special_mode EQ vim_delimit AND
21        screen-name EQ vim_begdate_name.
22       screen-request = 1. vim_modify_screen = 'X'.
23     ENDIF.
24 *   IF X_HEADER-RDONLYFLAG = 'X' AND                      "Subviews ..
25 *      X_HEADER-MAINTVIEW <> X_HEADER-VIEWNAME.
26     IF vim_objfield <> space AND vim_object = x_header-maintview.
27       LOOP AT x_namtab WHERE viewfield = vim_objfield AND
28                           ( texttabfld = space OR keyflag = space ).
    IF x_namtab-readonly = vim_hidden.
      screen-active = '0'. vim_modify_screen = 'X'.
    ELSEIF x_namtab-readonly = rdonly.
      screen-input = '0'. vim_modify_screen = 'X'.
    ENDIF.
    EXIT.
  ENDLOOP.
ENDIF.
ENDIF.                                                  ".. Subviews
IF vim_modify_screen = 'X'.
  MODIFY SCREEN.
ENDIF.
DLOOP.
 vim_special_mode EQ vim_delete.
SET CURSOR FIELD f LINE 1 OFFSET o. "Always just 1 line in TC
DIF.
 status-action EQ kopieren.
neuer = 'N'.
DIF.
ODULE.                    "liste_show_liste OUTPUT

------------------------------------------------------------------*
    MODULE LISTE_INITIALISIEREN OUTPUT                            *
------------------------------------------------------------------*
    ........                                                      *
------------------------------------------------------------------*
LE liste_initialisieren OUTPUT.
 vim_called_by_cluster <> space.                        "SW CTRL ..
PERFORM vim_vcldocking_control.
DIF.                               ".. SW CTRL
atus-mode = list_bild.
tle-mode  = list_bild.

Thanks

Re: Table maintenence

Sandra_Rossi — Fri, 17 Apr 2009 20:40:23 GMT

SE14 transaction. Choose adjust by deleting data to delete all records.

Re: Table maintenence

Former Member — Fri, 17 Apr 2009 20:41:08 GMT

here you have 2 options,

1) Delete the existed table maintenance generator and recreate it again. (Before you delete existed check why it was not working now? did it work previously in prod box?)

2) Since you are planning to delete the entire table & since it is custom table then you can develop small program to delete the data from the table (first discuss with the functional guy).

Re: Table maintenence

Former Member — Fri, 17 Apr 2009 21:28:55 GMT

I have recreated the table maintenence generator and it now the sm30 opens up teh records for one of the table which has 130,882 records but dosent open and goes into another runtime error msg saying the size of the file is larger than the permitted internal table size.

This table has 700,675 records. Is it due to teh isze of the data records that this table dosnet open in sm30?

topic Table maintenence in Application Development and Automation Discussions

Table maintenence

Re: Table maintenence

Re: Table maintenence

Re: Table maintenence