REFH

Transparent Table Application Table
10 Fields 2 CDS Views

References between CO object numbers, header table

REFH is an SAP database table in S/4HANA. References between CO object numbers, header table. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TreasuryReference view_entity from BASIC Treasury Reference Information
TOE_CDS_TRM_DEALS view_entity inner cds view for deal nominals in TOENE

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reftyp kl_typ Reference Cat.
KEY refnr kl_nr Reference
status kl_saktiv Status
dzterm tb_dzterm Payment Date
kontrh tb_kunnr_new Partner
ext_ref_id kl_ext_ref External ID of Reference
cfi_code ftr_cfi_code CFI Code
upi ftr_upi Unique Prod. ID
isin ranl_isin Sec. ID (ISIN)

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.

-- References between CO object numbers, header table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REFH (
    MANDT,       -- Client [mandt]
    REFTYP,      -- Reference Cat. [kl_typ]
    REFNR,       -- Reference [kl_nr]
    STATUS,      -- Status [kl_saktiv]
    DZTERM,      -- Payment Date [tb_dzterm]
    KONTRH,      -- Partner [tb_kunnr_new]
    EXT_REF_ID,  -- External ID of Reference [kl_ext_ref]
    CFI_CODE,    -- CFI Code [ftr_cfi_code]
    UPI,         -- Unique Prod. ID [ftr_upi]
    ISIN,        -- Sec. ID (ISIN) [ranl_isin]
    PRIMARY KEY (MANDT, REFTYP, REFNR)
);

Learn More