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 Content Component encountered an error
This Content Component encountered an error

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 <FS> 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 <FS>.
SELECT * FROM LFA1 INTO TABLE t_LFA1 WHERE NAME1 LIKE <FS>.
This was first published in March 2005

Dig deeper on SAP ABAP

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close