MARO

Description


mapping tablesMATA

Technical Data


Schema Version 4.5.13
Tablespace 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 VARCHAR2(256 CHAR), NOT NULL
Available Index IX_ID_SD_ED_MARO

IN_01

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

IN_02

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

IN_03

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

IN_04

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

START_DATE

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

END_DATE

Definition The end date of the Mapping Table Row
Type DATE, NOT NULL
Available Index IX_ID_SD_ED_MARO

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_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
Tablespace CATALOG_INDX

IX_ID_SD_ED_MARO

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