Skip to Content
0
Former Member
May 14, 2010 at 05:02 AM

Incorrect update while loop- endloop in ZTABLE "zle_lagerplanung"

42 Views

Hi All,

Database table "zle_lagerplanung" is updating with the last record only.

Here is my code:

TABLES:  zle_lagerplanung.    "Storage bin plan

Data : BEGIN OF gw_zle_lagerplanung occurs 0,
           SEl,                               "stores which row user has selected
           aufnr TYPE zle_lagerplanung-aufnr,
           runnr TYPE zle_lagerplanung-runnr,
           kdauf TYPE zle_lagerplanung-kdauf,
           kdpos TYPE zle_lagerplanung-kdpos,
           etenr TYPE zle_lagerplanung-etenr,
           prio  TYPE zle_lagerplanung-prio,
           auart TYPE zle_lagerplanung-auart,
           werk TYPE zle_lagerplanung-werk,
           lgtyp TYPE zle_lagerplanung-lgtyp,
           art TYPE zle_lagerplanung-art,
           anzle TYPE zle_lagerplanung-anzle,
           lgpla TYPE zle_lagerplanung-lgpla,
           papiermaschine TYPE zle_lagerplanung-papiermaschine,
           breite TYPE zle_lagerplanung-breite,
           durchmesser TYPE zle_lagerplanung-durchmesser,
           fa TYPE zle_lagerplanung-fa,
           anzhoehe TYPE zle_lagerplanung-anzle,
END OF gw_zle_lagerplanung.

data : begin of gt_update OCCURS 0,
           text(30),
       end of gt_update.
*----------------------------------------------------------------------*
*  Internal table declaration.
*----------------------------------------------------------------------*
DATA : gt_zle_lagerplanung Like STANDARD TABLE OF gw_zle_lagerplanung.

This is the select query
  SELECT runnr kdauf kdpos etenr prio werk lgtyp art anzle lgpla papiermaschine
         breite durchmesser fa anzhoehe
    FROM zle_lagerplanung INTO CORRESPONDING FIELDS OF TABLE gt_zle_lagerplanung
   WHERE kdauf IN s_kdauf
     AND KDPOS IN s_kdpos
     AND werk = p_werks.

here is the update statement while press the save button

case r_ucomm.
   When '&DATA_SAVE'           "user press Save 
     loop at gt_zle_lagerplanung into gw_zle_lagerplanung.
         move gw_zle_lagerplanung-fa to gt_update-Text.
           APPEND gt_update to gt_update.
          update zle_lagerplanung." set FA = gt_update.
          commit work.
    endloop.
endcase.

The three values in gt_zle_lagerplanung-fa fields are "

TEST 123

ABC 123

XYZ 123.

But FA field in Ztable "zle_lagerplanung" updating with the last values = XYZ 123 for all three records.

I guess there is incorrect update statement in the loop - endloop.

Thanks in Advance.