interface

[Former Member]

how can i fetch the records of 3 tables with a single select query,without using join. ibm 0 5

could you tell me the difference between an INTERFACE AND CONVERSION?

[Former Member]

hi ,

To fetch from more than one table , table is must -- that is the fundamental of database query .

The second part of your question is ambiguos , can you be more specific ?

Thanks

Soumyadip

[Former Member]

hi,

I think you have to use select with in select but it won't be good,either u have to use for all entries or joins.

difference between Interfaces and conversions :

Conversion, converting legacy system data into SAP data. Meaning that it is mainly a one shot deal, for example bringing your customer master to SAP from the legacy system, converting the fields used in legacy to the fields and values used in SAP.

Interface, a program or group of programs that handle the passing of data from one system to another. These programs work together to export the data from one system and import into a target system, maybe these programs run once a day, maybe twice, may every hour throughout the day. It is a good way to keep the data in two or more systems in sync with each other.

In short, conversions are written to load data into SAP onetime. These are typically file based.

Interfaces are written to exchange/update/send/receive data between SAP and other systems on an ongoing basis. These can be in many forms, file based, idoc based, real time(business connector, XI etc are useful in this), xml, and the list goes on.

Interface and Conversion program with BDC are same.

Only the difference in the mode of execution.

Conversions Program - mainly used for master data

migration. Mostly will be executed standalone and

once .

Interface Programs - These program will be executed

periodically for Transaction data upload(may be

for some periodic report). So these programs are

scheduled.

Conversions - One time upload of data

Interfaces - Communication between two systems to transfer the data. It can be in a scheduled way also. Example SAP to external system and External system to SAP.

if useful reward points.