How to include headers in an Open Hub Destination

Determine the data source for the Open Hub

Define the Open Hub Destination

In the Destination tab Define the properties for the Open Hub, such as the server and file name, as well as the format

In the Field Definition tab, include the field names for the Open Hub Destination

Create the corresponding Transformation

Map each InfoObject to their corresponding field

It is possible to add regular formulas

Use the End Routine to define the name for the fields in the Open Hub, but consider a counter only for the first line.

Execute the DTP

Once the Data Transfer is complete, the file is generated and it can be viewed through AL11

ABAP Routine

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

… “insert your code here

   DATA: t_rs TYPE TABLE OF _ty_s_TG_1,
          wa_rs TYPE _ty_s_TG_1.

wa_rs–account =‘ACCOUNT’.
wa_rs–flow =‘FLOW’.
wa_rs–cat_code =‘CAT_CODE’.
wa_rs–company =‘COMPANY’.
wa_rs–currency =‘CURRENCY’.
wa_rs–data_source =‘DATA_SOURCE’.
wa_rs–interco =‘INTERCO’.
wa_rs–profit_center =‘PROFIT_CENTER’.
wa_rs–ri_code =‘RI_CODE’.
wa_rs–scenario =‘SCENARIO’.
wa_rs–scope =‘SCOPE’.
wa_rs–time =‘TIME’.
wa_rs–signeddata =‘SIGNEDDATA’.
wa_rs–createdate =‘CREATEDATE’.

ZCOUNTER = ZCOUNTER + 1.
IF ZCOUNTER = 1.
  APPEND wa_rs TO t_rs.
ENDIF.
LOOP AT RESULT_PACKAGE INTO wa_rs.
  APPEND wa_rs TO t_rs.
  DELETE RESULT_PACKAGE.
ENDLOOP.

RESULT_PACKAGE[] = t_rs[].

*$*$ end of routine – insert your code only before this line         *-*