05-19-2010 3:49 PM
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.
05-19-2010 3:55 PM
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.
05-19-2010 3:52 PM
Hi,
try:
select erdat aedat from
qmel
into correspondind fields of table gt_qmel .
Regards,
MaryM
05-19-2010 3:55 PM
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.
05-19-2010 4:11 PM
Hi,
I did all the changes now i am getting sy-subrc = 4.
date field value not changing as per my logic.
please help
05-19-2010 4:13 PM
05-19-2010 4:20 PM
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.
05-19-2010 4:48 PM
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
02-07-2011 2:19 PM
Hi,
I did all the changes now i am getting sy-subrc = 4.
date field value not changing as per my logic.
please help
02-07-2011 2:27 PM
modify qmel from table gt_qmel[].
I refuse to help people who update an SAP database table; esp.those who are not that experienced,