Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Display vendor names with all combinations of a parameter

This tip using a dynamic where clause will reveal a list of all vendor names with all combinations of a parameter.

This piece of code will show a list with all the vendor names and all the combinations of a given parameter.

Study the select statement carefully and the usage of the dynamic where clause. Also notice the usage of the field symbols.

  
REPORT ZDEMO_LIKE_STATEMENT.

DATA L_NAME1 LIKE LFA1-NAME1,
L_SYMBOL VALUE '%'.
FIELD-SYMBOLS &ltFS> TYPE ANY.
DATA : T_LFA1 LIKE LFA1 OCCURS 0 with header line.
PARAMETERS : NAME1 LIKE LFA1-NAME1.
CONCATENATE NAME1 L_SYMBOL INTO L_NAME1.
ASSIGN L_NAME1 TO &ltFS>.
SELECT * FROM LFA1 INTO TABLE t_LFA1 WHERE NAME1 LIKE &ltFS>.
This was last published in March 2005

Dig Deeper on SAP ABAP

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close