#SPARTAN ITAB IDEAS UPDATE#

Wa_totalcollectoractions-date01 = wa_collectoraction-dat. SELECT SINGLE name1 FROM kna1 INTO wa_totalcollectoractions-name1 Wa_totalcollectoractions-kunnr = wa_collectoraction-kunnr. Wa_totalcollectoractions-bukrs = wa_collectoraction-bukrs. MODIFY it_collectoraction FROM wa_collectoraction. WHERE bukrs = wa_collectoraction-bukrs AND SELECT SINGLE * FROM zcollectoraction INTO CORRESPONDING FIELDS OF wa_collectoraction

LOOP AT it_collectoraction INTO wa_collectoraction. SELECT bukrs kunnr dat MAX( time ) AS timeįROM zcollectoraction INTO CORRESPONDING FIELDS OF TABLE it_collectoraction SELECT-OPTIONS: so_kunnr FOR kna1-kunnr OBLIGATORY,ĬALL FUNCTION 'REUSE_ALV_VARIANT_DEFAULT_GET' PARAMETERS p_bukrs TYPE bukrs OBLIGATORY. PARAMETERS: variant LIKE disvariant-variant. SELECTION-SCREEN BEGIN OF BLOCK bl1 WITH FRAME TITLE text-001. It_totalcollectoractions TYPE TABLE OF ty_totalcollectoractions WITH KEY kunnr.ĭATA: fieldcatalog TYPE slis_t_fieldcat_alv WITH HEADER LINE, Wa_totalcollectoractions TYPE ty_totalcollectoractions, It_collectoraction LIKE TABLE OF zcollectoraction,

TYPES: BEGIN OF ty_totalcollectoractions,ĭATA: wa_collectoraction LIKE zcollectoraction,

#SPARTAN ITAB IDEAS UPDATE#

date12 (Dec), action12.ĭuring loop of itab I want if the itab2 has a record with bukrs and kunnr then it will update date and action according to the month of itab-date, if it do not exist (bukrs, kunnr) then insert a record to itab2. The itab2 with fields bukrs, kunnr, name1 (from kna1),date01 (jan), action01, date02 (Feb), action02. I have itab with fields bukrs, kunnr, date, action. *how to insert in itab2 if fields 1,2 & 3 do not exist or update itab2 if fields 1,2 & 3 exist? I want to do the following Loop at itab into wa_itab.

Spartan itab ideas