SAP ABAP Table VIOB27 (Relationship between properties and buildings)

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	TRANSP	Transparent table
Transparent table	VIOB27	Table Relationship Diagram
Short Description	Relationship between properties and buildings

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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
4	SGRNR	☑	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
5	SGENR	☑	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
6	DGULTAB	☑	DGULTAB	DDAT	DATS	8	0	Date from when assignment is valid
7	PGEBANT	☐	VVPGEBANT	VVGEBANT	DEC	5	2	Percentage share of building on property
8	JEZUORD	☐	VVJEZUORD	JANE	CHAR	1	0	Flag: End of assignment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIOB27	BUKRS	T001	BUKRS	KEY	1	CN
2	VIOB27	MANDT	T000	MANDT	KEY	1	CN
3	VIOB27	SGENR	VIOB03	SGENR	KEY	1	CN
4	VIOB27	SGRNR	VIOB02	SGRNR	KEY	1	CN
5	VIOB27	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20020219
SAP Release Created in