CUSTOMER_MANAGEMENT_AREA

Description


The CUSTOMER_MANAGEMENT_AREA table contains a set of customer management areas defined in the system landscape in an integrated SAP Solution scenario. Each area is identified by a name, and is composed of a mandatory ERP system responsible for this area, and an optional CRM system. An area is defined by the JCo destinations of these systems stored in the CONFIGURATION table. Consult the SAP CC Library (Application Help) for more information.

Technical Data


Schema Version 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


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

Name PK FK IX Uses Used by
NAME     IX_CUSTOMER_MANAGEMENT_AREA     
SAP_ERP_JCO_DEST_NAME          
SAP_CRM_JCO_DEST_NAME          
IS_DEFAULT          

Column Details


NAME

Definition The name of the customer management area
Type NVARCHAR(256), NOT NULL
Available Index IX_CUSTOMER_MANAGEMENT_AREA

SAP_ERP_JCO_DEST_NAME

Definition The mandatory JCo destination to an SAP ERP/FI-CA system. This JCo destination is a configuration entry defined in the CONFIGURATION table.
Type NVARCHAR(12), NOT NULL

SAP_CRM_JCO_DEST_NAME

Definition The optional JCo destination to an SAP CRM system. This JCo destination is a configuration entry defined in the CONFIGURATION table.
Type NVARCHAR(12), NULL

IS_DEFAULT

Definition Indicates that this area is the default customer management area. Only one default area can be defined.
Type DECIMAL(1), NOT NULL

Index Details


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

IX_CUSTOMER_MANAGEMENT_AREA

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