SAP ABAP Table PIQPROC_DH (Activity Documents: Document Header)

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	TRANSP	Transparent table
Transparent table	PIQPROC_DH	Table Relationship Diagram
Short Description	Activity Documents: Document Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Activity Document: Key
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	DOCID	☑	PIQPROC_DOCID	PIQPROC_DOCID	CHAR	32	0	Activity Document Identification Key
4	.INCLUDE	☐				0	0	Activity Document Header: Activity and Key Date
5	PROCESS	☐	PIQPROCESS	PIQPROCESS	CHAR	4	0	Activity	T7PIQPROCESS
6	REASON	☐	PIQPROCREASON	PIQAPPREASON	NUMC	4	0	Activity Reason	T7PIQREASON
7	KEY_DATE	☐	PIQPROC_KEY_DATE	DATUM	DATS	8	0	Activity Key Date (General)
8	KEY_TIME	☐	PIQPROC_KEY_TIME	UZEIT	TIMS	6	0	Time on Activity Key Date
9	KEY_TIMEZONE	☐	PIQPROC_KEY_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Activity Key Date and Time	TTZZ
10	.INCLUDE	☐				0	0	Activity Document Header: General Data (Internal)
11	TIMESTAMP	☐	PIQPROC_DOC_TIMESTAMP	TZNTSTMPL	DEC	21	7	Time Stamp of Activity Document
12	UNAME	☐	PIQPROC_DOC_UNAME	XUBNAME	CHAR	12	0	User Who Created the Activity Document	USR02
13	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
14	CM_RELEASE	☐	PIQCM_RELEASE	CHAR10	CHAR	10	0	Release of Add-On for IS-HER-CM (Campus Management)
15	.INCLUDE	☐				0	0	Activity Document Header: Objects
16	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
17	OTYPE	☐	PIQPROC_OTYPE	OTYPE	CHAR	2	0	Object Type of Activity Reference Object	T778O
18	OBJID	☐	PIQPROC_OBJID	HROBJID	NUMC	8	0	Object ID of Activity Reference Object	PLOGI
19	ST_OBJID	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student	PLOGI
20	.INCLUDE	☐				0	0	Activity Document Header: For Period Data of Activity
21	.INCLUDE	☐				0	0	Activity Document Header: Valid From
22	BEGDA	☐	PIQPROC_BEGDA	DATUM	DATS	8	0	Start Date of Activity For-Period
23	BEGPERYR	☐	PIQPROC_BEGPERYR	PIQPERYR	NUMC	4	0	Academic Year (Start of Activity For-Period)	T7PIQYEAR
24	BEGPERID	☐	PIQPROC_BEGPERID	PIQPERID	NUMC	3	0	Academic Session (Start of Activity For-Period)	T7PIQYEARPRD
25	.INCLUDE	☐				0	0	Activity Document Header: Valid To
26	ENDDA	☐	PIQPROC_ENDDA	DATUM	DATS	8	0	End Date of Activity For-Period
27	ENDPERYR	☐	PIQPROC_ENDPERYR	PIQPERYR	NUMC	4	0	Academic Year (End of Activity For-Period)	T7PIQYEAR
28	ENDPERID	☐	PIQPROC_ENDPERID	PIQPERID	NUMC	3	0	Academic Session (End of Activity For-Period)	T7PIQYEARPRD
29	.INCLUDE	☐				0	0	Activity Document Header: Reference Activity
30	REF_DOCID	☐	PIQPROC_REFPROC_DOCID	PIQPROC_DOCID	CHAR	32	0	Reference Activity Identification Key	PIQPROC_DH
31	REF_PROCESS	☐	PIQPROC_REFPROCESS	PIQPROCESS	CHAR	4	0	Reference Activity	T7PIQPROCESS
32	REF_LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQPROC_DH	BEGPERID	T7PIQYEARPRD	PERID
2	PIQPROC_DH	BEGPERYR	T7PIQYEAR	PERYR
3	PIQPROC_DH	ENDPERID	T7PIQYEARPRD	PERID
4	PIQPROC_DH	ENDPERYR	T7PIQYEAR	PERYR
5	PIQPROC_DH	KEY_TIMEZONE	TTZZ	TZONE
6	PIQPROC_DH	LOGSYSTEM	TBDLS	LOGSYS
7	PIQPROC_DH	MANDT	T000	MANDT
8	PIQPROC_DH	OBJID	PLOGI	OBJID
9	PIQPROC_DH	OTYPE	T778O	OTYPE
10	PIQPROC_DH	PLVAR	T778P	PLVAR
11	PIQPROC_DH	PROCESS	T7PIQPROCESS	PROCESS
12	PIQPROC_DH	REASON	T7PIQREASON	REASON
13	PIQPROC_DH	REF_DOCID	PIQPROC_DH	MANDT
14	PIQPROC_DH	REF_LOGSYSTEM	TBDLS	LOGSYS
15	PIQPROC_DH	REF_PROCESS	T7PIQPROCESS	PROCESS
16	PIQPROC_DH	ST_OBJID	PLOGI	OBJID
17	PIQPROC_DH	UNAME	USR02	BNAME

History

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