Show TOC

  CRM Territory Attribute Set

Technical Name: 0CRM_TRAS_ATTR

Technical Data

DataSource Type

Attributes (Master Data)

Hierarchies

Application Components

CRM Sales (0CRM_SALES-IO)

Available as from OLTP Release

CRM 4.0

Available as from PlugIn Release

n/a

RemoteCube-Capable

Use

This DataSource is one of several that enables you to extract Territory Managementinformation from your CRM system to the Business Information Warehouse.

The CRM Territory Attribute Set DataSource extracts the attributes used by the customer to define territories.

Delta Update

This DataSource is delta enabled.

Fields of Origin for the Extract Structure

Fields in the Extract Structure

Description of the Field in the Extract Structure

Table of Origin

Field in the Table of Origin

BP_BRICK

Market segmentation of business partner (CRM Pharma)

CRMM_TERRATTRIB

BP_BRICK

BP_COUNTRY

Country key of business partner

CRMM_TERRATTRIB

BP_COUNTRY

BP_GROUP

Business partner group

CRMM_TERRATTRIB

BP_GROUP

BP_MAIN_SPEC

Qualification key of business partner (CRM Pharma/Healthcare)

CRMM_TERRATTRIB

BP_MAIN_SPEC

BP_POST_CODE

City Postal Code

CRMM_TERRATTRIB

BP_POST_CODE

BP_REGION

Region (State, Province, County)

CRMM_TERRATTRIB

BP_REGION

BP_SUBGROUP

Business partner subgroup

CRMM_TERRATTRIB

BP_SUBGROUP

BU_PARTNER

Business partner number

CRMM_TERRATTRIB

BP_GUID

CLIENT

Client

CRMM_TERRATTRIB

CLIENT

PM_CATEGORY

Category GUID

CRMM_TERRATTRIB

PM_CATEGORY

RECORDMODE

Record modus

TERR_GUID

Territory GUID

CRMM_TERRATTRIB

TERRITORY_V_GUID

TRAT_GUID

CRM order object GUID

CRMM_TERRATTRIB

GUID

VALID_FROM

Date (valid from)

CRMM_TERRITORY_V

VALID_FROM

VALID_TO Date (valid to)

CRMM_TERRITORY_V

VALID_TO