Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

JOIN

Go to solution
Former Member

‎09-19-2008 5:50 PM

0 Kudos

Do the two fields in the ON portion of a join have to be the exact same datatype and length

1 ACCEPTED SOLUTION

Go to solution
former_member585060
Active Contributor

‎09-19-2008 6:20 PM

0 Kudos

Yes,

There are certain restrictions in the database system, which mean that totally arbitrary combinations of fields cannot be linked together. Two fields can be linked only if both fields have the same data type in the Dictionary (including the length attribute). This means that two fields can be linked if they have the same domain. There are separate search functions for each table to assist in the search for suitable fields. Text, domains and data types can be searched for. The text search operates across the technical names of the fields as well as over the long texts. The Field documentation function can be used to find information about the technical definition of a field, so as to allow a specific search for suitable fields.

see the documentation

http://help.sap.com/saphelp_46c/helpdata/EN/d2/cb45a5455611d189710000e8322d00/content.htm

3 REPLIES 3

Go to solution
Former Member

‎09-19-2008 6:19 PM

0 Kudos

Hi,

I believe for Joins it is not required that the data type and length should match...But for FOR ALL ENTRIES both should match..the internal table field and database field...

Thanks

Naren

Go to solution
former_member585060
Active Contributor

‎09-19-2008 6:20 PM

0 Kudos

Yes,

There are certain restrictions in the database system, which mean that totally arbitrary combinations of fields cannot be linked together. Two fields can be linked only if both fields have the same data type in the Dictionary (including the length attribute). This means that two fields can be linked if they have the same domain. There are separate search functions for each table to assist in the search for suitable fields. Text, domains and data types can be searched for. The text search operates across the technical names of the fields as well as over the long texts. The Field documentation function can be used to find information about the technical definition of a field, so as to allow a specific search for suitable fields.

see the documentation

http://help.sap.com/saphelp_46c/helpdata/EN/d2/cb45a5455611d189710000e8322d00/content.htm