SAP ABAP View V_CMS_LR_DE_R_SH (View - Search Real Estate by Land Register Details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-RE (Application Component) Real Estate
     ⤷ CMS_RE (Package) Collateral Management System: Real Esate

Basic Data

View Type	D	Database View
Database View	V_CMS_LR_DE_R_SH
Short Description	View - Search Real Estate by Land Register Details
Root table	CMS_RE_OBJ	Real estate header details

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CMS_RE_OBJ	CMS_RE_OBJ
2	CMS_RE_OBJ_PRT
3	CMS_RE_PRT_LR
4	CMS_LR_DE_A
5	CMS_LR_DE_B
6	TCMS_RE_TYP
7	TCMS_RE_TYP_T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CMS_RE_OBJ	MANDT	JL	EQ				0	0
2	CMS_RE_OBJ_PRT	MANDT	JR	EQ			AND	0	0
3	CMS_RE_OBJ	OBJ_GUID	JL	EQ				0	0
4	CMS_RE_OBJ_PRT	OBJ_GUID	JR	EQ			AND	0	0
5	CMS_RE_OBJ_PRT	MANDT	JL	EQ				0	0
6	CMS_RE_PRT_LR	MANDT	JR	EQ			AND	0	0
7	CMS_RE_OBJ_PRT	OBJ_PRT_GUID	JL	EQ				0	0
8	CMS_RE_PRT_LR	OBJ_PRT_GUID	JR	EQ			AND	0	0
9	CMS_RE_PRT_LR	MANDT	JL	EQ				0	0
10	CMS_LR_DE_B	MANDT	JR	EQ			AND	0	0
11	CMS_RE_PRT_LR	LR_ID	JL	EQ				0	0
12	CMS_LR_DE_B	SECB_GUID	JR	EQ			AND	0	0
13	CMS_LR_DE_B	MANDT	JL	EQ				0	0
14	CMS_LR_DE_A	MANDT	JR	EQ			AND	0	0
15	CMS_LR_DE_B	SECA_GUID	JL	EQ				0	0
16	CMS_LR_DE_A	SECA_GUID	JR	EQ			AND	0	0
17	TCMS_RE_TYP	MANDT	JL	EQ				0	0
18	CMS_RE_OBJ	MANDT	JR	EQ			AND	0	0
19	TCMS_RE_TYP	OBJECT_TYPE	JL	EQ				0	0
20	CMS_RE_OBJ	OBJECT_TYPE	JR	EQ			AND	0	0
21	TCMS_RE_TYP	MANDT	JL	EQ				0	0
22	TCMS_RE_TYP_T	MANDT	JR	EQ			AND	0	0
23	TCMS_RE_TYP	OBJECT_TYPE	JL	EQ				0	0
24	TCMS_RE_TYP_T	OBJECT_TYPE	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	CMS_RE_OBJ	MANDT		☐	MANDT	☐	Client
2	OBJ_GUID	CMS_RE_OBJ	OBJ_GUID		☐	CMS_RE_DTE_OBJ_GUID	☐	GUID for Real Estate Object
3	OBJ_PRT_GUID	CMS_RE_OBJ_PRT	OBJ_PRT_GUID		☐	CMS_RE_DTE_OBJ_PRT_GUID	☐	GUID for Object part
4	PRT_LR_GUID	CMS_RE_PRT_LR	PRT_LR_GUID		☐	CMS_RE_DTE_PRT_LR_GUID	☐	GUID for part LR
5	LR_ID	CMS_RE_PRT_LR	LR_ID		☐	CMS_RE_DTE_LR_ID_LKY	☐	Link Key between RE and LR systems
6	SECA_GUID	CMS_LR_DE_A	SECA_GUID		☐	CMS_DTE_LR_DE_SECA_GUID	☐	GUID for Table CMS_LR_DE_A
7	DISTRICT	CMS_LR_DE_A	DISTRICT		☐	CMS_DTE_LR_DE_DISTRICT	☐	District Court
8	SUB_DISTRICT	CMS_LR_DE_A	SUB_DISTRICT		☐	CMS_DTE_LR_DE_SUB_DISTRICT	☐	Land Register District
9	VOLUME_NO	CMS_LR_DE_A	VOLUME_NO		☐	CMS_DTE_LR_DE_VOLUME_NO	☐	Volume Number
10	PAGE_NO	CMS_LR_DE_A	PAGE_NO		☐	CMS_DTE_LR_DE_PAGE_NO	☐	Page Number
11	LANGUAGE	TCMS_RE_TYP_T	LANGUAGE		☐	CMS_RE_DTE_LNG_KEY	☐	Language in which description is needed
12	REG_TYPE	CMS_LR_DE_A	REG_TYPE		☐	CMS_DTE_LR_DE_REG_TYP	☐	Register Type
13	ADMIN_ORG_UNIT	CMS_RE_OBJ	ADMIN_ORG_UNIT		☐	CMS_DTE_ADMINORG	☐	Administration Organizational Unit
14	OLD_REF_ID	CMS_LR_DE_A	OLD_REF_ID		☐	CMS_DTE_LR_DE_OLD_REF_ID	☐	Reference of Old Land Register, in case data was migrated
15	OBJECT_ID	CMS_RE_OBJ	OBJECT_ID		☐	CMS_RE_DTE_OBJECT_ID	☐	Object ID
16	OBJECT_TYPE	CMS_RE_OBJ	OBJECT_TYPE		☐	CMS_RE_DTE_OBJ_TYP	☐	Real Estate Object Type ID
17	OBJECT_DESC	CMS_RE_OBJ	OBJECT_DESC		☐	CMS_RE_DTE_OBJ_DESC	☐	Description of the Real Estate Object
18	NAME	TCMS_RE_TYP_T	NAME		☐	CMS_RE_DTE_NAME	☐	Name in a specified language

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	20130529
SAP Release Created in	200