The concept of Return Table in 3.X we use with Expert Routine in BI.

• When we have Data Targets where we are feeding most of the Info Objects with the Routine.

Note – When we implement Expert Routine it disables Star Routine, End Routine and Transformation Rules.

Example

Splitting one Record to Multiple Records.

SOURCE (INPUT)

Create these Info Objects

We can see in Screen-Shot 1 we are doing the Transformation.

In Screen-Shot 2 we can see that, the same screen of Transformation, We need to go to Edit and choose Export Routine.

Then Start Routine, End Routine and Transformations will get disabled.

Screen-Shot1

Screen-Shot2

In Screen-Shot3 we have to write the code.

Screen-Shot3

We can see in Screen-Shot4 Export Routine has been created.

Screen-Shot4

In Screen-Shot5 we can see how single Record is splitted in to Multiple Records

Screen-Shot5