Standard input output conversion not version for one user

[Former Member]

Hi All,

I am facing an issue which i never seen before, hope some can help me.

I am a developer and using my ID to run a FM, this FM have a select statement which runs perfectly fine with me, but when my functional consultant login with her ID this select statement not works.

here is the select statement.

SELECT *

         FROM    /ZDSI/DB_SERIAL

         INTO    CORRESPONDING FIELDS OF TABLE LT_DB_SERIAL

        WHERE PHYSINVENTORY EQ LV_PHYSICAL_INVENTORY AND

                      FISCALYEAR          EQ LV_FISCAL_YEAR        AND

                      ITEMNUMBER        EQ <FS_ITEMS>-ITEM.

variable has the below values,

LV_PHYSICAL_INVENTORY =  0100000880,

LV_FISCAL_YEAR                 = 2015,

<FS_ITEMS>-ITEM                = 001

now in table /ZDSI/DB_SERIAL the values are like

LV_PHYSICAL_INVENTORY =  100000880,

LV_FISCAL_YEAR                 = 2015,

<FS_ITEMS>-ITEM                = 1

so the problem is its works with my id which is normal, but with other id its not able to get the record from table.

I know its some thing to do with standard conversion in SAP, but not sure what to do here. Any idea.

[Former Member]

Hello,

What are the domains of your fields? Inside the domain check the conversion exits:

I used matnr as a example: Conversion Routine:

If your domains don't have a conversion routine for input and output. Maybe you will have to deal with it in program, before your select.

Regards,

Thales Schmidt

[former_member184158]

you have to use this conversion

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

   EXPORTING

     input         = LV_PHYSICAL_INVENTORY

  IMPORTING

    OUTPUT        = LV_PHYSICAL_INVENTORY

[former_member184158]

data lt_tab TYPE TABLE OF zibo_test.

data LV_PHYSICAL_INVENTORY  type zibo_test-physinventory.

data LV_FISCAL_YEAR         TYPE zibo_test-fiscalyear.

data lv_ITEM                TYPE zibo_test-itemnumber.

LV_PHYSICAL_INVENTORY = 0100000880.

LV_FISCAL_YEAR        = 2015.

lv_item = 001.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

   EXPORTING

     input         = LV_PHYSICAL_INVENTORY

  IMPORTING

    OUTPUT        = LV_PHYSICAL_INVENTORY

           .

  select * from zibo_test INTO TABLE lt_tab

   where PHYSINVENTORY = LV_PHYSICAL_INVENTORY

   and fiscalyear = LV_FISCAL_YEAR

   and itemnumber = lv_item.

[nishantbansal91]

Dear Gejo,

As suggested by experts please use the conversion exit for safer side.

and Second thing please make sure that the type of the variable LV_PHYSICAL_INVENTORY is same like the data element in the table. 

Thanks

Nishant Bansal

[Former Member]

Thank you all for looking into this.

I got the issue, there is a setting "Switch off conver. exit while testing" in function builder tab under utilities--> Settings. the check box should be unchecked so that the standard SAP conversions can work.

Again thanks a lot.

John