CTE_D_LOG_TRA_PY

Transparent Table Application Table
12 Fields 2 CDS Views

Payroll Posting Log Trace

CTE_D_LOG_TRA_PY is an SAP database table in S/4HANA. Payroll Posting Log Trace. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CTE_CDS_HCM_LATEST_TRACE_PY view from Latest log traces entries for documents
CTE_CDS_HCM_MON_PY view inner CDS View for monitoring documents

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY doc_store_ref CTE_UUID UUID
KEY sequential_no CTE_SEQUENTIAL_NUMBER Sequential No
action_code CTE_FND_POST_DOC_ACTION_CODE Document Action
status CTE_FND_POST_LOG_TRACE_STATUS Status
username XUBNAME User
timestamp CTE_FND_POST_DOC_CREATED_AT Created
lognumber CTE_LOGNUMBER Lognumber
conf_uuid CTE_UUID UUID
high_no_ind CHAR01 Char01
additional_information CTE_FND_POST_TRACE_LOG_ADD_INF Additional Info
instruction_code CTE_FND_POST_INSTRUCTION_CODE Instruction

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.

-- Payroll Posting Log Trace
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CTE_D_LOG_TRA_PY (
    CLIENT,                  -- Client [MANDT]
    DOC_STORE_REF,           -- UUID [CTE_UUID]
    SEQUENTIAL_NO,           -- Sequential No [CTE_SEQUENTIAL_NUMBER]
    ACTION_CODE,             -- Document Action [CTE_FND_POST_DOC_ACTION_CODE]
    STATUS,                  -- Status [CTE_FND_POST_LOG_TRACE_STATUS]
    USERNAME,                -- User [XUBNAME]
    TIMESTAMP,               -- Created [CTE_FND_POST_DOC_CREATED_AT]
    LOGNUMBER,               -- Lognumber [CTE_LOGNUMBER]
    CONF_UUID,               -- UUID [CTE_UUID]
    HIGH_NO_IND,             -- Char01 [CHAR01]
    ADDITIONAL_INFORMATION,  -- Additional Info [CTE_FND_POST_TRACE_LOG_ADD_INF]
    INSTRUCTION_CODE,        -- Instruction [CTE_FND_POST_INSTRUCTION_CODE]
    PRIMARY KEY (CLIENT, DOC_STORE_REF, SEQUENTIAL_NO)
);

Learn More