OFFER

Definition

The OFFER table contains a description of the offer

Technical Data

Schema Version	2025.0.0
Tablespace	CATALOG_DATA
Partitioned	No

Summary

The OFFER 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_OFFER				OFFER_TRANSLATION_INSTANCE (OFFE_OID) OFFER_TIER_TABLE_INSTANCE (OFFE_OID) OFFER_PARAMETER (OFFE_OID) OFFER_PARA_KEY (OFFE_OID) OFFER_COUNTER_DESC (OFFE_OID) OFFER_CONDITION (HOLDER_OFFE_OID) OFFER_CDES_KEY (OFFE_OID) OFFER_ADDITIONAL_INFO (OFFE_OID) CHARGE_DEPENDENCY (OFFE_OID) CHARGE_CONDITION (OFFE_OID)	The unique identifier for this offer More...
CLIENT_NUMBER			IX_OFFER_OWNERIX_OFFER_CODE			The client number associated to the offer
CODE			IX_OFFER_CODE		SUBSCRIPTION (OFFER_CODE)	The identification code (or codename) of the offer
OWNER			IX_OFFER_OWNER			The owner of the offer
SHORT_DESCRIPTION						A short description of the offer
LONG_DESCRIPTION						A long description of the offer
EFFECTIVE_DATE						The effective date of the offer
EXPIRATION_DATE						The expiration date of the offer

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

Definition	The unique identifier for this offer
Description	The unique identifier for this offer. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_OFFER

CLIENT_NUMBER

Definition	The client number associated to the offer
Type	DECIMAL(3), NOT NULL
Available Index	IX_OFFER_OWNER
Available Index	IX_OFFER_CODE

CODE

Definition	The identification code (or codename) of the offer
Type	VARCHAR(256), NOT NULL
Available Index	IX_OFFER_CODE

OWNER

Definition	The owner of the offer
Type	VARCHAR(64), NOT NULL
Available Index	IX_OFFER_OWNER

SHORT_DESCRIPTION

Definition	A short description of the offer
Type	VARCHAR(256), NULL

LONG_DESCRIPTION

Definition	A long description of the offer
Type	VARCHAR(2000), NULL

EFFECTIVE_DATE

Definition	The effective date of the offer
Type	TIMESTAMP, NULL

EXPIRATION_DATE

Definition	The expiration date of the offer
Type	TIMESTAMP, NULL

Primary Key Details

See the primary key information:

PK_OFFER

Column(s)	OID
Tablespace	CATALOG_INDX

Index Details

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

IX_OFFER_OWNER

Indexed Column(s)	CLIENT_NUMBER,OWNER
Unique	No
Partitioned	No
Tablespace	CATALOG_INDX

IX_OFFER_CODE

Indexed Column(s)	CLIENT_NUMBER,CODE
Unique	Yes
Partitioned	No
Tablespace	CATALOG_INDX