SAP ABAP Table JGVSADRGP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JGVSADRGP	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	ADRNR	☑	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number
3	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
4	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
5	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
6	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
7	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
8	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
9	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
10	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
11	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
12	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
13	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
14	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
15	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
16	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
17	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
18	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
19	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key
20	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
21	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
22	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
23	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
24	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
25	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
26	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
27	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
28	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
29	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
30	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
31	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
32	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
33	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
34	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGVSADRGP	ANRED	TJG43	JANRED	REF	C	CN
2	JGVSADRGP	CITYC	T005G	CITYC	REF	C	CN
3	JGVSADRGP	COUNC	T005E	COUNC	REF	C	CN
4	JGVSADRGP	LAND1	T005	LAND1	REF	C	CN
5	JGVSADRGP	MANDT	T000	MANDT	KEY	1	CN
6	JGVSADRGP	NAMZU	T535N	TITEL
7	JGVSADRGP	PEINORTPF	JSTORTPRO	ALORT	REF	C	CN
8	JGVSADRGP	POSTEINORT	JSTORTPRO	ALORT	REF	C	CN
9	JGVSADRGP	POSTEINSTR	JSTSTRPRO	STRASSENNR	REF	C	CN
10	JGVSADRGP	REGIO	T005S	BLAND	REF	C	CN
11	JGVSADRGP	SPRAS	T002	SPRAS	REF	C	CN
12	JGVSADRGP	TITEL	T535N	TITEL
13	JGVSADRGP	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in