Hierarchy
SAP_BS_FND (Software Component) SAP Business Suite Foundation⤷
CA-EPT-BCV (Application Component) Business Context Viewer⤷
/BCV/QRM (Package) BCV Query Management Layer
Basic Data
| Data Element | /BCV/QRM_RES_ATTR_SSEQNO |
| Short Description | Sort Sequence Number of Query Result Field |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | /BCV/FND_SEQUENCE_NO | |
| Data Type | NUMC | Character string with only digits |
| Length | 4 | |
| Decimal Places | 0 | |
| Output Length | 4 | |
| 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 | Sort Seq. |
| Medium | 15 | Sort Seq. No. |
| Long | 20 | Sort Seq. No. |
| Heading | 10 | Sort Seq. |
Documentation
Definition
Use
In this field, you enter a number that specifies the order in which the system sorts the query result data. The number specifies the position of the result field within the sort criteria. If you do not enter a number, the system does not consider the query result field as sort criterion. If you do not enter a sort sequence number for any of the result fields, the system returns the result data in an arbitrary order.
Dependencies
In the Sort Dir. (Sort Direction of Query Result Field) field, you can specify whether the system sorts the result data according to this result field in ascending or descending order. The system uses the ascending order as a default value.
Example
Assume that a query contains the query result fields MATERIAL, DATE, and QUANTITY (representing sales orders). For MATERIAL, you have specified sort sequence number 1 and sort direction Ascending. For DATE, you have specified sort sequence number 2 and sort direction Descending. The result data retrieved from the search connector looks like this:
MATERIAL DATE QUANTITY
PROD03 01.06.2008 100
PROD02 03.06.2008 200
PROD01 01.06.2008 300
PROD03 03.06.2008 400
After sorting, the result data looks like this:
MATERIAL DATE QUANTITY
PROD01 01.06.2008 300
PROD02 03.06.2008 200
PROD03 03.06.2008 400
PROD03 01.06.2008 100
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 701 |
