FCHT_MATCH_UPL

Transparent Table Application Table
18 Fields 1 CDS Views

Upload of Financial Chain Material Assignments

FCHT_MATCH_UPL is an SAP database table in S/4HANA. Upload of Financial Chain Material Assignments. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinChainMaterialAssgmtUpload view_entity from BASIC Fin Chain Material Assignment Upload

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uuid UUID UUID
upload_id FCH_MAT_ASSGNMT_UPLOAD_ID Upload ID
file_name FILE_FILENAME File Name
file_binary XSTRINGVAL Binary String
file_mimetype FCH_MIME_TYPE MIME Type
create_user FCH_CREATE_USER Created By
create_timestamp FCH_CREATE_TIMESTAMP Created
change_user FCH_CHANGE_USER Changed By
change_timestamp FCH_CHANGE_TIMESTAMP Changed
local_last_changed_at ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
log_handle BALLOGHNDL Handle
log_severity FCH_APPL_LOG_SEVERITY Appl Log Severity
job_count BTCJOBCNT Job No.
job_name BTCJOB Job Name
num_items_total FCH_NUM_ITEMS_TOTAL Total Items
num_items_successful FCH_NUM_ITEMS_SUCCESSFUL Created Items
num_items_erroneous FCH_NUM_ITEMS_ERRONEOUS Error Items

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.

-- Upload of Financial Chain Material Assignments
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCHT_MATCH_UPL (
    MANDT,                  -- Client [MANDT]
    UUID,                   -- UUID [UUID]
    UPLOAD_ID,              -- Upload ID [FCH_MAT_ASSGNMT_UPLOAD_ID]
    FILE_NAME,              -- File Name [FILE_FILENAME]
    FILE_BINARY,            -- Binary String [XSTRINGVAL]
    FILE_MIMETYPE,          -- MIME Type [FCH_MIME_TYPE]
    CREATE_USER,            -- Created By [FCH_CREATE_USER]
    CREATE_TIMESTAMP,       -- Created [FCH_CREATE_TIMESTAMP]
    CHANGE_USER,            -- Changed By [FCH_CHANGE_USER]
    CHANGE_TIMESTAMP,       -- Changed [FCH_CHANGE_TIMESTAMP]
    LOCAL_LAST_CHANGED_AT,  -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    LOG_HANDLE,             -- Handle [BALLOGHNDL]
    LOG_SEVERITY,           -- Appl Log Severity [FCH_APPL_LOG_SEVERITY]
    JOB_COUNT,              -- Job No. [BTCJOBCNT]
    JOB_NAME,               -- Job Name [BTCJOB]
    NUM_ITEMS_TOTAL,        -- Total Items [FCH_NUM_ITEMS_TOTAL]
    NUM_ITEMS_SUCCESSFUL,   -- Created Items [FCH_NUM_ITEMS_SUCCESSFUL]
    NUM_ITEMS_ERRONEOUS,    -- Error Items [FCH_NUM_ITEMS_ERRONEOUS]
    PRIMARY KEY (MANDT, UUID)
);

Learn More