ETTIFN

Transparent Table Application Table
25 Fields 1 CDS Views

Installation Facts (Normal)

ETTIFN is an SAP database table in S/4HANA. Installation Facts (Normal). It contains 25 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 (25)

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
wert1 E_WERT1 Entry value
wert2 E_WERT2 Val.to be billd
string1 STRING1 Key 1
string2 STRING2 Key 2
string3 STRING3 Key 3
string4 STRING4 Key 4
ersatzwert ERSATZWERT Replacemt value
betrag E_BETRAG Amount
waers WAERS Currency
cologrp_inst E_COLOGRP_INST Coloc. Grp Inst

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.

-- Installation Facts (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]
    WERT1,         -- Entry value [E_WERT1]
    WERT2,         -- Val.to be billd [E_WERT2]
    STRING1,       -- Key 1 [STRING1]
    STRING2,       -- Key 2 [STRING2]
    STRING3,       -- Key 3 [STRING3]
    STRING4,       -- Key 4 [STRING4]
    ERSATZWERT,    -- Replacemt value [ERSATZWERT]
    BETRAG,        -- Amount [E_BETRAG]
    WAERS,         -- Currency [WAERS]
    COLOGRP_INST,  -- Coloc. Grp Inst [E_COLOGRP_INST]
    PRIMARY KEY (MANDT, ANLAGE, OPERAND, SAISON, AB, ABLFDNR)
);

Learn More