SAP ABAP Table ISSR_VIGBUCH (ISSR: Grundbuchdaten + Adressedaten Grundbuchamt)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-SR (Application Component) Regulatory reporting for insurance companies
⤷ VVSRFISL (Package) Statutory Reporting for Insurance from FI-SL
⤷ FS-SR (Application Component) Regulatory reporting for insurance companies
⤷ VVSRFISL (Package) Statutory Reporting for Insurance from FI-SL
Basic Data
Table Category | INTTAB | Structure |
Structure | ISSR_VIGBUCH | Table Relationship Diagram |
Short Description | ISSR: Grundbuchdaten + Adressedaten Grundbuchamt |
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 | Address formating function module transfer structure | |||||
2 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
3 | NAME1 | NAME1_ADRS | TEXT40 | CHAR | 40 | 0 | Name 1 of an address | ||
4 | NAME2 | NAME2_ADRS | TEXT40 | CHAR | 40 | 0 | Name 2 of an address | ||
5 | NAME3 | NAME3_ADRS | TEXT40 | CHAR | 40 | 0 | Name 3 of an address | ||
6 | NAME4 | NAME4_ADRS | TEXT40 | CHAR | 40 | 0 | Name 4 of an address | ||
7 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
8 | PFACH | PFACH_BAS | PFACH | CHAR | 10 | 0 | PO box | ||
9 | PSTL2 | PSTL2_BAS | PSTLZ | CHAR | 10 | 0 | PO Box postal code | ||
10 | PFORT | PFORT_ADRS | TEXT40 | CHAR | 40 | 0 | PO Box city | ||
11 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
12 | PSTLZ | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
13 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
14 | ORT02 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
15 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
16 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
17 | INLND | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
18 | ANZZL | ANZEI | ANZEI | DEC | 2 | 0 | Number of lines in address | ||
19 | PRIOR | PRITY_ADRS | CHAR9 | CHAR | 9 | 0 | Address lines priority | ||
20 | WAREN | WAREN | WAREN | CHAR | 1 | 0 | Delivery address ID | ||
21 | LINE0 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
22 | LINE1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
23 | LINE2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
24 | LINE3 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
25 | LINE4 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
26 | LINE5 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
27 | LINE6 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
28 | LINE7 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
29 | LINE8 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
30 | LINE9 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
31 | LINEK | LINES | LINES | CHAR | 80 | 0 | Address line | ||
32 | LINED | LINES | LINES | CHAR | 80 | 0 | Address line | ||
33 | LINED0 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
34 | PO_BOX_LOBBY | AD_PO_BOX_LBY | TEXT40 | CHAR | 40 | 0 | PO Box Lobby | ||
35 | DELI_SERV_TYPE | AD_DELIVERY_SERVICE_TYPE | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | 0 | Type of Delivery Service | ||
36 | DELI_SERV_NUMBER | AD_DELIVERY_SERVICE_NUMBER | CHAR10 | CHAR | 10 | 0 | Number of Delivery Service | ||
37 | COUNTY | AD_COUNTY | TEXT40 | CHAR | 40 | 0 | County | ||
38 | TOWNSHIP | AD_TOWNSHIP | TEXT40 | CHAR | 40 | 0 | Township | ||
39 | .INCLUDE | 0 | 0 | Land register | |||||
40 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
41 | SGRUNDB | SGRUNDB | SGRUNDB | NUMC | 8 | 0 | Land register number | * | |
42 | .INCLUDE | 0 | 0 | Land Register Data Fields | |||||
43 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 1 | |||||
44 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 1a | |||||
45 | PARTNR | BP_PARTNR | BP_PARTNR | CHAR | 10 | 0 | Business Partner Number | BP000 | |
46 | XGBVON | XGBVON | XTEXT25 | CHAR | 25 | 0 | Land register district | ||
47 | NBANDNR | NBANDNR | TEXT15 | CHAR | 15 | 0 | Land register volume number | ||
48 | NBLATTNR | NBLATTNR | TEXT15 | CHAR | 15 | 0 | Land register page number | ||
49 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 1b | |||||
50 | JLOESCH | JLOESCH | JLOESCH | CHAR | 1 | 0 | Real Estate Deletion Indicator/Flag | ||
51 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 1c | |||||
52 | SGRBA | SGRBA | SGRBA | NUMC | 2 | 0 | Land register type | TDO6 | |
53 | FEINS | FEINS | MEINS | UNIT | 3 | 0 | Area unit | T006 | |
54 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 2 | |||||
55 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
56 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
57 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
58 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
59 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
60 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
61 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
62 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
63 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
64 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 3 | |||||
65 | XGBAMT | XGBAMT | XTEXT25 | CHAR | 25 | 0 | Land registry ID | ||
66 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 4 | |||||
67 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
68 | VVNUMOBJ | VVNUMOBJ | VVNUMOBJ | CHAR | 2 | 0 | Key for number range object | ||
69 | RFAKT | VVRFAKT | VVRFAKT | NUMC | 6 | 0 | Conversion factor for fractional share of property | ||
70 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
71 | BERGRP | VVBERGRP | VVBERGRP | CHAR | 40 | 0 | Authorization group | ||
72 | .INCLU--AP | 0 | 0 | LUM: Append für VIGBUCH-Erweiterung | |||||
73 | SGBVON | SGBVON | CHAR6 | CHAR | 6 | 0 | Grundbuchbezirk | TIVGBBEZ | |
74 | ENDDATE | VVDATECLOSE | DATE | DATS | 8 | 0 | Schließungsdatum Grundbuch | ||
75 | AKTKZ | AKTKZ | YNFLG | CHAR | 1 | 0 | Indicator: Active |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ISSR_VIGBUCH | FEINS | T006 | MSEHI | KEY | 1 | CN |
2 | ISSR_VIGBUCH | MANDT | T000 | MANDT | KEY | 1 | CN |
3 | ISSR_VIGBUCH | PARTNR | BP000 | PARTNR | KEY | 1 | CN |
4 | ISSR_VIGBUCH | SGBVON | TIVGBBEZ | SGBVON | |||
5 | ISSR_VIGBUCH | SGRBA | TDO6 | SGRBA | KEY | 1 | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 200 |