ETTIFN

Transparent Table Application Table
15 Fields 1 CDS Views

Anlagefakten (normal)

ETTIFN is an SAP database table in S/4HANA. Anlagefakten (normal). It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
CRMS4_IU_I_ILNF view_entity from Utilities Installation Fact

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY anlage anlage Installation
KEY operand e_operand Operand
KEY saison saison Season
KEY ab abzeitsch Valid From
KEY ablfdnr ablfdnr Cons. No.
bis biszeitsch Valid to
belnr e_belnr Billing Doc.No.
mbelnr e_belnr Billing Doc.No.
mauszug mauszug Fact was changed as a result of move-out
altbis biszeitsch Valid to
inaktiv inaktivkz Entry inactive
manaend manaend Manual change
tarifart tarifart Rate Type
kondigr kondigr Rate fact group

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.

-- Anlagefakten (normal)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ETTIFN (
    MANDT,     -- Client [mandt]
    ANLAGE,    -- Installation [anlage]
    OPERAND,   -- Operand [e_operand]
    SAISON,    -- Season [saison]
    AB,        -- Valid From [abzeitsch]
    ABLFDNR,   -- Cons. No. [ablfdnr]
    BIS,       -- Valid to [biszeitsch]
    BELNR,     -- Billing Doc.No. [e_belnr]
    MBELNR,    -- Billing Doc.No. [e_belnr]
    MAUSZUG,   -- Fact was changed as a result of move-out [mauszug]
    ALTBIS,    -- Valid to [biszeitsch]
    INAKTIV,   -- Entry inactive [inaktivkz]
    MANAEND,   -- Manual change [manaend]
    TARIFART,  -- Rate Type [tarifart]
    KONDIGR,   -- Rate fact group [kondigr]
    PRIMARY KEY (MANDT, ANLAGE, OPERAND, SAISON, AB, ABLFDNR)
);

Learn More