Skip to main content Skip to complementary content

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

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).

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!