SAP Function TB_LIMIT_CHARS_MAIN - Central Distributor for DB Access Keys to Limit Characteristics

Parameter Reference Type Length Default Optional Text
IR_BUKRS LMALV_T_R_BUKRS 0 X Range for Company Code (Import)
IR_CONTROL01 LMALV_T_R_CONTROL01 0 X Range for Monitoring Unit (Import)
IR_COUNTRY LMALV_T_R_COUNTRY 0 X Range for Country (Import)
IR_CRATING LMALV_T_R_CRATING 0 X Range for Rating of Relevant Country for Country Risk (Import)
IR_INTORG LMALV_T_R_INTORG 0 X Range for Internal Organization Unit (Import)
IR_PARTNR LMALV_T_R_PARTNR 0 X Range for Business Partner (Import)
IR_RATING LMALV_T_R_RATING 0 X Range for Rating (Import)
IR_RCID01 LMALV_T_R_RCID 0 X Range for Customer Characteristic 1 (Import)
IR_RCID02 LMALV_T_R_RCID 0 X Range for Customer Characteristic 2 (Import)
IR_RCID03 LMALV_T_R_RCID 0 X Range for Customer Characteristic 3 (Import)
IR_RCID04 LMALV_T_R_RCID 0 X Range for Customer Characteristic 4 (Import)
IR_RCID05 LMALV_T_R_RCID 0 X Range for Customer Characteristic 5 (Import)
IR_RCID06 LMALV_T_R_RCID 0 X Range for Customer Characteristic 6 (Import)
IR_RCID07 LMALV_T_R_RCID 0 X Range for Customer Characteristic 7 (Import)
IR_RCID08 LMALV_T_R_RCID 0 X Range for Customer Characteristic 8 (Import)
IR_RCID09 LMALV_T_R_RCID 0 X Range for Customer Characteristic 9 (Import)
IR_RCID10 LMALV_T_R_RCID 0 X Range for Customer Characteristic 10 (Import)
IR_RCID11 LMALV_T_R_RCID 0 X Range for Customer Characteristic 11 (Import)
IR_RCID12 LMALV_T_R_RCID 0 X Range for Customer Characteristic 12 (Import)
IR_RCID13 LMALV_T_R_RCID 0 X Range for Customer Characteristic 13 (Import)
IR_RCID14 LMALV_T_R_RCID 0 X Range for Customer Characteristic 14 (Import)
IR_RCID15 LMALV_T_R_RCID 0 X Range for Customer Characteristic 15 (Import)
IR_RCOUNTRY LMALV_T_R_RCOUNTRY 0 X Range for Relevant Country for Country Risk (Import)
IR_RDEALER LMALV_T_R_RDEALER 0 X Range for Traders (Import)
IR_RLV TRLM_T_R_RLV 0 X Transfer Structure Ranges: Limit Record Number
IR_RPORTB LMALV_T_R_RPORTB 0 X Range for Portfolio (Import)
IR_SECTOR LMALV_T_R_SECTOR 0 X Range for Industry Sectors (Import)
IR_SLA TRLM_T_R_SLA 0 X Transfer Structure Ranges: Limit Type
IR_SLDFIL TRLM_T_R_SLDFIL 0 X Range for Display Filters
IR_SLH TRLM_T_R_SLH 0 X Transfer Structure Ranges: Hierarchy Level
IR_SLPG LMALV_T_R_SLPG 0 X Range for Limit Product Group (Import)
IR_WAERS LMALV_T_R_WAERS 0 X Range for Characteristic Currency (Import)
IT_ENTRIES_LA TRLM_T_LA 0 X Selection Table for I_ACCESS_MODE = '2' and '3'
IT_ENTRIES_LKEY TRLM_T_TAKEY 0 X Selection Table for I_ACCESS_MODE = '2' and '3'
IT_ENTRIES_LM TRLM_T_LM 0 X Selection Table for I_ACCESS_MODE = '2' and '3'
IT_WHERE RSDS_TWHERE 0 X Not when I_ACCESS_MODE = '2', see coding
I_ACCESS_MODE C C 0 '1' X ==> Long Text
I_CLEAR_VTBLS BOOLE-BOOLE C 1 'X' X Delete Export Table Before Selection?
I_INCLUDE_INITIAL_VALUES BOOLE-BOOLE C 1 X Select Initial Values Additionally
I_LS TRLM_LS3 0 X Limits: Mapping Logical - Physical Keys
I_MAX_FIELD FELD-NAME C 132 X Returns Max ( Field Name in i_max_field in e_max
I_ROWS SYST-TABIX I 4 0 X Option: ... up to x Rows

Parameter Reference Type Length Text
E_MAX 0 See I_MAX_FIELD

Parameter Reference Type Length Default Optional Text
CT_VTBLS TRLM_T_LS 0 X Limit Records

Exception Text
EXPRESSION_ERROR Internal Error When Converting WHERE Condition
FNAME_ERROR Incorrect Field Name in I_MAX_FIELD
PARAM_ERROR Invalid Call

Description
Access mode, that is the mode of the select statement, the where clausein particular.

Value range
'1': Access via specified range tables (IR_xxx).
'2': Access ... for all entries ... via specified entry tables: EITHER:IT_ENTRIES_LM in the format TRLM_T_LM (characteristics) OR IT_ENTRIES_LA(only limit types) OR IT_ENTRIES_LKEY. The or is an XOR (exclusive or).
'3': Mode '1' and '2' simultaneously, that is both IR_xxx andI_ENTRIES_Lx are considered.
'4': Access via characteristic structure I_LS: Empty fields in thestructure are NOT considered.
In each case you can also choose to specify an additional selectionusing the parameter IT_WHERE.

Description
Means that the DB query also views initial values contained in fieldsfor the database as hits.
Maps the following statements:
a) for I_ACCESS_MODE 1, 3, and 4:
Select * from dbtab
where ( field in Range OR field = '' ).
b) for I_ACCESS_MODE 2 and 3:
Select * from dbtab for all entries in entriestab
where ( field = entriestab-field or field = '').