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 Application Help for more information.
| Schema Version | 2025.0.0 | |
| Partitioned | No | |
The CUSTOMER_MANAGEMENT_AREA 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 |
|---|---|---|---|---|---|---|
| CLIENT_NUMBER | IX_CUSTOMER_MANAGEMENT_AREA |
|
The client number associated to the customer management area | |||
| NAME | IX_CUSTOMER_MANAGEMENT_AREA |
|
The name of the customer management area | |||
| SAP_ERP_JCO_DEST_NAME |
|
The mandatory JCo destination to an SAP ERP/FI-CA system. This JCo destination is a configuration entry defined in the CONFIGURATION table. | ||||
| SAP_CRM_JCO_DEST_NAME |
|
The optional JCo destination to an SAP CRM system. This JCo destination is a configuration entry defined in the CONFIGURATION table. | ||||
| IS_DEFAULT |
|
Indicates that this area is the default customer management area. Only one default area can be defined. |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The client number associated to the customer management area |
| Type | DECIMAL(3), NOT NULL |
| Available Index | IX_CUSTOMER_MANAGEMENT_AREA |
| Definition | The name of the customer management area |
| Type | NVARCHAR(256), NOT NULL |
| Available Index | IX_CUSTOMER_MANAGEMENT_AREA |
| 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 |
| 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 |
| Definition | Indicates that this area is the default customer management area. Only one default area can be defined. |
| Type | DECIMAL(1), NOT NULL |
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:
| Indexed Column(s) | CLIENT_NUMBER,NAME |
| Unique | Yes |
| Partitioned | No |
