The CRMURLPHIO table in SAP ERP or S/4HANA stores CRM: URL: CD:: Instances of Physical Information Objects data. There are total 25 fields in CRMURLPHIO table. The CRM: URL: CD:: Instances of Physical Information Objects table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMURLPHIO table. It is in Content Management in CRM (CRM_KNOWLEDGE) ABAP package and is part of the Content Management (CRM-BF-COM) module.
SAP CRMURLPHIO Table Fields
Following is the list of fields that are available in SAP CRMURLPHIO table. The primary key fields of the table are MANDT (Client), PHIO_ID (Physical document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| 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) |
