09-19-2008 5:50 PM
Do the two fields in the ON portion of a join have to be the exact same datatype and length
09-19-2008 6: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
09-19-2008 6:17 PM
Can u chk it this link..
http://help.sap.com/erp2005_ehp_03/helpdata/EN/0f/49bd6a5d5049edba7b3afe6c7956e3/frameset.htm
09-19-2008 6: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
09-19-2008 6: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