topic Re: how to write data to table in Application Development and Automation Discussions

how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 13:03:41 GMT

I don't write data to table . And the table is created by me .Can you help me ?

The code is following:

  LOOP AT lt_dz INTO wa_dz.    
SELECT SINGLE maktx INTO wa_dz-maktx
      FROM makt WHERE matnr = wa_dz-matnr AND spras = sy-langu.
    SHIFT wa_dz-matnr LEFT DELETING LEADING '0'.
    "IF sy-tcode = 'ZRMM009' AND wa_h-zbsat = 'C'.
     "wa_dz-ssmng = wa_dz-bdmng.
 IF  wa_h-zbsat = 'S'.
      CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
        EXPORTING
          input  = wa_dz-ssmng
        IMPORTING
          output = wa_dz-ssmng.
    UPDATE ztpsmx SET SSMNG = wa_dz-ssmng " I only write data to table by it.
          WHERE zpsdh = l_zpsdh AND zgwei = wa_dz-zgwei AND matnr = wa_dz-matnr.
    ENDIF.
    MODIFY lt_dz FROM wa_dz TRANSPORTING matnr maktx ssmng.
  ENDLOOP.

Re: how to write data to table

Sandra_Rossi — Mon, 10 Aug 2020 13:06:30 GMT

What did you conclude from your debug?

Re: how to write data to table

Sandra_Rossi — Mon, 10 Aug 2020 13:09:00 GMT

By the way, not related to your question, but SSMNG is a numeric field, it's incorrect to use CONVERSION_EXIT_ALPHA_INPUT.

Re: how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 13:11:10 GMT

To Sandra

I don't write data to table by program.

Re: how to write data to table

Abinathsiva — Mon, 10 Aug 2020 13:38:19 GMT

Hi 1190_5939_439

Check the MATNR data in Ztable

 LOOP AT lt_dz INTO wa_dz.    
SELECT SINGLE maktx INTO wa_dz-maktx
      FROM makt WHERE matnr = wa_dz-matnr AND spras = sy-langu.

    SHIFT wa_dz-matnr LEFT DELETING LEADING '0'. "Check this how it's captured in ZTable.

 IF  wa_h-zbsat = 'S'.
    UPDATE ztpsmx SET SSMNG = wa_dz-ssmng 
       WHERE zpsdh = l_zpsdh AND zgwei = wa_dz-zgwei AND matnr = wa_dz-matnr.
 ENDIF.
    MODIFY lt_dz FROM wa_dz TRANSPORTING matnr maktx ssmng.
  ENDLOOP.

Re: how to write data to table

Sandra_Rossi — Mon, 10 Aug 2020 13:50:18 GMT

Please use the COMMENT button for comments, questions, adding details, replying to OP comment, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

If you want to target someone, if this person has posted an Answer, use the button COMMENT, if this person is the Original Poster of the question he/she will be automatically informed, otherwise copy/paste their hyperlinked name so that the person receives a warning (NB: @ doesn't work/but typing this character will suggest hyperlinked names).

Re: how to write data to table

Sandra_Rossi — Mon, 10 Aug 2020 13:53:16 GMT

If the UPDATE sets sy-subrc <> 0, no data is updated because there is no line corresponding to the WHERE condition. To know why the column values of ZTPSMX don't correspond to the values in the WHERE condition, write a temporary program with a SELECT and change the WHERE condition until a line is found, and you'll understand your error.

Re: how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 14:08:23 GMT

Thanks. I understand how to add comment.

Re: how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 14:21:21 GMT

Hi abishankar

Can you tell me how to check the MATNR data in Ztable? when I delete "SHIFT wa_dz-matnr LEFTDELETINGLEADING'0'". the result is the same. I don't understand the code.

Re: how to write data to table

Abinathsiva — Mon, 10 Aug 2020 14:24:56 GMT

Hi, Directly try by

Modify Ztable from table internaltable.

Re: how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 14:27:14 GMT

When I write a temporary program. And I give var to value. In the ztable , SSMNG is chaged. The code is following :

REPORT ZJGLTEST.
DATA:l_zpsdh     LIKE ztpsmx-zpsdh,               
     wa_h        LIKE ztpsmx,
     l_bldat     LIKE mkpf-bldat,                 
     l_budat     LIKE mkpf-budat,                 
     l_lgfse     LIKE t001l-lgobe,                
     l_lgobe     LIKE t001l-lgobe,                
     l_name2     LIKE t001w-name1,                
     l_zbsat(12).
DATA: BEGIN OF lt_dz OCCURS 0.
        INCLUDE STRUCTURE ztpsmx.
DATA:   maktx    LIKE makt-maktx,
        posar(1),
        END OF lt_dz.
DATA:wa_dz LIKE lt_dz.
DATA: MAT_DOC TYPE MBLNR,
      mat_gjahr TYPE gjahr.

UPDATE ztpsmx SET SSMNG = '1'
 WHERE  zpsdh = 'PE2008100008' AND zgwei = 'UB40' AND matnr = '85101200FNAA2000'.

Re: how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 14:37:09 GMT

Is it right ?

 LOOP AT lt_dz INTO wa_dz.
    SELECT SINGLE maktx INTO wa_dz-maktx
      FROM makt WHERE matnr = wa_dz-matnr AND spras = sy-langu.
  "  SHIFT wa_dz-matnr LEFT DELETING LEADING '0'.
    "IF sy-tcode = 'ZRMM009' AND wa_h-zbsat = 'C'.
     "wa_dz-ssmng = wa_dz-bdmng.
   IF  wa_h-zbsat = 'S'.
     MODIFY ztpsmx  from lt_dz.   " I add it .
    "UPDATE ztpsmx SET SSMNG = wa_dz-ssmng "zeile = l_zeile
        "  WHERE zpsdh = l_zpsdh AND zgwei = wa_dz-zgwei AND matnr = wa_dz-matnr.
    ENDIF.
    MODIFY lt_dz FROM wa_dz TRANSPORTING matnr maktx ssmng.
  ENDLOOP.

Re: how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 14:40:56 GMT

the data is NOT still written in the ztable.

Re: how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 14:44:24 GMT

HI sandra.rossi

what is the" line corresponding"?

Re: how to write data to table

1190_5939_439 — Mon, 10 Aug 2020 15:00:51 GMT

HI sandra.rossi

Thanks. I will do it as what you said.

Re: how to write data to table

Sandra_Rossi — Mon, 10 Aug 2020 15:09:30 GMT

For instance, write a temporary program with this kind of SELECT to understand why no line is found by doing a wider search (test SY-DBCNT or SY-SUBRC at each SELECT to know if something is found or not):

DATA itab TYPE TABLE OF ztpsmx.
SELECT * FROM ztpsmx WHERE zpsdh = 'PE2008100008' AND zgwei = 'UB40' AND matnr = '85101200FNAA2000' INTO TABLE itab.
SELECT COUNT(*) FROM ztpsmx WHERE zpsdh = 'PE2008100008' INTO TABLE itab.
SELECT COUNT(*) FROM ztpsmx WHERE zpsdh = 'PE2008100008' AND zgwei = 'UB40' INTO TABLE itab.
SELECT COUNT(*) FROM ztpsmx WHERE matnr = '85101200FNAA2000' INTO TABLE itab.
SELECT COUNT(*) FROM ztpsmx WHERE matnr LIKE '85101200F%' INTO TABLE itab.
SELECT COUNT(*) FROM ztpsmx WHERE matnr LIKE '%85101200F%' INTO TABLE itab.

etc.

Re: how to write data to table

1190_5939_439 — Tue, 11 Aug 2020 00:57:09 GMT

The error is here when I use your code and change your code.

Re: how to write data to table

1190_5939_439 — Tue, 11 Aug 2020 06:36:59 GMT

I find the answer. I put the code in error position.

LOOP AT lt_dz INTO wa_dz WHERE ssmng > 0 AND zuart = 'PE'.
      CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
        EXPORTING
          input  = wa_dz-matnr
        IMPORTING
          output = wa_dz-matnr.


      gmitem-material = wa_dz-matnr.
      gmitem-plant    = wa_dz-werks.              "工厂
      gmitem-stge_loc = wa_dz-lgfsb.              "发出库存地
      gmitem-move_type  = '411'.                  "移动类型


      gmitem-move_plant = wa_dz-werks.
      gmitem-move_stloc = wa_dz-lgort.            "接收库存地
      gmitem-entry_qnt  = wa_dz-ssmng.            "实收数量
         UPDATE ztpsmx SET  SSMNG = wa_dz-ssmng                           WHERE zpsdh = l_zpsdh AND zgwei = wa_dz-zgwei AND matnr = wa_dz-matnr." I put it  here.
      CONCATENATE wa_dz-zbanz '/' wa_dz-zgwei INTO gmitem-item_text.      "班组/工位
      APPEND gmitem.
      CLEAR gmitem.
*序列号
      IF wa_dz-zzvin IS NOT INITIAL.
        gmserial-matdoc_itm = l_zeile.
        gmserial-serialno   = wa_dz-zzvin.
        APPEND gmserial.
        l_zeile = l_zeile + 1.
      ENDIF.
*
    ENDLOOP.