Validations and Assignments on Tuple

[Former Member]

Hi All,

Can any one make me clear on what validaitons we can do on tuples and what we cant do??

Thanks

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

You can execute validations on Tuple but assignments dont run on Tuple fields.

For better understanding please go through these links:

For validations:

This talks about workaround to achieve Tuple assignments

A very detailed description of Workarounds to handle limitations of Tuple:

Worarounds for assignments:

Hope this helps.

Please let me know if you have any query.

Thanks,

Ravi

Edited by: Ravi Verma on Aug 23, 2011 11:38 PM

[Former Member · Accepted solution]

Hi Ravi,

Thanks for the links but I am unable to understand clearly what validaitons we can do and what cant.. More over there is a SAP Note in one of the link but its removed in service market place..

Can any one let meknow what are the limitations and what can be validated on tuples??

Can we validate each member fields of a multi valued tuple?

Can we validate each member fields of a multi valued tuple based on other member of same tuples?

can we validate all fields at main table level?

can we validate multi valed tupe with reference to main table level?

can we validate multi valued tuple with reference to look up or other tuple table?

Thanks

Rajeev

[former_member40425 · Accepted solution]

Hi

Please find below answers of your query.

Can we validate each member fields of a multi valued tuple?
Yes.

Can we validate each member fields of a multi valued tuple based on other member of same tuples?
Yes

can we validate all fields at main table level?
No

can we validate multi valed tupe with reference to main table level?
Yes

can we validate multi valued tuple with reference to look up or other tuple table?
Please elaborate.

Regards,

Rohit

[Former Member · Accepted solution]

Hi Rohit,

1)can we validate all fields at main table level?

No

Its not possible to validate fields at main table level?? can you please eloborate this???

2)Suppose you have a tuple with members look up, nested tuple then Is it possible to do validaitons of all members of tuples and also all members of nested tuple??

3) Can we able to perfrom validations on tuple and all tuple members with reference to main table ???

Regards,

Rajeev

[former_member40425 · Accepted solution]

 1)can we validate all fields at main table level?
No
Its not possible to validate fields at main table level?? can you please eloborate this???

Suppose you have two fields TupleFieild_A and TupleFieild_B under a Tuple.

You can not validate TupleFieild_A and TupleFieild_A and TupleFieild_B fields at main table level.

 2)Suppose you have a tuple with members look up, nested tuple then Is it possible to do validaitons of all members of tuples and also all members of nested tuple??

You can validate tuple with members look up.

3) Can we able to perfrom validations on tuple and all tuple members with reference to main table ???

Yes we can do this.

I hope it helps.

Regards,

Rohit

[Former Member · Accepted solution]

Hi Rohit,

Thanks for your reply.

Can you please clear the difference of Point 1 and 3?

Also from your explanation I understood that we can validate all members of nested tuples as well.. Please correct me if I am wrong..

Suppose I have a validation : STATUS field in maintable level and Field A and Field B is in tuple level so is it posisble to perform the validation as below:

If Field A and Field B are not null and numbers then STATUS is true else false?

If any of the Field A is 1 then Status should be TRUE?? Because Tuple is multi valued...

If anyof the field A is Null and Field B is number then Staus is Flase??

Comming to tuple validaitons with in a tuple (Multi Valied):

If all the field A value then raise validation error

If any of the Field A is null then raise validation error

If Field A and Field B are null then rasie validaiton error

If any of FieldA or FieldB are null then raise validaiton error

Please let me know your comments.

Thanks

Rajeev

[former_member40425 · Accepted solution]

Hi Rajeev,

If Field A and Field B are not null and numbers then STATUS is true else false?
If any of the Field A is 1 then Status should be TRUE?? Because Tuple is multi valued...
If anyof the field A is Null and Field B is number then Staus is Flase??

This is not possible as you can not check value of tuple fields at main table level.

 Comming to tuple validaitons with in a tuple (Multi Valied):
If all the field A value then raise validation error
If any of the Field A is null then raise validation error
If Field A and Field B are null then rasie validaiton error
If any of FieldA or FieldB are null then raise validaiton error

Yes, it can be done. For above all four conditions you just have to put following mandatory check as below on both the tuple fields.

IF_NOT_NULL(<Tuple_Field>.[Record])

I hope it helps.

Regards,

Rohit

[Former Member · Accepted solution]

HI Rohit,

Thanks once again.

So just to summarise:

1)We can do validaitons on any member of multi valued Tuple table (Also any member of multi values nested tuple) and can play around..

2)We can do validaitons on any field (except Multi valued Tuple) on main table level

3)We cant do any validations on main table level which needs tuple values

And also we cant do any assignments on multi valued tuple.

Please do let me know if I am missing any thing or any thing incorrect.

Regards.

Rajeev

[former_member40425 · Accepted solution]

 1)We can do validaitons on any member of multi valued Tuple table (Also any member of multi values nested tuple) and can play around..

True

2)We can do validaitons on any field (except Multi valued Tuple) on main table level

You can validate Multivalued Tuple also like you can make it mandatory or something but can't create validation on tuple members on main table level.

3)We cant do any validations on main table level which needs tuple values

True.

And also we cant do any assignments on multi valued tuple.

Right, You can not create any assignment on tuples.

Regards,

Rohit

[Former Member · Accepted solution]

Hi Rohit,

Thanks for your inputs..

I created the validations on tuple by choosing the tuple table.. and its just simple one called NOTNULL.. IS_NULL(Field Name)

And I went ot the record mode selected the record and executed the validation NOTNULL but its all the time giving no error.. even there is no record or if record exist with NULL and record exist with out NULL..

Can you please let me know how to execute validations on tuples??

Regards,

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

What is the exceution type you have chosen,is it None?

Try choosing warning or Error.

Thanks,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Execution type is Error already...

DOnt know what I am missing..

Regards,

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

In the validation expression make sure you did these :

Select Is Not Null(Field Name)

Execution type is not None

Creating a Tuple record with this field missing will result in a error message.

thanks,

Ravi

[former_member40425 · Accepted solution]

Make sure you are writing Validation using Fields and Operators and Funtions buttons. Sometime if we write validation manually then it gets corrupted.