Dynamic select query using source syntax

[snekha]

Introduction:

This blog intends dynamic fields or table selection in select query based on the condition. My requirement is to show vendor or customer details based on T-code. A traditional approach is to use conditional statement (IF .. ELSE)  to determine fields, table and where condition. However, there is an alternative and dynamic approach by utilizing source syntax which eliminates reductant code

Step 1: Declare type as below image.

Step 2: Declare internal table as common for both vendor or customer details.
Note: Inline declaration in select query is not possible in source syntax

Step 3: Map the structure(ls_source_syntax) based on T-Code

1. Column - Based on T-code map the required fields.
2. Source - Based on T-Code map the required table.
3. Where – based on T-Code map the selection option

Step 4: Dynamically fields, table, where get mapped based on T-code as shown in the image

Case 1: T-Code: ZLIFNR – Vendor details for particular vendor.

Step1: Pass the input and execute

Output:

Case 2: T-Code: ZKUNNR – Customer details

Step1: Pass the input and execute

Output:

Conclusion:

With the source syntax, we can construct select query dynamically based on our requirement to make more flexible instead of traditional approach.