Table and field for Query

[Former Member]

Hi,

I open the form on item Master -> Row details - Item Master Data, on view of the menu 'system information'

I want to know which table and field, on the screen say :

106010001-00[Form=1 Item=1000060 variable=1 #0000000149,DATA031]

Could you help me how to know which table and fields? how to read the code?

please advise

Thanks,

Ben

[Former Member]

Do you try to create a FMS? Just ask the question for how to achieve anything will be much easier than giving puzzle to us.

Thanks,

Gordon

[Former Member]

Ho Gordon,

What does FMS mean?

Thanks

[Former Member]

Check this link which explains;

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5cae89f9-0901-0010-64be-f37d9a7eed7b]

you need to have Flash Player and Webex player installed to play this ELearning content

[Former Member]

FMS stands for Formatted Search. My guess is right. You are trying a FMS query.

When you created UDF under 'Item - Warehouse', it is available under Inventory Data tab in Item Master.

You can use FMS to assign value or list to this UDF for user to choose.

Thanks,

Gordon

[former_member583013]

Ben,

You question is not clear. Where are you seeing Row's in Item Master?

Please state with an example.

[Former Member]

Thank you Suda for quick respond, yes correct 'Row in Item's Master'

example:

I created UDF 'Item - Warehouse' the field is 'Rack', user has enter the data and I want to create query.

but i don't know which table and field keep it the data.

Thanks,

Ben

[former_member583013]

When you are in the Item Warehouses, the table should be OITW and the user field should be something like with U_Rack or U_userfield?