CTE_D_FIN_PT_DOC

Transparent Table Application Table
34 Fields 3 CDS Views

Posting Documents

CTE_D_FIN_PT_DOC is an SAP database table in S/4HANA. Posting Documents. It contains 34 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CTE_CDS_FIN_MON_PT view from CDS View for Monotoring Document export to Concur
I_ConcurDocument view_entity from BASIC
I_ConcurImpDocumentsAllUnion view_entity from BASIC Concur All Posted Documents with Invoice

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY system_key CTE_SYSTEM_KEY_NUMBER System Key
KEY document_type CTE_FND_POST_DOC_TYPE Document Type
KEY document_id CTE_FND_POST_DOC_ID Doc. ID
KEY revision_id CTE_FND_POST_DOC_REV_ID Rev. Number
document_key CTE_FND_POST_DOC_KEY Doc. Key
hash_key CTE_FND_POST_DOC_HASH_KEY Hash Key
status CTE_FND_POST_DOC_STATUS Status
acknowledged_ind CTE_FND_POST_DOC_ACKNOWLEDGED Acknowledgement Sent
confirmed_ind CTE_FND_POST_DOC_CONFIRMED_IND Confirmation Sent
paid_ind CTE_FND_POST_DOC_NOTIFIED_IND Payment Status Sent
modified_ind CTE_FND_POST_DOC_MODIFIED_IND Modified by Customer
document_name CTE_FND_POST_DOC_NAME Document Name
concur_payee_id CTE_FND_POST_CONCUR_PAYEE_ID Employee / Vendor ID
creation_timstp CTE_FND_POST_DOC_CREATED_AT Created
update_timstp CTE_FND_POST_DOC_UPDATED_AT Changed
lognumber CTE_LOGNUMBER Lognumber
fin_srv_doc_id CTE_FND_POST_DOC_ID_FIN_QUEUE ID in FI Queue
api_version_id CTE_API_VERSION_ID CTE API Version ID
log_trace_uuid CTE_UUID UUID
doc_ref_key CTE_FND_POST_DOC_REF_KEY Doc Reference Key
ext_data_ind CTE_FND_POST_EXT_DATA_IND External System Ind.
attachment_ind CTE_FND_POST_DOC_AT_RETR_IND Attachments Retr.
payment_status CTE_FND_POST_DOC_PAYMNT_STATUS Payment Status
company_code BUKRS Company Code
business_partner BU_PARTNER Busn. Partner
retention_date CTE_RETENTION_DATE Retention Date
sdm_version CTE_SDM_VERSION SDM Version
report_number CTE_FND_POST_REPORT_NUMBER Report Number
attachment_total_number CTE_FND_POST_AT_TOTAL_NUMBER Att. Number
doc_ref_key_type CTE_FND_POST_DOC_REF_KEY_TYPE Doc. Ref. Key Type
config_ref_key_type CTE_FND_PT_CONFIG_REF_KEY_TYPE Conf. Ref. Key Type
receipt_total_number CTE_FND_POST_RT_TOTAL_NUMBER RT. Number
receipt_ind CTE_FND_POST_DOC_RT_RETR_IND Receipt Retr.

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.

-- Posting Documents
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CTE_D_FIN_PT_DOC (
    CLIENT,                   -- Client [MANDT]
    SYSTEM_KEY,               -- System Key [CTE_SYSTEM_KEY_NUMBER]
    DOCUMENT_TYPE,            -- Document Type [CTE_FND_POST_DOC_TYPE]
    DOCUMENT_ID,              -- Doc. ID [CTE_FND_POST_DOC_ID]
    REVISION_ID,              -- Rev. Number [CTE_FND_POST_DOC_REV_ID]
    DOCUMENT_KEY,             -- Doc. Key [CTE_FND_POST_DOC_KEY]
    HASH_KEY,                 -- Hash Key [CTE_FND_POST_DOC_HASH_KEY]
    STATUS,                   -- Status [CTE_FND_POST_DOC_STATUS]
    ACKNOWLEDGED_IND,         -- Acknowledgement Sent [CTE_FND_POST_DOC_ACKNOWLEDGED]
    CONFIRMED_IND,            -- Confirmation Sent [CTE_FND_POST_DOC_CONFIRMED_IND]
    PAID_IND,                 -- Payment Status Sent [CTE_FND_POST_DOC_NOTIFIED_IND]
    MODIFIED_IND,             -- Modified by Customer [CTE_FND_POST_DOC_MODIFIED_IND]
    DOCUMENT_NAME,            -- Document Name [CTE_FND_POST_DOC_NAME]
    CONCUR_PAYEE_ID,          -- Employee / Vendor ID [CTE_FND_POST_CONCUR_PAYEE_ID]
    CREATION_TIMSTP,          -- Created [CTE_FND_POST_DOC_CREATED_AT]
    UPDATE_TIMSTP,            -- Changed [CTE_FND_POST_DOC_UPDATED_AT]
    LOGNUMBER,                -- Lognumber [CTE_LOGNUMBER]
    FIN_SRV_DOC_ID,           -- ID in FI Queue [CTE_FND_POST_DOC_ID_FIN_QUEUE]
    API_VERSION_ID,           -- CTE API Version ID [CTE_API_VERSION_ID]
    LOG_TRACE_UUID,           -- UUID [CTE_UUID]
    DOC_REF_KEY,              -- Doc Reference Key [CTE_FND_POST_DOC_REF_KEY]
    EXT_DATA_IND,             -- External System Ind. [CTE_FND_POST_EXT_DATA_IND]
    ATTACHMENT_IND,           -- Attachments Retr. [CTE_FND_POST_DOC_AT_RETR_IND]
    PAYMENT_STATUS,           -- Payment Status [CTE_FND_POST_DOC_PAYMNT_STATUS]
    COMPANY_CODE,             -- Company Code [BUKRS]
    BUSINESS_PARTNER,         -- Busn. Partner [BU_PARTNER]
    RETENTION_DATE,           -- Retention Date [CTE_RETENTION_DATE]
    SDM_VERSION,              -- SDM Version [CTE_SDM_VERSION]
    REPORT_NUMBER,            -- Report Number [CTE_FND_POST_REPORT_NUMBER]
    ATTACHMENT_TOTAL_NUMBER,  -- Att. Number [CTE_FND_POST_AT_TOTAL_NUMBER]
    DOC_REF_KEY_TYPE,         -- Doc. Ref. Key Type [CTE_FND_POST_DOC_REF_KEY_TYPE]
    CONFIG_REF_KEY_TYPE,      -- Conf. Ref. Key Type [CTE_FND_PT_CONFIG_REF_KEY_TYPE]
    RECEIPT_TOTAL_NUMBER,     -- RT. Number [CTE_FND_POST_RT_TOTAL_NUMBER]
    RECEIPT_IND,              -- Receipt Retr. [CTE_FND_POST_DOC_RT_RETR_IND]
    PRIMARY KEY (CLIENT, SYSTEM_KEY, DOCUMENT_TYPE, DOCUMENT_ID, REVISION_ID)
);

Learn More