DFACTS

Transparent Table Application Table
15 Fields 1 CDS Views

OBJNR to Facts

DFACTS is an SAP database table in S/4HANA. OBJNR to Facts. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PublicSectorFact view from BASIC Fact Entries

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY obart J_OBART Object Type
KEY objid J_OBJID Object ID
KEY fact_type_seq PS_FACT_TYPE_SEQ Fact Type Sequence
KEY fact_type_rep PS_FACT_TYPE_REP Fact Type Repetition
KEY fact_cat_seq PS_FACT_CAT_SEQ Fact Cat. Sequence
KEY fact_cat_rep PS_FACT_CAT_REP Fact Cat Repetition
KEY valid_to PS_VALID_TO Valid to
valid_from PS_VALID_FROM Valid from
fact_set PS_FACTS_SET Fact Set
fact_type PS_FACT_TYPE Fact Type
fact_category PS_FACTCAT Fact Category
value_generic PS_FACT_GENERIC Value
qual_generic PS_FACT_QUAL_GENERIC Qualifier
objnr J_OBJNR Object number

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.

-- OBJNR to Facts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFACTS (
    CLIENT,         -- Client [MANDT]
    OBART,          -- Object Type [J_OBART]
    OBJID,          -- Object ID [J_OBJID]
    FACT_TYPE_SEQ,  -- Fact Type Sequence [PS_FACT_TYPE_SEQ]
    FACT_TYPE_REP,  -- Fact Type Repetition [PS_FACT_TYPE_REP]
    FACT_CAT_SEQ,   -- Fact Cat. Sequence [PS_FACT_CAT_SEQ]
    FACT_CAT_REP,   -- Fact Cat Repetition [PS_FACT_CAT_REP]
    VALID_TO,       -- Valid to [PS_VALID_TO]
    VALID_FROM,     -- Valid from [PS_VALID_FROM]
    FACT_SET,       -- Fact Set [PS_FACTS_SET]
    FACT_TYPE,      -- Fact Type [PS_FACT_TYPE]
    FACT_CATEGORY,  -- Fact Category [PS_FACTCAT]
    VALUE_GENERIC,  -- Value [PS_FACT_GENERIC]
    QUAL_GENERIC,   -- Qualifier [PS_FACT_QUAL_GENERIC]
    OBJNR,          -- Object number [J_OBJNR]
    PRIMARY KEY (CLIENT, OBART, OBJID, FACT_TYPE_SEQ, FACT_TYPE_REP, FACT_CAT_SEQ, FACT_CAT_REP, VALID_TO)
);

Learn More