List of External Programs¶
- Run Data Exchange
- Rba Runner
- Execute Command
- Execute Stored Procedure
- Execute Groovy Script
- Send Email
- AdapLink Snooze Program
- Close Database Connection
- Import Cross Tabular data from spreadsheet to ALDH.Qty_Staging
- DB Cleaner
- Build Mat_Header
- Build Material Hierarchies
- Build Location Header
- Build Consumer Header
- Calculate and build historical inventory
- Building Qty_Staging table
- Building Mat_Loc_Cons
- Export cross tabular Smoothie data to excel
- Export tabular Smoothie data to database
- Restore from Autobox output file
- Export Autobox data to file
- Export ESOPT data to file
Common Input Parameters¶
LOG_SYS_STAGE¶
The logical system ID for the Staging database which is used by the external program in context. Usually the data from Staging database are imported to ALDH database.
Example: If the logical system ID is configured as SAP_STAGE for the Staging database:
LOG_SYS_STAGE = SAP_STAGE
LOG_SYS_ALDH¶
The logical system ID for the ALDH database which is used by the external program in context.
Example: If the logical system ID for the ALDH database is configured as LOG_ALDH:
LOG_SYS_ALDH = LOG_ALDH
BAT_SIZE_STAGE¶
Batch size used by the program to get data from Staging database. Performing the operations in batch is very useful to avoid the unnecessary memory consumption. The value for the batch is given in terms of number of records in Staging table and can be adjusted based upon the hardware configuration of the server where the program runs.
Example: To set 10000 records in a batch for staging table:
BAT_SIZE_STAGE = 10000
BAT_SIZE_ALDH¶
Batch size in terms of number of records for the ALDH tables. The parameter is useful while exporting the data from ALDH tables.
Example: To set 10000 records in a batch for ALDH table:
BAT_SIZE_ALDH = 10000
UPDATE_MOD_ALDH¶
The update mode while inserting the data into ALDH tables. AdapLink supports three modes for the update data:
- ‘I’ for inserting data
- ‘U’ for updating data
- ‘M’ for modifying (insert first and update if fails) data
Any mode for updating data can be used depending on the target database environment.
UPDATE_MOD_STAG¶
The update mode while inserting the data into SAP Staging tables. AdapLink supports three modes for the update data:
- ‘I’ for inserting data
- ‘U’ for updating data
- ‘M’ for modifying (insert first and update if fails) data
Any mode for updating data can be used depending on the target database environment.
