SAP ABAP Table VGEADR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VGEADR	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	OBJNR	☑	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)
3	OBTYP	☑	SOBTYP	SOBTYP	NUMC	2	0	Object type for objects to which addresses are assigned	TZV03
4	ADRNR	☑	SADRNR	SADRNR	CHAR	10	0	Address number	SANS1
5	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
6	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
7	ADRZUS	☐	ADRZUS	TEXT35	CHAR	35	0	Address addit. info. (e.g. storey)
8	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
9	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
10	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
11	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
12	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
13	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
14	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
15	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
16	STRA1	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
17	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
18	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VGEADR	ADRNR	SANS1	ADRNR	KEY	1	1
2	VGEADR	LAND1	T005	LAND1	KEY	1	1
3	VGEADR	MANDT	T000	MANDT	KEY	1	1
4	VGEADR	OBTYP	TZV03	OBTYP	KEY	1	1
5	VGEADR	REGIO	T005S	BLAND	KEY	1	1

History

Last changed by/on	SAP	20130529
SAP Release Created in