SAP Table PIQPROC_DH
Activity Documents: Document Header
PIQPROC_DH (Activity Documents: Document Header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PIQPROC_DH to other SAP tables.
PIQPROC_DH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| DOCID | Activity Document Identification Key | PIQPROC_DOCID | CHAR | 32 | 0 | |||
| PROCESS | Activity | PIQPROCESS | T7PIQPROCESS | CHAR | 4 | 0 | ||
| REASON | Activity Reason | PIQPROCREASON | T7PIQREASON | NUMC | 4 | 0 | ||
| KEY_DATE | Activity Key Date (General) | PIQPROC_KEY_DATE | DATS | 8 | 0 | |||
| KEY_TIME | Time on Activity Key Date | PIQPROC_KEY_TIME | TIMS | 6 | 0 | |||
| KEY_TIMEZONE | Time Zone of Activity Key Date and Time | PIQPROC_KEY_TIMEZONE | TTZZ | CHAR | 6 | 0 | ||
| TIMESTAMP | Time Stamp of Activity Document | PIQPROC_DOC_TIMESTAMP | DEC | 21 | 7 | |||
| UNAME | User Who Created the Activity Document | PIQPROC_DOC_UNAME | USR02 | CHAR | 12 | 0 | ||
| LOGSYSTEM | Logical System | LOGSYSTEM | TBDLS | CHAR | 10 | 0 | ||
| CM_RELEASE | Release of Add-On for IS-HER-CM (Campus Management) | PIQCM_RELEASE | CHAR | 10 | 0 | |||
| PLVAR | Plan Version | PLVAR | T778P | CHAR | 2 | 0 | ||
| OTYPE | Object Type of Activity Reference Object | PIQPROC_OTYPE | T778O | CHAR | 2 | 0 | ||
| OBJID | Object ID of Activity Reference Object | PIQPROC_OBJID | PLOGI | NUMC | 8 | 0 | ||
| ST_OBJID | Object ID of Student | PIQST_OBJID | PLOGI | NUMC | 8 | 0 | ||
| BEGDA | Start Date of Activity For-Period | PIQPROC_BEGDA | DATS | 8 | 0 | |||
| BEGPERYR | Academic Year (Start of Activity For-Period) | PIQPROC_BEGPERYR | T7PIQYEAR | NUMC | 4 | 0 | ||
| BEGPERID | Academic Session (Start of Activity For-Period) | PIQPROC_BEGPERID | T7PIQYEARPRD | NUMC | 3 | 0 | ||
| ENDDA | End Date of Activity For-Period | PIQPROC_ENDDA | DATS | 8 | 0 | |||
| ENDPERYR | Academic Year (End of Activity For-Period) | PIQPROC_ENDPERYR | T7PIQYEAR | NUMC | 4 | 0 | ||
| ENDPERID | Academic Session (End of Activity For-Period) | PIQPROC_ENDPERID | T7PIQYEARPRD | NUMC | 3 | 0 | ||
| REF_DOCID | Reference Activity Identification Key | PIQPROC_REFPROC_DOCID | PIQPROC_DH | CHAR | 32 | 0 | ||
| REF_PROCESS | Reference Activity | PIQPROC_REFPROCESS | T7PIQPROCESS | CHAR | 4 | 0 | ||
| REF_LOGSYSTEM | Logical System | LOGSYSTEM | TBDLS | CHAR | 10 | 0 | ||
PIQPROC_DH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PIQPROC_DH | BEGPERID | SYST | MANDT | T7PIQYEARPRD | Academic Year/Session Assignments | MANDT |
| PIQPROC_DH | BEGPERID | PIQPROC_DH | BEGPERYR | T7PIQYEARPRD | Academic Year/Session Assignments | PERYR |
| PIQPROC_DH | BEGPERID | PIQPROC_DH | BEGPERID | T7PIQYEARPRD | Academic Year/Session Assignments | PERID |
| PIQPROC_DH | BEGPERYR | SYST | MANDT | T7PIQYEAR | Academic Years | MANDT |
| PIQPROC_DH | BEGPERYR | PIQPROC_DH | BEGPERYR | T7PIQYEAR | Academic Years | PERYR |
| PIQPROC_DH | ENDPERID | PIQPROC_DH | ENDPERID | T7PIQYEARPRD | Academic Year/Session Assignments | PERID |
| PIQPROC_DH | ENDPERID | SYST | MANDT | T7PIQYEARPRD | Academic Year/Session Assignments | MANDT |
| PIQPROC_DH | ENDPERID | PIQPROC_DH | ENDPERYR | T7PIQYEARPRD | Academic Year/Session Assignments | PERYR |
| PIQPROC_DH | ENDPERYR | PIQPROC_DH | ENDPERYR | T7PIQYEAR | Academic Years | PERYR |
| PIQPROC_DH | ENDPERYR | SYST | MANDT | T7PIQYEAR | Academic Years | MANDT |
| PIQPROC_DH | KEY_TIMEZONE | SYST | MANDT | TTZZ | Time zones | CLIENT |
| PIQPROC_DH | KEY_TIMEZONE | PIQPROC_DH | KEY_TIMEZONE | TTZZ | Time zones | TZONE |
| PIQPROC_DH | LOGSYSTEM | PIQPROC_DH | LOGSYSTEM | TBDLS | Logical system | LOGSYS |
| PIQPROC_DH | MANDT | PIQPROC_DH | MANDT | T000 | Clients | MANDT |
| PIQPROC_DH | OBJID | SYST | MANDT | PLOGI | Table Index HRP* | MANDT |
| PIQPROC_DH | OBJID | PIQPROC_DH | PLVAR | PLOGI | Table Index HRP* | PLVAR |
| PIQPROC_DH | OBJID | PIQPROC_DH | OTYPE | PLOGI | Table Index HRP* | OTYPE |
| PIQPROC_DH | OBJID | PIQPROC_DH | OBJID | PLOGI | Table Index HRP* | OBJID |
| PIQPROC_DH | OTYPE | PIQPROC_DH | OTYPE | T778O | Object Types | OTYPE |
| PIQPROC_DH | OTYPE | SYST | MANDT | T778O | Object Types | MANDT |
| PIQPROC_DH | PLVAR | SYST | MANDT | T778P | Plan Versions | MANDT |
| PIQPROC_DH | PLVAR | PIQPROC_DH | PLVAR | T778P | Plan Versions | PLVAR |
| PIQPROC_DH | PROCESS | PIQPROC_DH | PROCESS | T7PIQPROCESS | Activities | PROCESS |
| PIQPROC_DH | REASON | SYST | MANDT | T7PIQREASON | Reasons | MANDT |
| PIQPROC_DH | REASON | PIQPROC_DH | REASON | T7PIQREASON | Reasons | REASON |
| PIQPROC_DH | REF_DOCID | PIQPROC_DH | REF_DOCID | PIQPROC_DH | Activity Documents: Document Header | MANDT |
| PIQPROC_DH | REF_DOCID | SYST | MANDT | PIQPROC_DH | Activity Documents: Document Header | .INCLUDE |
| PIQPROC_DH | REF_LOGSYSTEM | PIQPROC_DH | REF_LOGSYSTEM | TBDLS | Logical system | LOGSYS |
| PIQPROC_DH | REF_PROCESS | PIQPROC_DH | REF_PROCESS | T7PIQPROCESS | Activities | PROCESS |
| PIQPROC_DH | ST_OBJID | SYST | MANDT | PLOGI | Table Index HRP* | MANDT |
| PIQPROC_DH | ST_OBJID | PIQPROC_DH | PLVAR | PLOGI | Table Index HRP* | PLVAR |
| PIQPROC_DH | ST_OBJID | 'ST' | PLOGI | Table Index HRP* | OTYPE | |
| PIQPROC_DH | ST_OBJID | PIQPROC_DH | ST_OBJID | PLOGI | Table Index HRP* | OBJID |
| PIQPROC_DH | UNAME | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| PIQPROC_DH | UNAME | PIQPROC_DH | UNAME | USR02 | Logon Data (Kernel-Side Use) | BNAME |
