SAP MSS_CREATE_PARTITION_TABLE Function Module for









MSS_CREATE_PARTITION_TABLE is a standard mss create partition table SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used to perform a specific ABAP function and below is the pattern details, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for mss create partition table FM, simply by entering the name MSS_CREATE_PARTITION_TABLE into the relevant SAP transaction such as SE37 or SE38.

Function Group: SFMSS_PARTITION
Program Name: SAPLSFMSS_PARTITION
Main Program: SAPLSFMSS_PARTITION
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function MSS_CREATE_PARTITION_TABLE pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'MSS_CREATE_PARTITION_TABLE'"
EXPORTING
PART_TABNAME = "Table Name
* PRID = 0 "Internal Tables, Current Row Index
* KEYFLAG = 'C' "
* PART_TYPE = 'RANGE' "
PART_COLNAME = "Field Name
* LEFT_RIGHT = 'LEFT' "
* VALUE_TYPE = 'INT4' "
* VALUE_LENGTH = 0 "
* VALUE_DECIMALS = 0 "
* CHECK_EXISTENCE = 'X' "CHAR01 Data Element for SYST
* EXECUTE = ' ' "CHAR01 Data Element for SYST

TABLES
* STATEMENT_TAB_OUT = "
* DDFIELDS_IN = "DB-relevant description of DD table fields
PART_VALUES_IN = "
* FILEGROUPS_IN = "
* PART_NAMES_IN = "

EXCEPTIONS
WRONG_DATABASE_PLATFORM = 1 TABLE_DOES_ALREADY_EXIST = 2 STORAGE_PARAM_ERROR = 3 STATEMENT_NOT_GENERATED = 4 STATEMENT_EXEC_ERROR = 5 NAMETAB_READ_ERROR = 6
.



IMPORTING Parameters details for MSS_CREATE_PARTITION_TABLE

PART_TABNAME - Table Name

Data type: DD02L-TABNAME
Optional: No
Call by Reference: No ( called with pass by value option)

PRID - Internal Tables, Current Row Index

Data type: SY-TABIX
Optional: Yes
Call by Reference: No ( called with pass by value option)

KEYFLAG -

Data type:
Default: 'C'
Optional: Yes
Call by Reference: No ( called with pass by value option)

PART_TYPE -

Data type: MSSPARTTYPE
Default: 'RANGE'
Optional: Yes
Call by Reference: No ( called with pass by value option)

PART_COLNAME - Field Name

Data type: DD03L-FIELDNAME
Optional: No
Call by Reference: No ( called with pass by value option)

LEFT_RIGHT -

Data type: MSSPARTRIGHT
Default: 'LEFT'
Optional: Yes
Call by Reference: No ( called with pass by value option)

VALUE_TYPE -

Data type: MSSPARTPARATYP
Default: 'INT4'
Optional: Yes
Call by Reference: No ( called with pass by value option)

VALUE_LENGTH -

Data type: DD03L-LENG
Optional: Yes
Call by Reference: No ( called with pass by value option)

VALUE_DECIMALS -

Data type: DD03L-DECIMALS
Optional: Yes
Call by Reference: No ( called with pass by value option)

CHECK_EXISTENCE - CHAR01 Data Element for SYST

Data type: SYCHAR01
Default: 'X'
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXECUTE - CHAR01 Data Element for SYST

Data type: SYCHAR01
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for MSS_CREATE_PARTITION_TABLE

STATEMENT_TAB_OUT -

Data type:
Optional: Yes
Call by Reference: Yes

DDFIELDS_IN - DB-relevant description of DD table fields

Data type: DDFIELD
Optional: Yes
Call by Reference: Yes

PART_VALUES_IN -

Data type: MSSSYSNAMETAB
Optional: No
Call by Reference: Yes

FILEGROUPS_IN -

Data type: MSSSYSNAMETAB
Optional: Yes
Call by Reference: Yes

PART_NAMES_IN -

Data type: MSSSYSNAMETAB
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

WRONG_DATABASE_PLATFORM -

Data type:
Optional: No
Call by Reference: Yes

TABLE_DOES_ALREADY_EXIST -

Data type:
Optional: No
Call by Reference: Yes

STORAGE_PARAM_ERROR -

Data type:
Optional: No
Call by Reference: Yes

STATEMENT_NOT_GENERATED -

Data type:
Optional: No
Call by Reference: Yes

STATEMENT_EXEC_ERROR -

Data type:
Optional: No
Call by Reference: Yes

NAMETAB_READ_ERROR -

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for MSS_CREATE_PARTITION_TABLE Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than 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 newer method of declaring data variables on the fly. 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), which i why i have stuck to the origianl for this example.

DATA:
lv_part_tabname  TYPE DD02L-TABNAME, "   
lt_statement_tab_out  TYPE STANDARD TABLE OF DD02L, "   
lv_wrong_database_platform  TYPE DD02L, "   
lv_prid  TYPE SY-TABIX, "   0
lv_keyflag  TYPE SY, "   'C'
lv_part_type  TYPE MSSPARTTYPE, "   'RANGE'
lt_ddfields_in  TYPE STANDARD TABLE OF DDFIELD, "   
lv_table_does_already_exist  TYPE DDFIELD, "   
lv_part_colname  TYPE DD03L-FIELDNAME, "   
lt_part_values_in  TYPE STANDARD TABLE OF MSSSYSNAMETAB, "   
lv_storage_param_error  TYPE MSSSYSNAMETAB, "   
lv_left_right  TYPE MSSPARTRIGHT, "   'LEFT'
lt_filegroups_in  TYPE STANDARD TABLE OF MSSSYSNAMETAB, "   
lv_statement_not_generated  TYPE MSSSYSNAMETAB, "   
lv_value_type  TYPE MSSPARTPARATYP, "   'INT4'
lt_part_names_in  TYPE STANDARD TABLE OF MSSSYSNAMETAB, "   
lv_statement_exec_error  TYPE MSSSYSNAMETAB, "   
lv_value_length  TYPE DD03L-LENG, "   0
lv_nametab_read_error  TYPE DD03L, "   
lv_value_decimals  TYPE DD03L-DECIMALS, "   0
lv_check_existence  TYPE SYCHAR01, "   'X'
lv_execute  TYPE SYCHAR01. "   ' '

  CALL FUNCTION 'MSS_CREATE_PARTITION_TABLE'  "
    EXPORTING
         PART_TABNAME = lv_part_tabname
         PRID = lv_prid
         KEYFLAG = lv_keyflag
         PART_TYPE = lv_part_type
         PART_COLNAME = lv_part_colname
         LEFT_RIGHT = lv_left_right
         VALUE_TYPE = lv_value_type
         VALUE_LENGTH = lv_value_length
         VALUE_DECIMALS = lv_value_decimals
         CHECK_EXISTENCE = lv_check_existence
         EXECUTE = lv_execute
    TABLES
         STATEMENT_TAB_OUT = lt_statement_tab_out
         DDFIELDS_IN = lt_ddfields_in
         PART_VALUES_IN = lt_part_values_in
         FILEGROUPS_IN = lt_filegroups_in
         PART_NAMES_IN = lt_part_names_in
    EXCEPTIONS
        WRONG_DATABASE_PLATFORM = 1
        TABLE_DOES_ALREADY_EXIST = 2
        STORAGE_PARAM_ERROR = 3
        STATEMENT_NOT_GENERATED = 4
        STATEMENT_EXEC_ERROR = 5
        NAMETAB_READ_ERROR = 6
. " MSS_CREATE_PARTITION_TABLE




ABAP code using 7.40 inline data declarations to call FM MSS_CREATE_PARTITION_TABLE

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

"SELECT single TABNAME FROM DD02L INTO @DATA(ld_part_tabname).
 
 
 
"SELECT single TABIX FROM SY INTO @DATA(ld_prid).
 
DATA(ld_keyflag) = 'C'.
 
DATA(ld_part_type) = 'RANGE'.
 
 
 
"SELECT single FIELDNAME FROM DD03L INTO @DATA(ld_part_colname).
 
 
 
DATA(ld_left_right) = 'LEFT'.
 
 
 
DATA(ld_value_type) = 'INT4'.
 
 
 
"SELECT single LENG FROM DD03L INTO @DATA(ld_value_length).
 
 
"SELECT single DECIMALS FROM DD03L INTO @DATA(ld_value_decimals).
 
DATA(ld_check_existence) = 'X'.
 
DATA(ld_execute) = ' '.
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!