topic Re: Range Table to Select Statement in Application Development and Automation Discussions

Range Table to Select Statement

sap_cohort — Tue, 21 Nov 2006 16:41:37 GMT

Anyone know a function module or example code to convert a range table of selections to SQL Selections? I need to convert the following format to SQL Select. The BT seems hardest to convert. Example: 1/3/06 BT 1/10/06

CHANM	RSCHANM	CHAR	30
SIGN	RALDB_SIGN	CHAR	1
COMPOP	RSDRI_COMPOP	CHAR	2
LOW	RSCHAVL	CHAR	60
HIGH	RSCHAVL	CHAR	60

Re: Range Table to Select Statement

Former Member — Tue, 21 Nov 2006 16:45:15 GMT

Hi,

Use the IN operator in the WHERE clause of the select statement..

ex.

RANGES: R_MATNR FOR MARA-MATNR.

SELECT * FROM MARA

WHERE MATNR IN R_MATNR.

is this what you want..

Do you want to build the where clause for a range ..Then use the function module ASEL_CEDST_2_RANGE_WHERE..

Thanks,

Naren

Re: Range Table to Select Statement

sap_cohort — Tue, 21 Nov 2006 16:49:46 GMT

Thanks for the reply! Unfortunately there are multiple characteristics in the range table. Also, in my bw system I don't have access to that Function Module. Any more ideas?

Thanks!

Re: Range Table to Select Statement

sap_cohort — Tue, 21 Nov 2006 16:51:02 GMT

Hi, I found the Function Module RSDS_RANGE_TO_WHERE in my BW system. It was a matter of knowing which keywords to look for. Thanks for the help!

Re: Range Table to Select Statement

former_member194669 — Tue, 21 Nov 2006 17:08:07 GMT

Hi,

Try to use FREE_SELECTIONS_RANGE_2_WHERE. Its will be a dynamic selection convertion.

aRs

Re: Range Table to Select Statement

Former Member — Tue, 21 Nov 2006 17:18:12 GMT

HI,

See the below FM's

ARBW_SELECT_RANGES_FILL

G_SET_DYNAMIC_LIST_RANGES

TR_FILL_RANGES

Re: Range Table to Select Statement

sap_cohort — Tue, 21 Nov 2006 21:19:15 GMT

Thanks. This one didn't work as it fails when an entity has a numeric value. Ex. 0CALDAY

Re: Range Table to Select Statement

sap_cohort — Tue, 21 Nov 2006 21:19:59 GMT

Thanks for the help.

I Found FM F4_CONV_SELOPT_TO_WHERECLAUSE to help me out..

Re: Range Table to Select Statement

uwe_schieferstein — Tue, 21 Nov 2006 21:23:54 GMT

Hello Kenneth

Perhaps function module RH_DYNAMIC_WHERE_BUILD may be the one you are looking for. You fill TABLES parameter condtab with your conditions and the clause is returned in where_clause.

Regards

Uwe

Re: Range Table to Select Statement

sap_cohort — Wed, 22 Nov 2006 14:29:52 GMT

Thanks, but I found FM F4_CONV_SELOPT_TO_WHERECLAUSE to help me out.. Doesn't require and other parameters than the range table and doesn't do any DB Checks...

Thanks!