apply validations on internal table fields before updating table

[Karan_Chopra_]

I have to upload data from a CSV file to R3 ztable, but before that I have to apply diffrent validations to check if fileds does not contaion invalid characters ....

eg

for a currency field I want to check if user has entered value in decimail format e.g 3.23, -22.33 etc but not like this 3..2, _+3.33, e3e& etc

How can I do this .....

[Karan_Chopra_]

I have to upload data from a CSV file to R3 ztable, but before that I have to apply diffrent validations to check if fileds does not contaion invalid characters ....

eg

for a currency field I want to check if user has entered value in decimail format e.g 3.23, -22.33 etc but not like this 3..2, _+3.33, e3e& etc

How can I do this .....

[Karan_Chopra_]

Plz help.....

Edited by: Karan Chopra on Oct 2, 2010 3:16 PM

[Former Member]

Hi Karan,

Why don't you create a BDC program for SM30 transaction to upload data from .csv file to R3 Z table? Standard SAP consistency checks and authorizations are automatically performed when you upload data through BDC technique.

Thanks

Nitesh

[deepak_dhamat]

hi ,

There are lots of thread related to upload data .

you can search in SDN .

One method is to upload data in excel format and getting data in one internal table and then validatiing

before insert or update .

Moderator message - Please respect the 2,500 character maximum when posting. Post only the relevant portions of code

Regards

Deepak.

Edited by: Rob Burbank on Oct 3, 2010 3:36 PM

[Karan_Chopra_]

I need to give some other values also in case of error its not direct upload

I need to chk each value one by one...

Edited by: Karan Chopra on Oct 2, 2010 6:44 PM

[Former Member]

Moderator message - Please do not ask or answer basic questions Thread locked Rob