SAP AUDPHIO Audit: Instances of Physical Information Objects Table
Overview
AUDPHIO is a standard SAP S/4HANA table that stores Audit: Instances of Physical Information Objects data. There are total 25 fields in the AUDPHIO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUDPHIO belongs to Audit Management (CA-AUD) module and is located in the package Audit Management - General Core Functions (PLM_AUDIT_CORE).
In addition, following links provide an overview of foreign key relationships, if any, that link AUDPHIO to other SAP tables and standard CDS views available based on AUDPHIO table in S/4HANA 2020.
Techincal Settings of AUDPHIO
Below are technical details of the table AUDPHIO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUDPHIO Fields
The following table gives you an overview of the fields available in AUDPHIO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| PHIO_ID | Physical document | SDOK_PHID | CHAR | 32 | |
| PH_CLASS | Physical document class | SDOK_PHCL | SDOKPHCL | CHAR | 10 |
| LOIO_ID | Logical document | SDOK_LOID | BDS_LOIO | CHAR | 32 |
| LO_CLASS | Class of logical document | SDOK_LOCL | * | CHAR | 10 |
| STATE | Technical Status of a Physical Document | SDOK_PHSTA | NUMC | 4 | |
| DESCRIPT | Title of a document | SDOK_TITEL | CHAR | 64 | |
| LANGU | Language Key | SPRAS | T002 | LANG | 1 |
| CREA_USER | Created By | SDOK_CRUSR | CHAR | 12 | |
| CREA_TIME | Creation Time (UTC) | SDOK_CRTST | NUMC | 14 | |
| CHNG_USER | Last Changed By | SDOK_CHUSR | CHAR | 12 | |
| CHNG_TIME | Time of change (UTC) | SDOK_CHTST | NUMC | 14 | |
| STOR_CAT | Category for physical documents | SDOK_STCAT | SDOKSTCAE | CHAR | 10 |
| DOC_FORMAT | Document format (TEXT, TIFF, RTF, PDF, ...) | SDOK_FORM | SDOKFORM | CHAR | 4 |
| DOC_PROT | Document protection | SDOK_DPROT | CHAR | 4 | |
| PROP01 | Attribute feature (short version) | SDOK_PRV_S | CHAR | 15 | |
| PROP02 | Attribute feature (short version) | SDOK_PRV_S | CHAR | 15 | |
| PROP03 | Attribute feature (short version) | SDOK_PRV_S | CHAR | 15 | |
| PROP04 | Attribute feature (short version) | SDOK_PRV_S | CHAR | 15 | |
| PROP05 | Attribute feature (mid-length version) | SDOK_PRV_M | CHAR | 20 | |
| PROP06 | Attribute feature (mid-length version) | SDOK_PRV_M | CHAR | 20 | |
| PROP07 | Attribute feature (mid-length version) | SDOK_PRV_M | CHAR | 20 | |
| PROP08 | Attribute feature (long version) | SDOK_PRV_L | CHAR | 40 | |
| PROP09 | Attribute feature (long version) | SDOK_PRV_L | CHAR | 40 | |
| PROP10 | Attribute feature (long version) | SDOK_PRV_L | CHAR | 40 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AUDPHIO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUDPHIO | DOC_FORMAT | C: CN | SDOKFORM |
| AUDPHIO | LANGU | 1: CN | T002 |
| AUDPHIO | LOIO_ID | 1: CN | BDS_LOIO |
| AUDPHIO | PH_CLASS | 1: CN | SDOKPHCL |
| AUDPHIO | STOR_CAT | 1: CN | SDOKSTCAE |