ABAP program to download 160+ (the actual list of tables will be given) tables from SAP onto a desktop computer. Most of the tables are configuration tables (T*), however some tables are master tables (Customer, Vendor, Material etc.). Most tables require all data and all fields to be downloaded, however some tables require only a subset of fields in the table to be downloaded and some tables require only some data to be downloaded (eg: text tables - only specific language data to be downloaded). Users will need to be able specify in the program the language, and date from which data is required to be downloaded.
The following are the requirements:
1. ABAP program to be developed to download a specific set of tables from SAP to desktop computer. Around 160 tables needs to be downloaded from SAP.
2. The program needs to work on SAP ECC versions 5.0 and ECC 6.0.
3. A single form is required which will require inputs from the user based upon which the tables will be downloaded from SAP. The form will specify:
a) The directory on the desktop computer in which the tables will be downloaded to. Appropriate validations to existence of the directory is required.
b) Langauge - This will be used to filter and download data for the language specified (relevant for around 40 tables of the 160 tables)
c) Date From & Date to - The date from and 2 which data is to be downloaded (relevant for around 2 tables)
d)Some fields will only require a subset of fields to be downloaded (relevant for around 5 tables)
e) The files will be downloaded in text format to the desktop computer.
f) The naming convention of the downloaded text files will be "Tablename"z.txt.
g) Coding shall ensure that minimum SAP resources are used while tables are downloaded to the local computer.
h) A status message will be shown during download displaying which tables is being downloaded, total number of tables downloaded and remaining number of tables)
i) A summary text file will also be generated at the end of the program displaying tables downloaded and the number of records downloaded)