topic Generic input validity check against table/field in Application Development and Automation Discussions

Generic input validity check against table/field

Former Member — Mon, 03 Dec 2007 12:33:12 GMT

Hello!

Is there some function or something which would enable checking of a value against ANY table/field (or domain) combination? This is tricky because there are numerous criteria types. For example, date and currency fields have specific formats, many fields have foreign key table, others have value table or fixed values list in domain...

I know that each of data types have specific functions. But I wonder is there something generic?

For example (note that this doesn't work):

DATA: l_value TYPE char132.
l_value = '20071231'.
CALL FUNCTION 'CHECK_VALUE'
  EXPORTING tablename = 'BSEG'
            fieldname = 'BLDAT'
            value     = l_value
  EXCEPTIONS invalid = 1.

Thanks in advance!

Regards,

Igor

Re: Generic input validity check against table/field

Former Member — Mon, 03 Dec 2007 13:13:20 GMT

Hi,

the following function exists for domain controls : CHECK_DOMAIN_VALUES.

You can also take a look in program /SAPDMC/SAP_LSMW_CONV_DATA_CHK to find some ideas.

David

Re: Generic input validity check against table/field

Former Member — Mon, 03 Dec 2007 14:52:26 GMT

Hi, David!

This function looks promising, but doesn't work. Whatever combination I enter (good domain-good value, bad domain-bad value, good domain-bad value...), I get WRONG_VALUE exception.

Thanks for your input!

Igor