topic Re: check table for a structure in Application Development and Automation Discussions

check table for a structure

Former Member — Thu, 19 Feb 2009 08:55:42 GMT

Hi,

I am creating a structure, where I need to specify the check for a particular field?

thanks in advance

thanks

Chitra

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:03:32 GMT

HI,

can you be more specific on the question.

regards

sarves

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:03:47 GMT

While creating the structure in Component Type OR Data Type field u can assign the checks for the particular field.

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:08:50 GMT

Oops,

It was a typo, it is check table not ' check'.

I have created ZTABLE and ZFIELDS and ZDOMAIN too,

but the check table column in 'Entry help/check' tab is not in edit mode .

Please help me here.

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:09:01 GMT

hi,

please more specific,

and u can create a structure of whatever the field ur needed, u can check in 2 ways using check statemet or using where condition, example is as below.

SELECT * FROM SBOOK INTO SBOOK_WA.

CHECK: SBOOK_WA-CARRID = 'LH' AND

SBOOK_WA-CONNID = '0400'.

ENDSELECT.

The above code can be much more optimized by the code written below which avoids CHECK, selects with selection list

SELECT CARRID CONNID FLDATE BOOKID FROM SBOOK INTO TABLE T_SBOOK

WHERE SBOOK_WA-CARRID = 'LH' AND

SBOOK_WA-CONNID = '0400'.

Edited by: girish marulappa on Feb 19, 2009 10:10 AM

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:12:34 GMT

Hi ,

On the data element of your structure's field you can attach search help . For that follow the path -

SE11 --> create search help ---> go to data element of that particular field -

> further characteristics ---> specify the search help name and parameter .

Regards

Pinaki

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:14:58 GMT

Hi Chitra,

Check tables can be specified at Domain level for a field.

Click on Domai for a field, then select Value range tab, specify the check table name at Value table.

Regards,

Sunil

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:15:44 GMT

for this one u should select the check box display maintaince allowed

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:16:31 GMT

Hi,

Try like this...

SE11 --> give structure name --> select the field -->goto entry help/chect tab --> click foreign key button (key symbol button) --> give check table name and field names and all based upon ur requirement.

Hope its helps

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:22:00 GMT

hi,

for edit the table u shold select the display/maintainance allowed in delevary and maintainance tab.

regards girish.

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:28:26 GMT

Hi chitra.

i understood ur problem.

for this go on ENTRY HELP/CHECK tab

now place the cursor on the field for which u want check table active.

after placing cursor on that field click on the icon which have the KEY picture on it(Tool tip shows the Foregin Key as text) near Search Help tab.

here u can give the check table for entry

Edited by: tahir naqqash on Feb 19, 2009 2:29 PM

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:41:45 GMT

Hi Tahir,

thank you so much, I already explored and found the solution

Thanks a lot

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:42:38 GMT

Thanks Tahir

Re: check table for a structure

Former Member — Thu, 19 Feb 2009 09:45:08 GMT

U are welcome brother.SDN is for helping and knowledge sharing