PIQPROC_DH SAP (Activity Documents: Document Header) Table details

Dictionary Type: Table
Description: Activity Documents: Document Header




ABAP Code to SELECT data from PIQPROC_DH
Related tables to PIQPROC_DH
Access table PIQPROC_DH




Table field list including key, data, relationships and ABAP select examples

PIQPROC_DH is a standard SAP Table which is used to store Activity Documents: Document Header data and is available within R/3 SAP systems depending on the version and release level.

The PIQPROC_DH table consists of various fields, each holding specific information or linking keys about Activity Documents: Document Header data available in SAP. These include MANDT (Client), DOCID (Activity Document Identification Key), PROCESS (Activity), REASON (Activity Reason).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP PIQPROC_DH table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
DOCIDActivity Document Identification Key PIQPROC_DOCIDCHAR32PIQPROC_DOCID
PROCESSActivity PIQPROCESSCHAR4T7PIQPROCESSPIQPROCESS
REASONActivity Reason PIQPROCREASONNUMC4T7PIQREASONPIQAPPREASON
KEY_DATEActivity Key Date (General) PIQPROC_KEY_DATEDATS8DATUM
KEY_TIMETime on Activity Key Date PIQPROC_KEY_TIMETIMS6UZEIT
KEY_TIMEZONETime Zone of Activity Key Date and Time PIQPROC_KEY_TIMEZONECHAR6TTZZTZNZONE
TIMESTAMPTime Stamp of Activity Document PIQPROC_DOC_TIMESTAMPDEC21(7) TZNTSTMPL
UNAMEUser Who Created the Activity Document PIQPROC_DOC_UNAMECHAR12USR02XUBNAME
LOGSYSTEMLogical System LOGSYSTEMCHAR10TBDLSALPHALOGSYS
CM_RELEASERelease of Add-On for IS-HER-CM (Campus Management) PIQCM_RELEASECHAR10CHAR10
PLVARPlan Version PLVARCHAR2T778PPLVARPOP
OTYPEObject Type of Activity Reference Object PIQPROC_OTYPECHAR2T778OOTYPE
OBJIDObject ID of Activity Reference Object PIQPROC_OBJIDNUMC8PLOGIHROBJID
ST_OBJIDObject ID of Student PIQST_OBJIDNUMC8PLOGIHROBJIDSTUDENT
BEGDAStart Date of Activity For-Period PIQPROC_BEGDADATS8DATUM
BEGPERYRAcademic Year (Start of Activity For-Period) PIQPROC_BEGPERYRNUMC4T7PIQYEARPIQPERYR
BEGPERIDAcademic Session (Start of Activity For-Period) PIQPROC_BEGPERIDNUMC3T7PIQYEARPRDPIQPERID
ENDDAEnd Date of Activity For-Period PIQPROC_ENDDADATS8DATUM
ENDPERYRAcademic Year (End of Activity For-Period) PIQPROC_ENDPERYRNUMC4T7PIQYEARPIQPERYR
ENDPERIDAcademic Session (End of Activity For-Period) PIQPROC_ENDPERIDNUMC3T7PIQYEARPRDPIQPERID
REF_DOCIDReference Activity Identification Key PIQPROC_REFPROC_DOCIDCHAR32PIQPROC_DHPIQPROC_DOCID
REF_PROCESSReference Activity PIQPROC_REFPROCESSCHAR4T7PIQPROCESSPIQPROCESS
REF_LOGSYSTEMLogical System LOGSYSTEMCHAR10TBDLSALPHALOGSYS

Key field Non-key field



How do I retrieve data from SAP table PIQPROC_DH using ABAP code

The following ABAP code Example will allow you to do a basic selection on PIQPROC_DH to SELECT all data from the table
DATA: WA_PIQPROC_DH TYPE PIQPROC_DH.

SELECT SINGLE *
FROM PIQPROC_DH
INTO CORRESPONDING FIELDS OF WA_PIQPROC_DH
WHERE...

How to access SAP table PIQPROC_DH

Within an ECC or HANA version of SAP you can also view further information about PIQPROC_DH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!