MAPPING_TABLE_ROW

Mapping Table Row

Definition


The MAPPING_TABLE_ROW table contains the rows of the mapping tables stored in the pricing catalog of a service provider

Technical Data


Schema Version 2023.0.3
Tablespace COCKPIT_DATA
Partitioned No

Summary


The MAPPING_TABLE_ROW table is defined by the following columns in your back-end database. See the column details for more information.

Name PK FK IX Uses Used by Definition
ID     IX_MAPPING_TABLE_ROW_MIIX_MAPPING_TABLE_ROW_MESIMSIX_MAPPING_TABLE_ROW_MSIMS   

    The identifier of the mapping table row. If no value is specified, it is generated by the SAP CC Cockpit back-end application.
    MAPPING_TABLE_OID     IX_MAPPING_TABLE_ROW_MOIX_MAPPING_TABLE_ROW_MIIX_MAPPING_TABLE_ROW_MSEOIX_MAPPING_TABLE_ROW_MMSOIX_MAPPING_TABLE_ROW_MESIMSIX_MAPPING_TABLE_ROW_MSIMSIX_MAPPING_TABLE_ROW_MMSSOIX_MAPPING_TABLE_ROW_MIMSIOIX_MAPPING_TABLE_ROW_MISO   

      The unique identifier of the mapping table that owns the mapping table row
      END_DATE        

        The end date of the validity period of the mapping table row
        IN_01        

          The value of the first input of the mapping table row
          IN_02        

            The value of the second input of the mapping table row
            IN_03        

              The value of the third input of the mapping table row
              IN_04        

                The value of the fourth input of the mapping table row
                IN_05        

                  The value of the fifth input of the mapping table row
                  IN_06        

                    The value of the sixth input of the mapping table row
                    IN_07        

                      The value of the seventh input of the mapping table row
                      IN_08        

                        The value of the eighth input of the mapping table row
                        IN_09        

                          The value of the ninth input of the mapping table row
                          IN_10        

                            The value of the tenth input of the mapping table row
                            IN_11        

                              The value of the eleventh input of the mapping table row
                              IN_12        

                                The value of the twelfth input of the mapping table row
                                IN_13        

                                  The value of the thirteenth input of the mapping table row
                                  IN_14        

                                    The value of the fourteenth input of the mapping table row
                                    IN_15        

                                      The value of the fifteenth input of the mapping table row
                                      IN_16        

                                        The value of the sixteenth input of the mapping table row
                                        IN_17        

                                          The value of the seventeenth input of the mapping table row
                                          IN_18        

                                            The value of the eighteenth input of the mapping table row
                                            IN_19        

                                              The value of the nineteenth input of the mapping table row
                                              IN_20        

                                                The value of the twentieth input of the mapping table row
                                                IN_21        

                                                  The value of the twenty-first input of the mapping table row
                                                  IN_22        

                                                    The value of the twenty-second input of the mapping table row
                                                    IN_23        

                                                      The value of the twenty-third input of the mapping table row
                                                      IN_24        

                                                        The value of the twenty-fourth input of the mapping table row
                                                        IN_25        

                                                          The value of the twenty-fifth input of the mapping table row
                                                          IN_26        

                                                            The value of the twenty-sixth input of the mapping table row
                                                            IN_27        

                                                              The value of the twenty-seventh input of the mapping table row
                                                              IN_28        

                                                                The value of the twenty-eighth input of the mapping table row
                                                                IN_29        

                                                                  The value of the twenty-ninth input of the mapping table row
                                                                  IN_30        

                                                                    The value of the thirtieth input of the mapping table row
                                                                    IN_31        

                                                                      The value of the thirty-first input of the mapping table row
                                                                      IN_32        

                                                                        The value of the thirty-second input of the mapping table row
                                                                        IN_33        

                                                                          The value of the thirty-third input of the mapping table row
                                                                          IN_34        

                                                                            The value of the thirty-fourth input of the mapping table row
                                                                            IN_35        

                                                                              The value of the thirty-fifth input of the mapping table row
                                                                              IN_36        

                                                                                The value of the thirty-sixth input of the mapping table row
                                                                                IN_37        

                                                                                  The value of the thirty-seventh input of the mapping table row
                                                                                  IN_38        

                                                                                    The value of the thirty-eighth input of the mapping table row
                                                                                    IN_39        

                                                                                      The value of the thirty-ninth input of the mapping table row
                                                                                      IN_40        

                                                                                        The value of the fortieth input of the mapping table row
                                                                                        OUT_N_01        

                                                                                          The value of an output column (Number type)
                                                                                          OUT_N_02        

                                                                                            The value of an output column (Number type)
                                                                                            OUT_N_03        

                                                                                              The value of an output column (Number type)
                                                                                              OUT_N_04        

                                                                                                The value of an output column (Number type)
                                                                                                OUT_N_05        

                                                                                                  The value of an output column (Number type)
                                                                                                  OUT_N_06        

                                                                                                    The value of an output column (Number type)
                                                                                                    OUT_N_07        

                                                                                                      The value of an output column (Number type)
                                                                                                      OUT_N_08        

                                                                                                        The value of an output column (Number type)
                                                                                                        OUT_N_09        

                                                                                                          The value of an output column (Number type)
                                                                                                          OUT_N_10        

                                                                                                            The value of an output column (Number type)
                                                                                                            OUT_N_11        

                                                                                                              The value of an output column (Number type)
                                                                                                              OUT_N_12        

                                                                                                                The value of an output column (Number type)
                                                                                                                OUT_N_13        

                                                                                                                  The value of an output column (Number type)
                                                                                                                  OUT_N_14        

                                                                                                                    The value of an output column (Number type)
                                                                                                                    OUT_N_15        

                                                                                                                      The value of an output column (Number type)
                                                                                                                      OUT_N_16        

                                                                                                                        The value of an output column (Number type)
                                                                                                                        OUT_N_17        

                                                                                                                          The value of an output column (Number type)
                                                                                                                          OUT_N_18        

                                                                                                                            The value of an output column (Number type)
                                                                                                                            OUT_N_19        

                                                                                                                              The value of an output column (Number type)
                                                                                                                              OUT_N_20        

                                                                                                                                The value of an output column (Number type)
                                                                                                                                OUT_N_21        

                                                                                                                                  The value of an output column (Number type)
                                                                                                                                  OUT_N_22        

                                                                                                                                    The value of an output column (Number type)
                                                                                                                                    OUT_N_23        

                                                                                                                                      The value of an output column (Number type)
                                                                                                                                      OUT_N_24        

                                                                                                                                        The value of an output column (Number type)
                                                                                                                                        OUT_N_25        

                                                                                                                                          The value of an output column (Number type)
                                                                                                                                          OUT_N_26        

                                                                                                                                            The value of an output column (Number type)
                                                                                                                                            OUT_N_27        

                                                                                                                                              The value of an output column (Number type)
                                                                                                                                              OUT_N_28        

                                                                                                                                                The value of an output column (Number type)
                                                                                                                                                OUT_N_29        

                                                                                                                                                  The value of an output column (Number type)
                                                                                                                                                  OUT_N_30        

                                                                                                                                                    The value of an output column (Number type)
                                                                                                                                                    OUT_S_01        

                                                                                                                                                      The value of an output column (String or currency type)
                                                                                                                                                      OUT_S_02        

                                                                                                                                                        The value of an output column (String or currency type)
                                                                                                                                                        OUT_S_03        

                                                                                                                                                          The value of an output column (String or currency type)
                                                                                                                                                          OUT_S_04        

                                                                                                                                                            The value of an output column (String or currency type)
                                                                                                                                                            OUT_S_05        

                                                                                                                                                              The value of an output column (String or currency type)
                                                                                                                                                              OUT_S_06        

                                                                                                                                                                The value of an output column (String or currency type)
                                                                                                                                                                OUT_S_07        

                                                                                                                                                                  The value of an output column (String or currency type)
                                                                                                                                                                  OUT_S_08        

                                                                                                                                                                    The value of an output column (String or currency type)
                                                                                                                                                                    OUT_S_09        

                                                                                                                                                                      The value of an output column (String or currency type)
                                                                                                                                                                      OUT_S_10        

                                                                                                                                                                        The value of an output column (String or currency type)
                                                                                                                                                                        OUT_S_11        

                                                                                                                                                                          The value of an output column (String or currency type)
                                                                                                                                                                          OUT_S_12        

                                                                                                                                                                            The value of an output column (String or currency type)
                                                                                                                                                                            OUT_S_13        

                                                                                                                                                                              The value of an output column (String or currency type)
                                                                                                                                                                              OUT_S_14        

                                                                                                                                                                                The value of an output column (String or currency type)
                                                                                                                                                                                OUT_S_15        

                                                                                                                                                                                  The value of an output column (String or currency type)
                                                                                                                                                                                  OUT_S_16        

                                                                                                                                                                                    The value of an output column (String or currency type)
                                                                                                                                                                                    OUT_S_17        

                                                                                                                                                                                      The value of an output column (String or currency type)
                                                                                                                                                                                      OUT_S_18        

                                                                                                                                                                                        The value of an output column (String or currency type)
                                                                                                                                                                                        OUT_S_19        

                                                                                                                                                                                          The value of an output column (String or currency type)
                                                                                                                                                                                          OUT_S_20        

                                                                                                                                                                                            The value of an output column (String or currency type)
                                                                                                                                                                                            OUT_S_21        

                                                                                                                                                                                              The value of an output column (String or currency type)
                                                                                                                                                                                              OUT_S_22        

                                                                                                                                                                                                The value of an output column (String or currency type)
                                                                                                                                                                                                OUT_S_23        

                                                                                                                                                                                                  The value of an output column (String or currency type)
                                                                                                                                                                                                  OUT_S_24        

                                                                                                                                                                                                    The value of an output column (String or currency type)
                                                                                                                                                                                                    OUT_S_25        

                                                                                                                                                                                                      The value of an output column (String or currency type)
                                                                                                                                                                                                      OUT_S_26        

                                                                                                                                                                                                        The value of an output column (String or currency type)
                                                                                                                                                                                                        OUT_S_27        

                                                                                                                                                                                                          The value of an output column (String or currency type)
                                                                                                                                                                                                          OUT_S_28        

                                                                                                                                                                                                            The value of an output column (String or currency type)
                                                                                                                                                                                                            OUT_S_29        

                                                                                                                                                                                                              The value of an output column (String or currency type)
                                                                                                                                                                                                              OUT_S_30        

                                                                                                                                                                                                                The value of an output column (String or currency type)
                                                                                                                                                                                                                START_DATE        

                                                                                                                                                                                                                  The start date of the validity period of the mapping table row
                                                                                                                                                                                                                  STATE     IX_MAPPING_TABLE_ROW_MSEOIX_MAPPING_TABLE_ROW_MMSOIX_MAPPING_TABLE_ROW_MESIMSIX_MAPPING_TABLE_ROW_MSIMSIX_MAPPING_TABLE_ROW_MMSSOIX_MAPPING_TABLE_ROW_MIMSIOIX_MAPPING_TABLE_ROW_MISO   

                                                                                                                                                                                                                    The state of the mapping table row

                                                                                                                                                                                                                    More...

                                                                                                                                                                                                                    OID     IX_MAPPING_TABLE_ROW_MO   

                                                                                                                                                                                                                      The unique identifier of the mapping table row. It is generated by the SAP CC Cockpit application.
                                                                                                                                                                                                                      MAPPING_TABLE_OID_SORT     IX_MAPPING_TABLE_ROW_MMSOIX_MAPPING_TABLE_ROW_MESIMSIX_MAPPING_TABLE_ROW_MSIMSIX_MAPPING_TABLE_ROW_MMSSOIX_MAPPING_TABLE_ROW_MIMSIO   

                                                                                                                                                                                                                        The unique identifier of the released or draft mapping table that owns the row.
                                                                                                                                                                                                                        INPUT_HASH     IX_MAPPING_TABLE_ROW_MIMSIOIX_MAPPING_TABLE_ROW_MISO   

                                                                                                                                                                                                                          The hash of the input columns of the mapping table, used for the detection of duplicate rows
                                                                                                                                                                                                                          IN_ERROR_CODE     IX_MAPPING_TABLE_ROW_MIMSIO   

                                                                                                                                                                                                                            The error code for the input columns of the mapping table row
                                                                                                                                                                                                                            OUT_ERROR_CODE        

                                                                                                                                                                                                                              The error code for the output columns of the mapping table row
                                                                                                                                                                                                                              EDITING_STATUS     IX_MAPPING_TABLE_ROW_MSEOIX_MAPPING_TABLE_ROW_MESIMS   

                                                                                                                                                                                                                                The editing status of the mapping table row

                                                                                                                                                                                                                                More...

                                                                                                                                                                                                                                SORT_PRIORITY     IX_MAPPING_TABLE_ROW_MESIMSIX_MAPPING_TABLE_ROW_MSIMSIX_MAPPING_TABLE_ROW_MMSSO   

                                                                                                                                                                                                                                  Used by SAP CC Cockpit user interface to sort the mapping table rows.

                                                                                                                                                                                                                                  Column Details

                                                                                                                                                                                                                                  The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

                                                                                                                                                                                                                                  ID

                                                                                                                                                                                                                                  Definition The identifier of the mapping table row. If no value is specified, it is generated by the SAP CC Cockpit back-end application.
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NOT NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MI
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MESIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MSIMS

                                                                                                                                                                                                                                  MAPPING_TABLE_OID

                                                                                                                                                                                                                                  Definition The unique identifier of the mapping table that owns the mapping table row
                                                                                                                                                                                                                                  Type DECIMAL(28), NOT NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MI
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MSEO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MMSO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MESIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MSIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MMSSO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MIMSIO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MISO

                                                                                                                                                                                                                                  END_DATE

                                                                                                                                                                                                                                  Definition The end date of the validity period of the mapping table row
                                                                                                                                                                                                                                  Type DATE, NULL

                                                                                                                                                                                                                                  IN_01

                                                                                                                                                                                                                                  Definition The value of the first input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_02

                                                                                                                                                                                                                                  Definition The value of the second input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_03

                                                                                                                                                                                                                                  Definition The value of the third input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_04

                                                                                                                                                                                                                                  Definition The value of the fourth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_05

                                                                                                                                                                                                                                  Definition The value of the fifth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_06

                                                                                                                                                                                                                                  Definition The value of the sixth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_07

                                                                                                                                                                                                                                  Definition The value of the seventh input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_08

                                                                                                                                                                                                                                  Definition The value of the eighth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_09

                                                                                                                                                                                                                                  Definition The value of the ninth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_10

                                                                                                                                                                                                                                  Definition The value of the tenth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_11

                                                                                                                                                                                                                                  Definition The value of the eleventh input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_12

                                                                                                                                                                                                                                  Definition The value of the twelfth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_13

                                                                                                                                                                                                                                  Definition The value of the thirteenth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_14

                                                                                                                                                                                                                                  Definition The value of the fourteenth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_15

                                                                                                                                                                                                                                  Definition The value of the fifteenth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_16

                                                                                                                                                                                                                                  Definition The value of the sixteenth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_17

                                                                                                                                                                                                                                  Definition The value of the seventeenth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_18

                                                                                                                                                                                                                                  Definition The value of the eighteenth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_19

                                                                                                                                                                                                                                  Definition The value of the nineteenth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_20

                                                                                                                                                                                                                                  Definition The value of the twentieth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_21

                                                                                                                                                                                                                                  Definition The value of the twenty-first input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_22

                                                                                                                                                                                                                                  Definition The value of the twenty-second input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_23

                                                                                                                                                                                                                                  Definition The value of the twenty-third input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_24

                                                                                                                                                                                                                                  Definition The value of the twenty-fourth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_25

                                                                                                                                                                                                                                  Definition The value of the twenty-fifth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_26

                                                                                                                                                                                                                                  Definition The value of the twenty-sixth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_27

                                                                                                                                                                                                                                  Definition The value of the twenty-seventh input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_28

                                                                                                                                                                                                                                  Definition The value of the twenty-eighth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_29

                                                                                                                                                                                                                                  Definition The value of the twenty-ninth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_30

                                                                                                                                                                                                                                  Definition The value of the thirtieth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_31

                                                                                                                                                                                                                                  Definition The value of the thirty-first input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_32

                                                                                                                                                                                                                                  Definition The value of the thirty-second input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_33

                                                                                                                                                                                                                                  Definition The value of the thirty-third input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_34

                                                                                                                                                                                                                                  Definition The value of the thirty-fourth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_35

                                                                                                                                                                                                                                  Definition The value of the thirty-fifth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_36

                                                                                                                                                                                                                                  Definition The value of the thirty-sixth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_37

                                                                                                                                                                                                                                  Definition The value of the thirty-seventh input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_38

                                                                                                                                                                                                                                  Definition The value of the thirty-eighth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_39

                                                                                                                                                                                                                                  Definition The value of the thirty-ninth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  IN_40

                                                                                                                                                                                                                                  Definition The value of the fortieth input of the mapping table row
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_N_01

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_02

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_03

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_04

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_05

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_06

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_07

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_08

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_09

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_10

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_11

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_12

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_13

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_14

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_15

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_16

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_17

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_18

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_19

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_20

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_21

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_22

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_23

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_24

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_25

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_26

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_27

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_28

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_29

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_N_30

                                                                                                                                                                                                                                  Definition The value of an output column (Number type)
                                                                                                                                                                                                                                  Type DECIMAL(28,6), NULL

                                                                                                                                                                                                                                  OUT_S_01

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_02

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_03

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_04

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_05

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_06

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_07

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_08

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_09

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_10

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_11

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_12

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_13

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_14

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_15

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_16

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_17

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_18

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_19

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_20

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_21

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_22

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_23

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_24

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_25

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_26

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_27

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_28

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_29

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  OUT_S_30

                                                                                                                                                                                                                                  Definition The value of an output column (String or currency type)
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL

                                                                                                                                                                                                                                  START_DATE

                                                                                                                                                                                                                                  Definition The start date of the validity period of the mapping table row
                                                                                                                                                                                                                                  Type DATE, NULL

                                                                                                                                                                                                                                  STATE

                                                                                                                                                                                                                                  Definition The state of the mapping table row
                                                                                                                                                                                                                                  Format

                                                                                                                                                                                                                                  The possible values are:

                                                                                                                                                                                                                                  • 0: CREATED
                                                                                                                                                                                                                                  • 1: MODIFIED
                                                                                                                                                                                                                                  • 2: RELEASED

                                                                                                                                                                                                                                  Type DECIMAL(3), NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MSEO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MMSO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MESIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MSIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MMSSO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MIMSIO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MISO

                                                                                                                                                                                                                                  OID

                                                                                                                                                                                                                                  Definition The unique identifier of the mapping table row. It is generated by the SAP CC Cockpit application.
                                                                                                                                                                                                                                  Type DECIMAL(28), NOT NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MO

                                                                                                                                                                                                                                  MAPPING_TABLE_OID_SORT

                                                                                                                                                                                                                                  Definition The unique identifier of the released or draft mapping table that owns the row.
                                                                                                                                                                                                                                  Type DECIMAL(28), NOT NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MMSO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MESIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MSIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MMSSO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MIMSIO

                                                                                                                                                                                                                                  INPUT_HASH

                                                                                                                                                                                                                                  Definition The hash of the input columns of the mapping table, used for the detection of duplicate rows
                                                                                                                                                                                                                                  Type VARCHAR2(256 CHAR), NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MIMSIO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MISO

                                                                                                                                                                                                                                  IN_ERROR_CODE

                                                                                                                                                                                                                                  Definition The error code for the input columns of the mapping table row
                                                                                                                                                                                                                                  Type DECIMAL(28), NOT NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MIMSIO

                                                                                                                                                                                                                                  OUT_ERROR_CODE

                                                                                                                                                                                                                                  Definition The error code for the output columns of the mapping table row
                                                                                                                                                                                                                                  Type DECIMAL(10), NOT NULL

                                                                                                                                                                                                                                  EDITING_STATUS

                                                                                                                                                                                                                                  Definition The editing status of the mapping table row
                                                                                                                                                                                                                                  Format

                                                                                                                                                                                                                                  The possible values are:

                                                                                                                                                                                                                                  • 0: NEW
                                                                                                                                                                                                                                  • 1: MODIFIED
                                                                                                                                                                                                                                  • 2: RELEASED
                                                                                                                                                                                                                                  • 3: REMOVED
                                                                                                                                                                                                                                  • 4: ERROR

                                                                                                                                                                                                                                  Type DECIMAL(10), NOT NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MSEO
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MESIMS

                                                                                                                                                                                                                                  SORT_PRIORITY

                                                                                                                                                                                                                                  Definition Used by SAP CC Cockpit user interface to sort the mapping table rows.
                                                                                                                                                                                                                                  Type DECIMAL(10), NOT NULL
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MESIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MSIMS
                                                                                                                                                                                                                                  Available Index IX_MAPPING_TABLE_ROW_MMSSO

                                                                                                                                                                                                                                  Index Details

                                                                                                                                                                                                                                  The following database indexes are available in the MAPPING_TABLE_ROW database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MO

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID,OID
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MI

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID,ID
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MSEO

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID,STATE,EDITING_STATUS
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MMSO

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID_SORT,MAPPING_TABLE_OID,STATE
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MESIMS

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID_SORT,EDITING_STATUS,SORT_PRIORITY,ID,MAPPING_TABLE_OID,STATE
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MSIMS

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID_SORT,SORT_PRIORITY,ID,MAPPING_TABLE_OID,STATE
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MMSSO

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID_SORT,MAPPING_TABLE_OID,STATE,SORT_PRIORITY
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MIMSIO

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID_SORT,INPUT_HASH,MAPPING_TABLE_OID,STATE,IN_ERROR_CODE
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX

                                                                                                                                                                                                                                  IX_MAPPING_TABLE_ROW_MISO

                                                                                                                                                                                                                                  Indexed Column(s) MAPPING_TABLE_OID,INPUT_HASH,STATE
                                                                                                                                                                                                                                  Unique No
                                                                                                                                                                                                                                  Partitioned No
                                                                                                                                                                                                                                  Tablespace COCKPIT_INDX