SAP ABAP Data Element ADMI_WCLAU (Where Clause of Method SELECT)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-ADK (Application Component) Archive Development Kit
     ⤷ SARC (Package) Archive Development Kit
Basic Data
Data Element ADMI_WCLAU
Short Description Where Clause of Method SELECT  
Data Type
Category of Dictionary Type     Direct Type Entry
Type of Object Referenced     No Information
Domain / Name of Reference Type      
Data Type STRG   Character String of Variable Length 
Length 0    
Decimal Places 0    
Output Length 0    
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 Where Cl. 
Medium 20 Where Clause 
Long 40 Where Clause of Select Statement 
Heading 40 Where Clause of Select Statement 
Documentation

Definition

A search criterion in the form of an OpenSQL WHERE clause for method SELECT.

Use

In the search for resources in a property index using specific properties, the search criterion is formulated as an OpenSQL WHERE clause.

In addition to the properties of the index you can also use the following properties in the WHERE clause:

  • resType: Type of resource; all capitalized ('XML', 'XSD', 'XSL', 'BIN')
  • resLength: Size of the resource in bytes
  • checkStatus: Status of the check ('_' = not checked; 'W' = well-formed, 'V' = valid; 'I' = invalid, 'N' = not well-formed)
  • isPacked: packed ('Y' = yes, 'N' = no)

Dependencies

Example

Based on a property index for flight bookings, which contains the properties CARRID and FLDATE, the WHERE clauses return the following:

  • CARRID = 'LH'
  • ( FLDATE LIKE '2003%' ) AND ( checkStatus = 'V' )
  • ( ( CARRID <> 'LH' ) OR ( resLength < 1000 ) )

The URIs of the flight bookings

  • for the carrier "LH"
  • for flights in the year 2003 that were already validated in the system
  • for flights by carriers other than "LH" and for "LH" fights, whose XML representation uses up less than 1000 bytes.

History
Last changed by/on SAP  20110908 
SAP Release Created in 640