validation

[Former Member]

Hi All,

I have query in validation WRBTR (Amount)

I had developed one BDC ( SESSION) for TCODE FB01

i was upload the data from excel file

During file upload, i want validate amount field

in the amount like 12,550.00

it will goes to error table table

in the amount like 12550

it will goes to correct data table

how to validate this amount field, Is there is any Function module

or

u have sample code plz send me, it would be very helpful for me

i look forward to your reply

Thanks & Regards

SEK

[jayanthi_jayaraman]

Hi,

Before passing the value do as follows.

for eg..

data v1 type p decimals 2.

data c1.

v1 = '12,550.00'.

c1 = v1.

replace all occurrences of ',' with '' into c1.

Now use c1 in the BDC.

Message was edited by:

Jayanthi Jayaraman

[Former Member]

hi Rajashekar,

Use Conversion FM before sending the data to error table for getting that go to se11 and enter the table name .... find for the fied( amount ) on data element( double click ), domain ( double click ) there you will find the conversion routine( double click ) ... to find the required FM ..

Regards,

Santosh

[Former Member]

You can use the write statement:

write wrtbr to v_wrbtr no-grouping decimals 0.

v_wrtbtr must be a char type variable.

Regards,

ravi