topic Re: Data Writing to Application server in Application Development and Automation Discussions

Data Writing to Application server

Former Member — Tue, 07 Jul 2009 11:00:38 GMT

Hi,

I am Uploading 108 fields of data to application server file

Below ZFI_PAYMENT is the table which contains 108 fields of data

Please check my code

TYPES: ty_file TYPE zfi_payment.

DATA: wa_file TYPE ty_file.

DATA: it_file TYPE STANDARD TABLE OF ty_file.

FIELD-SYMBOLS: <f1> TYPE ANY,

<f2> TYPE ANY.

TYPES: BEGIN OF ty_data,

data type string,

END OF ty_data.

DATA: wa_data TYPE ty_data,

it_data TYPE STANDARD TABLE OF ty_data.

DATA: v_pay_amount(23).

DATA: as_file TYPE file VALUE '/usr/sap/RD2/DVEBMGS20/work/fi_test2'.

select * from zfi_payment into table it_file.

open dataset as_file for output in text mode encoding default.

LOOP AT it_file INTO wa_file.

DO.

ASSIGN COMPONENT sy-index OF STRUCTURE wa_file TO <f1>.

IF sy-subrc <> 0.

EXIT.

ENDIF.

IF sy-index = 5.

MOVE wa_file-pay_amount TO v_pay_amount.

CONCATENATE wa_data-data v_pay_amount '@' INTO wa_data-data.

ELSE.

CONCATENATE wa_data-data <f1> '@' INTO wa_data-data.

ENDIF.

ENDDO.

move wa_data-data to wa_data1.

TRANSFER WA_DATA-DATA TO AS_FILE.

APPEND wa_data TO it_data.

CLEAR: WA_DATA,V_PAY_AMOUNT,WA_FILE,wa_data1.

ENDLOOP.

close dataset as_file.

Here i am getting all 108 fileds of data into IT_DATA. (in debugging i seen that)

But the only 68 fields of data is writing to the appl server.

there is no problem in ztable and internal tables. data is coming properly to wa_data and it_data also.

Please Give me reply

Regards

sri

Re: Data Writing to Application server

Former Member — Tue, 07 Jul 2009 11:10:25 GMT

Hi,

I guess, Now you are viewing only the first 68 fields on the application server. If yes, that is because of the restriction on the size and length can be viewed on application server.

Try downloading directly from here.

I guess, again using the OPEN DATASET and reading the file, it will retrieve all the data completely, i.e. only for viewing purpose, you can view the complete data.

Regards,

Nangunoori.

Re: Data Writing to Application server

kesavadas_thekkillath — Tue, 07 Jul 2009 11:12:28 GMT

try with cg3z

Re: Data Writing to Application server

Former Member — Tue, 07 Jul 2009 11:17:05 GMT

Hi,

download file from application server to presentation server and check if all fields are being downloaded. Use transaction code CG3Y to download from app server to presentation server.

Regards,

Sachin

Re: Data Writing to Application server

Former Member — Tue, 07 Jul 2009 11:20:14 GMT

Hi santosh,

thanks for your message

the remaining fields data is not appearing on the application server

so if i use again read statemnet how the data will come

Regards

sri

Re: Data Writing to Application server

Former Member — Tue, 07 Jul 2009 11:26:01 GMT

If the data in the application server is incomplete when you view it, it doesn't mean that it really is. SAP screen is limitted and therefore only displays a limited number of characters. Just continue with whatever you want to do with the data and you will see that they are complete. (This is of course assuming that you have no problem with the logic)