Alphanumeric Range

former_member462254 — Fri, 28 Nov 2014 05:56:30 GMT

Hello Experts,

There is a requirement to fetch data from T343 table with below mentioned fields. Here i am facing problem with the char fields STAWE / ENDWE which can't be used as a range (start and end of storage bins) / LT, GT, GE, LE in where clause because of its char type

SELECT SINGLE* from t343 INTO lw_t343

                    WHERE lgnum = lagp-LGNUM

                      and lgtyp = lagp-lgtyp

                      and lptyp = lagp-lptyp

                      and lgber = lagp-lgber

                     and stawe ge lagp-lgpla   ===> stawe - char type

                     and endwe le lagp-lgpla. ===> endwe - char type

Reuirement : need to fetch Total capacity of storage bin ( T343-LKAPV) from Table: T343 which must exist between the range of

T343-STAWE & T343-ENDWE

=> I do have above mentioned parameters in where clause but unable to fetch appropriate data from same query.

Note: don't have value of sequence No. T343-LFDNR here

Thanks and Regards,

Anoop

Re: Alphanumeric Range

former_member191761 — Fri, 28 Nov 2014 06:04:34 GMT

Hi Anoop,

What are the values that you have in T343-STAWE & T343-ENDWE and LAGP-LGPLA fields?

for Character fields, you have to use operators like CP, CS, CO etc .

Else you can create a range table for LAGP-LGPLA values and use that range table in where condition like stawe in Range table.

Regards

Sri

Re: Alphanumeric Range

former_member191761 — Mon, 01 Dec 2014 09:36:34 GMT

hi Anoop,

Was your problem solved?

Regards

Sri

topic Re: Alphanumeric Range in Application Development and Automation Discussions

Alphanumeric Range

Re: Alphanumeric Range

Re: Alphanumeric Range