topic Re: Check Table in Application Development and Automation Discussions

Check Table

bjorn-henrik_zink — Wed, 14 Jun 2006 12:20:18 GMT

Hi,

I want to create a check table for a data type. Here is what I have created so far:

data type: ZDAT (Domain ZDOM)

domain: ZDOM (Value Table)

table: ZTAB (Containing field ZFIE with field type ZDAT)

I try to create a foreign key for the ZFIE but receive the following message:

Check table of the domain is current table (FK maintenance not possible)

Finally, I have created a report containing a field that points to ZDAT. The value table is working fine, but there is no check on the field.

Anybody who knows how I can get the check working?

Thanks.

Elvez

Re: Check Table

Former Member — Wed, 14 Jun 2006 12:23:50 GMT

Elvez,

If u used value table means it proposes a check table when u create a foreign key. But it does not validate the values.

- Selvapandian Arunachalam

Re: Check Table

Former Member — Wed, 14 Jun 2006 12:26:14 GMT

For do a check the possible way is to write a

select single query with the key fields passing in where clause.

. You can write this code on AT-SECLECTION-SCREEN.

rgds,

Re: Check Table

bjorn-henrik_zink — Wed, 14 Jun 2006 12:28:11 GMT

Hi Thomas,

is there anyway to do this without programming?

/Elvez

Re: Check Table

Former Member — Wed, 14 Jun 2006 12:30:59 GMT

Elvez,

in the parameter, use value check addition. automatically it will check against the corresponding database table.

- Selvapandian Arunachalam

Re: Check Table

Former Member — Wed, 14 Jun 2006 12:35:18 GMT

Hi,

you need to validate explicitly in your program under the event at selection-screen.

using the

select single * from ztab into wa where <condition>.

Regards

vijay

Re: Check Table

bjorn-henrik_zink — Wed, 14 Jun 2006 12:36:54 GMT

Hi Selvapandian Arunachalam,

it is not working for me, could you provide an example?

/Elvez

Re: Check Table

bjorn-henrik_zink — Wed, 14 Jun 2006 12:39:35 GMT

Hi Vijay,

see answer above - is it possible to do this without further programming?

/Elvez

Re: Check Table

Former Member — Wed, 14 Jun 2006 12:52:17 GMT

Ok, Sorry.please ignore.

Regards

vijay

Re: Check Table

suresh_datti — Wed, 14 Jun 2006 12:55:03 GMT

Hi Elvez,

The 'Value Check' option is for a selection screen parameter.. to quote SAP help " It Ensures that the value entered in the field is checked against the check table or fixed values defined in the ABAP Dictionary. There must be a LIKE reference to an ABAP Dictionary field. "

How have you declared the field ZFIE in your Program?

Regards,

Suresh Datti

Re: Check Table

bjorn-henrik_zink — Wed, 14 Jun 2006 13:03:39 GMT

Hi Suresh,

that might be it - I have declared ZFIE type ZDAT.

/Elvez

Re: Check Table

Former Member — Wed, 14 Jun 2006 16:07:24 GMT

Hi Elvez,

Sorry, I'm left for the day that time.

Syntax:

PARAMETERS: <Parameter variable> like <Database table>-<field name> VALUE CHECK.

Ex:

PARAMETERS: P_MATNR like MARA-MATNR VALUE CHECK.

It will check against the DDID table.

Re: Check Table

bjorn-henrik_zink — Thu, 15 Jun 2006 06:11:39 GMT

Hi,

this time I am the one apologizing for having left for the day.

The code did not check anything when I entered a non-sense value? How come?

/Elvez

Re: Check Table

Former Member — Thu, 15 Jun 2006 06:42:15 GMT

Hi Elvez,

try this

Parameters : p_var type mara-WRKST value check.

this wud provide an automatic check...