SAP DPR_TS_API_DOCUMENT_DATA Table in S/4 HANA - API Attributes for Documents
DPR_TS_API_DOCUMENT_DATA is a standard SAP Table which is used to store API Attributes for Documents data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the DPR_TS_API_DOCUMENT_DATA table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: DPR_TS_API_DOCUMENT_DATA
DPR_TS_API_DOCUMENT_DATA table structure field list
Below is the full DPR_TS_API_DOCUMENT_DATA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| PARENT_GUID | Unique Object Key | DPR_TV_OBJECT_GUID_CHAR | CHAR | 32(0) | SYSUUID_C | |||||
| OBJECT_TYPE | Object Type (According to CL_DPR_COLL_CO=>SC_TYPE...) | STRG | 0(0) | |||||||
| DOCID | EDMS: Document ID | EDMS_DOCID | CHAR | 32(0) | SDOK_DOCID | |||||
| DOC_TYPE | EDMS: Document Category | EDMS_DOC_TYPE | CHAR | 10(0) | EDMS_DOC_TYPE | |||||
| DOC_NUMBER | EDMS: External Document Number | EDMS_DOC_NUMBER | CHAR | 64(0) | EDMS_DOC_NUMBER | |||||
| DOC_PART | EDMS: Document Part | EDMS_DOC_PART | CHAR | 10(0) | EDMS_DOC_PART | |||||
| DOC_VERSION | EDMS: Document Version | EDMS_DOC_VERSION | CHAR | 10(0) | EDMS_DOC_VERSION | |||||
| DOC_INDEX | EDMS: Document Index | EDMS_DOC_INDEX | CHAR | 10(0) | EDMS_DOC_INDEX | |||||
| DOC_NAME | EDMS: Document Name | EDMS_DOC_NAME | CHAR | 255(0) | SDOK_FILNM | |||||
| DOC_DESCRIPTION | EDMS: Document Description | EDMS_DESCRIPTION | CHAR | 255(0) | SDOK_FILNM | |||||
| DOC_CREATED_BY | User Name | UNAME | CHAR | 12(0) | UNAME | |||||
| DOC_CHANGED_BY | User Name | UNAME | CHAR | 12(0) | UNAME | |||||
| PARENT_ID | EDMS: Document ID | EDMS_DOCID | CHAR | 32(0) | SDOK_DOCID | |||||
| IS_FOLDER | Checkbox | XFELD | CHAR | 1(0) | XFELD | |||||
| ENCRYPTION | List of File Formats | EDMS_T_DOC_FILE_FORMATS | CHAR | 80(0) | EDMS_T_DOC_FILE_FORMATS | |||||
| DOC_CREATED_BY_NAME | Name of Person Who Created the Project Element | DPR_TV_CREATED_BY_NAME | CHAR | 80(0) | TEXT80 | |||||
| DOC_CHANGED_BY_NAME | Name of Person Who Last Changed the Project Element | DPR_TV_CHANGED_BY_NAME | CHAR | 80(0) | TEXT80 | |||||
| DOC_CREATED_ON_DATE | Created On | DPR_TV_CREATED_ON_DATE | DATS | 8(0) | ||||||
| DOC_CREATED_AT_TIME | Time Created | DPR_TV_CREATED_AT_TIME | TIMS | 6(0) | ||||||
| DOC_CHANGED_ON_DATE | Changed On | DPR_TV_CHANGED_ON_DATE | DATS | 8(0) | ||||||
| DOC_CHANGED_AT_TIME | Changed At | DPR_TV_CHANGED_AT_TIME | TIMS | 6(0) | ||||||
| STATUS_ID | Status ID | CFS_STATUS_ID | CHAR | 32(0) | SYSUUID_C | |||||
| STATUS_NAME | Status name | CFS_STATUS_NAME | SSTR | 64(0) | ||||||
| STATUS_DESCRIPTION | Status Description | CFS_STATUS_DESCR | STRG | 0(0) | ||||||
| STATUS_ALT_KEY | Status: Alternative, External Key | CFS_STATUS_ALT_KEY | CHAR | 5(0) | J_ESTAT | |||||
| STATUS_CREATED_BY | Created By | CFS_CREATED_BY | CHAR | 12(0) | USNAM | |||||
| STATUS_CHANGED_BY | Changed by | CFS_CHANGED_BY | CHAR | 12(0) | USNAM | |||||
| STATUS_TEXT | Language-Dependent Status Short Text | CFS_STATUS_TEXT | CHAR | 30(0) | TEXT30 | |||||
| STATUS_PROFILE_ID | Status Profile ID | CFS_STATUS_PROFILE_ID | CHAR | 32(0) | SYSUUID_C | |||||
| STATUS_CREATED_BY_NAME | Name of Person Who Created the Project Element | DPR_TV_CREATED_BY_NAME | CHAR | 80(0) | TEXT80 | |||||
| STATUS_CHANGED_BY_NAME | Name of Person Who Last Changed the Project Element | DPR_TV_CHANGED_BY_NAME | CHAR | 80(0) | TEXT80 | |||||
| STATUS_CREATED_ON_DATE | Created On | DPR_TV_CREATED_ON_DATE | DATS | 8(0) | ||||||
| STATUS_CREATED_AT_TIME | Time Created | DPR_TV_CREATED_AT_TIME | TIMS | 6(0) | ||||||
| STATUS_CHANGED_ON_DATE | Changed On | DPR_TV_CHANGED_ON_DATE | DATS | 8(0) | ||||||
| STATUS_CHANGED_AT_TIME | Changed At | DPR_TV_CHANGED_AT_TIME | TIMS | 6(0) | ||||||
| ACT_FILE_ID | Unique Object Key | DPR_TV_OBJECT_GUID_CHAR | CHAR | 32(0) | SYSUUID_C | |||||
| ACT_FILE_DESCRIPTION | EDMS: File Description | EDMS_FILE_DESCRIPTION | CHAR | 64(0) | SDOK_PROPV | |||||
| ACT_FILE_NAME | EDMS: URL | EDMS_URL | CHAR | 4096(0) | SADC4096 | |||||
| ACT_FILE_MIMETYPE | HTML content type | W3CONTTYPE | CHAR | 128(0) | W3_CONTTYP | |||||
| ACT_FILE_SIZE | EDMS: File Size | EDMS_FILE_SIZE | INT4 | 10(0) | ||||||
| ACT_FILE_CREATED_BY_NAME | Name of Person Who Created the Project Element | DPR_TV_CREATED_BY_NAME | CHAR | 80(0) | TEXT80 | |||||
| ACT_FILE_CHANGED_BY_NAME | Name of Person Who Last Changed the Project Element | DPR_TV_CHANGED_BY_NAME | CHAR | 80(0) | TEXT80 | |||||
| ACT_FILE_CREATED_ON_DATE | Created On | DPR_TV_CREATED_ON_DATE | DATS | 8(0) | ||||||
| ACT_FILE_CREATED_AT_TIME | Time Created | DPR_TV_CREATED_AT_TIME | TIMS | 6(0) | ||||||
| ACT_FILE_CHANGED_ON_DATE | Changed On | DPR_TV_CHANGED_ON_DATE | DATS | 8(0) | ||||||
| ACT_FILE_CHANGED_AT_TIME | Changed At | DPR_TV_CHANGED_AT_TIME | TIMS | 6(0) | ||||||
| ACT_FILE_CHECKED_OUT | EDMS: Checked Out | EDMS_CHECKED_OUT | CHAR | 1(0) | XFELD | |||||
| ACT_FILE_CHECKOUT_USER | EDMS: Checked Out By | EDMS_CHECKEDOUT_USER | CHAR | 12(0) | UNAME | |||||
| IS_THUMBNAIL | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
| IS_DELETABLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
| PARENT_EDMS_DOCID | EDMS: Document ID | EDMS_DOCID | CHAR | 32(0) | SDOK_DOCID | |||||
| PARENT_EDMS_PATH | DPR String | DPR_STRING | STRG | 0(0) | DPR_STRING | |||||
| EDMS_PATH | DPR String | DPR_STRING | STRG | 0(0) | DPR_STRING | |||||
| CAN_CREATE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 1(0) | BOOLE | |||||
| EA_DUMMY | Dummy | CHAR | 1(0) |
Search for further information about these or an SAP related objects