MARO

Data Rows in Mapping Tables (in SAP Master Data > Pricing Configuration for End-Customer Services)

Definition

The MARO table contains all the rows of the mapping tables stored by the SAP CC system

Description

The MARO database table stores all the data rows of the mapping tables managed by the SAP CC system. The basic definitions of the mapping tables are stored in the MATA table.

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

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

Name	IX	Uses	Definition
ID	IX_ID_SD_ED_MARO		The identifier of the mapping table row. It must be unique in the mapping table containing the row.
IN_01			The value of the first input column
IN_02			The value of the second input column
IN_03			The value of the third input column
IN_04			The value of the fourth input column
IN_05			The value of the fifth input column
IN_06			The value of the sixth input column
IN_07			The value of the seventh input column
IN_08			The value of the eighth input column
IN_09			The value of the ninth input column
IN_10			The value of the tenth input column
IN_11			The value of the eleventh input column
IN_12			The value of the twelfth input column
IN_13			The value of the thirteenth input column
IN_14			The value of the fourteenth input column
IN_15			The value of the fifteenth input column
IN_16			The value of the sixteenth input column
IN_17			The value of the seventeenth input column
IN_18			The value of the eighteenth input column
IN_19			The value of the nineteenth input column
IN_20			The value of the twentieth input column
START_DATE	IX_ID_SD_ED_MARO		The start date and time of the validity period for the mapping table row. Each data row is defined for a specific period.
END_DATE	IX_ID_SD_ED_MARO		The end date and time of the validity period for the mapping table row. Each data row is defined for a specific period.
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)
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)
MATA_OID	IX_MARO IX_ID_SD_ED_MARO	MATA (OID)	The identifier (OID) of the mapping table containing the row
VERSION_ID	IX_MARO		Determined at mapping table level, this identifier is incremented each time a modification is performed on a row of a mapping table.

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. It must be unique in the mapping table containing the row.
Type	NVARCHAR(256), NOT NULL
Available Index	IX_ID_SD_ED_MARO

IN_01

Definition	The value of the first input column
Type	NVARCHAR(256), NULL

IN_02

Definition	The value of the second input column
Type	NVARCHAR(256), NULL

IN_03

Definition	The value of the third input column
Type	NVARCHAR(256), NULL

IN_04

Definition	The value of the fourth input column
Type	NVARCHAR(256), NULL

IN_05

Definition	The value of the fifth input column
Type	NVARCHAR(256), NULL

IN_06

Definition	The value of the sixth input column
Type	NVARCHAR(256), NULL

IN_07

Definition	The value of the seventh input column
Type	NVARCHAR(256), NULL

IN_08

Definition	The value of the eighth input column
Type	NVARCHAR(256), NULL

IN_09

Definition	The value of the ninth input column
Type	NVARCHAR(256), NULL

IN_10

Definition	The value of the tenth input column
Type	NVARCHAR(256), NULL

IN_11

Definition	The value of the eleventh input column
Type	NVARCHAR(256), NULL

IN_12

Definition	The value of the twelfth input column
Type	NVARCHAR(256), NULL

IN_13

Definition	The value of the thirteenth input column
Type	NVARCHAR(256), NULL

IN_14

Definition	The value of the fourteenth input column
Type	NVARCHAR(256), NULL

IN_15

Definition	The value of the fifteenth input column
Type	NVARCHAR(256), NULL

IN_16

Definition	The value of the sixteenth input column
Type	NVARCHAR(256), NULL

IN_17

Definition	The value of the seventeenth input column
Type	NVARCHAR(256), NULL

IN_18

Definition	The value of the eighteenth input column
Type	NVARCHAR(256), NULL

IN_19

Definition	The value of the nineteenth input column
Type	NVARCHAR(256), NULL

IN_20

Definition	The value of the twentieth input column
Type	NVARCHAR(256), NULL

START_DATE

Definition	The start date and time of the validity period for the mapping table row. Each data row is defined for a specific period.
Type	DATETIME, NOT NULL
Available Index	IX_ID_SD_ED_MARO

END_DATE

Definition	The end date and time of the validity period for the mapping table row. Each data row is defined for a specific period.
Type	DATETIME, NOT NULL
Available Index	IX_ID_SD_ED_MARO

OUT_S_01

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

OUT_S_02

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

OUT_S_03

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

OUT_S_04

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

OUT_S_05

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

OUT_S_06

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

OUT_S_07

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

OUT_S_08

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

OUT_S_09

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

OUT_S_10

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

OUT_S_11

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

OUT_S_12

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

OUT_S_13

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

OUT_S_14

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

OUT_S_15

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

OUT_S_16

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

OUT_S_17

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

OUT_S_18

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

OUT_S_19

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

OUT_S_20

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

OUT_S_21

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

OUT_S_22

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

OUT_S_23

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

OUT_S_24

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

OUT_S_25

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

OUT_S_26

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

OUT_S_27

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

OUT_S_28

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

OUT_S_29

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

OUT_S_30

Definition	The value of an output column (String or currency type)
Type	NVARCHAR(256), 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

MATA_OID

Definition	The identifier (OID) of the mapping table containing the row
Type	DECIMAL(28), NOT NULL
Available Index	IX_MARO
Available Index	IX_ID_SD_ED_MARO

VERSION_ID

Definition	Determined at mapping table level, this identifier is incremented each time a modification is performed on a row of a mapping table.
Type	DECIMAL(28), NOT NULL
Available Index	IX_MARO

Index Details

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

IX_MARO

Indexed Column(s)	MATA_OID, VERSION_ID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_ID_SD_ED_MARO

Indexed Column(s)	ID, START_DATE, END_DATE, MATA_OID
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX