topic Re: Standard input output conversion not version for one user in Application Development and Automation Discussions

Standard input output conversion not version for one user

Former Member — Fri, 15 May 2015 20:13:02 GMT

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.

Re: Standard input output conversion not version for one user

Former Member — Fri, 15 May 2015 20:38:12 GMT

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

Re: Standard input output conversion not version for one user

former_member184158 — Sat, 16 May 2015 04:44:11 GMT

you have to use this conversion

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = LV_PHYSICAL_INVENTORY

IMPORTING

OUTPUT = LV_PHYSICAL_INVENTORY

Re: Standard input output conversion not version for one user

former_member184158 — Sat, 16 May 2015 04:47:55 GMT

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.

Re: Standard input output conversion not version for one user

nishantbansal91 — Sat, 16 May 2015 06:49:48 GMT

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

Re: Standard input output conversion not version for one user

Former Member — Fri, 22 May 2015 14:55:20 GMT

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