SAP ABAP Table VIRAPP (RE: Rental Application)
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 | INTTAB | Structure |
Structure | VIRAPP | Table Relationship Diagram |
Short Description | RE: Rental Application |
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 | SIDGDEMAND | RESADSGDEMAND | RESADSGDEMAND | CHAR | 20 | 0 | Rental Request Identification (Global ID) | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VIRAPP | BEARKZ | TIVC1 | BEARKZ | KEY | 1 | CN |
2 | VIRAPP | BSTAT | TIVC3 | BSTAT | KEY | 1 | CN |
3 | VIRAPP | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | VIRAPP | PARTFROM | TIVP1 | PARTFROM | KEY | 1 | CN |
5 | VIRAPP | PARTWAY | TIVP3 | WAY | KEY | 1 | CN |
6 | VIRAPP | PARTWHY | TIVP2 | PARTWHY | KEY | 1 | CN |
7 | VIRAPP | SBONI | TIV62 | SBONI | |||
8 | VIRAPP | SBUEADR | SPRT1 | PARTNR | |||
9 | VIRAPP | VADRNR | BP000 | PARTNR | KEY | 1 | CN |
10 | VIRAPP | VORMKZ | TIVC2 | VORMKZ | KEY | 1 | CN |
11 | VIRAPP | XSTAAT | T005 | LAND1 | REF | C | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |