topic Re: table research in Application Development and Automation Discussions

table research

Former Member — Thu, 13 Mar 2014 10:14:34 GMT

hi everyone

I need to know corresponding fields from an external system .Sap fields is mara-bismt.Is there any sap sable that stores relations between tables from sap and external system?

Kindly help me find a way to display correspoding fields

Re: table research

custodio_deoliveira — Thu, 13 Mar 2014 10:28:57 GMT

Hi Fotini,

No, there's no such thing. Unless you create this "mapping" table on your system.

Cheers,

Custodio

Re: table research

Former Member — Thu, 13 Mar 2014 10:39:17 GMT

Sorry I am very new to this .Could you please tell me how I can create such a table or a topic to read?

Re: table research

custodio_deoliveira — Thu, 13 Mar 2014 11:12:04 GMT

Hi,

Search for ABAP Dictionary (transaction SE11), create tables. Then create a table with (at least) 2 fields: SAP Fieldname, External System Fieldname. There are other ways to do it but this is probably the simplest. '

For anything more basic than this I'll have to follow a moderator's advice and suggest you take some training.

Cheers,

Custodio

Re: table research

Former Member — Thu, 13 Mar 2014 11:38:43 GMT

Surely you should be able to speak to the owner(s) of the external system, have a conversation with them and decide what fields map to what between SAP and their system?

How are you expecting people here on SCN to know (by magic?) what fields map to what?

I really think you will get further with this by speaking to people within your company/customer, rather than asking for help here as we know absolutely nothing about your SAP and/or external systems.

Good luck!

Re: table research

RaymondGiuseppi — Thu, 13 Mar 2014 12:10:13 GMT

Only answers I can provide is" analyze documents written by the staff that executed the migration or developped the interfaces" or "organize meeting between people with knowledge of each ERP/product".

Regards,

Raymond

Re: table research

Former Member — Thu, 13 Mar 2014 13:29:36 GMT

thanks Custodio

Re: table research

custodio_deoliveira — Thu, 13 Mar 2014 22:16:36 GMT

No worries. By the way, Gareth's and Ray's answers/advices are better than mine.