Hierarchy
⤷ PA-PA-US (Application Component) USA
⤷ PAOC_PAD_US_FD (Package) US Federal Public Sector
Basic Data
Data Element | P10P_PRVAL |
Short Description | Parameter Value |
Data Type
Category of Dictionary Type | Direct Type Entry | |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | ||
Data Type | CHAR | Character String |
Length | 80 | |
Decimal Places | 0 | |
Output Length | 80 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | Value |
Medium | 15 | Parameter Value |
Long | 25 | Parameter Value |
Heading | 25 | Parameter Value |
Documentation
Definition
This is the value that a parameter should equal, or by which it should be bounded.
Use
In the configuration of the validation value table access methods, you need to restrict the values of key fields of the database table for the selection of records. The selection is defined by the statement:
SELECT SINGLE * FROM (T5UPBSPA22-DBTAB)
INTO (DBTAB_STRUCTURE) WHERE
(FIELD_1) IN (SELECTION_TABLE_1) AND
(FIELD_2) IN (SELECTION_TABLE_2) AND
...
(FIELD_N) IN (SELECTION_TABLE_N).
In the above statement, the table (T5UPBSPA22-DBTAB) is the table defined in table T5UPBSPA22 that uses the selection rule defined in this view. This is read into a structure of the appropriate type that we call (DBTAB_STRUCTURE). (FIELD_1), (FIELD_2), ... (FIELD_N) are fields of the table (T5UPBSPA22-DBTAB). For each field, a selection table is created.
See the SAP Help documentation for the SELECT statement for detailed information on the selection table.
The selection table for (FIELD_N) has the following structure:
SIGN: 'I' for inclusive, 'E' for exclusive.
OPTION: 'EQ' for equal, 'NE' for not equal, 'BT' for between, etc.
LOW: A field of type (FIELD_N). For OPTION choices that refer to one field such as 'EQ', this is the field used for comparison. For OPTION choices that refer to ranges such as 'BT', then both LOW and HIGH fields are used.
HIGH: A field of type (FIELD_N). As noted above, this is used only for OPTION choices that refer to a range.
The 'Low Parameter Value' is entered in the 'LOW' field of the table above, and the 'High Parameter Value' is entered in the 'High' field above.
Example
In this example, we are using the default selection table T5UPBSPA24 to hold the data to be selected via the configured access method CL_HRPBSUSPA_VT=>BASIC_PAY_01. In this case, we specify in view V_T5UPBSPA22 that the return field is 'LOPAY'. In the selection criteria, we show only the date selection, so this example is not complete. For the date selection we configure the following values:
Seq No DBFLD Inc/Exc Option Low Value High Value
001 BEGDA I LE I_EFF_DATE
002 ENDDA I GE I_EFF_DATE
Here the table field T5UPBSPA24-BEGDA must be less than or equal to I_EFF_DATE and the table field T5UPBSPA24-ENDDA must be greater than or equal to I_EFF_DATE.
History
Last changed by/on | SAP | 20050428 |
SAP Release Created in | 600 |