REFON

Transparent Table Application Table
12 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 12 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 (12)

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
cruser TB_CRUSER Entered By
dcrdat TB_DCRDAT Entry Date
tcrtim TB_TCRTIM Entry Time
upuser TB_UPUSER Changed By
dupdat TB_DUPDAT Changed On
tuptim TB_TUPTIM Time Changed
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]
    CRUSER,  -- Entered By [TB_CRUSER]
    DCRDAT,  -- Entry Date [TB_DCRDAT]
    TCRTIM,  -- Entry Time [TB_TCRTIM]
    UPUSER,  -- Changed By [TB_UPUSER]
    DUPDAT,  -- Changed On [TB_DUPDAT]
    TUPTIM,  -- Time Changed [TB_TUPTIM]
    RRANG,   -- Ranking [KL_RRANG]
    PRIMARY KEY (MANDT, REFTYP, REFNR, OBJNR)
);

Learn More