SAP ABAP Interface IF_FDT_DB_LOOKUP (FDT: DB Lookup)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-SRV-BR (Application Component) BRFplus - ABAP-Based Business Rules
⤷
SFDT_EXPRESSIONS (Package) BRFplus: Expressions
⤷
⤷
Meta Relationship - Used By
| # | Relationship type | Used by | Short Description | Created on |
|---|---|---|---|---|
| 1 | Interface implementation (CLASS c. INTERFACES i_ref) | CL_FDT_DB_LOOKUP | FDT: DB Lookup | 20061206 |
Properties
| Interface | IF_FDT_DB_LOOKUP | |
| Short Description | FDT: DB Lookup |
General Data
| Package | SFDT_EXPRESSIONS | BRFplus: Expressions |
| Created | 20061206 | SAP |
| Last changed | 20140121 | SAP |
| Unicode checks active |
Forward declarations
| # | Type group / Object type | Type | Type Description |
|---|---|---|---|
| 1 | ABAP | Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
| 2 | IF_FDT_CONSTANTS | Forward declaration interface (INTERFACE i DEFINITION DEF... | Forward declaration interface (INTERFACE i DEFINITION DEF... |
| 3 | IF_FDT_ELEMENT | Forward declaration interface (INTERFACE i DEFINITION DEF... | Forward declaration interface (INTERFACE i DEFINITION DEF... |
| 4 | IF_FDT_TYPES | Forward declaration interface (INTERFACE i DEFINITION DEF... | Forward declaration interface (INTERFACE i DEFINITION DEF... |
Interfaces
| # | Interface | Abstract | Final | Description | Created on |
|---|---|---|---|---|---|
| 1 | IF_FDT_EXPRESSION | FDT: Expression | 20061206 |
Friends
Interface IF_FDT_DB_LOOKUP has no friend.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | GC_AGGREGATION_FUNCTION_AVG | Constant | Public | Type reference (TYPE) | AGGREGATION_FUNCTION | 'AVG' | Aggregate Function "Average" | 20081105 | |
| 2 | GC_AGGREGATION_FUNCTION_COUNT | Constant | Public | Type reference (TYPE) | AGGREGATION_FUNCTION | 'COUNT' | Aggregate Function "Count" | 20081105 | |
| 3 | GC_AGGREGATION_FUNCTION_MAX | Constant | Public | Type reference (TYPE) | AGGREGATION_FUNCTION | 'MAX' | Aggregate Function "Max" | 20081105 | |
| 4 | GC_AGGREGATION_FUNCTION_MIN | Constant | Public | Type reference (TYPE) | AGGREGATION_FUNCTION | 'MIN' | Aggregate Function "Min" | 20081105 | |
| 5 | GC_AGGREGATION_FUNCTION_SUM | Constant | Public | Type reference (TYPE) | AGGREGATION_FUNCTION | 'SUM' | Aggregate Function "Sum" | 20081105 | |
| 6 | GC_EXTY_DB_LOOKUP | Constant | Public | Type reference (TYPE) | IF_FDT_TYPES=>ID | IF_FDT_CONSTANTS=>GC_EXTY_DB_LOOKUP | Expression Type "DB Lookup" | 20080417 | |
| 7 | GC_MODE_AGGREGATION_SELECT | Constant | Public | Type reference (TYPE) | FDT_SELECT_MODE | 'AS' | Aggregation Select | 20081105 | |
| 8 | GC_MODE_EXISTENCE_CHECK | Constant | Public | Type reference (TYPE) | FDT_SELECT_MODE | 'EC' | Existence Check | 20081105 | |
| 9 | GC_MODE_SELECT | Constant | Public | Type reference (TYPE) | FDT_SELECT_MODE | ' ' | Normal select | 20081105 | |
| 10 | GC_OPTION_BETWEEN | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_BETWEEN | Between ... and ... | 20080326 | |
| 11 | GC_OPTION_CONTAINS_PATTERN | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_CONTAINS_PATTERN | Matches pattern | 20080326 | |
| 12 | GC_OPTION_EQUAL | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_EQUAL | Equal to | 20080326 | |
| 13 | GC_OPTION_GREATER | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_GREATER | Greater than | 20080326 | |
| 14 | GC_OPTION_GREATER_EQUAL | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_GREATER_EQUAL | Greater than or equal to | 20080326 | |
| 15 | GC_OPTION_INITIAL | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_INITIAL | Is initial | 20080326 | |
| 16 | GC_OPTION_LESS | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_LESS | Less than | 20080326 | |
| 17 | GC_OPTION_LESS_EQUAL | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_LESS_EQUAL | Less than or equal to | 20080326 | |
| 18 | GC_OPTION_NOT_BETWEEN | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_NOT_BETWEEN | Not between ... and ... | 20080326 | |
| 19 | GC_OPTION_NOT_CONTAINS_PATTERN | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_NOT_CONTAINS_PATTERN | Does not match pattern | 20080326 | |
| 20 | GC_OPTION_NOT_EQUAL | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_NOT_EQUAL | Not equal to | 20080326 | |
| 21 | GC_OPTION_NOT_INITIAL | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>OPTION | IF_FDT_ELEMENT=>GC_OPTION_NOT_INITIAL | Is not initial | 20080326 | |
| 22 | GC_SIGN_EXCLUDE | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>SIGN | IF_FDT_ELEMENT=>GC_SIGN_EXCLUDE | Range limit excluded | 20080326 | |
| 23 | GC_SIGN_INCLUDE | Constant | Public | Type reference (TYPE) | IF_FDT_ELEMENT=>SIGN | IF_FDT_ELEMENT=>GC_SIGN_INCLUDE | Range limit included | 20080326 | |
| 24 | MV_ACTION | Instance attribute | Public | Attribute reference (LIKE) | 20071228 | ||||
| 25 | MV_CUSTOMIZING_OBJECT | Instance attribute | Public | Attribute reference (LIKE) | 20071228 | ||||
| 26 | MV_EXPRESSION_TYPE_ID | Instance attribute | Public | Attribute reference (LIKE) | 20071228 | ||||
| 27 | MV_ID | Instance attribute | Public | Attribute reference (LIKE) | 20061212 | ||||
| 28 | MV_LOCAL_OBJECT | Instance attribute | Public | Attribute reference (LIKE) | 20071228 | ||||
| 29 | MV_MASTERDATA_OBJECT | Instance attribute | Public | Attribute reference (LIKE) | 20071228 | ||||
| 30 | MV_OBJECT_TYPE | Instance attribute | Public | Attribute reference (LIKE) | 20071228 | ||||
| 31 | MV_RULE | Instance attribute | Public | Attribute reference (LIKE) | 20071228 | ||||
| 32 | MV_SYSTEM_OBJECT | Instance attribute | Public | Attribute reference (LIKE) | 20071228 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | Instance method | Public | Method | Returns the aggregation function | 20081103 | |
| 2 | Instance method | Public | Method | Get Dynamic Database View | 20130122 | |
| 3 | Instance method | Public | Method | Returns the conditions for the DB lookup | 20061206 | |
| 4 | Instance method | Public | Method | Get the field mapping | 20081112 | |
| 5 | Instance method | Public | Method | Get the mode of the Select | 20081105 | |
| 6 | Instance method | Public | Method | Get parameter binding for dynamic database view | 20130219 | |
| 7 | Instance method | Public | Method | Returns the single flag | 20061206 | |
| 8 | Instance method | Public | Method | Returns the DB table name to read from | 20061208 | |
| 9 | Instance method | Public | Method | Sets the aggregation function | 20081103 | |
| 10 | Instance method | Public | Method | Set Dynamic Database View | 20130122 | |
| 11 | Instance method | Public | Method | Sets the conditions for the DB lookup | 20061206 | |
| 12 | Instance method | Public | Method | Set the field mapping | 20081112 | |
| 13 | Instance method | Public | Method | Set the mode of the Select | 20081105 | |
| 14 | Instance method | Public | Method | Set parameter binding for dynamic database view | 20130219 | |
| 15 | Instance method | Public | Method | Sets the single flag for the DB lookup | 20061206 | |
| 16 | Instance method | Public | Method | Sets the DB table to read from | 20061208 |
Events
Interface IF_FDT_DB_LOOKUP has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | AGGREGATION_FUNCTION | Public | Type reference (TYPE) | FDT_INC_EXPR_2200_DATA-AGGR_FNCT | Aggregation Function (see GC_AGGREGATION_FUNCTION*) | 20081103 | |
| 2 | S_BINDING | Public | See coding | 20130220 | BEGIN OF s_binding,
position TYPE int2,
object_id TYPE if_fdt_types=>id, "Context DO or Expression.
r_object_value TYPE REF TO data, "For direct value input
parameter_id TYPE if_fdt_types=>id, "DDBV input parameter ID
END OF s_binding
|
||
| 3 | S_FIELD_CONDITION | Public | See coding | Field Condition | 20061206 | BEGIN OF s_field_condition,
fieldname TYPE fieldname,
sign TYPE ddsign,
option TYPE ddoption,
low TYPE if_fdt_types=>id,
low_value TYPE char70,
high TYPE if_fdt_types=>id,
high_value TYPE char70,
aggr_fnct TYPE fdt_aggr_fnct,
position TYPE int2,
END OF s_field_condition
|
|
| 4 | S_FIELD_MAPPING | Public | See coding | Field Mapping | 20081112 | BEGIN OF s_field_mapping ,
db_field_name TYPE fieldname,
object_id TYPE if_fdt_types=>id,
aggr_fnct TYPE fdt_aggr_fnct,
pos TYPE int2,
END OF s_field_mapping
|
|
| 5 | TS_FIELD_CONDITION | Public | See coding | Field Conditions | 20061206 | ts_field_condition TYPE SORTED TABLE OF s_field_condition
WITH UNIQUE KEY fieldname sign option low low_value high high_value
|
|
| 6 | TS_FIELD_MAPPING | Public | See coding | Field Mappings | 20081112 | ts_field_mapping TYPE SORTED TABLE OF s_field_mapping
WITH UNIQUE KEY pos
|
|
| 7 | T_BINDING | Public | See coding | 20130220 | t_binding TYPE STANDARD TABLE OF s_binding WITH DEFAULT KEY
|
Method Signatures
Method GET_AGGREGATION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | EV_AGGREGATION_FIELD | Call by reference | Type reference (TYPE) | FIELDNAME | Field Name | 20081103 | |||
| 2 | EV_AGGREGATION_FUNCTION | Call by reference | Type reference (TYPE) | AGGREGATION_FUNCTION | R/2 table | 20081103 | |||
| 3 | EV_DISTINCT | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE if distinct selection | 20090107 | |||
| 4 | IV_TIMESTAMP | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>TIMESTAMP | Time Stamp (active version) | 20081105 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20081103 |
Method GET_DDBV Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_TIMESTAMP | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>TIMESTAMP | Time Stamp (active version, UTC) | 20130122 | |||
| 2 | RV_DDBV_ID | Value transfer | Type reference (TYPE) | IF_FDT_TYPES=>ID | Universal Unique Identifier | 20130122 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20130122 |
Method GET_FIELD_CONDITIONS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_TIMESTAMP | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>TIMESTAMP | 20061208 | ||||
| 2 | RTS_FIELD_CONDITION | Value transfer | Type reference (TYPE) | TS_FIELD_CONDITION | 20061206 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20061208 |
Method GET_MAPPING Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_TIMESTAMP | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>TIMESTAMP | Time Stamp (active version) | 20081112 | |||
| 2 | RTS_FIELD_MAPPING | Value transfer | Type reference (TYPE) | TS_FIELD_MAPPING | 20081112 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20081112 |
Method GET_MODE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_TIMESTAMP | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>TIMESTAMP | Time Stamp (active version) | 20081105 | |||
| 2 | RV_MODE | Value transfer | Type reference (TYPE) | FDT_SELECT_MODE | FDT: Select mode for DB Lookup | 20081110 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | 20081105 |
Method GET_PARAMETER_BINDING Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_TIMESTAMP | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>TIMESTAMP | Time Stamp (active version, UTC) | 20130219 | |||
| 2 | RT_BINDING | Value transfer | Type reference (TYPE) | T_BINDING | 20130221 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20130219 |
Method GET_SINGLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_TIMESTAMP | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>TIMESTAMP | 20061208 | ||||
| 2 | RV_SINGLE | Value transfer | Type reference (TYPE) | ABAP_BOOL | 20061208 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20061208 |
Method GET_TABLE_NAME Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_TIMESTAMP | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>TIMESTAMP | 20061208 | ||||
| 2 | RV_TABLE_NAME | Value transfer | Type reference (TYPE) | TABNAME | Table Name | 20061208 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20061208 |
Method SET_AGGREGATION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_AGGREGATION_FIELD | Call by reference | Type reference (TYPE) | FIELDNAME | Field Name | 20081103 | |||
| 2 | IV_AGGREGATION_FUNCTION | Call by reference | Type reference (TYPE) | AGGREGATION_FUNCTION | 20081103 | ||||
| 3 | IV_DISTINCT | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | Distinct selection | 20090107 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20081103 |
Method SET_DDBV Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_DDBV_ID | Call by reference | Type reference (TYPE) | IF_FDT_TYPES=>ID | Universal Unique Identifier | 20130122 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20130122 |
Method SET_FIELD_CONDITIONS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ITS_FIELD_CONDITION | Call by reference | Type reference (TYPE) | TS_FIELD_CONDITION | 20061208 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20061208 |
Method SET_MAPPING Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ITS_FIELD_MAPPING | Call by reference | Type reference (TYPE) | TS_FIELD_MAPPING | 20081112 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20081201 |
Method SET_MODE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_MODE | Call by reference | Type reference (TYPE) | FDT_SELECT_MODE | GC_MODE_SELECT | FDT: Select mode for DB Lookup | 20081105 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20081201 |
Method SET_PARAMETER_BINDING Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IT_BINDING | Call by reference | Type reference (TYPE) | T_BINDING | 20130220 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | FDT: Invalid Input | 20130219 |
Method SET_SINGLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_SINGLE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20061208 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | 20061208 |
Method SET_TABLE_NAME Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | IV_TABLE_NAME | Call by reference | Type reference (TYPE) | TABNAME | Table Name | 20061208 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | 20061208 |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 710 |