topic Re: Manipulate data in dynamic table in Application Development and Automation Discussions

Manipulate data in dynamic table

former_member382644 — Mon, 22 May 2006 08:32:10 GMT

Hi,

How can I modify/delete data in a dyanmic table ?

i have created the <dytable>.

Can i read it with conditions ? like :

read table <dytable> with key field1 = 'abc'.

if i use loop & assign, it is too slow.

loop at <dytable> assigning <dytable_line>.

assigning component 'FIELD' to <fs>.

if <fs> = 'abc'

Thanks

Wilson

Re: Manipulate data in dynamic table

Former Member — Mon, 22 May 2006 08:34:45 GMT

check the thread..

Re: Manipulate data in dynamic table

Former Member — Mon, 22 May 2006 08:42:07 GMT

Hai Wilson

Variables for later use

DATA: TABLENAME(10),

COUNT_ROWS TYPE I.

Setting the table name dynamically

MOVE 'CUSTOMERS' TO TABLENAME.

Selecting data

SELECT COUNT( * ) FROM (TABLENAME) INTO COUNT_ROWS.

WRITE: TABLENAME, COUNT_ROWS.

Parameters for reading a single line, can be modified by the end user

PARAMETERS: KEY1(10) DEFAULT 'NAME',

VALUE1(25),

KEY2 LIKE KEY1 DEFAULT 'ID',

VALUE2 LIKE VALUE1.

Declarations for later use

TABLES CUSTOMERS.

DATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100

WITH HEADER LINE.

Filling the internal table

SELECT * FROM CUSTOMERS INTO TABLE ALL_CUSTOMERS.

Dynamic read table command

READ TABLE ALL_CUSTOMERS

WITH KEY (KEY1) = VALUE1

(KEY2) = VALUE2.

Displaying the result

IF SY-SUBRC EQ 0.

WRITE: / ALL_CUSTOMERS-ID,

ALL_CUSTOMERS-NAME,

ALL_CUSTOMERS-CITY,

ALL_CUSTOMERS-TELEPHONE.

ELSE.

WRITE 'Entry not found'.

ENDIF.

Thanks & regards

Sreeni

Re: Manipulate data in dynamic table

former_member382644 — Mon, 22 May 2006 09:16:08 GMT

Hello,

I am using field-symbols, not dynamic statement.

And i don't want to use loop at assign because it is slow for me.

Thanks

Wilson

Re: Manipulate data in dynamic table

Former Member — Mon, 22 May 2006 09:28:04 GMT

I don't believe you can do it, because the system can know the fields only at run-time, so you'll get an error while actving or generating your report.

You can have some chance if the field-symbol is directly linked to a structure:

TYPES: BEGIN OF LT_ITAB,

FIELD1.....,

FIELD2.....,

END OF LT_ITAB.

TYPES: GT_ITAB TYPE STANDARD TABLE OF LT_ITAB.

FIELD-SYMBOLS: <FS_ITAB> TYPE GT_ITAB,

<WA> TYPE ANY.

READ TABLE <FS_ITAB> INTO <WA> WITH KEY FIELD1 = 'XXXX'.

Max

Re: Manipulate data in dynamic table

Former Member — Mon, 22 May 2006 09:30:34 GMT

You cannot read the table using the standard read statement. But if you want to delete the rows from the dynamic table use the statement delete itab index sy-tabix.

Re: Manipulate data in dynamic table

former_member382644 — Mon, 22 May 2006 09:33:26 GMT

Any method for searching the dynamic table ?

Re: Manipulate data in dynamic table

Former Member — Mon, 22 May 2006 09:36:19 GMT

i am not aware of any other searching technique for a dynamic table without using the loop and assigning technique