small issue in dialog program

Can you not delete all items and insert the ones that you have in your bespoke transaction.

Hi suchitra,

do one thing ,,

-

first task

1.first of all select all the contents of ztable based on primary keys into a internal table itab.

1 m1 pqr 12

2 m2 def 9

3 m3 abc 2

4 m4 xyz 1

2. in ur m-pool table control u r performing the operations like delete and modify to the table control GET THE CONTENTS INTO UR FINAL TABLE JTAB ..Lets say

This is ur final jtab.

1 m1 pqr 12

2 m2 def 19

4 m4 xyz 1

NOW PERFORM COMPARISIONS,

3. LOOP AT ITAB.

READ TABLE JTAB WITH KEY ITEMNO = ITAB-ITEMNO

AND MATNR = JTAB-MATNR

And menge = jtab -menge

IF SY-SUBRC <> 0.

ITAB-ITEMNO = JTAB-ITEMNO.

ITAB_MATNR = JTAB-MATNR.

ITAB_MATDESC = JTAB_MATDESC

ITAB_MENGE = JTAB_MENGE

MODIFY ITAB. ”TRANSPORTING

ENDIF.

ENDLOOP.

• THIS WILL COVER RECORD 2 IN UR ITAB CHANGES ARE OK ..

-

second task ..

4. NOW SINCE U HAVE DELETED RECORD 3 ,, PLACE IN AN EXTRA FILED IN THE JTAB STRUCTURE

LIKE CHAR TYPE C, SAME HAS TO BE IN ITAB ALSO

AND MAKE IT X WHEN EVER U DELETE IT IN TABLE CONTROL

LIKE THIS THE O/P IM EXPECTING HERE IS IN JTAB

1 m1 pqr 12

2 m2 def 19

3 m3 abc 2 x

4 m4 xyz 1

LOOP AT ITAB.

READ TABLE JTAB WITH KEY ITEMNO = ITAB-ITEMNO

AND MATNR = JTAB-MATNR

IF JTAB-CHAR = ‘X’.

ITAB-ITEMNO = JTAB-ITEMNO.

ITAB_MATNR = JTAB-MATNR.

ITAB_MATDESC = JTAB_MATDESC

ITAB_MENGE = JTAB_MENGE

ITAB-CHAR = JTAB-CHAR

MODIFY ITAB. ”TRANSPORTING

ENDIF.

ENDLOOP.

NOW THE ITAB CONTENT IS

1 m1 pqr 12

2 m2 def 19

3 m3 abc 2 x

4 m4 xyz 1

My suggestion to u is modify the ztable from itab .

Without deleting entry 3

This will solve ur prob .

Cause when u do a select next time

Select entries where char <> ‘X’

Which will fetch u

1 m1 pqr 12

2 m2 def 19

4 m4 xyz 1

Try to bring the logic in a single loop this will do

i have split this for ur understanding ....

Hi suchitra,

like with ref to prev reply ,

u r logic was bringing the deletion / modification of the ztable in a single shot ..

now u r trying to do two things at a single time ,,

delete the entry ,,

modify the item so a compaq logic has to be drawn to get this thing done ..

THOGHT I NEED ONLY THESE DATA TO BE PRESENT IN MY ZTABLE

1 m1 pqr 12

2 m2 def 19

3 m4 xyz 1

but actually the correct one is

u need to get this ..

1 m1 pqr 12

2 m2 def 19

4 m4 xyz 1

right.

so its always a good practice to mark the deleted records with a indicator which will be easy .

just try to get the content of the table control and check go with the logic.

one advice from some one was delete the whole z table and insert it .. even that will work but what if the table contents are say 1000+ and u are changing only 2 records for this i need to delete and again insert back the whole stuff ..

regards,

Vijay

Suchitra,

The simplest way is to try and follow the below logic.

As you said that you have header and item tables...and surely the two have a common field. So once you have the modified data in ur table control (one deleted and other modified as in your example).

logic for update_item_table.

1. delete the records from ztable(details) for the particular header key.

2. insert the records from control to ztable(details).

U would get the required result.

Hi,

Both deletion and updation could not be done together.

There should be minimal database hits.

1.Keep the deleted records of the item table in a temporary table and delete those records from the main item table.

2.Update the main item table with the changed values.

3.Delete the datarecords from the DB table using the temporary internal table.

4.modify the records in in DB table using the modified main itab.

Hope this will solve your issue

cheers