topic Re: regarding value table in Application Development and Automation Discussions

regarding value table

Former Member — Wed, 17 Mar 2010 07:41:11 GMT

I have created a table and I was attached it to the field as value table at the domain level . what my question is when we use that field in report program as selection-screen field it will show us list of possible value for that field how it will show us is there any program execute behind the value table? please Clarify my doubt

Regards,

D.kiran kumar.

Re: regarding value table

Former Member — Wed, 17 Mar 2010 07:58:13 GMT

Hi,

this is a standard system behaviour.

This is a C function, not ABAP function. You do not have influence on it.

After calling value help it probably check domain or foreign key is structure fields.

Regards,

Przemysław

Re: regarding value table

MarcinPciak — Wed, 17 Mar 2010 08:19:21 GMT

My Friend,

Value table is checked against user entry only if foreign key relationship is defined for the field which uses that domain. This means that it must be transformed to check table in order the input help can be provided at all. So it is DB foreign key relationship which is giving you the possibility to select a value form value table (check table).

Without former mentiod foreing key definition your value table is useless and you will not receive any input help for field using this domain.

Regards

Marcin

Re: regarding value table

Former Member — Wed, 17 Mar 2010 08:24:52 GMT

Hi,


Value table is checked against user entry only if foreign key relationship is defined for the field which uses that domain.

This is one situation.

But if you enter table for the domain, it takes primary key of the table.

This is easier for selection screen, you just enter data element with such domain,

you do not need to define parameter as structure-field.

Regards,

Przemysław

Re: regarding value table

MarcinPciak — Wed, 17 Mar 2010 08:54:56 GMT


But if you enter table for the domain, it takes primary key of the table.
This is easier for selection screen, you just enter data element with such domain,
you do not need to define parameter as structure-field.

But this does not provide the input help for that screen field. Value table at domain level is insufficient to provide such input. It is purerly used to provide foreing key relationship when you define one for table/structure field which uses that data element. System proposes then that value table primary key as default one for foreign key relationship. That's all it is used for.

Simple proof


parameters pa_con type S_CONN_ID.  "this data element uses domain S_CONN_ID which has SPFLI value table defined, on screen no input help is provided for the field

Regards

Marcin

Re: regarding value table

Former Member — Wed, 17 Mar 2010 08:59:28 GMT

Hi,

this is true, because S_CONN_ID is not able to use primary key - S_CARR_ID generates value help.

Regards,

Przemysław

Re: regarding value table

MarcinPciak — Wed, 17 Mar 2010 09:06:00 GMT

S_CARR_ID has search help assiged to it (S_CARRIER_ID), that's why we get input help, not because it is a part of primary key .

Regards

Marcin

Re: regarding value table

Former Member — Wed, 17 Mar 2010 09:10:41 GMT

Hi,

OK, thanks, I agree with your version.

Regards,

Przemysław

Re: regarding value table

MarcinPciak — Wed, 17 Mar 2010 09:22:24 GMT

No problem, constructive discussion is always welcome:)

Cheers

Marcin