getting synatax error "The WA 'gt_qmel 'is n't long enough''

[Former Member]

Hi,

this program i am writting for one time execution to update the date field. in standard table qmel.But i am getting the synatx error

""The WA 'gt_qmel 'is n't long enough' ""

REPORT Z_PMD.

Tables:qmel.

Types:begin of ty_qmel,

erdat type erdat,

aedat type aedat,

end of ty_qmel.

data:gt_qmel type standard table of ty_qmel,

gs_qmel like line of gt_qmel.

select erdat aedat from

qmel

into table gt_qmel .

loop at gt_qmel into gs_qmel.

if gs_qmel-erdat ne gs_qmel-aedat.

gs_qmel-aedat = gs_qmel-erdat.

modify qmel from table gt_qmel .

clear gs_qmel.

endif.

endloop.

[MaryM]

Hi,

try:

select erdat aedat from

qmel

into correspondind fields of table gt_qmel .

Regards,

MaryM

[kesavadas_thekkillath]

modify qmel from table gt_qmel .

gt_qmel must hold the same structure of table qmel.

I dont see any key fields in your internal table too , QMNUM must be included.

[Former Member]

Hi,

I did all the changes now i am getting sy-subrc = 4.

date field value not changing as per my logic.

please help

[kesavadas_thekkillath]

Post your changed code .

[Former Member]

Hi,

Thanks ...

This is my code

Tables:qmel.

Types:begin of ty_qmel,

qmnum type qmnum,

erdat type erdat,

aedat type aedat,

end of ty_qmel.

data:gt_qmel type standard table of qmel,

gt_qmel1 type standard table of qmel,

gs_qmel like line of gt_qmel.

select qmnum erdat aedat from

qmel

into corresponding fields of table gt_qmel .

loop at gt_qmel into gs_qmel.

if gs_qmel-erdat ne gs_qmel-aedat.

gs_qmel-aedat = gs_qmel-erdat.

append gs_qmel to gt_qmel1.

modify qmel from table gt_qmel1.

clear gs_qmel.

endif.

endloop.

[kesavadas_thekkillath]

Hi try this

 data:gt_qmel type standard table of qmel.
 field-symbols:<fs> type qmel.
  select * from qmel
              into corresponding fields of  table gt_qmel
              where qmel~erdat ne qmel~aedat.
  if gt_qmel[] is not initial.
   loop at gt_qmel assigning <fs>.
    <fs>-aedat = <fs>-erdat.
   endloop.
   modify qmel from table gt_qmel[].
endif.

Debug and proceed further

[Former Member]

Hi,

I did all the changes now i am getting sy-subrc = 4.

date field value not changing as per my logic.

please help

[Former Member]

modify qmel from table gt_qmel[].

I refuse to help people who update an SAP database table; esp.those who are not that experienced,