SAP ABAP Table PIQAPP_ADDPERSONAL (Application: Additional 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_ADDPERSONAL	Table Relationship Diagram
Short Description	Application: Additional 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	RELIGION	☐	PIQKONFE	KONFE	CHAR	2	0	Religious Denomination Key	T516T
2	ETHNIC_GRP	☐	PIQETHNIC	PIQETHNIC	CHAR	4	0	Ethnic Origin	T7PIQETHNIC
3	JOB	☐	PIQTAETE	TAESL	NUMC	8	0	Student's Job	T513C
4	SOCIAL_GRP	☐	PIQSOCIAL	PIQSOCIAL	CHAR	2	0	Social Class	T7PIQSOCIAL
5	SERVICE_STATUS	☐	PIQSERV_STAT	MILSA	NUMC	2	0	Service Status	T505M
6	SERVICE_NUMBER	☐	PIQSERV_NR		CHAR	20	0	Service Number
7	VETERAN_NUMBER	☐	PIQVETERAN_NR		CHAR	20	0	Veteran Administration Number
8	DRIVERS_LICENSE_COUNTRY	☐	DR_LIC_LAND1_PS	LAND1	CHAR	3	0	Country in Which Driver's License Was Issued	T005
9	DRIVERS_LICENSE_REGION	☐	DR_LIC_REGIO_PS	REGIO	CHAR	3	0	Region in Which Driver's License Was Issued	T005S
10	DRIVERS_LICENSE_NO	☐	DR_LIC_NO_PS		CHAR	20	0	Driver's License Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAPP_ADDPERSONAL	DRIVERS_LICENSE_COUNTRY	T005	LAND1	REF	1	CN
2	PIQAPP_ADDPERSONAL	DRIVERS_LICENSE_REGION	T005S	BLAND	REF	1	CN
3	PIQAPP_ADDPERSONAL	ETHNIC_GRP	T7PIQETHNIC	ETHNIC
4	PIQAPP_ADDPERSONAL	JOB	T513C	TAETE
5	PIQAPP_ADDPERSONAL	RELIGION	T516T	KONFE
6	PIQAPP_ADDPERSONAL	SERVICE_STATUS	T505M	MILSA
7	PIQAPP_ADDPERSONAL	SOCIAL_GRP	T7PIQSOCIAL	SOCIAL		1	CN

History

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