SAP ABAP Table PIQEI_STRUC_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_STRUC_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	.INCLUDE	☐				0	0	BAPI Structure for Student: Personal Data
2	FORM_OF_ADDRESS_KEY	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
3	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
4	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
5	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
6	MIDDLE_NAME	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
7	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
8	NAME_AFFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
9	ARISTOCRATIC_TITLE	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
10	NICKNAME	☐	PIQ_RUFNM	PAD_VORNM	CHAR	40	0	Known As
11	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
12	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
13	BIRTHPLACE	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
14	COUNTRY_OF_BIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
15	COUNTRY_OF_BIRTH_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
16	REGION_OF_BIRTH	☐	PIQ_GBDEP	REGIO	CHAR	3	0	Region of Birth (State, Province, County)	T005S
17	NATIONALITY_AT_BIRTH	☐	PIQ_GBNAT	LAND1	CHAR	3	0	Nationality (Citizenship) at Birth	*
18	NATIONALITY_AT_BIRTH_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
19	NATIONALITY	☐	PIQNATSL	LAND1	CHAR	3	0	Nationality (Citizenship)	*
20	NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
21	SECOND_NATIONALITY	☐	PIQNATS2	LAND1	CHAR	3	0	Second Nationality (Citizenship)	*
22	SECOND_NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
23	THIRD_NATIONALITY	☐	PIQNATS3	LAND1	CHAR	3	0	Third Nationality (Citizenship)	*
24	THIRD_NATIONALITY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
25	GENDER_KEY	☐	GESCH	GESCH	CHAR	1	0	Gender Key
26	MARITAL_STATUS	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
27	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
28	CORRESP_LANGUAGE	☐	PIQ_SPRAS	SPRAS	LANG	1	0	Language of Communication	T002
29	CORRESP_LANGUAGE_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
30	DEATH_DATE	☐	PIQ_DEATHDATE	DATE	DATS	8	0	Date of Death
31	DEATH_REGDATE	☐	PIQ_REGDEATHDATE	DATE	DATS	8	0	Date On Which Death Was Recorded

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQEI_STRUC_PERSONAL	ARISTOCRATIC_TITLE	T535N	TITEL	REF	1	CN
2	PIQEI_STRUC_PERSONAL	CORRESP_LANGUAGE	T002	SPRAS	REF	1	CN
3	PIQEI_STRUC_PERSONAL	COUNTRY_OF_BIRTH	T005	LAND1	REF	1	CN
4	PIQEI_STRUC_PERSONAL	FORM_OF_ADDRESS_KEY	T522G	ANRED	REF	1	CN
5	PIQEI_STRUC_PERSONAL	MARITAL_STATUS	T502T	FAMST	REF	1	CN
6	PIQEI_STRUC_PERSONAL	NAME_AFFIX	T535N	TITEL	REF	1	CN
7	PIQEI_STRUC_PERSONAL	REGION_OF_BIRTH	T005S	BLAND	REF	1	CN
8	PIQEI_STRUC_PERSONAL	TITEL	T535N	TITEL	REF	1	CN

History

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