Technical settings are required to provide information about size, buffering, data class and logging changes.
"Performance is relatively bad with FOR ALL ENTRIES especially when the condition size is bigger. Also, one should make sure internal table is not empty as the query will then fetch all entries.
INNER JOIN iTab has better performance among the two."
INNER JOIN iTab has better performance among the two."
"BAPIs are remote enabled function modules that provide external access (from standalone JAVA or VB) to an SAP Business Application like ""Create Sales Order"" wrapped in Business Objects. BAPI cannot contain Exceptions.
RFC is a protocol for communication between different systems within SAP environment similar to HTTP. It can contain Exceptions."
RFC is a protocol for communication between different systems within SAP environment similar to HTTP. It can contain Exceptions."
1. script is client dependent one while smartform is client independent
2. In scripts we have to write print program while in smart forms it is not necessary
3. In scripts we can have 99 main windows while in smartforms we can have only 1 main window.
4. Smart forms exist without main window where as in script not possible.
2. In scripts we have to write print program while in smart forms it is not necessary
3. In scripts we can have 99 main windows while in smartforms we can have only 1 main window.
4. Smart forms exist without main window where as in script not possible.
"Sort the 2 tables based on key fields.
Loop over the 1st table.
Use a table operation or READ TABLE on the 2nd table based on the key fields of the 1st table's work area or field symbol.
This would provide the sy-tabix value.
Loop over the 2nd table based on this sy-tabix.
Advantage: We would be processing only the relevant entries from the 2nd table."
Loop over the 1st table.
Use a table operation or READ TABLE on the 2nd table based on the key fields of the 1st table's work area or field symbol.
This would provide the sy-tabix value.
Loop over the 2nd table based on this sy-tabix.
Advantage: We would be processing only the relevant entries from the 2nd table."
Form Interface contains fields or tables passed from the driver program to the Smartform. Variables declared within the Global Definitions can be used inside Smartform only.
Data is not updated in database table unless Session is processed
A table type can be used as an Importing/Exporting/Changing parameter in a FM. However, Tables parameter is now obsolete.
We can use the TMG events for this purpose
Create a custom FM in SE37 by selecting Remote-enabled module. Go to SM59 and create an RFC Destination from current system to target system. Logon details have to be saved which will be provided by Security/BASIS. Click on Test Connection. If connection fails we will get an error otherwise we would see KBs of data transferred.