Creating a Job for aggregating and filtering data in multiple SAP tables - 7.3

SAP
Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Business applications > SAP components
Data Quality and Preparation > Third-party systems > Business applications > SAP components
Design and Development > Third-party systems > Business applications > SAP components

Before you begin

  • The corresponding SAP transport that performs the SAP table join function needs to be installed on your SAP system. For more information, see the related documentation on how to install a Talend function module for SAP.

  • The FTP connection has been set up on the SAP server side to allow the tELTSAPMap component to download all data files generated by the SAP system.

  • The connection dedicated to your SAP server has been set up in the Repository tree view and the two SAP tables ZTAL_VBRK and ZTAL_VBRP to be joined and their schemas have been retrieved and saved under the SAP connection node.

Procedure

  1. Create a new Job and add a tELTSAPMap component and a tFileOutputDelimited component onto the design workspace.
  2. Drag and drop the table node ZTAL_VBRK in the Repository tree view onto the design workspace, in the pop-up dialog box, select tELTSAPInput and click OK, a tELTSAPInput component labeled to ZTAL_VBRK will be added.
  3. Do the same to drag and drop the table node ZTAL_VBRP in the Repository tree view onto the design workspace to add another tELTSAPInput component labeled to ZTAL_VBRP.
  4. Link the tELTSAPInput component labeled to ZTAL_VBRK to the tELTSAPMap component using a Link > ZTAL_VBRK (Table) connection.
  5. Link the tELTSAPInput component labeled to ZTAL_VBRP to the tELTSAPMap component using a Link > ZTAL_VBRP (Table) connection.
  6. Link the tELTSAPMap component to the tFileOutputDelimited component using a Row > *New Output* (Main) connection, in the pop-up dialog box, enter the output name out in the field and click OK. The tELTSAPMap component will be linked to the tFileOutputDelimited component using a connection labeled to out (Main).