SAP ABAP View M_DEBIM (View for Customer Selection for Rental Agreement)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

View Type	D	Database View
Database View	M_DEBIM
Short Description	View for Customer Selection for Rental Agreement
Root table	VIMIMV	Lease-Out

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIMIMV	VIMIMV
2	VZGPO
3	BP000

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VIMIMV	MANDT	JL	EQ				0	0
2	VZGPO	MANDT	JR	EQ			AND	0	0
3	VIMIMV	MANDT	JL	EQ				0	0
4	BP000	MANDT	JR	EQ			AND	0	0
5	VZGPO	SOBJEKT	JL	EQ				0	0
6	VIMIMV	INTRENO	JR	EQ			AND	0	0
7	VZGPO	PARTNR	JL	EQ				0	0
8	BP000	PARTNR	JR	EQ			AND	0	0
9	VZGPO	ROLETYP		EQ	'0600'		OR	0	0
10	VZGPO	ROLETYP		EQ	'0601'		OR	0	0
11	VZGPO	ROLETYP		EQ	'0624'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VIMIMV	MANDT		☐	MANDT	☐	Client
2	INTRENO	VIMIMV	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
3	SNUMOBJ	VZGPO	SNUMOBJ		☐	VVNUMOBJ	☐	Key for number range object
4	SOBJEKT	VZGPO	SOBJEKT		☐	VVSOBJGPO	☐	Internal key for object for business partner table
5	PARTNR	VZGPO	PARTNR		☐	BP_PARTNR	☐	Business Partner Number
6	ROLETYP	VZGPO	ROLETYP		☐	BP_ROLETYP	☐	Business Partner Role Category
7	DTRANS	VZGPO	DTRANS		☐	VVDTRANS	☐	Flow data key: System date
8	KUNNR	VZGPO	KUNNR		☐	KUNNR	☐	Customer Number
9	NAME1	BP000	NAME1		☐	BP_NAME1	☐	Name 1 (surname for persons, otherwise company name)
10	NAME2	BP000	NAME2		☐	BP_NAME2	☐	Name 2 (Continuation of NAME 1)
11	BUKRS	VIMIMV	BUKRS		☐	BUKRS	☐	Company Code
12	SMIVE	VIMIMV	SMIVE		☐	SMIVE	☐	Lease-Out Number
13	SWENR	VIMIMV	SWENR		☐	SWENR	☐	Business Entity Number
14	SMENR	VIMIMV	SMENR		☐	SMENR	☐	Number of Rental Unit
15	DMIBEG	VIMIMV	DMIBEG		☐	DMIBE	☐	Rental start date
16	DMIEND	VIMIMV	DMIEND		☐	DMIEN	☐	Rental end date
17	SMVART	VIMIMV	SMVART		☐	SMVART	☐	External Real Estate contract type
18	DKUEZU	VIMIMV	DKUEZU		☐	DKUZU	☐	Contract Notice Per
19	E_SMIVE	VIMIMV	E_SMIVE		☐	VVESMIVE	☐	Contract No. of Collective Lease-Outs
20	KONTOBV	VIMIMV	KONTOBV		☐	VVIKONTOBV	☐	Bank procedure account number

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