topic Re: Validation on Amount field in Application Development and Automation Discussions

Validation on Amount field

Former Member — Thu, 30 Jul 2009 09:34:13 GMT

Hi,

I have a reqmt to generate two files with one program

one is .txt file need to upload to application server and another is csv file send as mail.

Here im using PAYR table and fetching RWBTR amount field.

The reqmt is when ever we are generating .txt file the amount filed should not contain any decimals. Ex : 40.00 --- 4000

But when sending as mail field value should conatin decimals. Ex : 4000 --- 40.00

Pls provide me some pointer.

Thanks

Former Member — Thu, 30 Jul 2009 09:37:43 GMT

The field RWBTR has decimals, so u can move it to the csv file direclty, and u can pack it before moving it to the text file:

PARAMETERS: AMOUNT TYPE PAYR-RWBTR.

DATA: CSV(20) TYPE C,
      TXT(20) TYPE C.

MOVE AMOUNT TO CSV.

WRITE CSV.

PACK AMOUNT TO TXT.

WRITE / TXT.

Max

Former Member — Thu, 30 Jul 2009 10:27:39 GMT

Hi,

During Generation of Text File, pass amount field value into some character type field and then generate the file.

For CSV, do with the original amount field.

Only one additional field you have to use for amount field and your problem will be solved.

Regds,

Anil