2010 Jan 12 10:05 PM
Hello Experts,
Iu2019ve trying to write a code to fetch data in my program and create a file on server. My program work fine. However every time I run my program it append data at the end of the tile which it created 1st time. I donu2019t want this to happen. I want to new record to print on this file or in other words I want it to over write the file. Here is my code of dataset part.
-
open dataset file for appending in text mode encoding default.
if sy-subrc ne 0.
write:/ 'File Opening/Creation Error'.
exit.
endif.
loop at ivbrk.
clear record.
move ivbrk-headr to record+1(1).
move ivbrk-vbeln to record+3(10).
move ivbrk-waerk to record+15(5).
move ivbrk-knumv to record+22(10).
move ivbrk-fkdat to record+34(8).
move ivbrk-kunrg to record+43(10).
move ivbrk-kunag to record+54(10).
transfer record to file.
loop at ivbrp where vbeln = ivbrp-vbeln.
clear items.
move ivbrp-items to items+1(1).
move ivbrp-posnr to items+3(6).
move ivbrp-fkimg to items+11(13).
move ivbrp-vrkme to items+25(3).
move ivbrp-meins to items+30(3).
move ivbrp-ntgew to items+34(15).
move ivbrp-brgew to items+50(15).
move ivbrp-gewei to items+66(3).
transfer items to file.
endloop.
endloop.
close dataset file.-
Can please somebody tell me what change I should make to over write on this file?
Thanks a lot in advance.
Moderator message - Please use code tags around your code
Edited by: Rob Burbank on Jan 12, 2010 5:08 PM
2010 Jan 12 10:54 PM
Try using this:
open dataset file for output in text mode encoding default.
Hello Experts,
Iu2019ve trying to write a code to fetch data in my program and create a file on server. My program work fine. However every time I run my program it append data at the end of the tile which it created 1st time. I donu2019t want this to happen. I want to new record to print on this file or in other words I want it to over write the file. Here is my code of dataset part.
-
open dataset file for appending in text mode encoding default.
if sy-subrc ne 0.
write:/ 'File Opening/Creation Error'.
exit.
endif.
loop at ivbrk.
clear record.
move ivbrk-headr to record+1(1).
move ivbrk-vbeln to record+3(10).
move ivbrk-waerk to record+15(5).
move ivbrk-knumv to record+22(10).
move ivbrk-fkdat to record+34(8).
move ivbrk-kunrg to record+43(10).
move ivbrk-kunag to record+54(10).
transfer record to file.
loop at ivbrp where vbeln = ivbrp-vbeln.
clear items.
move ivbrp-items to items+1(1).
move ivbrp-posnr to items+3(6).
move ivbrp-fkimg to items+11(13).
move ivbrp-vrkme to items+25(3).
move ivbrp-meins to items+30(3).
move ivbrp-ntgew to items+34(15).
move ivbrp-brgew to items+50(15).
move ivbrp-gewei to items+66(3).
transfer items to file.
endloop.
endloop.
close dataset file.-
Can please somebody tell me what change I should make to over write on this file?
Thanks a lot in advance.
Moderator message - Please use code tags around your code
Edited by: Rob Burbank on Jan 12, 2010 5:08 PM
2010 Jan 12 10:08 PM
Hey zero:
open dataset file for appending in text mode encoding default.Probably because you're opening it for appending.
Rob
2010 Jan 12 10:54 PM
Try using this:
open dataset file for output in text mode encoding default.