topic Re: selection restriction using check table in Application Development and Automation Discussions

selection restriction using check table

Former Member — Fri, 20 Jun 2008 12:17:45 GMT

I have created two custom tables, ZSH_VERIFY and ZSH_CHK_VU. The first is a master data table and the second is a check table. For one particular field MODOP in ZSH_VERIFY, the list of values is small and fixed, i.e. 'V', 'U', 'X'. ZSH_CHK_VU contains three fields, MANDT, MODOP and MODSC. The fIrst two are key fields. I have created 3 records for ZSH_CHK_VU containing the values 'V', 'U' and 'X' for MODOP.

I want that at the selection screen for ZSH_VERIFY, for field MODOP, a list of the values in ZSH_CHK_VU, i.e. 'V', 'U' and 'X' should appear as the input options.

I have created a data element ZSH_OP of built-in type CHAR, length 1 and am using it in the field definition for MODOP in both tables. I have set ZSH_CHK_VU as a check table for field MODOP in ZSH_VERIFY using foreign key determination. As far as I know, this should give me the result I need but it is not working. Any help would be greatly appreciated. Thanks.

Regards

Re: selection restriction using check table

ravisankara_varaprasad — Fri, 20 Jun 2008 12:43:52 GMT

Hi ,

As for I know , If you take the domain with fixed values and type as char , then it should give the desired result for you. Please cross check once again.

and to restrict the correct values , you can write the Events in Table Maintenance generator (or) second method is modify the custom function group given for Table Maintenance generator . But second method is not preferable .

Hope it helps you.

Thanking You.

Kind Regards,

Ravi Sankar.Z

Re: selection restriction using check table

valter_oliveira — Fri, 20 Jun 2008 13:42:45 GMT

Hello.

If it's not working, you can always create a matchcode object in se11 for your table and then use it in the selection screen declaration like:

PARAMETERS: p_aufnr TYPE aufk-aufnr MATCHCODE OBJECT zmatchcode.

Also check this link (for matchcodes):

http://help.sap.com/saphelp_nw04/helpdata/en/41/f6b237fec48c67e10000009b38f8cf/frameset.htm

Regards.

Valter Oliveira.