SAP ABAP Table PIQEI_PERSONAL (External Interface: Personal Data)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQBP_D (Package) Campus Management: SAP Business Partner Enhancements

Basic Data

Table Category	INTTAB	Structure
Structure	PIQEI_PERSONAL	Table Relationship Diagram
Short Description	External Interface: Personal Data

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	TASK	☐	PIQEI_TASK	PIQEI_TASK	CHAR	1	0	External Interface: Change Indicator
2	DATA_KEY	☐	PIQEI_INFTYKEY		STRU	0	0
3	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
4	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
5	DATA	☐	PIQEI_STRUC_PERSONAL		STRU	0	0
6	.INCLUDE	☐				0	0	BAPI Structure for Student: Personal Data
7	FORM_OF_ADDRESS_KEY	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key
8	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
9	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
10	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
11	MIDDLE_NAME	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
12	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title
13	NAME_AFFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix
14	ARISTOCRATIC_TITLE	☐	NAMZU	TITEL	CHAR	15	0	Other Title
15	NICKNAME	☐	PIQ_RUFNM	PAD_VORNM	CHAR	40	0	Known As
16	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
17	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
18	BIRTHPLACE	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
19	COUNTRY_OF_BIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth
20	COUNTRY_OF_BIRTH_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
21	REGION_OF_BIRTH	☐	PIQ_GBDEP	REGIO	CHAR	3	0	Region of Birth (State, Province, County)
22	NATIONALITY_AT_BIRTH	☐	PIQ_GBNAT	LAND1	CHAR	3	0	Nationality (Citizenship) at Birth
23	NATIONALITY_AT_BIRTH_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
24	NATIONALITY	☐	PIQNATSL	LAND1	CHAR	3	0	Nationality (Citizenship)
25	NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
26	SECOND_NATIONALITY	☐	PIQNATS2	LAND1	CHAR	3	0	Second Nationality (Citizenship)
27	SECOND_NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
28	THIRD_NATIONALITY	☐	PIQNATS3	LAND1	CHAR	3	0	Third Nationality (Citizenship)
29	THIRD_NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
30	GENDER_KEY	☐	GESCH	GESCH	CHAR	1	0	Gender Key
31	MARITAL_STATUS	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key
32	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
33	CORRESP_LANGUAGE	☐	PIQ_SPRAS	SPRAS	LANG	1	0	Language of Communication
34	CORRESP_LANGUAGE_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
35	DEATH_DATE	☐	PIQ_DEATHDATE	DATE	DATS	8	0	Date of Death
36	DEATH_REGDATE	☐	PIQ_REGDEATHDATE	DATE	DATS	8	0	Date On Which Death Was Recorded
37	DATAX	☐	PIQEI_STRUC_PERSONALX		STRU	0	0
38	.INCLUDE	☐				0	0	BAPI Structure for Student: Personal Data (Change Params)
39	FORM_OF_ADDRESS_KEY	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
40	INITIALS	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
41	FIRST_NAME	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
42	LAST_NAME	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
43	MIDDLE_NAME	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
44	TITEL	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
45	NAME_AFFIX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
46	ARISTOCRATIC_TITLE	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
47	NICKNAME	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
48	NAME_AT_BIRTH	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
49	DATE_BIRTH	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
50	BIRTHPLACE	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
51	COUNTRY_OF_BIRTH	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
52	COUNTRY_OF_BIRTH_ISO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
53	REGION_OF_BIRTH	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
54	NATIONALITY_AT_BIRTH	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
55	NATIONALITY_AT_BIRTH_ISO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
56	NATIONALITY	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
57	NATIONALITY_ISO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
58	SECOND_NATIONALITY	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
59	SECOND_NATIONALITY_ISO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
60	THIRD_NATIONALITY	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
61	THIRD_NATIONALITY_ISO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
62	GENDER_KEY	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
63	MARITAL_STATUS	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
64	PERSIDNO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
65	CORRESP_LANGUAGE	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
66	CORRESP_LANGUAGE_ISO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
67	DEATH_DATE	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
68	DEATH_REGDATE	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
69	CURRENTLY_VALID	☐	BUS_EI_CURRENTLY_VALID	BU_EI_CURRENTLY_VALID	CHAR	1	0	External Interface: Data Currently Valid

History

Last changed by/on	SAP	20140121
SAP Release Created in	600