APOC_D_OR_DOC

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
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)

KeyField Data ElementDescription DomainTypeLength
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)
);