SAP ABAP View VGEOOBJLOC (View of Geoloc and Geoobjr)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-GEO (Application Component) Geographical Functions
     ⤷ SZGL (Package) R/3 Central Basis Development: Geo Locations

Basic Data

View Type	D	Database View
Database View	VGEOOBJLOC
Short Description	View of Geoloc and Geoobjr
Root table	GEOOBJR	Gen. object ref. (customer, plant, ...)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	GEOOBJR	GEOOBJR
2	GEOLOC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	GEOLOC	CLIENT	JL	EQ				0	0
2	GEOOBJR	CLIENT	JR	EQ			AND	0	0
3	GEOLOC	GUIDLOC	JL	EQ				0	0
4	GEOOBJR	GUIDLOC	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	GEOOBJR	CLIENT		☐	MANDT	☐	Client
2	GUIDOBJR	GEOOBJR	GUIDOBJR		☐	GEOGUID	☐	GUID 16
3	OBJKEY	GEOOBJR	OBJKEY		☐	SWO_TYPEID	☐	Object key
4	OBJTYPE	GEOOBJR	OBJTYPE		☐	SWO_OBJTYP	☐	Object Type
5	OBJSUBTYPE	GEOOBJR	OBJSUBTYPE		☐	SWO_OBJTYP	☐	Object Type
6	LOGSYS	GEOOBJR	LOGSYS		☐	LOGSYS	☐	Logical system
7	EXTID	GEOOBJR	EXTID		☐	GEOEXTID	☐	External ID for Geo objects (additional info)
8	CREATEDOBJR	GEOOBJR	CREATED		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	CREATEDBYOBJR	GEOOBJR	CREATEDBY		☐	UNAME	☐	User Name
10	CHANGEDOBJR	GEOOBJR	CHANGED		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	CHANGEDBYOBJR	GEOOBJR	CHANGEDBY		☐	UNAME	☐	User Name
12	GUIDLOC	GEOLOC	GUIDLOC		☐	GEOGUID	☐	GUID 16
13	LONGITUDE	GEOLOC	LONGITUDE		☐	GEOLON	☐	Geo location longitude
14	LATITUDE	GEOLOC	LATITUDE		☐	GEOLAT	☐	Geo location latitude
15	ALTITUDE	GEOLOC	ALTITUDE		☐	GEOALT	☐	Geo location height
16	SRCID	GEOLOC	SRCID		☐	GEOSRCID	☐	Geo location data source ID/Geocoder ID
17	SRCTSTMP	GEOLOC	SRCTSTMP		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
18	PRECISID	GEOLOC	PRECISID		☐	GEOPRECIS	☐	Precision (street, postal code, ...) of a Geo location
19	TZONE	GEOLOC	TZONE		☐	TIMEZONE	☐	Time Zone
20	CREATEDLOC	GEOLOC	CREATED		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
21	CREATEDBYLOC	GEOLOC	CREATEDBY		☐	UNAME	☐	User Name
22	CHANGEDLOC	GEOLOC	CHANGED		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
23	CHANGEDBYLOC	GEOLOC	CHANGEDBY		☐	UNAME	☐	User Name
24	ADDRNUMBER	GEOLOC	ADDRNUMBER		☐	AD_ADDRNUM	☐	Address number
25	ADDRLOGSYS	GEOLOC	ADDRLOGSYS		☐	LOGSYS	☐	Logical system
26	ADDRGUID	GEOLOC	ADDRGUID		☐	AD_GUID	☐	Address guid

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110908
SAP Release Created in	46D