The MACA database table stores the partial definitions of all the mapping table classes (in master data)
that are managed by the SAP CC Core Server system.
Note
The rest of the definitions is stored in the following database tables:
For each end-customer service to monetize with SAP Convergent Charging, a pricing catalog
includes all the pricing elements that are necessary to design and set up the pricing
configuration.
A mapping table class defines a common structure for a subset of:
| Schema Version | 5.0.6 | |
| Partitioned | No | |
The MACA 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 |
|---|---|---|---|---|---|---|
| OID | PK_MACA |
|
The unique identifier of the mapping table class in the database. It is generated by the SAP CC system. | |||
| ID |
|
The identifier (or NAME in some user interfaces) of the mapping table class that is configured in master data. It must be unique. | ||||
| DESCRIPTION |
|
The textual and understandable description for a mapping table class | ||||
| OWNER | CATALOG_ENTRY (OWNER)
|
|
The owner information of the pricing catalog that contains a mapping table class in this database table - or another owner reference that is not associated to a catalog |
As of SP 3, Manage Mapping Table Classes is an app in the SAP CC Cockpit application that enables
the SAP CC pricing specialists to create and maintain some mapping table classes in
the
pricing catalog for a service provider company that want to monetize its marketable
end-customer services.
You configure these data templates to define the multicolumn structure and key characteristics
for some sets of mapping tables
or subscriber mapping tables.
Mapping table classes in SAP Convergent Charging are master data that define
the common characteristics and the multicolumn structures (input and output columns)
for different sets of:
A mapping table class is part of a service pricing catalog. It defines the following
columns:
A subset of data values from the input columns maps to a value subset in the output
columns.
The format is:
1
The first column includes unique technical IDs for the row definitions to facilitate
the data table maintenance for a given row
and for a given period
Two columns include the definition period for each row in a mapping table:
Column Range
Scope
Column Count
Column Types
Typical Use or Example
Default columns (predefined)
Row identifiers
String
Validity periods
2
Date/Time
Input columns with the comparative data values
Pricing data or custom data
Max. 20
Output columns
Pricing data or custom data
Max. 30
A mapping table class is viewable in SAP CRM (integrated SAP Solutions) or another interfaced CRM application or provisioning system.
Note
To facilitate your integration, SAP CC provides you with two technical interfaces (Web Services (WS) and HCI) to implement in your SAP system landscape. Refer to the available service operations in:
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique identifier of the mapping table class in the database. It is generated by the SAP CC system. |
| Type | DECIMAL(28), NOT NULL |
| Primary Key | PK_MACA |
| Definition | The identifier (or NAME in some user interfaces) of the mapping table class that is configured in master data. It must be unique. |
| Description |
The identifier or identification name of the mapping table class in a service pricing catalog for the end-customer services to monetize with SAP Convergent Charging.
ID must be unique in the SAP CC system and in its back-end database system.
Note
The ID information is also visible in the following SAP CC user interfaces as the
Name fields:
|
| Type | NVARCHAR(256), NOT NULL |
| Definition | The textual and understandable description for a mapping table class |
| Type | NVARCHAR(2000), NULL |
| Definition | The owner information of the pricing catalog that contains a mapping table class in this database table - or another owner reference that is not associated to a catalog |
| Description |
Data values in the OWNER column are mandatory.
Each pricing element or object such as a a mapping table class, a charge plan, a reusable
charge,
or a pricing macro must have some owner information as a technical key that is used
by the SAP CC system.
SAP Convergent Charging uses this key for grouping and associating some data objects together.
When a pricing element is included in a pricing catalog,
the owner information that is set for the pricing element (aka data object) must be
the same
as the owner information that is set for this pricing catalog.
Otherwise, the pricing element is orphan and not included in a pricing catalog some
owner information must be set.
|
| Type | NVARCHAR(256), NOT NULL |
See the primary key information:
| Column(s) | OID |
| Tablespace | CATALOG_INDX |
