Routines

There are 5 types of routines:

1. At Info Package :- To give the dynamic file name to info package (we need to assign the file name to P_Filename variable).

2. START ROUTINE :- Available at Transformations. It will trigger before transformations. generally used to filtering the records or Fetching global data to be used in characteristic routine.

SOURCE_PACKAGE will having the total content information and structure will be same as the source transformation.

3. END ROUTINE :- Available at Transformation and trigger after transformations. Generally end user is used for updating data based on existing data. RESULT_PACKAGE will have process information and structure will be same as the target.

4. EXPERT ROUTINE :- In Transfer rules Edit -> Expert routine will be available. SOURCE_PACKAGE and RESULT_PACKAGE will be available here. Transformations will be deleted once click on Expert Routine and Start and End Routine will be deactivated once you click on Expert Routine. Generally we used this to split single record into multiple records.

5. CHARACTERISTIC ROUTINE :- Inside the transformations on Char/Key Figure. It will trigger after start routine and before end routine. All global objects declared in Start routine will be available here.

Question:  I have field routine, start routine and end routine in my transformation for an object. which one executes first?

Ans:  Start Routine executes first.
          Field Routine executes second.
          End Routine will be executed after these two.