Show TOC

Example: Start RoutineLocate this document in the navigation structure

Use

In the SAP ERP system, you are loading data using DataSource General Ledger: Transaction Figures (FI_GL_1) into DataStore object FIGL: Transaction Figures (0FIGL_O06).

You want to create a start routine that deletes all the records from a data package with debit and credit postings that are zero.

  1. Create a transformation. The source of the transformation has the Total Debit Postings (UMSOL) and Total Credit Postings (UMHAB) fields. They are assigned to the InfoObjects Total Debit Postings (0DEBIT) and Total Credit Postings (0CREDIT).

  2. Choose Create Start Routine. The routine editor opens.

  3. Go to the local part of the routine. Enter the following code:

Sample Code 
*----------------------------------------------------------------------*
  METHOD start_routine.
*=== Segments ===

    FIELD-SYMBOLS:
      <SOURCE_FIELDS>    TYPE _ty_s_SC_1.

*$*$ begin of routine - insert your code only below this line        *-* 

  DELETE SOURCE_PACKAGE where UMHAB = 0 and UMSOL = 0

*$*$ end of routine - insert your code only before this line         *-*
  ENDMETHOD.                    "start_routine
*----------------------------------------------------------------------*

The delete statement is the only line you need to filter debit and credit postings without values from the data package.

  1. You exit the routine editor.

  2. You save the transformation. An edit icon next to the Start Routine indicates that a start routine is available.