MARO

Description

mapping tablesMATA

Technical Data

Schema Version	4.5.13
Segment	CATALOG_DATA
Partitioned	No

Summary

The MARO table is defined by the following columns. See the column details for more information.

Name	PK	FK	IX	Uses	Used by
ID			IX_ID_SD_ED_MARO
IN_01
IN_02
IN_03
IN_04
START_DATE			IX_ID_SD_ED_MARO
END_DATE			IX_ID_SD_ED_MARO
OUT_S_01
OUT_S_02
OUT_S_03
OUT_S_04
OUT_S_05
OUT_S_06
OUT_S_07
OUT_S_08
OUT_S_09
OUT_S_10
OUT_S_11
OUT_S_12
OUT_S_13
OUT_S_14
OUT_S_15
OUT_N_01
OUT_N_02
OUT_N_03
OUT_N_04
OUT_N_05
OUT_N_06
OUT_N_07
OUT_N_08
OUT_N_09
OUT_N_10
OUT_N_11
OUT_N_12
OUT_N_13
OUT_N_14
OUT_N_15
MATA_OID			IX_MAROIX_ID_SD_ED_MARO	MATA (OID)

Column Details

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

START_DATE

Definition	The start date for the Mapping Table Row
Type	DATETIME, NOT NULL
Available Index	IX_ID_SD_ED_MARO

END_DATE

Definition	The end date of the Mapping Table Row
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_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

MATA_OID

Definition	The identifier of the Mapping Table containing the row
Type	DECIMAL(28), NOT NULL
Available Index	IX_MARO
Available Index	IX_ID_SD_ED_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
Unique	No
Partitioned	No
Clustered	No
Segment	CATALOG_INDX

IX_ID_SD_ED_MARO

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