topic Re: apply validations on internal table fields before updating table in Application Development and Automation Discussions

apply validations on internal table fields before updating table

Karan_Chopra_ — Sat, 02 Oct 2010 08:32:03 GMT

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 ....

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 .....

Re: apply validations on internal table fields before updating table

Karan_Chopra_ — Sat, 02 Oct 2010 08:59:03 GMT

Plz help.....

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

Re: apply validations on internal table fields before updating table

Former Member — Sat, 02 Oct 2010 10:09:14 GMT

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

Re: apply validations on internal table fields before updating table

deepak_dhamat — Sat, 02 Oct 2010 10:21:24 GMT

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

Re: apply validations on internal table fields before updating table

Karan_Chopra_ — Sat, 02 Oct 2010 10:54:45 GMT

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

Re: apply validations on internal table fields before updating table

Former Member — Sun, 03 Oct 2010 19:38:11 GMT

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