SPENDING_STATUS_DESC

Description


Technical Data


Schema Version 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
OID PK_SSD    IX_SSD_ID    SSD_LABEL (SSD_OID)
 
ID     IX_SSD_ID     
DESCRIPTION          
ID_KEY          

Column Details


OID

Definition The internal unique identifier of the spending status description. It is generated by the SAP CC system.
Type DECIMAL(28), NOT NULL
Primary Key PK_SSD
Available Index IX_SSD_ID

ID

Definition The identifier of the spending status description
Type NVARCHAR(256), NOT NULL
Available Index IX_SSD_ID

DESCRIPTION

Definition The text description of the spending status description
Type NVARCHAR(2000), NOT NULL

ID_KEY

Definition The identification key used in replacement of the spending status description identifier
Type DECIMAL(28), NOT NULL

Primary Key Details


PK_SSD

Column(s) OID
Filegroup CATALOG_DATA

Index Details


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

IX_SSD_ID

Indexed Column(s) ID,OID
Unique Yes
Partitioned No
Clustered No
Filegroup CATALOG_INDX