SAP ABAP Data Element /BCV/QRM_ROW_LIMIT_SSEQNO (Sort Sequence Number of Row Limit)

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_ROW_LIMIT_SSEQNO
Short Description	Sort Sequence Number of Row Limit

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	Limit SNo.
Medium	15	Limit Seq.No.
Long	21	Seq. No. of Row Limit
Heading	40	Sort Sequence Number of Row Limit

Documentation

Definition

Use

In this field, you specify which result records belong to the same result class. A result class contains all result records where certain result fields have the same values. The system considers all result fields that have a sort sequence number lower than or equal to the number you entered in this field. If none of the result fields fulfill this condition, the system does not determine result classes.

Dependencies

You have to enter a value in the Row Limit (Row Limit) field of the Query Header detailed view. The row limit specifies the maximum number of result records per result class that the system returns.

Example

You can use result classes to create statistics, for example, to find the top three customers per year regarding sales volume. Assume that a query contains the result fields CUSTOMER, YEAR, and SALES (representing sales volume per customer and year). The result data returned from the search connector is the following:

CUSTOMER YEAR SALES

CUST01 2007 100,000

CUST01 2008 300,000

CUST02 2007 200,000

CUST03 2007 400,000

CUST03 2008 500,000

CUST04 2007 600,000

If you are interested in the top three customers per year regarding sales volume, you have to do the following:

To specify that the system determines result classes for calendar years, enter 1in the Limit SNo. (Sort Sequence Number of Row Limit) field and in the Sort Seq. (Sort Sequence Number of Query Result Field) field of the result field YEAR.
To specify that the system sorts the result records in each result class descending by the sales volume, enter 2 in the Sort Seq. (Sort Sequence Number of Query Result Field) field, and select Descending in the Sort Dir. (Sort Direction of Query Result Field) field of the query result field SALES.
To specify that you are only interested in the three best customers of each result class, enter 3 in the Row Limit (Row Limit) field.

After determination of the result classes, the result data is the following: