value range

[Former Member]

hi all ,

How can i maintain new values in the value range of the field ESTKZ .

please help.

thanks.

sridhar.

[Former Member]

Hi,

Consider this example:

r_matnr for mara-matnr.

Filling the range is accomplished by:

r_matnr-low = '000000000000000001'.

r_matnr-low = '000000000000009999'.

r_matnr-option = 'BT'.

r_matnr-sign = 'I'.

APPEND r_matnr.

The selection is then accomplished by:

SELECT * FROM mara WHERE matnt in r_matnr.

Hope this helps you.

Best Regards,

Anjali

[Former Member]

select-options : s_estkz for tab-estkz.

to add new values

s_estkz-sign = 'I'.

s_estkz-option = 'EQ'.

s_estkz-low = '12345'.

s_estkz-high = ''.

append s_estkz.

clear s_estkz.

[Former Member]

Hello Sridhar,

As I understand u r asking abt the values in data dictionary. In that case u will have to make modifications to dictionary object.

[Former Member]

Hi,

Value range-values are nothing but giving the values in DOMAIL level.

For FIELD-ESTKZ double click on DATA TYPE then later double click on DOMAIN.

There you will find the VALUE RANGE TAB. Click on it.

There you have to give values.

Since it is STANDARD field I think you must have authorization.

Value Range values means when you give these values then the system will allow you to append those values for that particular field.

Thanks.

If this helps you reward with points.

[Former Member]

Hi Sridhar,

If ESTKZ is a Selection-screen field which you have defined using SELECT-OPTIONS:

SELECT-OPTIONS: s_estkz for tab-estkz.

s_estkz-sign = 'I'.

s_estkz-option = 'EQ'.

s_estkz-low = 'AAAA'.

append s_estkz.

clear s_estkz.

s_estkz-sign = 'I'.

s_estkz-option = 'EQ'.

s_estkz-low = 'BBBB'.

append s_estkz.

clear s_estkz.

If ESTKZ is a database table field then go to Data Element -> Domain -> Value range.

If you want some particular values, you can maintain them under Single vals.

And if you want range of values, you can maintain them under Intervals by specifying lower limit and upper limit.

Regards,

Neeraj Gupta

[jayanthi_jayaraman]

Hi,

For that you need to have access key.

Go to SE11.In datatype, type ESTKZ.

In the domain ,ESTKZ,double click it.

In the window,click value range and give the new values there.

Kindly reward points by clicking the star on the left of reply,if it helps.