check table for a structure

[Former Member]

Hi,

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

thanks in advance

thanks

Chitra

[Former Member]

HI,

can you be more specific on the question.

regards

sarves

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

hi,

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

regards girish.

[Former Member]

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

[Former Member]

Hi Tahir,

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

Thanks a lot

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks Tahir

[Former Member]

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