SAP ABAP Table J_1SVBADRE (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	J_1SVBADRE	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	BUNDNR	☑	BUND	BUND	CHAR	12	0	Bundle	JVTBUND
3	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
4	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
5	ETENR	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	JKEP
6	LFNDR	☑	LFNDR_MNG	NUMC8	NUMC	8	0	IS-M: Sequence Number for Quantity Schedule Line
7	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
8	ADRESSVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
9	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
10	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
11	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
12	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
13	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
14	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
15	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
16	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
17	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
18	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
19	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
20	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
21	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
22	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
23	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
24	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
25	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
26	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
27	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
28	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
29	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
30	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
31	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
32	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
33	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
34	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
35	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
36	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
37	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
38	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
39	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
40	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
41	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
42	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
43	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
44	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
45	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
46	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
47	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
48	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
49	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
50	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
51	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
52	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
53	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
54	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
55	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
56	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
57	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
58	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
59	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
60	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
61	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
62	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
63	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
64	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
65	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
66	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
67	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
68	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
69	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
70	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
71	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
72	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
73	VBELN_REF	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
74	POSNR_REF	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
75	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
76	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
77	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
78	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
79	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
80	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
81	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
82	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
83	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
84	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
85	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
86	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
87	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
88	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1SVBADRE	ADRNR	JGTSADR	ADRNR	KEY	1	CN
2	J_1SVBADRE	ANRED	TJG43	JANRED	REF	C	CN
3	J_1SVBADRE	BEABLS_REF	JRTBEABST	BEABLST	REF	C	CN
4	J_1SVBADRE	BUNDNR	JVTBUND	BUNDNR	KEY	1	CN
5	J_1SVBADRE	CITYC	T005G	CITYC	REF	C	CN
6	J_1SVBADRE	COUNC	T005E	COUNC	REF	C	CN
7	J_1SVBADRE	ETENR	JKEP	ETENR	KEY	1	CN
8	J_1SVBADRE	GPHERK	TJG41	GPHERK	KEY	1	CN
9	J_1SVBADRE	GP_REF	JGTGPNR	GPNR	REF	C	CN
10	J_1SVBADRE	JPARVW_REF	TJG39	JPARVW	REF	C	CN
11	J_1SVBADRE	LAND1	T005	LAND1	REF	C	CN
12	J_1SVBADRE	MANDT	T000	MANDT	KEY	1	CN
13	J_1SVBADRE	NAMZU	T535N	TITEL
14	J_1SVBADRE	NIELS	TNLS	NIELS	REF	C	CN
15	J_1SVBADRE	PEINORTPF	JSTORTPRO	ALORT	REF	C	CN
16	J_1SVBADRE	POSNR	JKAP	POSNR	KEY	1	CN
17	J_1SVBADRE	POSNR_REF	JKAP	POSNR	REF	C	CN
18	J_1SVBADRE	POSTEINORT	JSTORTPRO	ALORT	REF	C	CN
19	J_1SVBADRE	POSTEINSTR	JSTSTRPRO	STRASSENNR	REF	C	CN
20	J_1SVBADRE	REGIO	T005S	BLAND	REF	C	CN
21	J_1SVBADRE	SPRAS	T002	SPRAS	REF	C	CN
22	J_1SVBADRE	TITEL	T535N	TITEL
23	J_1SVBADRE	VBELN	JKAK	VBELN	KEY	1	CN
24	J_1SVBADRE	VBELN_REF	JKAK	VBELN	REF	C	CN
25	J_1SVBADRE	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in