topic Re: HOW TO INSERT DATA INTO STANDARD TABLE in Application Development and Automation Discussions

HOW TO INSERT DATA INTO STANDARD TABLE

Former Member — Fri, 29 Aug 2008 09:43:41 GMT

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

Re: HOW TO INSERT DATA INTO STANDARD TABLE

Former Member — Fri, 29 Aug 2008 09:46:10 GMT

HI ,

use update statement . Update t006 from table i_t006.

Re: HOW TO INSERT DATA INTO STANDARD TABLE

Former Member — Fri, 29 Aug 2008 09:59:24 GMT

thank you but the table is not getting updated.

Re: HOW TO INSERT DATA INTO STANDARD TABLE

Former Member — Fri, 29 Aug 2008 10:01:11 GMT

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.

Re: HOW TO INSERT DATA INTO STANDARD TABLE

Former Member — Fri, 29 Aug 2008 12:05:48 GMT

HI,

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

Re: HOW TO INSERT DATA INTO STANDARD TABLE

Former Member — Tue, 02 Sep 2008 04:50:43 GMT

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

Re: HOW TO INSERT DATA INTO STANDARD TABLE

Former Member — Thu, 04 Sep 2008 05:15:24 GMT

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

Re: HOW TO INSERT DATA INTO STANDARD TABLE

Former Member — Thu, 04 Sep 2008 08:27:11 GMT

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