Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Looking at the logic of validation Qualified Lookup.

Hi,

I have a main table called Business Partner. There is a field called Address which is

Lookup[Qualified Flat](multi-valued). Now, the lookup table is Addresses.

The Addresses table contains a field named Phone No. which is Text with 50. It is neither Unique field nor Display field.

Now, there is a validation which is being used as Phone No. validation in Business Partner[main table].

The logic is:

IF(IS_NOT_NULL(Address.Phone Number), LEFT(Address.Phone Number, 1) < > "" AND IF(FIND(Address.Phone Number, "-")>0, FIND(MID(Address.Phone Number, FIND(Address.Phone Number, "-")1, LEN(Address.Phone Number)), "-")=0,TRUE),TRUE)

Now, according to my understanding it means:

Phone Number is not null and if there is a phone number liked 1-45678900, then is valid phone number but also if Phone Number is not null then it is valid.

Please co-relate my understanding.

I need to know the meaning of all the Functions used in Validation Expression.

Just tell me the grammer of all functions used in SAP MDM Validation.

Regards

Kaushik Banerjee

Edited by: Kaushik Banerjee on Oct 3, 2008 6:21 AM

Edited by: Kaushik Banerjee on Oct 3, 2008 6:30 AM

Tags:
replied

Hi Kaushik,

I tried to understand the logic

IF(IS_NOT_NULL(Address.Phone Number), LEFT(Address.Phone Number, 1) ""+

It says that phone number should start with "+" sign

IF(FIND(Address.Phone Number, "-")>0, FIND(MID(Address.Phone Number, FIND(Address.Phone Number, "-")1, LEN(Address.Phone Number)), "-")=0,TRUE),TRUE)+

It first check whether there is "-" present in the value and if yes then after the "-" rest of the value should not contain and more "-" sign.

In summary it says that Phone number is Valid only:

1. It is not null

2. It starts with "+"

3. It should contain only one "-"

Regards,

Jitesh Talreja

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question