PRICING_MACRO

Definition

The PRICING_MACRO table contains information about pricing macros

Description

The PRICING_MACRO table contains information about pricing macros. Several versions of pricing macro can be managed.

Technical Data

Schema Version	2023.0.2
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The PRICING_MACRO 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_PRICING_MACRO				RATE_COMPONENT_HOLDER (MACR_OID) OUT_MACRO_PROPERTY (MACR_OID) IN_MACRO_PROPERTY (MACR_OID) PMIN_ADDITIONAL_INFO (MACR_OID)	The pricing macro unique ID More...
CODE			IX_PRICING_MACRO_CODE		CATALOG_ENTRY (ENTRY_CODE)	The identification code (or NAME) for the pricing macro
DESCRIPTION						The textual and understandable description of the pricing macro
OWNER			IX_PRICING_MACRO_OWNER	CATALOG_ENTRY (OWNER)		The owner information of the pricing macro
MANAGED_BY_COCKPIT						This flag indicates if the pricing macro is managed by Cockpit or by Core Tool More...

Column Details

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

OID

Definition	The pricing macro unique ID
Description	The pricing macro unique ID. It is generated by the SAP CC system.
Type	DECIMAL(28), NOT NULL
Primary Key	PK_PRICING_MACRO

CODE

Definition	The identification code (or NAME) for the pricing macro
Type	NVARCHAR(256), NOT NULL
Available Index	IX_PRICING_MACRO_CODE

DESCRIPTION

Definition	The textual and understandable description of the pricing macro
Type	NVARCHAR(2000), NULL

OWNER

Definition	The owner information of the pricing macro
Type	NVARCHAR(64), NOT NULL
Available Index	IX_PRICING_MACRO_OWNER

MANAGED_BY_COCKPIT

Definition	This flag indicates if the pricing macro is managed by Cockpit or by Core Tool
Format	The possible values are: 0: managed by Core Tool 1: managed by Cockpit
Type	DECIMAL(1), NOT NULL
Default	0

Primary Key Details

See the primary key information:

PK_PRICING_MACRO

Column(s)	OID
Filegroup	CATALOG_DATA

Index Details

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

IX_PRICING_MACRO_OWNER

Indexed Column(s)	OWNER
Unique	No
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX

IX_PRICING_MACRO_CODE

Indexed Column(s)	CODE
Unique	Yes
Partitioned	No
Clustered	No
Filegroup	CATALOG_INDX