topic Re: Table in Application Development and Automation Discussions

Table

Former Member — Thu, 20 Mar 2008 12:25:19 GMT

Hi,

Can anyone plz the exact use of value table,value range and fixed value.

Does the above provide validations.

Re: Table

Former Member — Thu, 20 Mar 2008 12:29:20 GMT

Hi,

Ya.. value table is for Validations. If you give any other value other than the values in this table, it will throw error.

Regards,

CS.

Re: Table

Former Member — Thu, 20 Mar 2008 12:39:39 GMT

Hi,

This can be understand by simple example. For Gender there can possible values : Male, Female and Unknown.

So these values will be seen for user whenever s/he selects the Gender. If s/he wants to unput some other values then system wont accept.

These values can be entered as single values, intervals or you can maintain in table called value table for validation.

Hope this will clear your doubt.

Please reward if useful.

Regards,

Ramesh

Re: Table

Former Member — Thu, 20 Mar 2008 13:16:02 GMT

Hi,

Value table holds all the records that are allowed for a particular field in SAP database. For example, take AUART, Order type. For this all the values will maintained in T003O. If you enter any value for order type which is not maintained in T003O, you will get an error immediately. For example you didn't maintain 123 order type in T003O, and you try to enter a record with order type 123 in a ZXX table, you will get an error immediately.

Value range is similar, the only difference is you can specify a range of values. Fixed value's name itself says everything you cannot enter any other value than the specified one.

Hoep you are clear now. Reward if helpful.

Thanks,

Asha

Re: Table

Former Member — Mon, 24 Mar 2008 07:21:40 GMT

Hi,

ALL 3 provide validations..

Value table contains all the possible values that you can have for a particular feild in a table.

Value range specifies range of values having an upper limit and lower limit.

Fixed value means a constant value. that is you can not have any value other than the specified one

regards,

preet

reward if helpful.

Re: Table

Former Member — Mon, 24 Mar 2008 08:23:04 GMT

These are to provide validations as in from where the value can be selected.

Like if we put value table then the value for a corresponding fields can be selected from that very table only.

In value range you can give the range for the given fiels. For eg. if you give range from 1 to 9. You can enter value from 1 to 9 in that very field.

and fixed values are used to give validations when u want the vales to be selected from particular given values.

Reward if helpful

Palak Behal

Re: Table

Former Member — Mon, 24 Mar 2008 10:17:14 GMT

value table is nothing but the foreign key table.

The values in this table are checked against the primary key table.

It is used for validating the entries .

Value ranges means-you can specify a range of values

Fixed-The value remians constant.

Reward points if useful;

Re: Table

Former Member — Mon, 24 Mar 2008 10:28:15 GMT

Hi Ajaya,,

Value Table:

Always Value table means table which contain the all

possible existing value for that field(key).It refers to F4

functionality. Usually we will create any value table

whenever we are creating the key's domain.

Check Table:

The name itself is defines that it is the table which is

giving the check function when the foreign key is populated

with some value.

I mean to say that at the time you are populating elements

into the foreign key table at that time

ex: foreign key

you entered some value in above field and pressed ENTER

key on key board then system automatically excutes the

select statement on the existing check table, in order to

know whether this key's entry exist in the check table or

not.

So here the check table means the reference for comparision.

And foreign key table means referee which is asking for

check.

****************************************

For Value Range

Selecting Filter Values

Use

You use the value selection in the Business Explorer Analyzer to select filter values for characteristics.

Prerequisites

You have executed a query in an Excel workbook. You have also selected a characteristic in the filter cells, and chosen Select filter value... from the context menu (right mouse button).

Procedure

Selecting single values

This function is used only if the characteristic does not have an active display hierarchy.

...

1. In the top left of the selection field, choose single value, and (flat list) as the hierarchy.

2. Select one or more values from the list of available values displayed in the left-hand window, and drag the value(s) into the Selection box on the right (alternatively, use the pushbutton with the arrow pointing to the right to move the values).

Only those values for which there are data records in the InfoProvider, and which you are authorized to use are displayed. The number of available values in the left-hand window is restricted to 100. It is possible to remove this restriction, or to choose the values displayed according to other criteria. See Filter Values: Formulating Selection Conditions.

Selecting value ranges

This function is used only if the characteristic does not have an active display hierarchy.

You can set the time interval for individual time characteristics in the SAP Reference IMG. The value help only offers those values that lie within this time interval. In the SAP Reference IMG, choose BW Customizing ® Implementation Guide ® Business Information Warehouse ® Reporting-relevant Settings ® General Reporting Settings ® Set F4 Help and Hierarchies for Time Characteristics / OLAP Settings. On the General Settings tab page, you can set the required Time Interval.

...

1. Choose value range from the top left of the selection field, and the operator that you want to use (top right).

The following operators are possible:

¡ Is between

¡ Is greater than or equal to

¡ Is less than or equal to

¡ Is greater than

¡ Is less than

2. If you choose the operator between, first select the upper and lower limits of the interval from the list of available values in the left-hand window, and choose the button with the arrow pointing to the right. The characteristics for the interval you select appear in the right-hand Selection window.

If you choose one of the operators is greater than or equal to, is less than or equal to, is greater than, or is less than, select a value from the list of available values in the left-hand window, drag it across, and drop it into the Selection window on the right (alternatively use the button with the arrow pointing to the right to move the value across into the Selection window).

Intervals are formed using a key and not according to the displayed texts. For example, also contains August.

Check this link for more information :

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ede5446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/b2/2957394924834ee10000000a114084/content.htm

Please reward if help ful,,,

Sreekar.Kadiri.

Re: Table

prasanth_kasturi — Mon, 24 Mar 2008 11:56:29 GMT

Hi,

Can anyone plz the exact use of value table,value range and fixed value.

Does the above provide validations

Value Table: It is domain level proposed check table.

if you know in before hand the list of vaues to be entered in the field are contained in a table you will enter that table and when you crate foreign key relationship sysytem propses that table name.

value range: if you know the range of values that can be entered in the field you will enter the range and it acts as f4 help.

fixed values: if the field must have only a few fixed values(like gender which has m and f) we will give those in the fields. its also acts as f4 help.

you can overwrite the valuses in fixed values and value range

Re: Table

Former Member — Tue, 25 Mar 2008 12:34:08 GMT

hi,

value table : This is maintained at Domain Level.

When ever you create a domain , you can entered allowed values.

When ever you use this Domain, the system will forces you to enter only these values.

This is a sort of master check . To be maintained as a customization object. This mean that if you want to enter values to this table you have to create a development request & transport the same.

value range: by specifying fixed values.By stipulating a value table.