topic Re: Problem with data file written on application server thru datasets in Application Development and Automation Discussions

Problem with data file written on application server thru datasets

Former Member — Fri, 04 May 2007 11:18:06 GMT

Hi,

Through datasets operation am writing the contents of itab on application server.

But fields which are of type quantity, currency & type P with decimals are coming as some junk value with '#' and all, when checked on application server thorugh transaction al11. Other field values are coming properly.

Values are very well correct in itab. Also when same itab is downloaded on local machine the values are coming correctly.

Can anybody help me out.

regards

Re: Problem with data file written on application server thru datasets

Former Member — Fri, 04 May 2007 11:23:41 GMT

Hi,

For currency, Decimal fields you need to move data into CHAR fields and then transfer to application server.

MOVE l_CURRENCY TO L_CHAR_CURRENCY.

CONCATENATE field1

field2

l_currency

into l_file.

Transfer l_file........

Best regards,

Prashant

Re: Problem with data file written on application server thru datasets

Former Member — Fri, 04 May 2007 11:27:57 GMT

Hi,

You cannot use data types F, I,P, or X. Instead, transfer the data into Character fields and pass it to TRANSFER command. This will solve your issue.

Regards,

Chandima.

Re: Problem with data file written on application server thru datasets

Former Member — Fri, 04 May 2007 11:31:23 GMT

Hi Navin .

Instead of writing the whole code you can do the same with a transaction alrady there ..

T code: cg3z.

Better to do thru this. Will definitely save your time...... and also extra efforts.

Regards,

Jayant

PLease award if helpful