HOW TO INSERT DATA INTO STANDARD TABLE

[Former Member]

Hi all,

Can you tell me how i can insert data into std. table T006 through a report.

<removed_by_moderator>

Thanks In Advance

Raj Guru

Edited by: Julius Bussche on Aug 29, 2008 11:59 AM

[Former Member]

HI ,

use update statement . Update t006 from table i_t006.

[Former Member]

thank you but the table is not getting updated.

[Former Member]

V_T006D                          Dimensions for units of measure
V_T006E                          System for Units of Measurement
V_T006_EXP                       View for T006 with Selection Dimension Exponent
V_T006_L                         View for Determination of Units of Measurement for LENGTH
V_T006_T                         View for Determination of Units of Measurement for Time

There are so many maintenance views on the table. you can do this way if you want to do it programatically..

But Don't update Directly .

REPORT  ZTEST_MAINTAIN.
 
parameters: p_view(30) typ c default 'V_T006_T'.
 
call function 'VIEW_MAINTENANCE_CALL'
         exporting
              action                       = 'S'          "Display " U for update
              view_name                    = p_view
         exceptions
              client_reference             = 1
              foreign_lock                 = 2
              invalid_action               = 3
              no_clientindependent_auth    = 4
              no_database_function         = 5
              no_editor_function           = 6
              no_show_auth                 = 7
              no_tvdir_entry               = 8
              no_upd_auth                  = 9
              only_show_allowed            = 10
              system_failure               = 11
              unknown_field_in_dba_sellist = 12
              view_not_found               = 13
              others                       = 14.
    if sy-subrc  0.
 
    endif.

[Former Member]

HI,

After using update command please use commit statement. The data will be commited to your database table.

[Former Member]

Hi Raj,

Use the following statement :

MODIFY ztable FROM TABLE it_table.

but, if you want to fill the values from a work area then use the following :

MODIFY ztable FROM wa_table.

where ztable -> is a table in the database

it_table -> internal table,

wa_table -> work area

Regards,

Asha

[Former Member]

Hi Raj,

Use the following statement :

Insert ztable from table it_Table (Internal table).

but, if you want to fill the values from a work area then use the following :

Insert ztable from wa_Table (Work Area).

Insert command inserts the new data in database table.

While to modify the row whic is available in the database table, Use modify statement based on the key fields.

MODIFY ztable FROM TABLE it_table (Internal table).

but, if you want to fill the values from a work area then use the following :

MODIFY ztable FROM wa_table (Work Area).

Regards,

Abdur

[Former Member]

Hi,

Use Modify statement but remember one thing the internal table or work area from which you are inserting the data into the standard table must consists of all the primary key fields that are present in the standard table