topic Table has data but not selecting in program in Application Development and Automation Discussions

Table has data but not selecting in program

Former Member — Fri, 21 Sep 2007 10:49:02 GMT

Hi,

I have a problem with below piece of code.

I have data in the table VBAP and on debugging i could see value for ITAB_CATSDB-PERNR, but still the select is not fetching any rows.

===========================================================

SELECT SINGLE * FROM VBAP WHERE MATNR EQ ITAB_CATSDB-PERNR.

IF VBAP-ARKTX NE ''.

ITAB_CATSDBTEMP-ARKTX = VBAP-ARKTX.

ENDIF.

===========================================================

regards

Balaji

Former Member — Fri, 21 Sep 2007 10:52:10 GMT

Hi Balaji,

Into Is Missing.

SELECT SINGLE * FROM VBAP <b>into table "your internal table "</b> WHERE MATNR EQ ITAB_CATSDB-PERNR.

Thanks,

Reward If Helpful.

Former Member — Fri, 21 Sep 2007 10:53:01 GMT

may be it is due to leading zero problem

try like this

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = ITAB_CATSDB-PERNR

IMPORTING

OUTPUT = ITAB_CATSDB-PERNR

SELECT SINGLE * FROM VBAP WHERE MATNR EQ ITAB_CATSDB-PERNR.

IF VBAP-ARKTX NE ''.

ITAB_CATSDBTEMP-ARKTX = VBAP-ARKTX.

ENDIF.

it may work.

regards

shiba dutta

Former Member — Fri, 21 Sep 2007 10:56:18 GMT

Hi,

You need to use 'CONVERSION_EXIT_ALPHA_INPUT' functionmodule to conver the field to internal format then only write the Select statment

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = ITAB_CATSDB-PERNR

IMPORTING

OUTPUT = ITAB_CATSDB-PERNR

Regards

Sudheer