topic Re: LIST in Application Development and Automation Discussions

LIST

Former Member — Wed, 06 Jun 2007 11:45:43 GMT

HAI,

AFTER MODIFYING VALUES IN THE BASIC OR INTERACTIVE LIST HOE CAN I UPDATE THAT VALUE IN DATABASE TABLE

THANK YOU

ASHOK KUMAR

Re: LIST

Former Member — Wed, 06 Jun 2007 11:49:16 GMT

hi ashok,

use update keyword to update database table.

ex: UPDATE <data base table> FROM TABLE <itab>.

then write commitwork.

reward points if helpful.

regards,

seshu.

Re: LIST

Former Member — Wed, 06 Jun 2007 11:49:22 GMT

Declare an Internal table similar to the Database table which you wants to update

Move all the values/data from your interactive list to this Internal table .

then using this Internal tables update the database table using the command INSERT or Update.

see the doc

INSERT

... { {VALUES wa}

| {FROM wa|{TABLE itab [ACCEPTING DUPLICATE KEYS]}} }.

1. ... {VALUES wa} | {FROM wa} ...

2. ... FROM TABLE itab [ACCEPTING DUPLICATE KEYS] ...

After FROM and VALUES, you can specify a non-table-type data object wa. After FROM, you can also specify an internal table itab. The contents of the row(s) to be inserted are taken from these data objects

UPDATE

... { {SET set_expression [WHERE sql_cond]}

| {FROM wa|{TABLE itab}} }.

1. ... SET set_expression [WHERE sql_cond]

2. ... FROM wa

3. ... FROM TABLE itab

The specifications in source define which rows and columns are changed. Either individual columns are changed using the addition SET or entire rows are overwritten using the addition FROM.

After FROM, either a non-table-type data object wa or an internal table itab can be specified. The content of these objects determines - on the one hand - which row(s) is/are changed, and - on the other hand - which values are used to overwrite the row(s).

Reward points for useful Answers

Regards

Anji

Re: LIST

Former Member — Wed, 06 Jun 2007 11:49:24 GMT

Hi,

Read the Partciular line using the READ Statement and pass that value to the Z table.

Reward points if it is helpful.

Regards,

Sangeetha.A

Re: LIST

Former Member — Wed, 06 Jun 2007 12:04:47 GMT

hi,

update statement is used for updating database tables.

UPDATE <data base table> FROM TABLE <itab>.

ex: UPDATE mara from table it_mara.

if helpful reward some points.

with regards,

suresh.

Re: LIST

Former Member — Wed, 06 Jun 2007 12:05:08 GMT

hai,

HOW CAN I MOVE DATA FROM LIST TO INTERNAL TABLE.

IS IT USING READ SATEMENT OR SOME THING ELSE

THANK YOU

ASHOK

Re: LIST

Former Member — Wed, 06 Jun 2007 12:10:07 GMT

You will be displaying the interactive List by using a Internal Table.

so move the values of that Internal table to this new Internal table (ITAB) which is like the database table.

and now Insert the data to DB TABLE from this ITAB.

Reward points for useful Answers

Regards

Anji

Re: LIST

Former Member — Wed, 06 Jun 2007 12:24:12 GMT

HAI,

THAT INTERNAL TABLE DO NOT HAVE UPLOADED OR ENTERED DATA FROM LIST. IT HAS ONLY OLD DATAB . SO HOW CAN READ

THANK YOU

ASHOK KUMAR