REFON

Transparent Table Application Table
6 Fields 3 CDS Views

References between object numbers (CO object no.)

REFON is an SAP database table in S/4HANA. References between object numbers (CO object no.). It contains 6 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CmmdtyHdgFinanceTransRef view from BASIC Basic for Finance Transaction Reference
I_TreasuryReferenceItem view_entity from BASIC Treasury Reference Item Information
R_FinTransReference view from BASIC Fin Trans Reference Information

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reftyp kl_typ Reference Cat.
KEY refnr kl_nr Reference
KEY objnr j_objnr Object number
status kl_saktiv Status
rrang kl_rrang Ranking

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 object numbers (CO object no.)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REFON (
    MANDT,   -- Client [mandt]
    REFTYP,  -- Reference Cat. [kl_typ]
    REFNR,   -- Reference [kl_nr]
    OBJNR,   -- Object number [j_objnr]
    STATUS,  -- Status [kl_saktiv]
    RRANG,   -- Ranking [kl_rrang]
    PRIMARY KEY (MANDT, REFTYP, REFNR, OBJNR)
);

Learn More