KCD_EXCEL_SHEET_HEAD_CREAT SAP Function module

KCD_EXCEL_SHEET_HEAD_CREAT is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.

See here to view full function module documentation and code listing, simply by entering the name KCD_EXCEL_SHEET_HEAD_CREAT into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: KCDP
Released Date: Not Released
Processing type: Normal fucntion module

Pattern for FM KCD_EXCEL_SHEET_HEAD_CREAT - KCD EXCEL SHEET HEAD CREAT

CALL FUNCTION 'KCD_EXCEL_SHEET_HEAD_CREAT' "
  EXPORTING
    i_file_id =                 " kcdehead-file_id
    i_appl =                    " kcdu_excel_appl
    i_ol_row =                  " kcde_row_col
    i_ol_col =                  " kcde_row_col
  TABLES
    c_head =                    " kcdu_head_tab
    i_datar =                   " kcdu_datar_tab
    c_r_h =                     " kcder_h
  EXCEPTIONS
    ABBORT = 1                  "
    .  "  KCD_EXCEL_SHEET_HEAD_CREAT

ABAP code example for Function Module KCD_EXCEL_SHEET_HEAD_CREAT

The ABAP code below is a full code listing to execute function module KCD_EXCEL_SHEET_HEAD_CREAT including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).

DATA:
it_c_head  
 
 TYPE STANDARD TABLE OF KCDU_HEAD_TAB,"TABLES PARAM
wa_c_head
 
 LIKE LINE OF it_c_head
,
it_i_datar  
 
 TYPE STANDARD TABLE OF KCDU_DATAR_TAB,"TABLES PARAM
wa_i_datar
 
 LIKE LINE OF it_i_datar
,
it_c_r_h  
 
 TYPE STANDARD TABLE OF KCDER_H,"TABLES PARAM
wa_c_r_h
 
 LIKE LINE OF it_c_r_h
.

 

SELECT single FILE_ID 
  FROM KCDEHEAD 
  INTO @DATA(ld_i_file_id).


DATA(ld_i_appl) = 'Check type of data required'.

DATA(ld_i_ol_row) = 'Check type of data required'.

DATA(ld_i_ol_col) = 'Check type of data required'.
 

"populate fields of struture and append to itab
append wa_c_head to it_c_head.
 

"populate fields of struture and append to itab
append wa_i_datar to it_i_datar.
 

"populate fields of struture and append to itab
append wa_c_r_h to it_c_r_h.
.

CALL FUNCTION 'KCD_EXCEL_SHEET_HEAD_CREAT'
  EXPORTING
    i_file_id =                  ld_i_file_id
    i_appl =                     ld_i_appl
    i_ol_row =                   ld_i_ol_row
    i_ol_col =                   ld_i_ol_col
  TABLES
    c_head =                     it_c_head
    i_datar =                    it_i_datar
    c_r_h =                      it_c_r_h
  EXCEPTIONS
    ABBORT =                     1
    .  "  KCD_EXCEL_SHEET_HEAD_CREAT

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "Exception
  "Add code for exception here
ENDIF.

ABAP code to compare 7.40 inline data declaration with original syntax

The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.

DATA:

ld_i_file_id
 
 TYPE KCDEHEAD-FILE_ID ,
it_c_head
 
 TYPE STANDARD TABLE OF KCDU_HEAD_TAB ,
wa_c_head
 
 LIKE LINE OF it_c_head,
ld_i_appl
 
 TYPE KCDU_EXCEL_APPL ,
it_i_datar
 
 TYPE STANDARD TABLE OF KCDU_DATAR_TAB ,
wa_i_datar
 
 LIKE LINE OF it_i_datar,
ld_i_ol_row
 
 TYPE KCDE_ROW_COL ,
it_c_r_h
 
 TYPE STANDARD TABLE OF KCDER_H ,
wa_c_r_h
 
 LIKE LINE OF it_c_r_h,
ld_i_ol_col
 
 TYPE KCDE_ROW_COL .



SELECT single FILE_ID 
  FROM KCDEHEAD 
  INTO ld_i_file_id.
 

"populate fields of struture and append to itab
append wa_c_head to it_c_head.
ld_i_appl = 'Check type of data required'. 

"populate fields of struture and append to itab
append wa_i_datar to it_i_datar.
ld_i_ol_row = 'Check type of data required'. 

"populate fields of struture and append to itab
append wa_c_r_h to it_c_r_h.
ld_i_ol_col = 'Check type of data required'.