topic Re: validation in Application Development and Automation Discussions

validation

Former Member — Fri, 22 Dec 2006 07:51:28 GMT

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

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

i look forward to your reply

Thanks & Regards

SEK

Re: validation

jayanthi_jayaraman — Fri, 22 Dec 2006 08:01:06 GMT

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

Re: validation

Former Member — Fri, 22 Dec 2006 08:02:03 GMT

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

Re: validation

Former Member — Fri, 22 Dec 2006 08:21:54 GMT

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