regarding value table

[Former Member]

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.

[Former Member]

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

[MarcinPciak]

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

[Former Member]

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

[MarcinPciak]

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

[Former Member]

Hi,

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

Regards,

--

Przemysław

[MarcinPciak]

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

[Former Member]

Hi,

OK, thanks, I agree with your version.

Regards,

--

Przemysław

[MarcinPciak]

No problem, constructive discussion is always welcome:)

Cheers

Marcin