Skip to Content
avatar image
Former Member

JOIN

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 19, 2008 at 05:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2008 at 05:17 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2008 at 05:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded