SAP ABAP View CRMV_TR_TEXT (Territory Texts)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-TM (Application Component) Territory Management
     ⤷ CRM_TERRMAN (Package) Territory Management

Basic Data

View Type	D	Database View
Database View	CRMV_TR_TEXT
Short Description	Territory Texts
Root table	CRMM_TERRITORY	Area

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMM_TERRITORY	CRMM_TERRITORY
2	CRMM_TERRITORY_V
3	CRMM_TERRSTRUCT
4	CRMM_TERRITORY_T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMM_TERRITORY	CLIENT	JL	EQ				0	0
2	CRMM_TERRITORY_V	CLIENT	JR	EQ			AND	0	0
3	CRMM_TERRITORY	TERR_GUID	JL	EQ				0	0
4	CRMM_TERRITORY_V	TERR_GUID	JR	EQ			AND	0	0
5	CRMM_TERRITORY_V	CLIENT	JL	EQ				0	0
6	CRMM_TERRSTRUCT	CLIENT	JR	EQ			AND	0	0
7	CRMM_TERRITORY_V	GUID	JL	EQ				0	0
8	CRMM_TERRSTRUCT	TERRITORY_V_GUID	JR	EQ			AND	0	0
9	CRMM_TERRITORY_T	CLIENT	JL	EQ				0	0
10	CRMM_TERRITORY_V	CLIENT	JR	EQ			AND	0	0
11	CRMM_TERRITORY_T	TERRITORY_V_GUID	JL	EQ				0	0
12	CRMM_TERRITORY_V	GUID	JR	EQ			AND	0	0
13	CRMM_TERRITORY_V	STATE		NE	'E'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMM_TERRITORY	CLIENT		☐	MANDT	☐	Client
2	TERR_GUID	CRMM_TERRITORY	TERR_GUID		☐	CRMT_TERRITORY_GUID	☐	Territory GUID
3	GUID	CRMM_TERRSTRUCT	GUID		☐	CRMT_TERRITORY_GUID	☐	Territory GUID
4	PATH_GUID	CRMM_TERRSTRUCT	PATH_GUID		☐	CRMT_TERRITORY_PATH_GUID	☐	Territory Path GUID
5	TERRITORY_V_GUID	CRMM_TERRITORY_T	TERRITORY_V_GUID		☐	CRMT_TERRITORY_GUID	☐	Territory GUID
6	LANGU	CRMM_TERRITORY_T	LANGU		☐	CRMT_LANGUAGE	☐	Language Key of Description
7	DESCRIPTION	CRMM_TERRITORY_T	DESCRIPTION		☐	CRMT_TERRITORY_DESCRIPTION	☐	Territory Description
8	TERR_ID	CRMM_TERRITORY	TERR_ID		☐	CRMT_TERRITORY_ID	☐	Territory ID
9	VALID_FROM	CRMM_TERRITORY_V	VALID_FROM		☐	CRMT_VALID_FROM	☐	Time Dependency: Validity Start Date
10	VALID_TO	CRMM_TERRITORY_V	VALID_TO		☐	CRMT_VALID_TO	☐	Time Dependency: Validity End Date
11	PATH_ID	CRMM_TERRSTRUCT	PATH_ID		☐	CRMT_TERRITORY_PATH_ID	☐	Territory Hierarchy ID
12	DESCRIPTION_UC	CRMM_TERRITORY_T	DESCRIPTION_UC		☐	CRMT_TERRITORY_DESCRIPTION	☐	Territory Description

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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