Alphanumeric Range

[former_member462254]

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

[former_member191761]

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

[former_member191761]

hi Anoop,

Was your problem solved?

Regards

Sri