SAP ABAP Table PIQAPP_PERSONAL (Application: Personal Data)

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	PIQAPP_PERSONAL	Table Relationship Diagram
Short Description	Application: 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	FIRST_NAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
2	LAST_NAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
3	MIDDLE_NAME	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
4	NICKNAME	☐	PIQ_RUFNM	PAD_VORNM	CHAR	40	0	Known As
5	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
6	NAME_AFFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
7	ARISTOCRATIC_TITLE	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
8	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
9	FORM_OF_ADDRESS_KEY	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
10	NAME_AT_BIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
11	DATE_BIRTH	☐	PIQ_GBDAT	GBDAT	DATS	8	0	Date of Birth
12	COUNTRY_OF_BIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
13	REGION_OF_BIRTH	☐	PIQ_GBDEP	REGIO	CHAR	3	0	Region of Birth (State, Province, County)	T005S
14	BIRTHPLACE	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
15	NATIONALITY_AT_BIRTH	☐	PIQ_GBNAT	LAND1	CHAR	3	0	Nationality (Citizenship) at Birth	*
16	NATIONALITY	☐	NATSL	LAND1	CHAR	3	0	Nationality	*
17	SECOND_NATIONALITY	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	*
18	THIRD_NATIONALITY	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	*
19	CORRESP_LANGUAGE	☐	PIQ_SPRAS	SPRAS	LANG	1	0	Language of Communication	T002
20	PERSIDNO	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
21	GENDER_KEY	☐	GESCH	GESCH	CHAR	1	0	Gender Key
22	MARITAL_STATUS	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	463