SAP ABAP Table VIRPS402 (Real Estate: Ref. Info Structure S402 (Business Entities))
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 | VIRPS402 | Table Relationship Diagram |
Short Description | Real Estate: Ref. Info Structure S402 (Business Entities) |
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 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
2 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
3 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | VIOB01 | |
4 | PROFL | VVAPROF | APROF | CHAR | 6 | 0 | Settlement profile for costs | TKB1A | |
5 | XPROFL | VVXPROFL | TEXT30 | CHAR | 30 | 0 | Settlement profile for costs | ||
6 | ANLN1 | VVANLN1 | ANLN1 | CHAR | 12 | 0 | Asset: main number | ANLH | |
7 | ANZWE | VVAWE | DEC6 | DEC | 6 | 0 | No. of business entities | ||
8 | USR00 | USRCHAR201 | USRCHAR20 | CHAR | 20 | 0 | User-defined field 1 for 20 characters | ||
9 | USR01 | USRCHAR202 | USRCHAR20 | CHAR | 20 | 0 | User field 2 for 20 characters | ||
10 | USR02 | USRCHAR101 | USRCHAR10 | CHAR | 10 | 0 | User-defined field 1 for 10 characters | ||
11 | USR03 | USRCHAR102 | USRCHAR10 | CHAR | 10 | 0 | User-defined field 2 for 10 characters | ||
12 | USR04 | USRQUAN131 | USRQUAN13 | QUAN | 13 | 3 | User field 1 for set (length 10,3) | ||
13 | USE04 | USRUNIT | MEINS | UNIT | 3 | 0 | User field: Unit for quantity fields | * | |
14 | USR05 | USRQUAN132 | USRQUAN13 | QUAN | 13 | 3 | User field 2 for set (length 10.3) | ||
15 | USE05 | USRUNIT | MEINS | UNIT | 3 | 0 | User field: Unit for quantity fields | * | |
16 | USR06 | USRCURR131 | USRCURR13 | CURR | 13 | 3 | User field 1 for values (length 10.3) | ||
17 | USE06 | USRCUKY | WAERS | CUKY | 5 | 0 | User field: Unit for value fields | * | |
18 | USR07 | USRCURR132 | USRCURR13 | CURR | 13 | 3 | User field 2 for values (length 10.3) | ||
19 | USE07 | USRCUKY | WAERS | CUKY | 5 | 0 | User field: Unit for value fields | * | |
20 | USR08 | USRDATE1 | USRDATE | DATS | 8 | 0 | User field 1 for date | ||
21 | USR09 | USRDATE2 | USRDATE | DATS | 8 | 0 | User field 2 for date | ||
22 | USR10 | USRFLAG1 | FLAG | CHAR | 1 | 0 | User field 1 indicator for evaluations | ||
23 | USR11 | USRFLAG2 | FLAG | CHAR | 1 | 0 | User field 2 indicator for evaluations | ||
24 | DAKTBEST | DAKTBEST | DATUM | DATS | 8 | 0 | Date active in portfolio | ||
25 | FEINS | VVKFEINS | CHAR5 | CHAR | 5 | 0 | Unit: area | ||
26 | VVLEN | VVKLEN | CHAR5 | CHAR | 5 | 0 | Unit: length | ||
27 | REINS | VVKREINS | CHAR5 | CHAR | 5 | 0 | Unit: room content | ||
28 | WAERS | VVKWAERS | CHAR5 | CHAR | 5 | 0 | Unit: currency | ||
29 | RFAKT | VVXFAKT | CHAR6 | CHAR | 6 | 0 | Conversion factor for fractional share of property | ||
30 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
31 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
32 | SINSTBEZ | SINSTBEZ | SINSTBEZ | NUMC | 5 | 0 | Maintenance district | TIV16 | |
33 | XINSTBEZ | VVXINSTBEZ | CHAR15 | CHAR | 15 | 0 | Location: Maintenance district | ||
34 | SOBJLAGE | RESOBJLAGE | RESOBJLAGE | NUMC | 2 | 0 | Indicator: District Location of Object | TIV45 | |
35 | XOBJLAGE | VVXOBJLAGE | CHAR15 | CHAR | 15 | 0 | Location: district | ||
36 | SSTDORT | VVSSTDORT | VVSSTDORT | CHAR | 10 | 0 | Regional location | TIV35 | |
37 | XSTDORT | VVXSTDORT | XTEXT35 | CHAR | 35 | 0 | Regional location | ||
38 | SLAGEWE | SLAGEWE | SLAGEWE | NUMC | 4 | 0 | Business entity location number | TIV10 | |
39 | XLAGEWE | VVXLAGEWE | CHAR15 | CHAR | 15 | 0 | Location: Business ent. | ||
40 | SVERKEHR | SVERKEHR | SVERKEHR | CHAR | 1 | 0 | Transport Connections of Business Entity | TIV44 | |
41 | XVERKEHR | VVXERKEHR | XTEXT50 | CHAR | 50 | 0 | Location: Transport connections | ||
42 | SMIETR | SMIETR | SMIETR | CHAR | 5 | 0 | Tenancy law | TIV03 | |
43 | XMIETR | VVXMIETR | XTEXT30 | CHAR | 30 | 0 | Tenancy law | ||
44 | SMIETSP | SMIETSP | SMIETSP | CHAR | 6 | 0 | Representative list of rents assignment | TIV20 | |
45 | XMIETSP | VVXMIETSP | CHAR15 | CHAR | 15 | 0 | Representative list of rents: allocation | ||
46 | PROFIL | VVPROFIL | VVPROFIL | CHAR | 7 | 0 | Planning profile for Real Estate objects | TIV98 | |
47 | XPROFIL | VVXPROFIL | TEXT40 | CHAR | 40 | 0 | Planning profile | ||
48 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
49 | RKZBEST | RKZBEST | RKZBEST | CHAR | 1 | 0 | Object status | ||
50 | XKZBEST | VVXKZBEST | TEXT40 | CHAR | 40 | 0 | Status: portfolio | ||
51 | STTXT_EXT | VVXSTXTEXT | CHAR40 | CHAR | 40 | 0 | Status: Set by user | ||
52 | STTXT_INT | VVXSTTXTIN | CHAR40 | CHAR | 40 | 0 | Status: Set by system | ||
53 | XWETEXT | VVXWETEXT | XMBEZ | CHAR | 30 | 0 | Text for Business Entity | ||
54 | VORBK | VORBK | ABRVAR | CHAR | 4 | 0 | Predefined operating costs settlement variant | TIA01 | |
55 | XVORBK | VVXVORBK | CHAR50 | CHAR | 50 | 0 | Predefined operating costs settlement variant | ||
56 | VORHK | VORHK | ABRVAR | CHAR | 4 | 0 | Predefined heating expenses settlement variant | TIA01 | |
57 | XVORHK | VVXVORHK | CHAR50 | CHAR | 50 | 0 | Predefined heating expenses settlement variant | ||
58 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
59 | ADRNR | SOBJNR | SOBJNR | NUMC | 10 | 0 | Object number (virtual object) | * | |
60 | XSTRASSE | VVXSTRASSE | TEXT35 | CHAR | 35 | 0 | Address: Street/house number | ||
61 | XPLZ | VVXPLZ | PSTLZ | CHAR | 10 | 0 | Address: Postal code | ||
62 | XORT | VVXORT | TEXT35 | CHAR | 35 | 0 | Address: City |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VIRPS402 | ANLN1 | ANLH | ANLN1 | |||
2 | VIRPS402 | BUKRS | T001 | BUKRS | |||
3 | VIRPS402 | GSBER | TGSB | GSBER | |||
4 | VIRPS402 | KOKRS | TKA01 | KOKRS | |||
5 | VIRPS402 | KOSTL | CSKS | KOSTL | |||
6 | VIRPS402 | OBJNR | ONR00 | OBJNR | |||
7 | VIRPS402 | PRCTR | CEPC | PRCTR | |||
8 | VIRPS402 | PROFIL | TIV98 | PROFIL | |||
9 | VIRPS402 | PROFL | TKB1A | APROF | |||
10 | VIRPS402 | SINSTBEZ | TIV16 | SINSTBEZ | |||
11 | VIRPS402 | SLAGEWE | TIV10 | SLAGEWE | |||
12 | VIRPS402 | SMIETR | TIV03 | SMIETR | |||
13 | VIRPS402 | SMIETSP | TIV20 | SMIETSP | |||
14 | VIRPS402 | SOBJLAGE | TIV45 | SOBJLAGE | |||
15 | VIRPS402 | SSTDORT | TIV35 | SSTDORT | |||
16 | VIRPS402 | SVERKEHR | TIV44 | SVERKEHR | |||
17 | VIRPS402 | SWENR | VIOB01 | SWENR | |||
18 | VIRPS402 | VORBK | TIA01 | ABRVAR | |||
19 | VIRPS402 | VORHK | TIA01 | ABRVAR |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |