CUSTOMER_MANAGEMENT_AREA

Definition


The CUSTOMER_MANAGEMENT_AREA table contains a set of customer management areas defined in the system landscape in an integrated SAP Solution scenario

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 Application Help for more information.

Technical Data


Schema Version 5.0.6
Partitioned No

Summary


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
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.

          Column Details

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

          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