SAP ABAP Table CRMS_TERRATTRIB_DATES (Attributes structure with rule dates)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-TM (Application Component) Territory Management
     ⤷ CRM_TMIL (Package) Package for territory mgmt GENIL model

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_TERRATTRIB_DATES	Table Relationship Diagram
Short Description	Attributes structure with rule dates

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Territory Responsibility
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	TERRITORY_V_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	STATE	☐	CRMT_TERRITORY_STATE	CRM_TERRITORY_STATE	CHAR	1	0	Territory Status
6	SIGN	☐	CRMT_TERRMAN_ATTRIBUTE_SIGN	CHAR1	CHAR	1	0	+/- Sign for Attribute Combination (Include/Exclude)
7	BP_BRICK	☐	CRMPHAT_BRICK_NUMBER	CRMPHA_BRICK_NUMBER	CHAR	10	0	CRM Pharma. BP : Market Segmentation
8	BP_GROUP	☐	CRMPHAT_BP_GROUP	CRMPHA_BP_GROUP	CHAR	4	0	Group
9	BP_SUBGROUP	☐	CRMPHAT_BP_SUBGROUP	CRMPHA_BP_SUBGROUP	CHAR	4	0	Subgroup
10	BP_MAIN_SPEC	☐	CRMPHAT_BP_SPEC_KEY	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma/Healthcare BP: Qualification Key	*
11	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
12	BP_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
13	BP_ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
14	PM_CATEGORY	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
15	BP_POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
16	BP_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
17	PM_HIERARCHYGUID	☐	COMT_HIERARCHY_GUID	SYSUUID	RAW	16	0	Category Hierarchy GUID
18	PM_CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
19	BP_NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
20	NO_UNDEFIN_AFT	☐	CRMT_TERRITORY_AFT_MAINTAINED	CHAR1	CHAR	1	0	Territory AFT Maintained at Territory
21	AFT_0	☐	CRMT_TERRITORY_AFT_MAINTAINED	CHAR1	CHAR	1	0	Territory AFT Maintained at Territory
22	AFT_1	☐	CRMT_TERRITORY_AFT_MAINTAINED	CHAR1	CHAR	1	0	Territory AFT Maintained at Territory
23	AFT_2	☐	CRMT_TERRITORY_AFT_MAINTAINED	CHAR1	CHAR	1	0	Territory AFT Maintained at Territory
24	.INCLUDE	☐				0	0	Sales Area
25	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
26	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
27	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
28	SA_SALES_AREA	☐			CHAR	20	0
29	PM_SALE_CATEGORY	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
30	RULE_ID	☐	CRMDT_FDT_GUID	SYSUUID_C	CHAR	32	0	Rule Builder: Universal Unique Identifier
31	RULE_VALID_FROM	☐	CRM_TERRMAN_VALID_FROM	DATUM	DATS	8	0	Valid From Date of the Territory
32	RULE_VALID_TO	☐	CRM_TERRMAN_VALID_TO	DATUM	DATS	8	0	Valid To Date of the Territory

History

Last changed by/on	SAP	20130604
SAP Release Created in	701