topic Re: Check table values restrict? in Application Development and Automation Discussions

Check table values restrict?

former_member194669 — Thu, 24 May 2007 18:35:16 GMT

Hi,

I have declared a table with the following fields and check tables associated with


Field           Data Element    Data Type 	Check table
MANDT		MANDT		CLNT	                              
YFIELDNAME	FIELDNAME	CHAR		DD03L
YFIELDDESC	AS4TEXT		CHAR

check table values against field YFIELDNAME as follows


Check table ChkTablFld For.key table Foreign key fielGeneric  Constant                    
DD03L       TABNAME                                                                   
DD03L       FIELDNAME  YFE078        YFIELDNAME                                           
DD03L       AS4LOCAL                                                                  
DD03L       AS4VERS                                                                   
DD03L       POSITION

I have maintained a Table maintenance Generator for this table. But problem is while entering

values for this table thru table maintenance system should show only field names that beling to MARA

table .

How to do this.

I tried to give constant value MARA in check table parameter against TABNAME as shown above, but is not accepting

that.

Any info

Thanks

aRs

Re: Check table values restrict?

Former Member — Thu, 24 May 2007 18:43:49 GMT

Are you talking about F4 help?

You can create a search help and attach it t oYFIELDNAME.

Within Search help you can specify that you need TABNAME = MARA only.

Re: Check table values restrict?

former_member194669 — Thu, 24 May 2007 19:28:26 GMT

I don;t need a search help. I want values entered to be restricted .

Thanks

aRs.

Re: Check table values restrict?

Former Member — Thu, 24 May 2007 19:43:35 GMT

Hi,

You can create the table like below for field FIELDNAME.

YFIELDNAME MATNR CHAR18 MARA

thanks,

sksingh

Re: Check table values restrict?

former_member194669 — Thu, 24 May 2007 19:55:06 GMT

Hi,

I think you have not understand my question.

I need to restrict the check table values while entering values .

Thanks

aRs

Re: Check table values restrict?

Former Member — Thu, 24 May 2007 21:12:16 GMT

Hey you can try this:

Create a database view on DD03L.

Under 'Selection condition' tab, you can specify the condition that TABNAME = 'MARA'.

Use this Database view as a Checktable for YFIELDNAME.