| Table |
Summary |
Names and short descriptions of the tables of the Core Database.
| ACCESS_ACTI_CHRONOLOGY |
The ACCESS_ACTI_CHRONOLOGY table contains the chronology of access for a charge activation. |
| ACCESS_TABLE |
The ACCESS_TABLE table is used to define service and user access information. |
| ACTI_CHARGING_MAPPING |
The ACTI_CHARGING_MAPPING table is the mapping between the reference and the account to be charged in a charge activation.
|
| ACTI_DEPENDENT |
The ACTI_DEPENDENT table contains the dependent charge activation(s) of a charge activation. |
| ACTI_PARAMETER |
The ACTI_PARAMETER table contains information about parameters in charge activations. These parameters are first created
in the
price plan of the charge component corresponding to the charge activation. Then they are redefined in the charge activation.
|
| ACTI_TIER_TABLE_INSTANCE |
The ACTI_TIER_TABLE_INSTANCE table contains information about tier table instances in charge activations. |
| ACTI_TIER_TABLE_ROW |
The ACTI_TIER_TABLE_ROW table contains the rows of tier table instances in charge activations. |
| ACTI_TRANSLATION_INSTANCE |
The ACTI_TRANSLATION_INSTANCE table contains information about translation instances in charge activations. |
| ACTI_TRANSLATION_ROW |
The ACTI_TRANSLATION_ROW table contains the rows of translation table instances in charge activations. |
| AMOUNT_ALERT |
The AMOUNT_ALERT table represents an amount alert in a subscriber account. |
| AUDIT_CYCLE |
The AUDIT_CYCLE table contains settings for the audit cycles. |
| BATCH_RATING_GROUP_DESCRIPTION |
The BATCH_RATING_GROUP_DESCRIPTION table contains all batch rating groups, it also indicates their codes and descriptions.
|
| CACI |
The CACI table contains the charging contract items. |
| CACI_ACCOUNT_ASSIGNMENT |
The CACI_ACCOUNT_ASSIGNMENT table contains the account assignment of the charging contract items. |
| CACI_PARAMETER |
The CACI_PARAMETER table contains the parameters of the charging contract items. |
| CACI_SHARED_COUNTER |
The CACI_SHARED_COUNTER table contains the shared counters of the charging contract items. |
| CACI_USER_TECH_ID |
The CACI_USER_TECH_ID table contains the user technical identifiers of the charging contract items. |
| CACI_VALIDITY |
The CACI_VALIDITY table contains the validity dates for the charging contract items. |
| CACO |
The CACO table contains the description of the charging contract. |
| CACO_ADDITIONAL_INFO |
The CACO_ADDITIONAL_INFO table contains additional information defined in the charging contract. |
| CACO_BATCH |
The CACO_BATCH table contains the description of the charging contract used by the batch service client. |
| CACO_SHARED_COUNTER |
The CACO_SHARED_COUNTER table contains the shared counters dictionary of the charging contracts. |
| CAPA |
The CAPA table contains the description of the charge plan. |
| CAPA_ACCOUNT_ASSIGNMENT |
The CAPA_ACCOUNT_ASSIGNMENT table contains the account assignments of the charge plan. |
| CAPA_ADDITIONAL_INFO |
The CAPA_ADDITIONAL_INFO table contains additional information defined in the charge plan. |
| CAPA_CHARGE_DEPENDENCY |
The CAPA_CHARGE_DEPENDENCY table contains the charge dependencies of the charge plan. |
| CAPA_COUNTER |
The CAPA_COUNTER table contains the counters defined in the charge plan. |
| CAPA_NAMES_DICT |
The CAPA_NAMES_DICT table contains the names dictionary of the charge plan. |
| CAPA_PARAMETER |
The CAPA_PARAMETER table contains the parameters defined in the charge plan. |
| CAPA_USER_TECH_ID |
The CAPA_USER_TECH_ID table contains the user technical identifiers of the charge plan. |
| CAPI |
The CAPI table contains charge plan items. |
| CAPI_ACCOUNT_ASSIGNMENT_REF |
The CAPI_ACCOUNT_ASSIGNMENT_REF table shows which account assignment of the charge plan is referenced by the account assignment
of the charge plan item.
|
| CAPI_CHARGE_COMPONENT_REF |
The CAPI_CHARGE_COMPONENT_REF table contains customization parameters applied to the charge component referenced by the charge
plan item.
|
| CAPI_CHARGED_ITEM_MAPPING |
The CAPI_CHARGED_ITEM_MAPPING table contains the link between the charged item class and the charged item mapping inside
a charge
plan item.
|
| CAPI_CITM_ENTRY |
The CAPI_CITM_ENTRY table describes the entries of the charged item mapping in the charge plan item. |
| CAPI_COUNTER |
The CAPA_COUNTER table contains the counters of the charge plan items. |
| CAPI_COUNTER_REF |
The CAPI_COUNTER_REF table shows which charge plan counter is referenced by a charge plan item counter. |
| CAPI_PARAMETER |
The CAPA_PARAMETER table contains the parameters of the charge plan items. |
| CAPI_PARAMETER_REF |
The CAPI_PARAMETER_REF table shows which charge plan parameter is referenced by a charge plan item parameter. |
| CAPI_TAX_PARAMETER |
The CAPI_TAX_PARAMETER table describes the parameters of a Charge Plan tax parameter set. |
| CAPI_TAX_PARAMETER_SET |
The CAPI_TAX_PARAMETER_SET table contains the tax parameter set to compute taxes for a charge plan item. |
| CAPI_USER_TECH_ID_REF |
The CAPI_USER_TECH_ID_REF table shows which user technical identifier of the charge plan is referenced by the user technical
identifier of the charge plan item.
|
| CAPP_ADDITIONAL_INFO |
The CAPP_ADDITIONAL_INFO table contains additional information defined in the charge plan parameter. |
| CATALOG_ENTRY |
The CATALOG_ENTRY table contains the entry for a user catalog. In each user catalog you can find products, offers, translation
tables, tier tables and pricing macros.
|
| CCON_COUNTER_DESC |
The CCON_COUNTER_DESC table contains the description of counters in charge conditions. These counters are first created in
the
price plan of the charge component corresponding to the charge condition. Then they are linked to another counter (defined
at the
offer level) in the charge condition.
|
| CCON_PARAMETER |
The CCON_PARAMETER table contains information about parameters in charge conditions. These parameters are first created in
the
price plan of the charge component corresponding to the charge condition. Then they are redefined in the charge condition.
|
| CCON_TIER_TABLE_INSTANCE |
The CCON_TIER_TABLE_INSTANCE table contains information about tier table instances in charge conditions. |
| CCON_TIER_TABLE_ROW |
The CCON_TIER_TABLE_ROW table contains the rows of tier table instances in charge conditions. |
| CCON_TRANSLATION_INSTANCE |
The CCON_TRANSLATION_INSTANCE table contains information about translation table instances in charge conditions. |
| CCON_TRANSLATION_ROW |
The CCON_TRANSLATION_ROW table contains the rows of translation table instances in charge conditions. |
| CCPP_ADDITIONAL_INFO |
The CCPP_ADDITIONAL_INFO table contains the additional information for rating context properties in the price plan. |
| CHARGE_ACTIVATION |
The CHARGE_ACTIVATION table contains information about the charge activation.
A charge activation is contained in a subscription and gives the possibility to subscribe to an
existing charge condition.
|
| CHARGE_COMP_PRODUCT_CODE |
The CHARGE_COMPONENT_PRODUCT_CODE table contains the product codes supported by a charge component. |
| CHARGE_COMPONENT |
The CHARGE_COMPONENT table contains information about charge components. |
| CHARGE_CONDITION |
The CHARGE_CONDITION table describes the relationships between charge components and offer conditions. |
| CHARGE_DEPENDENCY |
The CHARGE_DEPENDENCY table describes the relationships between charges in offers. |
| CHARGED_ITEM_CLASS |
The CHARGED_ITEM_CLASS table contains basic information about the charged item classes (description, codename, owner) managed
by
SAP Convergent Charging.
|
| CHARGED_ITEM_FILES |
The CHARGED_ITEM_FILES table contains information about the files which contains charged items, and which generated by
the rater and bulk loader instances.
|
| CHARGED_ITEM_MAPPING |
The CHARGED_ITEM_MAPPING table contains le link between the charged item class and the Offer charged item mapping managed
by SAP
Convergent Charging.
|
| CHARGING_PLAN |
The CHARGING_PLAN table contains the charging plan. |
| CHARGING_PLAN_DICTIONARY |
The CHARGING_PLAN_DICTIONARY table contains the reference dictionary of a charge. |
| CI_DESCRIPTION |
The CI_DESCRIPTION table contains a description for each chargeable item class included in a product. A product can include
several
chargeable item classes.
Note:
mple.
|
| CIPA_ADDITIONAL_INFO |
The CIPA_ADDITIONAL_INFO table contains additional information defined in the parameters of the charge plan items. |
| CIPR_ADDITIONAL_INFO |
The CIPR_ADDITIONAL_INFO table contains additional information defined in the parameter reference of the charge plan item.
|
| CIT_AGGR_POLICY |
The CIT_AGGR_POLICY table contains the list of charged items aggregation policies which are defined in the system. |
| CIT_AGGR_RULE |
The CIT_AGGR_RULE table contains the list of charged items aggregation rules which are associated to existing
charged items aggregation policies.
|
| CITC_FIELD |
The CITC_FIELD table describes the fields of a charged item class. |
| CITM_ENTRY |
The CITM_ENTRY table describes the entries of an Offer charged item mapping. |
| COAC |
The COAC (CONTRACT_ACTIVATION) table contains the charge activations of the charging contract items. |
| CONFIGURATION |
The CONFIGURATION table contains tax parameters for the VAT and the EZTAX frameworks. |
| COUNTER |
The COUNTER table describes counters in subscriptions, charging contracts and charge activations. These counters are first
created in offers,
charge conditions or charge plans and charge plan items. Then they are redefined in a subscription or in a charge activation.
|
| COUNTER_DESC |
The COUNTER_DESC table contains the description of the counters used in charge components. |
| COUNTER_NAME_DICT |
The COUNTER_NAME_DICT table contains the description of the possible names for counters exposed to external systems. |
| COUNTER_SNAPSHOT |
The COUNTER_SNAPSHOT table contains counter values for subscriptions or charging contracts. A subscription that is not batch
only does not have any
entry in this table.
|
| COUNTRY_TAX_POLICY |
The COUNTRY_TAX_POLICY table sets the tax policy to apply for each country. It also defines if a country belongs to a
supra-national group which imposes any taxation rules (ex: EU, ALENA, ...).
|
| CREDIT_LIMIT_BALANCE |
The CREDIT_LIMIT_BALANCE table represents a credit limit balance in a subscriber account. |
| CURRENCY |
The CURRENCY table contains information about the currencies defined in SAP CC.
These currencies can correspond to the default
currencies defined in SAP CC or to the currencies retrieved from the implementation of the EIF.
|
| DBRC |
The DBRC table contains the list of duration-based reporting conditions
associated to the defined charged items aggregation policies.
|
| DETAIL_TEMPLATE |
The DETAIL_TEMPLATE table is used for filtering transaction details by name in a transaction template. |
| EIM_ADDITIONAL_INFO |
The EIM_ADDITIONAL_INFO table contains additional information about the exportable item mapping. |
| EIM_FIELD |
The EIM_FIELD table describes the fields of an exportable item mapping. |
| EIMF_ADDITIONAL_INFO |
The EIMF_ADDITIONAL_INFO table contains additional information about the exportable item mapping field. |
| EXPIRATION_ALERT |
The EXPIRATION_ALERT table represents an expiration alert in a subscriber account. |
| EXPIRATION_ALERT_SCHED |
The EXPIRATION_ALERT_SCHED table contains the last date when the alert scheduler has been triggered. |
| EXPORTABLE_ITEM_MAPPING |
The EXPORTABLE_ITEM_MAPPING table contains basic information about the exportable item mapping (code, citcCode,
externalSystemCode) managed by
SAP Convergent Charging.
|
| EXTERNAL_ACCOUNT |
The EXTERNAL_ACCOUNT table represents an external account or a postpaid account link in a subscriber account. |
| HCI_USER |
The HCI_USER table contains information about the authorized users of SAP Convergent Charging APIs. |
| HOLIDAY |
The HOLIDAY table contains the holidays used by the rating. To customize the holidays, see the
Desktop Tool Online Help
.
|
| HOLIDAYS_GROUP_DESCRIPTION |
The HOLIDAYS_GROUP_DESCRIPTION table describes how holidays are grouped (by country for example). |
| ID_TABLE |
The ID_TABLE table is used for unique identifier generation. |
| IN_MACA_COLUMN |
The IN_MACA_COLUMN table contains the input columns used in a Mapping Table Class. |
| IN_MACRO_PROPERTY |
The IN_MACRO_PROPERTY table contains the descriptions of rating context properties in the pricing macros. |
| IN_TABLE_ATTRIBUTE |
The IN_TABLE_ATTRIBUTE table contains the descriptions of the input attributes of the translation tables. |
| INSTANCE_CONFIGURATION |
The INSTANCE_CONFIGURATION table contains instance parameters of the parameters.xml file. |
| INSTANCE_KEY_STORE |
The INSTANCE_KEY_STORE table links an instance to a key store entry for using HTTPS. |
| INSTANCE_MAP |
The INSTANCE_MAP table gives the map of available instances of SAP Convergent Charging server. You can show online the list
of the instances by using the list command of the admin+ utility.
|
| ISO_4217 |
The ISO_4217 table contains information about the ISO 4217 currencies. |
| KEY_STORE |
The KEY_STORE table contains the private keys and their associated certificates for using HTTPS. Each entry is identified
by an
"alias" string.
|
| LICENSE |
The LICENSE table contains information about the SAP Convergent Charging license. |
| MACA |
The MACA tables contains the description of the mapping table classes. |
| MARO |
The MARO table contains the Mapping Table Rows of a Mapping
Table.
|
| MATA |
The MATA table contains the Mapping Tables. A Mapping Table is an instance of a Mapping Table Class and contains rows. |
| METRIC_RECORD |
The METRIC table contains information about the metrics of SAP Convergent Charging APIs. |
| NRCT |
The NRCT table contains the list of conditions associated to the defined reporting condition sets. |
| OBJECT_CHANGE_LOG |
The OBJECT_CHANGE_LOG table contains the list of changes performed on objects, including links to the related user operation
and
object snapshots.
|
| OBJECT_SNAPSHOT |
The OBJECT_SNAPSHOT table contains copies of objects, which are created either before or after the execution of an
operation which changed the object (creation, modification or deletion).
|
| OCON_COUNTER_DESC |
The OCON_COUNTER_DESC table contains the description of counters in offer conditions. These counters are first created in
the
offer corresponding to the offer condition. Then they are linked to another counter owned by the offer containing the offer
condition.
|
| OCON_PARAMETER |
The OCON_PARAMETER table contains information about parameters in offer conditions. These parameters are first created in
the
offer corresponding to the offer condition. Then they are redefined in the offer condition.
|
| OCON_TIER_TABLE_INSTANCE |
The OCON_TIER_TABLE_INSTANCE table contains information about tier table instances in offer conditions. |
| OCON_TIER_TABLE_ROW |
The OCON_TIER_TABLE_ROW table contains the rows of tier table instances in offer conditions. |
| OCON_TRANSLATION_INSTANCE |
The OCON_TRANSLATION_INSTANCE table contains information about translation table instances in offer conditions. |
| OCON_TRANSLATION_ROW |
The OCON_TRANSLATION_ROW table contains the rows of translation table instances in offer conditions. |
| OFFER |
The OFFER table contains a description of the offer. |
| OFFER_ADDITIONAL_INFO |
The OFFER_ADDITIONAL_INFO table contains additional information about the offer. |
| OFFER_CDES_KEY |
The OFFER_CDES_KEY table is a mapping between the key and the offer counter name. |
| OFFER_CONDITION |
The OFFER_CONDITION table describes offer conditions. An offer condition enables to use an existing offer as a suboffer in
another offer.
|
| OFFER_COUNTER_DESC |
The OFFER_COUNTER_DESC table contains the description of counters defined in offers. |
| OFFER_PARA_KEY |
The OFFER_PARA_KEY table is a mapping between the key and the parameter name in offers. |
| OFFER_PARAMETER |
The OFFER_PARAMETER table contains information about parameters defined in offers. |
| OFFER_TIER_TABLE_INSTANCE |
The OFFER_TIER_TABLE_INSTANCE table contains information about tier table instances in offers. |
| OFFER_TIER_TABLE_ROW |
The OFFER_TIER_TABLE_ROW table contains the rows of tier table instances in offers. |
| OFFER_TRANSLATION_INSTANCE |
The OFFER_TRANSLATION_INSTANCE table contains information about translation table instances in offers. |
| OFFER_TRANSLATION_ROW |
The OFFER_TRANSLATION_ROW table contains the rows of translation table instances in offers. |
| ONE_SHOT_RATE |
The ONE_SHOT_RATE table contains information about one shot rates. |
| OUT_MACA_COLUMN |
The OUT_MACA_COLUMN table contains the output columns used in a Mapping Table Class. |
| OUT_MACRO_PROPERTY |
The OUT_MACRO_PROPERTY table contains the descriptions of the properties generated in pricing macros. |
| OUT_TABLE_ATTRIBUTE |
The OUT_TABLE_ATTRIBUTE table contains the descriptions of the output attributes of the translation tables. |
| PARAMETER |
The PARAMETER table contains information about the parameters defined in price plans. |
| PMIN_ADDITIONAL_INFO |
The PMIN_ADDITIONAL_INFO table contains the additional information for rating context properties in the pricing macro. |
| PPACC_ACTI_CHRONOLOGY |
The PPACC_ACTI_CHRONOLOGY table contains the chronology of refill access for a charge activation. |
| PREPAID_ACCOUNT |
The PREPAID_ACCOUNT table represents a prepaid account in a subscriber account. |
| PREPAID_TRANSAC_MAPPING |
The PREPAID_TRANSAC_MAPPING table defines the mapping between prepaid details coming from the rating context and specific
fields
in the prepaid transaction files.
|
| PRICE_PLAN |
The PRICE_PLAN table contains information about price plans. |
| PRICE_PLAN_FREE_TEXT |
The PRICE_PLAN_FREE_TEXT table contains the free text for a price plan. |
| PRICING_MACRO |
The PRICING_MACRO table contains information about pricing macros. Several versions of pricing macro can be managed. |
| PRODUCT |
The PRODUCT table contains basic information about the chargeable item packages/products (description, codename, owner) managed
by SAP
Convergent Charging.
A product represents a customer service which can be charged according to its usage.
Note:
Product is a technical term only visible in the APIs and in the database schema; The corresponding business term is Chargeable
Item
Package.
|
| PROPERTY_DESCRIPTION |
The PROPERTY_DESCRIPTION table describes the properties of a chargeable item. |
| RATE_COMPONENT |
The RATE_COMPONENT table contains basic information about rating and charging components. The rating components are used
to build
price plans and the charging components are used to build charging plan.
|
| RATE_COMPONENT_HOLDER |
The RATE_COMPONENT_HOLDER table implements the links between a rating or a charging component and the object which contains
the
component. For a rating component, the container can be a usage rate, a recurring rate, a one-shot rate or a pricing macro.
For a
charging component, the container is a charging plan.
|
| RATE_COMPONENT_PROPERTY |
The RATE_COMPONENT_PROPERTY table contains detailed information about rating and charging components. |
| RATING_RECORD |
The RATING_RECORD table contains the data related to the prerating. Rating records are stored when a prerating operation
is
initially received. Each reserved event is stored in another rating record until the last postrating is received or the initial
prerating has expired.
|
| RATING_SESSION_@NUMBER@ |
The RATING_SESSION_@NUMBER@ tables stores rating session data for the session backup service.
@NUMBER@ is a variable part of the name. There is 480 tables with the same pattern name.
|
| RCST |
The RCST table contains the list of reporting condition sets associated to the defined charged items aggregation policies.
|
| RECURRING_RATE |
The RECURRING_RATE table contains information about recurring rates. |
| RI_CLASS |
The RI_CLASS table contains the description for each refill item class.
|
| RI_PROPERTY_DESCRIPTION |
The RI_PROPERTY_DESCRIPTION table describes the properties of a refill item class. |
| RR_COUNTER_MODIFICATION |
The RR_COUNTER_MODIFICATION table contains counter modifications for prerating. |
| RR_PROPERTY |
The RR_PROPERTY table contains rating record properties. These properties correspond to the state of chargeable item properties
or the state of a counter of the subscription.
|
| SUAC_ADDITIONAL_INFO |
The SUAC_ADDITIONAL_INFO table contains the additional information of a subscriber account. |
| SUBS_ADDITIONAL_INFO |
The SUBS_ADDITIONAL_INFO table contains subscription additional information. |
| SUBS_PARAMETER |
The SUBS_PARAMETER table contains parameters in subscriptions. These parameters are first created in the offer corresponding
to
the subscription. Then they are redefined in the subscription.
|
| SUBS_TIER_TABLE_INSTANCE |
The SUBS_TIER_TABLE_INSTANCE table contains information about tier table instances in subscriptions. |
| SUBS_TIER_TABLE_ROW |
The SUBS_TIER_TABLE_ROW table contains the rows of tier table instances in subscriptions. |
| SUBS_TRANSLATION_INSTANCE |
The SUBS_TRANSLATION_INSTANCE table contains information about translation table instances in subscriptions. |
| SUBS_TRANSLATION_ROW |
The SUBS_TRANSLATION_ROW table contains the rows of translation table instances in subscriptions. |
| SUBSCRIBER_ACCOUNT |
The SUBSCRIBER_ACCOUNT table contains the subscriber account data. A subscriber account represents a set of subscriptions
belonging to a subscriber.
|
| SUBSCRIPTION |
The SUBSCRIPTION table describes the subscription details. |
| SUMT |
The SUMT table contains the subscriber mapping tables. A subscriber mapping table is very similar to a mapping table but it
is attached
to a subscriber account and can be used by the contracts belonging to this subscriber account. It is an instance of a mapping
table class and it contains rows.
|
| SUMT_MARO |
The SUMT_MARO table contains the rows of the subscriber mapping tables.
|
| TAX_PARAMETER |
The TAX_PARAMETER table describes the parameter of a tax parameter set. |
| TAX_PARAMETER_SET |
The TAX_PARAMETER_SET table contains the tax parameters to compute tax for a given charge condition. |
| TAX_RATE |
The TAX_RATE table stores all the tax rates. |
| TIER_TABLE |
The TIER_TABLE table contains information about tier table. |
| TIER_TABLE_INSTANCE |
The TIER_TABLE_INSTANCE table contains information about tier table instances. |
| TIER_TABLE_OUT_ATTRIBUTE |
The TIER_TABLE_OUT_ATTRIBUTE table contains the descriptions of the output attributes of the tier tables. |
| TIER_TABLE_ROW |
The TIER_TABLE_ROW table contains the rows of tier table instances. |
| TRANSAC_TEMPLATE_DESC |
The TRANSAC_TEMPLATE_DESC table contains the description of transaction templates. Transaction templates are used to filter
postpaid transaction details.
|
| TRANSLATION_INSTANCE |
The TRANSLATION_INSTANCE table contains information about translation table instances. |
| TRANSLATION_ROW |
The TRANSLATION_ROW table contains the rows of translation table instances. |
| TRANSLATION_TABLE |
The TRANSLATION_TABLE table contains information about translation table. |
| USAGE_RATE |
The USAGE_RATE table contains information about usage rates. |
| USER_FAILED_AUTHENTICATION |
The USER_FAILED_AUTHENTICATION table contains the list of failed authentication attempts for users since their last
successful
authentication.
|
| USER_OPERATION |
The USER_OPERATION table contains all the audited operations. |
| USER_OPERATION_FILTER |
The USER_OPERATION_FILTER contains the filters used to audit SAP Convergent Charging operations. |
| USER_PASSWORD |
The USER_PASSWORD table contains the history of passwords of the users. Password history is stored only when advanced password
management is enabled.
|
| USER_RIGHT |
The USER_RIGHT table contains the list of rights for all the users of SAP CC. Each row is a given right for a user. A user
can
have many
rights.
|
| VERSION |
The VERSION table contains the history of the installed version of SAP Convergent Charging. |
| WS_IDEMPOTENCY |
The WS_IDEMPOTENCY table is used to store web services calls. |
| WS_JOB |
The WS_JOB table contains the Web Service Jobs. |