SAP ABAP Table AVIMI11 (Change document structure; individually generated)

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	AVIMI11	Table Relationship Diagram
Short Description	Change document structure; individually generated

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	VIMI11
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	.INCLUDE	☐				0	0	Structures for generating change document update programs
52	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in