Transfer Data from SAP

Parent Previous Next

MDA Workbench enables downloading tables of data from SAP tables.  



Features






Options


To manage option settings, choose File and then Options from the main menu ribbon.


Options > Transfer From SAP > Prefix Table Names


Data is transferred from SAP tables, either to files or tables in the active Local System Database.  This option controls the file or table names that will be used.


TRUE = The file name or the table name in the Local System Database is prefixed with the source SYSTEM and CLIENT.  For example, if LFA1 is extracted from ECD-300, then the table name in the active Local System Database will be ECD300_LFA1.  The file name would be ECD300_LFA1.TXT.  


Compare Data from SAP functionality expects Local System Database table names to be prefixed with SYSTEM and CLIENT, and thus requires data to be transferred with this option set to TRUE.


FALSE = The table name in the Local System Database is the same as the source.  For example, if LFA1 is extracted from ECD-300, then the table name in the Local System Database will be LFA1.  The file name would be LFA1.TXT


Validation Engine functionality expects Local System Database table names to not be prefixed with SYSTEM and CLIENT, and thus requires data to be transferred with this option set to FALSE.  



Options > Transfer From SAP > Field Delimiter


During data transfer, this character is used to delimit fields. Tab is the default, but may be a problem when transferring data that contains Tab characters.  In that case, Fixed Length is the better option.



Options > Transfer From SAP > Prefix Table Names (Fixed Value)


Prefix table names with a fixed value. Example: KNA1 becomes TEST_KNA1 if this value is set to TEST. If option for Prefix Table Names = True then this value is prefixed in addition.



Options > Transfer From SAP > Prompt for SAP System


TRUE =  The application prompts for the SAP Logon for each transfer of data.


FALSE = After the first prompt, the same SAP Logon is used.



Options > Transfer From SAP > SQL Database Schema


When using the Transfer Data from SAP to SQL Server function, this is the schema that will be used for the SQL Server database.



Options > Transfer From SAP > Transfer Row Limit


You may wish to limit the number of rows transferred from an SAP system.  Also, MDA Workbench uses standard RFC-enabled function modules and is unable to determine the row count for very large tables.  For example, DD02L has more than 7,000,000 rows, but the application cannot determine the row count as a first step in processing.  This setting limits the number of rows that will be transferred for a table.  This setting is also used as a limit when the row count cannot be determined, as with very large tables.


A value of 3000000 is the default.



Options > Transfer From SAP > Transfer Using Data Services Functions


TRUE =  use function module /BODS/RFC_READ_TABLE to transfer data. The sum of the width of all columns to be downloaded is limited to 2048 bytes.  This function module from Data Services may not be available in all SAP systems.


FALSE = use SAP function module RFC_READ_TABLE to transfer data.   The sum of the width of all columns to be downloaded is limited to 512 bytes.


Note that function module /BODS/RFC_READ_TABLE may not be available in your SAP system.


Note that security authorizations must specifically be granted to use /BODS/RFC_READ_TABLE.



Options > Transfer From SAP > Working Folder


During transfer of data from SAP, files are first written to the folder chosen in this option.


If the process Transfer Data from SAP to Local System Database is used the the files are automatically deleted after transfer.


If the process Transfer Data from SAP to SQL Server Database is used the the files are automatically deleted after transfer.


If the process Transfer Data from SAP to Text Files is used then the files will remain in this folder when the process is completed.


Existing files are overwritten each time the process is executed.



Options > Transfer From SAP > Working Folder - Delete Temp Files


During data transfer, temporary data files are written. If this option is TRUE then the files are deleted at the end of the transfer process.



Transfer With Filter


There is the possibility to filter the records that will be transferred from an SAP system. When transferring data from an SAP system-client it's not always desirable to transfer all rows of data.









Execution Overview - Transfer Data from SAP to Local System Database


You'll primarily use the buttons on the External Data ribbon.



Suppose you had a list of tables for which you wanted to extract data from ECC. You need to create a mapping project and import the table definitions one at a time into the mapping project before using Transfer Data from SAP to extract the data. But there's an easier way to create the mapping project. Here are the steps:



Execution Overview - Transfer Data from SAP to SQL Server Database


It's the same process as above, but instead of the data being transferred to the active Local System Database the data is transferred to an external SQL Server.





  Execution Overview - Transfer Data from SAP to Text Files


It's the same process as above, but instead of the data being transferred to the active Local System Database the data is transferred to tab-delimited text files.


You'll primarily use the buttons on the External Data ribbon.