SAP ABAP Table RVIMI11_ZS (RE: Application - Master Data and Additional Fields)

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

Table Category	INTTAB	Structure
Structure	RVIMI11_ZS	Table Relationship Diagram
Short Description	RE: Application - Master Data and Additional Fields

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	Applications - Real Estate Management
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SBWNR	☐	SBWNR	SBWNR	NUMC	7	0	Application number	*
4	SBWSTA	☐	SBWSTA	SBWSTAT	CHAR	1	0	Applicant status
5	VADRNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
6	SBWTYP	☐	SBWTYP	SBWTYP	CHAR	1	0	Applicant category
7	XANSPRP	☐	XANSPRP	XMBEZ	CHAR	30	0	Contact person
8	XSTAAT	☐	XSTAAT	LAND1	CHAR	3	0	Nationality	T005
9	XPASSNR	☐	XPASSNR	CHAR18	CHAR	18	0	Passport number
10	DPASSV	☐	DPASSV	DDAT	DATS	8	0	Date of submission of passport
11	XARBSTR	☐	XARBSTR	XCHA35	CHAR	35	0	Employer street
12	XARBORT	☐	XARBORT	XCHA35	CHAR	35	0	Employer postcode/city
13	XAVERM	☐	XAVERM	XCH50	CHAR	50	0	Current landlord
14	XAVSTR	☐	XAVSTR	XCHA35	CHAR	35	0	Landlord street
15	XAORT	☐	XAORT	XCHA35	CHAR	35	0	Postal code/city current landlord
16	XREFEREN	☐	XREFEREN	XCHA35	CHAR	35	0	Applicant reference data
17	SBONI	☐	SBONI	SBONI	NUMC	2	0	Credit standing application	TIV62
18	XWBONI	☐	XWBONI	XTEXT50	CHAR	50	0	Reason for credit standing
19	XALTSEX	☐	XALTSEX	XCHA35	CHAR	35	0	Age/sex of children
20	APERS	☐	APERS	DEC3	DEC	3	0	Number of persons
21	SBUEADR	☐	SBUEADR	SPARTNR	CHAR	10	0	Guarantor address	SPRT1
22	XTIER1	☐	XTIERE	XCHA35	CHAR	35	0	Domestic animal description
23	XABSAGE	☐	XABSAGE	XLBEZ	CHAR	60	0	Reason for rejection
24	DABSAGE	☐	DABSAGE	DDAT	DATS	8	0	Rejection date
25	XSITZ	☐	XSITZ	XCHA35	CHAR	35	0	Company head office
26	JOPTIO	☐	JOPTIO	JANEI	CHAR	1	0	Opting approved
27	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
28	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
29	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
30	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
31	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
32	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
33	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
34	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
35	DEINB	☐	DEINB	DDAT	DATS	8	0	Date application was received
36	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
37	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
38	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
39	RBELBIND1	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	*
40	RBELBIND2	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	*
41	RBELBIND3	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	*
42	RBELBIND4	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	*
43	DENDB	☐	VVDENDB	DDAT	DATS	8	0	Application valid to
44	BEARKZ	☐	VVIBEARKZ	CHAR4	CHAR	4	0	Processing Indicator for Rental Request	TIVC1
45	VORMKZ	☐	VVIVORMKZ	CHAR4	CHAR	4	0	Preselection Indicator for Rental Request	TIVC2
46	BSTAT	☐	VVIBSTAT	CHAR4	CHAR	4	0	Rental Request Processing Status	TIVC3
47	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
48	PARTFROM	☐	VVIPARTFROM	CHAR4	CHAR	4	0	Source of Prospect	TIVP1
49	PARTWHY	☐	VVIPARTWHY	CHAR4	CHAR	4	0	Reason for Acquisition	TIVP2
50	PARTWAY	☐	VVIWAY	CHAR4	CHAR	4	0	Enquiry method	TIVP3
51	XXSTAAT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
52	XKBONI	☐	XKBONI	XKBEZ	CHAR	15	0	Description of credit standing of application
53	XMBONI	☐	XMBONI	XMBEZ	CHAR	30	0	Description of credit standing of application

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RVIMI11_ZS	BEARKZ	TIVC1	BEARKZ	KEY	1	CN
2	RVIMI11_ZS	BSTAT	TIVC3	BSTAT	KEY	1	CN
3	RVIMI11_ZS	MANDT	T000	MANDT	KEY	1	CN
4	RVIMI11_ZS	PARTFROM	TIVP1	PARTFROM	KEY	1	CN
5	RVIMI11_ZS	PARTWAY	TIVP3	WAY	KEY	1	CN
6	RVIMI11_ZS	PARTWHY	TIVP2	PARTWHY	KEY	1	CN
7	RVIMI11_ZS	SBONI	TIV62	SBONI
8	RVIMI11_ZS	SBUEADR	SPRT1	PARTNR
9	RVIMI11_ZS	VADRNR	BP000	PARTNR	KEY	1	CN
10	RVIMI11_ZS	VORMKZ	TIVC2	VORMKZ	KEY	1	CN
11	RVIMI11_ZS	XSTAAT	T005	LAND1	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in