APOC_D_OR_DOC
APOC Document Index table
APOC_D_OR_DOC is an SAP database table in S/4HANA. APOC Document Index table. It contains 14 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| APOC_CDS_KPRO_KEY | view | inner | KPRO Keys for OC Original Documents | |
| APOC_CDS_REPO_KPRO_KEY | view | inner | Repo KPRO Keys for OC Original Documents |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | doc_id | apoc_doc_id | Document UUID | |||
| KEY | file_type | apoc_file_type | File Type of the Document | |||
| kpro_class | sdok_class | DocuClass | ||||
| kpro_id | sdok_docid | Object ID | ||||
| kpro_id_signed | sdok_docid | Object ID | ||||
| timestamp | timestamp | Time Stamp | ||||
| ref_cat | apoc_doc_ref_cat | |||||
| ref_id | /bobf/conf_key | NodeID | ||||
| num_pages | apoc_doc_no_of_pages | Number of Pages | ||||
| pdl_type | apoc_pdl_type | Page Descr. Language | ||||
| doc_name | apoc_document_name | Document Name | ||||
| is_orphan | apoc_doc_orphan | Flag: Is an orphan | ||||
| last_changed_at | apoc_doc_last_changed_at |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- APOC Document Index table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APOC_D_OR_DOC (
MANDT, -- Client [mandt]
DOC_ID, -- Document UUID [apoc_doc_id]
FILE_TYPE, -- File Type of the Document [apoc_file_type]
KPRO_CLASS, -- DocuClass [sdok_class]
KPRO_ID, -- Object ID [sdok_docid]
KPRO_ID_SIGNED, -- Object ID [sdok_docid]
TIMESTAMP, -- Time Stamp [timestamp]
REF_CAT, -- apoc_doc_ref_cat
REF_ID, -- NodeID [/bobf/conf_key]
NUM_PAGES, -- Number of Pages [apoc_doc_no_of_pages]
PDL_TYPE, -- Page Descr. Language [apoc_pdl_type]
DOC_NAME, -- Document Name [apoc_document_name]
IS_ORPHAN, -- Flag: Is an orphan [apoc_doc_orphan]
LAST_CHANGED_AT, -- apoc_doc_last_changed_at
PRIMARY KEY (MANDT, DOC_ID, FILE_TYPE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA