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."
"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.
A table type can be used as an Importing/Exporting/Changing parameter in a FM. However, Tables parameter is now obsolete.
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.
Primary key is a mandatory field. However, we can have only the MANDT as the primary keyand without any other unique key for the data we want to store. This would allow us to have only 1 entry per client.
Run transaction SCI, enter a Z name for the new variant and click on Create. For defining naming convention standards, goto Programming conventions -> Naming Conventions and click on the arrow. Similarly other checks can be defined.
"Text table contains explanatory text in different languages for values maintained in another table.
This Text table contains the Key same as the main table with an Extra field Language as key."
This Text table contains the Key same as the main table with an Extra field Language as key."