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