SAP Function Modules

comments icon Comments

IUUC_CREATE_TABLE SAP Function module - Create Table







IUUC_CREATE_TABLE 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 IUUC_CREATE_TABLE into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: IUUC_REMOTE
Released Date: Not Released
Processing type: Remote-Enabled
remote enabled module settings


Pattern for FM IUUC_CREATE_TABLE - IUUC CREATE TABLE 





CALL FUNCTION 'IUUC_CREATE_TABLE' "Create Table
  EXPORTING
    i_name =                    " ddobjname     Name of shadow table
*   i_orig_name =               " ddobjname     Name of original table
    is_dd02v =                  " dd02v         Generated Table for View DD02V
    is_dd09l =                  " dd09l         DD: Technical settings of tables
*   i_add_probtab_entry =       " boolean       boolean variable (X=true, -=false, space=unknown)
*   i_secind_field =            " fieldname     field in first position of sec. ind.
*   i_only_inactive_nametab =   " boolean       don't create table on DB; only inactive nametab
*   i_num_of_partitions =       " numc_3        requested number of partitions (Oracle)
*   i_sequence_sec_index =      " boolean       include sequence field in second. index
  IMPORTING
    e_rc =                      " syst-subrc    Return Value, Return Value After ABAP Statements
  TABLES
    it_dd03p =                  " dd03p         Structure
  EXCEPTIONS
    TABLE_CREATE_FAILED = 1     "               Table couldn't be created successfully
    MSSQL_IDENT_NOT_DEFINED = 2  "              IDENT field for MS SQL could not be defined
    DATA_CLASS_UNKNOWN = 3      "               data class is unknown
    INDEX_CREATION_FAILED = 4   "               index creation failed
    INVALID_INDEX_FIELDNAME = 5  "              invalid index fieldname
    .  "  IUUC_CREATE_TABLE

ABAP code example for Function Module IUUC_CREATE_TABLE





The ABAP code below is a full code listing to execute function module IUUC_CREATE_TABLE 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:
ld_e_rc    TYPE SYST-SUBRC
,
it_it_dd03p    TYPE STANDARD TABLE OF DD03P,"TABLES PARAM
wa_it_dd03p  LIKE LINE OF it_it_dd03p
.




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

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

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

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

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

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

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

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

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

"populate fields of struture and append to itab
append wa_it_dd03p to it_it_dd03p.
.

CALL FUNCTION 'IUUC_CREATE_TABLE'
  EXPORTING
    i_name =                     ld_i_name
*   i_orig_name =                ld_i_orig_name
    is_dd02v =                   ld_is_dd02v
    is_dd09l =                   ld_is_dd09l
*   i_add_probtab_entry =        ld_i_add_probtab_entry
*   i_secind_field =             ld_i_secind_field
*   i_only_inactive_nametab =    ld_i_only_inactive_nametab
*   i_num_of_partitions =        ld_i_num_of_partitions
*   i_sequence_sec_index =       ld_i_sequence_sec_index
  IMPORTING
    e_rc =                       ld_e_rc
  TABLES
    it_dd03p =                   it_it_dd03p
  EXCEPTIONS
    TABLE_CREATE_FAILED =        1
    MSSQL_IDENT_NOT_DEFINED =    2
    DATA_CLASS_UNKNOWN =         3
    INDEX_CREATION_FAILED =      4
    INVALID_INDEX_FIELDNAME =    5
    .  "  IUUC_CREATE_TABLE

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 2. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 3. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 4. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 5. "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_e_rc  TYPE SYST-SUBRC ,
ld_i_name  TYPE DDOBJNAME ,
it_it_dd03p  TYPE STANDARD TABLE OF DD03P ,
wa_it_dd03p  LIKE LINE OF it_it_dd03p,
ld_i_orig_name  TYPE DDOBJNAME ,
ld_is_dd02v  TYPE DD02V ,
ld_is_dd09l  TYPE DD09L ,
ld_i_add_probtab_entry  TYPE BOOLEAN ,
ld_i_secind_field  TYPE FIELDNAME ,
ld_i_only_inactive_nametab  TYPE BOOLEAN ,
ld_i_num_of_partitions  TYPE NUMC_3 ,
ld_i_sequence_sec_index  TYPE BOOLEAN .




ld_i_name = 'Check type of data required'. 

"populate fields of struture and append to itab
append wa_it_dd03p to it_it_dd03p.
ld_i_orig_name = 'Check type of data required'.
ld_is_dd02v = 'Check type of data required'.
ld_is_dd09l = 'Check type of data required'.
ld_i_add_probtab_entry = 'Check type of data required'.
ld_i_secind_field = 'Check type of data required'.
ld_i_only_inactive_nametab = 'Check type of data required'.
ld_i_num_of_partitions = 'Check type of data required'.
ld_i_sequence_sec_index = 'Check type of data required'.

Contribute (Add Comments)

Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name IUUC_CREATE_TABLE or its description.


   
 

IUUC_CREATE_TABLE - Create Table
IUUC_COUNT_ENTRIES_LOGGING_TBL - Count entries in the logging table
IUUC_COPY_DB_TABLE - copy a DB table, optionally with content
IUUC_COPY_DBCON_TO_SENDER - Copies the replication target dbcon to the sender
IUUC_CLASSIFICATION_EXIT - customer-specific classification logic
IUUC_CHECK_UNIQUE_INDEX - Check if tables has unique index (primary or secondary)