FCHT_CHAIN

Transparent Table Application Table
14 Fields 1 CDS Views

Financial Chain

FCHT_CHAIN is an SAP database table in S/4HANA. Financial Chain. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinancialChain view_entity from BASIC Financial Chain

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chain_id FCH_FINANCIAL_CHAIN_ID Financial Chain ID
chain_category FCH_FINANCIAL_CHAIN_CATEGORY FCH Category
lifecycle_status FCH_LIFECYCLE_STATUS Lifecycle Status
delivering_plant FCH_DELIVERING_PLANT Delivering Plant
receiving_plant FCH_RECEIVING_PLANT Initiating Plant
date_from FCH_DATE_FROM Validity Start Date
date_to FCH_DATE_TO Validity End Date
bukrs FCH_BUKRS Company Code
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

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.

-- Financial Chain
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCHT_CHAIN (
    MANDT,                  -- Client [MANDT]
    CHAIN_ID,               -- Financial Chain ID [FCH_FINANCIAL_CHAIN_ID]
    CHAIN_CATEGORY,         -- FCH Category [FCH_FINANCIAL_CHAIN_CATEGORY]
    LIFECYCLE_STATUS,       -- Lifecycle Status [FCH_LIFECYCLE_STATUS]
    DELIVERING_PLANT,       -- Delivering Plant [FCH_DELIVERING_PLANT]
    RECEIVING_PLANT,        -- Initiating Plant [FCH_RECEIVING_PLANT]
    DATE_FROM,              -- Validity Start Date [FCH_DATE_FROM]
    DATE_TO,                -- Validity End Date [FCH_DATE_TO]
    BUKRS,                  -- Company Code [FCH_BUKRS]
    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]
    PRIMARY KEY (MANDT, CHAIN_ID)
);

Learn More