SAP ABAP Data Element RKE_LFDNR (Sequence Number for Selection Condition)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KE (Package) Profitability Analysis
Basic Data
Data Element RKE_LFDNR
Short Description Sequence Number for Selection Condition  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type NUMC4    
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 Seq. no. 
Medium 15 Sequence number 
Long 20 Sequence number 
Heading 5 SeqNo 
Documentation

Note

Currently, the upper level selections of RKE_READ_OBJECTS are being read. The application itself has to filter you the records required. Later, the function module will only find the records requested in the selection table.

Definition

The sequential number means that several selections can be linked together in the following way:

S = S1 or S2 or S3 ... or Sn

or as follows:

S = S0 and (S1 or S2 or S3 ... or Sn) , or

S = (S0 and S1) or (S0 and S2) or (S0 and S3) ... or (S0 and Sn)

where S is the total selection variant, S0 the selection variant of sequential number 0, S1 the selection variant of sequential number 1, Sn the selection variant of sequential number n.

Within a selection, the conditions which relate to the same field are linked with or; the conditions which relate to different fields are linked with and.

Examples

Comparison report: Plan data 1995 / Actual data 1994 for customer 4711 / product 4711 is selected as follows:

Selection 1     Selection 2

KNDNR EQ 4711    KNDNR EQ 4711 (where KNDNR = customer)

ARTNR EQ 4711    ARTNR EQ 4711 (where ARTNR = product)

PLIKZ EQ 1     PLIKZ EQ 0 (where PLIKZ = plan/act.data flag)

GJAHR EQ 1995    GJAHR EQ 1994 (where GJAHR = fiscal year)

When you use the selection table with sequential numbering, it looks like this:

    SeqNo    FIELDNAME    OP    Value

    0001    KNDNR    EQ    4711
    0001    ARTNR    EQ    4711
    0001    PLIKZ    EQ    1
    0001    GJAHR    EQ    1995
    0002    KNDNR    EQ    4711
    0002    ARNTR    EQ    4711
    0002    PLIKZ    EQ    0
    0002    GJAHR    EQ    1994

For the purposes of accessing the database, it is simpler to exclude the common section by using seqential number 0:

    SeqNo    FIELDNAME    OP    Value

    0000    KNDNR    EQ    4711
    0000    ARTNR    EQ    4711
    0001    PLIKZ    EQ    1
    0001    GJAHR    EQ    1995
    0002    PLIKZ    EQ    0
    0002    GJAHR    EQ    1994

This selection table corresponds to the following statement:

SELECT .... WHERE ( KNDNR = '4711' AND ARTNR = '4711') 
                    AND (    (PLIKZ = 1      AND GJAHR = 1995) 
                          OR (PLIKZ = 0      AND GJAHR = 1994) )
History
Last changed by/on SAP  19940827 
SAP Release Created in 470