SAP ABAP Table PIQ_STUDENTLDB_ADDRESSDATA (Address Data for Logical Database RHIQ_STUDENT_LDB)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

Table Category	INTTAB	Structure
Structure	PIQ_STUDENTLDB_ADDRESSDATA	Table Relationship Diagram
Short Description	Address Data for Logical Database RHIQ_STUDENT_LDB

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	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Address Data
2	STANDARDADDRESS	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
3	C_O_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
4	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
5	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
6	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
7	NAMEOFREGIOGROUP	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
8	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
9	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
10	POSTL_COD3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
11	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
12	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
13	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
14	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
15	PO_W_O_NO	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
16	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
17	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
18	PO_BOX_NAMEOFSTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
19	POBOX_CTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
20	PO_CTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
21	PO_BOX_NAMEOFCOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
22	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
23	STR_ABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
24	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
25	HOUSE_NO2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
26	HOUSE_NO3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
27	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
28	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
29	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
30	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
31	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
32	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
33	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
34	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
35	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
36	NAMEOFCOUNTRY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
37	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
38	NAMEOFSTATE	☐	BEZEI20	TEXT20	CHAR	20	0	Description
39	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
40	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
41	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
42	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
43	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
44	LANGUISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
45	LANGUAGE	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
46	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
47	COMM_TYPE_TEXT	☐	AD_COM_TX	TEXT20	CHAR	20	0	Communication type description
48	.INCLUDE	☐				0	0	Telephone Data for Logical Database RHIQ_STUDENT_LDB
49	PHONE_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
50	PHONE_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
51	PHONE_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
52	TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
53	PHONE_EXTENSION	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
54	TEL_NO	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
55	CALLER_NO	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
56	PHONE_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
57	PHONE_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
58	PHONE_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
59	PHONE_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
60	PHONE_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
61	.INCLUDE	☐				0	0	Fax Data for Logical Database RHIQ_STUDENT_LDB
62	FAX_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
63	FAX_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
64	FAX_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
65	FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
66	FAX_EXTENSION	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
67	FAX_NO	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
68	SENDER_NO	☐	AD_FAXNRCL	CHAR30	CHAR	30	0	Fax number for finding sender
69	FAX_GROUP	☐	AD_FXGRP	AD_FXGRP	CHAR	1	0	Fax group (G3, G4, ...)
70	FAX_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
71	FAX_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
72	FAX_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
73	FAX_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
74	FAX_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
75	.INCLUDE	☐				0	0	Teletex Data for Logical Database RHIQ_STUDENT_LDB
76	TTX_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
77	TTX_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
78	TTX_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
79	TELETEX	☐	AD_TTXNMBR	TEXT30	CHAR	30	0	Teletex number
80	TTX_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
81	TTX_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
82	TTX_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
83	TTX_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
84	TTX_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
85	.INCLUDE	☐				0	0	Telex Data for Logical Database RHIQ_STUDENT_LDB
86	TLX_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
87	TLX_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
88	TLX_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
89	TELEX_NO	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
90	TLX_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
91	TLX_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
92	TLX_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
93	TLX_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
94	TLX_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
95	.INCLUDE	☐				0	0	SMTP Data for Logical Database RHIQ_STUDENT_LDB
96	SMTP_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
97	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
98	EMAIL_SRCH	☐	AD_SMTPAD2	CHAR20	CHAR	20	0	E-Mail Address Search Field
99	SMTP_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
100	SMTP_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
101	ENCODE	☐	AD_ENCODE	AD_ENCODE	CHAR	1	0	Desired Data Coding (E-Mail)
102	SMTP_TNEF	☐	AD_TNEF6	XFELD	CHAR	1	0	Flag: Receiver can receive TNEF coding via SMTP
103	SMTP_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
104	SMTP_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
105	SMTP_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
106	.INCLUDE	☐				0	0	RML Data for Logical Database RHIQ_STUDENT_LDB
107	RML_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
108	SYMB_DEST	☐	AD_SYMBDST	CHAR10	CHAR	10	0	Symbolic destination
109	REC_TYPE	☐	AD_RCVRTYP	CHAR1	CHAR	1	0	Recipient type (not currently used)
110	R_MAIL_CLT	☐	AD_UMAND	CHAR3	CHAR	3	0	RML- Client (Remote Mail, SAP - SAP - Communication)
111	R_MAIL	☐	AD_UNAME	CHAR12	CHAR	12	0	RML Name (Remote Mail, SAP - SAP - Communication)
112	RML_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
113	RML_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
114	RML_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
115	RML_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
116	RML_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
117	.INCLUDE	☐				0	0	X400 Data for Logical Database RHIQ_STUDENT_LDB
118	X400_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
119	X400_COUNTRY	☐	AD_X4CNTRY	LAND1	CHAR	3	0	X.400 country code	*
120	X400_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
121	ADM_DOM	☐	AD_X4ADMIN	CHAR16	CHAR	16	0	X.400 administration domain
122	PRIV_DOM	☐	AD_X4PRIVD	CHAR16	CHAR	16	0	X.400 private domain
123	ORGANIZATN	☐	AD_X4ORG	CHAR64	CHAR	64	0	X.400 organization
124	ORG_UNIT_1	☐	AD_X4ORG1	CHAR32	CHAR	32	0	X.400 organizational unit 1
125	ORG_UNIT_2	☐	AD_X4ORG2	CHAR32	CHAR	32	0	X.400 organizational unit 2
126	ORG_UNIT_3	☐	AD_X4ORG3	CHAR32	CHAR	32	0	X.400 organizational unit 3
127	ORG_UNIT_4	☐	AD_X4ORG4	CHAR32	CHAR	32	0	X.400 organizational unit 4
128	LASTNAME	☐	AD_X4LNAME	CHAR40	CHAR	40	0	X.400 last name
129	FIRSTNAME	☐	AD_X4FNAME	CHAR16	CHAR	16	0	X.400 first name
130	X400_INITIALS	☐	AD_X4INI	CHAR5	CHAR	5	0	X.400 Initials
131	GENERATION	☐	AD_X4GENER	CHAR3	CHAR	3	0	X.400 generation
132	X_121_ADDR	☐	AD_X4X121	CHAR15	CHAR	15	0	X.400 X.121 network address
133	TERM_ID	☐	AD_X4TRMID	CHAR24	CHAR	24	0	X.400 Terminal ID
134	TERM_TYPE	☐	AD_X4TRMTP	CHAR1	CHAR	1	0	X.400 terminal type
135	UANID	☐	AD_X4UANID	CHAR32	CHAR	32	0	X.400 user agent numeric ID
136	TYPE1	☐	AD_X4DDAT1	TEXT8	CHAR	8	0	X.400 domain defined attribute, type 1
137	VALUE1	☐	AD_X4DDAV1	TEXT128	CHAR	128	0	X.400 domain defined attribute, value 1
138	TYPE2	☐	AD_X4DDAT2	TEXT8	CHAR	8	0	X.400 domain defined attribute, type 2
139	VALUE2	☐	AD_X4DDAV2	TEXT128	CHAR	128	0	X.400 domain defined attribute, value 2
140	TYPE3	☐	AD_X4DDAT3	TEXT8	CHAR	8	0	X.400 domain defined attribute, type 3
141	VALUE3	☐	AD_X4DDAV3	TEXT128	CHAR	128	0	X.400 domain defined attribute, value 3
142	DDA_TYPE4	☐	AD_X4DDAT4	TEXT8	CHAR	8	0	X.400 domain defined attribute, type 4
143	DDA_VALUE4	☐	AD_X4DDAV4	TEXT128	CHAR	128	0	X.400 domain defined attribute, value 4
144	X400_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
145	X400_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
146	TXT_ENCODE	☐	AD_TENCODE	AD_TENCODE	CHAR	1	0	Desired text data coding (X.400)
147	X400_TNEF	☐	AD_TNEF8	XFELD	CHAR	1	0	Flag: Receiver can receive TNEF coding via X.400
148	X400_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
149	X400_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
150	X400_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
151	.INCLUDE	☐				0	0	RFC Data for Logical Database RHIQ_STUDENT_LDB
152	RFC_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
153	LOG_DEST	☐	AD_LOGDEST	RFCDEST	CHAR	32	0	RFC logical destination	*
154	RFC_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
155	RFC_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
156	RFC_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
157	RFC_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
158	RFC_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
159	.INCLUDE	☐				0	0	Print Data for Logical Database RHIQ_STUDENT_LDB
160	PRT_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
161	PRINT_DEST	☐	RSPOPNAME	RSPOPNAME	CHAR	4	0	Spool: Output device	*
162	PRT_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
163	PRT_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
164	PRT_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
165	PRT_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
166	.INCLUDE	☐				0	0	SSF Data for Logical Database RHIQ_STUDENT_LDB
167	SSF_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
168	SSF_DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
169	SSF_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
170	SSF_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
171	SSF_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
172	RFCDEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
173	SSFIDSHORT	☐	AD_SSFSCR	AD_SSFSCR	CHAR	132	0	SSFID field for screen display
174	SSF_NS	☐	SSFNS	SSFNSD	CHAR	10	0	SSF Namespace label
175	SSF_PROF	☐	SSFPROF	TEXT132	CHAR	132	0	SSF profile name
176	SSFIDPART1	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
177	SSFIDPART2	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
178	SSFIDPART3	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
179	SSFIDPART4	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
180	SSFIDPART5	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
181	SSFIDPART6	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
182	SSFIDPART7	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
183	SSFIDPART8	☐	AD_SSFID_1	AD_SSFID_1	CHAR	250	0	SSF name signatory/recipient: Parts 1-8
184	SSFIDPART9	☐	AD_SSFID_9	TEXT48	CHAR	48	0	SSF name signatory/recipient - part 9
185	SSF_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
186	.INCLUDE	☐				0	0	URI Data for Logical Database RHIQ_STUDENT_LDB
187	URI_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
188	URI_TYPE	☐	AD_URITYPE	AD_URITYPE	CHAR	3	0	URI type flag
189	URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
190	URI_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
191	URI_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
192	URI_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
193	URI_PART1	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
194	URI_PART2	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
195	URI_PART3	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
196	URI_PART4	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
197	URI_PART5	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
198	URI_PART6	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
199	URI_PART7	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
200	URI_PART8	☐	AD_URI_1	AD_URI_1	CHAR	250	0	Universal Resource Identifier (URI): Parts 1-8
201	URI_PART9	☐	AD_URI_9	TEXT48	CHAR	48	0	Universal Resource Identifier (URI) - Part 9
202	URI_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
203	.INCLUDE	☐				0	0	Pager Data for Logical Database RHIQ_STUDENT_LDB
204	PAG_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
205	PAG_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
206	PAG_STD_NO	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
207	PAGER_TYPE	☐	AD_PAGSERV	CHAR4	CHAR	4	0	Pager Service
208	PAGER	☐	AD_PAGNMBR	TEXT30	CHAR	30	0	Pager number
209	PAGER_NO	☐	AD_PGNRLNG	CHAR30	CHAR	30	0	Normalized pager search field
210	PAG_CALLER_NO	☐	AD_PAGNRCL	CHAR30	CHAR	30	0	Pager number for finding sender
211	PAG_STD_RECIP	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
212	PAG_R_3_USER	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
213	PAG_HOME_FLAG	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
214	PAG_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
215	PAG_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
216	.INCLUDE	☐				0	0	Address Notes for Logical Database RHIQ_STUDENT_LDB
217	ADDR_VERS	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
218	REM_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
219	REM_LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
220	ADR_NOTES	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
221	REM_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
222	.INCLUDE	☐				0	0	Communication Data for Logical Database RHIQ_STUDENT_LDB
223	COM_COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
224	COM_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
225	COM_LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
226	COMM_NOTES	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
227	COM_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
228	COM_ERRORFLAG	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
229	.INCLUDE	☐				0	0	SAP BP: BAPI Structue for Address Uses (Text Fields)
230	ADDRESSTYPE	☐	BU_ADRKIND	BU_ADRKIND	CHAR	10	0	Address Type	TB009
231	ADDRESSTYPETEXT	☐	BU_TXL010	TEXT40	CHAR	40	0	Name of address type
232	STANDARDADDRESSUSAGE	☐	BU_XDFADU	XFELD	CHAR	1	0	Indicator: Standard Address Usage

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQ_STUDENTLDB_ADDRESSDATA	ADDRESSTYPE	TB009	ADR_KIND	KEY	1	CN
2	PIQ_STUDENTLDB_ADDRESSDATA	COUNTRY	T005	LAND1	REF	1	CN
3	PIQ_STUDENTLDB_ADDRESSDATA	POBOX_CTRY	T005	LAND1	REF	C	CN
4	PIQ_STUDENTLDB_ADDRESSDATA	PO_BOX_REG	T005S	BLAND		C	CN
5	PIQ_STUDENTLDB_ADDRESSDATA	REGIOGROUP	ADRREGGRP	REGIOGROUP	REF	C	CN
6	PIQ_STUDENTLDB_ADDRESSDATA	REGION	T005S	BLAND	REF	C	CN
7	PIQ_STUDENTLDB_ADDRESSDATA	STR_ABBR	ADRSTRTYPE	STRTYPEAB	REF	C	CN
8	PIQ_STUDENTLDB_ADDRESSDATA	TIME_ZONE	TTZZ	TZONE	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in