PIQIB_ACTDOC_OVW SAP (Structure for Iblock:Activity Document) Structure details
Description: Structure for Iblock:Activity Document
Related tables to PIQIB_ACTDOC_OVW
Access table PIQIB_ACTDOC_OVW
Structure field list including key, data, relationships and ABAP select examples
PIQIB_ACTDOC_OVW is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for Iblock:Activity Document" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_PIQIB_ACTDOC_OVW TYPE PIQIB_ACTDOC_OVW.
The PIQIB_ACTDOC_OVW table consists of various fields, each holding specific information or linking keys about Structure for Iblock:Activity Document data available in SAP. These include DOCID (Activity Document Identification Key), PROCESS (Activity), REASON (Activity Reason), KEY_DATE (Activity Key Date (General)).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP PIQIB_ACTDOC_OVW structure 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 |
CREATE_USER_NAME | 0 | ||||||||
DOCID | Activity Document Identification Key | PIQPROC_DOCID | CHAR | 32 | Assigned to domain | PIQPROC_DOCID | |||
PROCESS | Activity | PIQPROCESS | CHAR | 4 | T7PIQPROCESS | PIQPROCESS | |||
REASON | Activity Reason | PIQPROCREASON | NUMC | 4 | T7PIQREASON | PIQAPPREASON | |||
KEY_DATE | Activity Key Date (General) | PIQPROC_KEY_DATE | DATS | 8 | DATUM | ||||
KEY_TIME | Time on Activity Key Date | PIQPROC_KEY_TIME | TIMS | 6 | UZEIT | ||||
KEY_TIMEZONE | Time Zone of Activity Key Date and Time | PIQPROC_KEY_TIMEZONE | CHAR | 6 | TTZZ | TZNZONE | |||
PROCESST | Activity (Description) | PIQPROCESS2T | CHAR | 40 | TEXT40 | ||||
REASONTEXT | Reason Description | PIQREASONT | CHAR | 25 | TEXT25 | ||||
TIMESTAMP | Time Stamp of Activity Document | PIQPROC_DOC_TIMESTAMP | DEC | 21(7) | TZNTSTMPL | ||||
TIMESTAMP_DATE | Activity Document Creation Date | PIQPROC_DOC_DATE | DATS | 8 | DATE | ||||
TIMESTAMP_TIME | Activity Document Creation Time | PIQPROC_DOC_TIME | TIMS | 6 | TIME | ||||
UNAME | User Who Created the Activity Document | PIQPROC_DOC_UNAME | CHAR | 12 | Assigned to domain | XUBNAME | |||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
CM_RELEASE | Release of Add-On for IS-HER-CM (Campus Management) | PIQCM_RELEASE | CHAR | 10 | CHAR10 | ||||
ARCHIVED | Indicator: Activity Document Is Archived | PIQPROC_DOC_XARCHIVED | CHAR | 1 | FLAG | ||||
PLVAR | Plan Version | PLVAR | CHAR | 2 | T778P | PLVAR | POP | ||
OTYPE | Object Type of Activity Reference Object | PIQPROC_OTYPE | CHAR | 2 | T778O | OTYPE | |||
OBJID | Object ID of Activity Reference Object | PIQPROC_OBJID | NUMC | 8 | PLOGI | HROBJID | |||
ST_OBJID | Object ID of Student | PIQST_OBJID | NUMC | 8 | PLOGI | HROBJID | STUDENT | ||
SCSRK | Program of Study | PIQSCSRK | CHAR | 12 | CHAR12 | ||||
SCTEXT | Program Description | PIQSCTXT | CHAR | 40 | TEXT40 | ||||
SMSRK | Module (Abbreviation) | PIQSMSHORT | CHAR | 12 | TEXT12 | ||||
SMTEXT | Module Name | PIQSMTEXT | CHAR | 40 | TEXT40 | ||||
STUDENT12 | Student Number | PIQSTUDENT12 | CHAR | 12 | PIQST | PIQSTUDENT12 | |||
NAME | Student's Name (Sortable) | PIQSTDTX | CHAR | 40 | TEXT40 | ||||
BEGDA | Start Date of Activity For-Period | PIQPROC_BEGDA | DATS | 8 | DATUM | ||||
BEGPERYR | Academic Year (Start of Activity For-Period) | PIQPROC_BEGPERYR | NUMC | 4 | T7PIQYEAR | PIQPERYR | |||
BEGPERID | Academic Session (Start of Activity For-Period) | PIQPROC_BEGPERID | NUMC | 3 | T7PIQYEARPRD | PIQPERID | |||
ENDDA | End Date of Activity For-Period | PIQPROC_ENDDA | DATS | 8 | DATUM | ||||
ENDPERYR | Academic Year (End of Activity For-Period) | PIQPROC_ENDPERYR | NUMC | 4 | T7PIQYEAR | PIQPERYR | |||
ENDPERID | Academic Session (End of Activity For-Period) | PIQPROC_ENDPERID | NUMC | 3 | T7PIQYEARPRD | PIQPERID | |||
BEGPERYT | Academic Year Description (Start of For-Period) | PIQPROC_BEGPERYT | CHAR | 20 | TEXT20 | ||||
BEGPERIT | Academic Session Description (Start of For-Period) | PIQPROC_BEGPERIT | CHAR | 20 | TEXT20 | ||||
ENDPERYT | Academic Year Description (End of For-Period) | PIQPROC_ENDPERYT | CHAR | 20 | TEXT20 | ||||
ENDPERIT | Academic Session Description (End of For-Period) | PIQPROC_ENDPERIT | CHAR | 20 | TEXT20 | ||||
REF_DOCID | Reference Activity Identification Key | PIQPROC_REFPROC_DOCID | CHAR | 32 | PIQPROC_DH | PIQPROC_DOCID | |||
REF_PROCESS | Reference Activity | PIQPROC_REFPROCESS | CHAR | 4 | T7PIQPROCESS | PIQPROCESS | |||
REF_LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
REF_PROCESST | Reference Activity (Description) | PIQPROC_REFPROCESST | CHAR | 40 | TEXT40 |
Key field | Non-key field |
How do I retrieve data from SAP structure PIQIB_ACTDOC_OVW using ABAP code?
As PIQIB_ACTDOC_OVW is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PIQIB_ACTDOC_OVW as there is no data to select.How to access SAP table PIQIB_ACTDOC_OVW
Within an ECC or HANA version of SAP you can also view further information about PIQIB_ACTDOC_OVW and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects