Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Check table values restrict?

former_member194669
Active Contributor
0 Likes
971

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

1 ACCEPTED SOLUTION
Read only

former_member194669
Active Contributor
0 Likes
721

Hi,

I think you have not understand my question.

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

Thanks

aRs

5 REPLIES 5
Read only

Former Member
0 Likes
721

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.

Read only

former_member194669
Active Contributor
0 Likes
721

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

Thanks

aRs.

Read only

Former Member
0 Likes
721

Hi,

You can create the table like below for field FIELDNAME.

YFIELDNAME MATNR CHAR18 MARA

thanks,

sksingh

Read only

former_member194669
Active Contributor
0 Likes
722

Hi,

I think you have not understand my question.

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

Thanks

aRs

Read only

0 Likes
721

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.