Error in Open Dataset. Application server file shows null value .

[former_member308418]

Dear Gurus,

As with my previous problem, I am now getting value from SAP Directory in AL11. But problem is-

1. When I try to get Quantity or Currency field, it shows runtime error while uploading in App. Server. So, I used Char data type variable to store currency field and concatenate these in a string type variable.

LOOP AT it_mseg INTO wa.
          move it_mseg-erfmg to amount.   " amount is a char type variable.
         CONCATENATE it_mseg-mblnr it_mseg-mjahr it_mseg-matnr amount it_mseg-werks it_mseg-lgort INTO ld_string.

  TRANSFER ld_string to filename.

But I am getting only 0 for all the records. If I directly transfer wa to filename, it shows values. But when i am passing string, all value shows 0. Plz give me solution.

Thanks,

With regards,

Tripod.

[former_member308418]

using a MOVE from a numeric field, you are copying the field in internal format and it may cause problems. With the WRITE statement, the numeric field is converted in text field.

[Former Member]

Hi,

use

WRITE it_mseg-erfmg to amount.

or, assuming that the currency is WW_WAERS,

WRITE it_mseg-erfmg CURRENCY WW_WAERS to amount.

[former_member308418]

Thanks Henry for reply. I think error is in concatenate into a string. Because when I exclude this amount field and try to concatenate in string, then also value shows all 0.

Plz give some logic to solve it.

With regards,

Tripod.

[Former Member]

using a MOVE from a numeric field, you are copying the field in internal format and it may cause problems. With the WRITE statement, the numeric field is converted in text field.

[former_member308418]

Hi Henri,

Thanks for your reply. I tried using write statement also. But problem remains the same. Finally I kept them in another internal table,by making required field as char, now data showing properly .

Thanks,

Best regards,

Tripod.

[kesavadas_thekkillath]

Dump message ?