topic Re: Clarification needed on Value table in Application Development and Automation Discussions

Clarification needed on Value table

Former Member — Sun, 15 Apr 2007 04:02:36 GMT

Hi,

If we maintain fixed values for a domain, and if use related data element to a Table field...

what is the actual functionality of this value table?

it provides only F4 input help?? or It enforces condition in such a way like the field should have values only from the value table while creating records for that table?

Regards,

Pra

Re: Clarification needed on Value table

Former Member — Sun, 15 Apr 2007 04:38:22 GMT

Hi,

Only if you have a check table..Then it checks whether the record exists in the check table..This will work only when giving input in a custom transaction..

But if you directly use INSERT statement...Then you can enter any values other than the check table..

Thanks,

Naren

Re: Clarification needed on Value table

Former Member — Sun, 15 Apr 2007 05:44:29 GMT

Narendran,

I'm asking about Value table, not about check table. I wud like to know the behaviour of value table..exactly?

if we maintain values at domain values, whether it enforces condition to allow only values which are maintained for that domain??

i wud like to input entries through screen , not with insert

Pra.

Re: Clarification needed on Value table

Former Member — Sun, 15 Apr 2007 08:12:41 GMT

it will alllow values which u are maintained in the domain i.e either fixed values or value table entries?

please do the validations check when u are entring data into perticular fields.

regards

Prabhu

Re: Clarification needed on Value table

Former Member — Mon, 16 Apr 2007 04:20:04 GMT

HI Praneet,

Value table never validates the table entries , It just provide the F4 help , But when an create an check table using value table then it validates the data entered.

Fixed valuse in the Domain also validates the data entered into that particular field

Regards,

Shafi

Re: Clarification needed on Value table

Former Member — Mon, 16 Apr 2007 06:07:51 GMT

Hi praneet,

1. wud like to know the behaviour of value table.

Value table will not come into picture. (bcos we are not using foreign key )

2. if we maintain values at domain values

a) It will help in F4 .

b) But, it won't enforce only those values for entry purpose,

(bcos foreign key is not maintained)

regards,

amit m.

Re: Clarification needed on Value table

Former Member — Mon, 16 Apr 2007 07:53:42 GMT

Shafi,

Did u mean that if we maintain value table or fixed values, the validation part comes into picture

only when we create check table ( foreign key) based on value table then only validation part comes into picture and it validates against the existing enties in value table,...

Is that right? Provide ur inputs if i am wrong...

PRa