ACCESS_TABLE

Accesses (Customer Master Data)

Definition

The ACCESS_TABLE database table is used to define service and customer access information

Technical Data

Schema Version	4.5.13
Tablespace	ACCESS_DATA
Partitioned	Yes, when you use the partitioning scheme and corresponding SQL scripts

Summary

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

Name	PK	IX
OID	PK_ACCESS_TABLE
USER_SERVICE_ID		IX_ACCESS
SERVICE_ID		IX_ACCESS
OWNER
PARTITION_ID	PK_ACCESS_TABLE	IX_ACCESS

Column Details

OID

Definition	The access unique ID
Type	DECIMAL(28), NOT NULL
Primary Key	PK_ACCESS_TABLE

USER_SERVICE_ID

Definition	The user service ID (USID) for the user access; a technical key that identifies the end customer regarding to the consumed digital service.
Type	VARCHAR(128), NOT NULL
Available Index	IX_ACCESS

SERVICE_ID

Definition	The service identifier (SID) for the user access
Type	VARCHAR(128), NOT NULL
Available Index	IX_ACCESS

OWNER

Definition	The name of the pricing catalog to which the access belongs
Description	The name of the pricing catalog to which the access belongs. This field is set automatically if the access was created by an SAP user associated to a catalog.
Type	VARCHAR(64), NULL

PARTITION_ID

Definition	The partition of the access
Type	DECIMAL(4), NOT NULL
Primary Key	PK_ACCESS_TABLE
Available Index	IX_ACCESS

Primary Key Details

PK_ACCESS_TABLE

Column(s)	PARTITION_ID, OID
Tablespace	ACCESS_INDX

Index Details

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

IX_ACCESS

Indexed Column(s)	PARTITION_ID,USER_SERVICE_ID,SERVICE_ID
Unique	Yes
Partitioned	Yes
Tablespace	ACCESS_INDX