TF150

Transparent Table Customizing Table
28 Fields 2 CDS Views

Sichten

TF150 is an SAP database table in S/4HANA. Sichten. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CnsldtnDimension view from BASIC Consolidation Dimension
ICA_CONSJOURNALENTRIES_5 view inner Match Consolidation Journal Entry Lines

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY dimen fc_dimen Dimension
iaind fc_iaind_d Status
bulgh fc_bulgh Length of cons unit
cglgh fc_cglgh Length of CG
indgs gsnk Co.cons.active
indgb gsbk BA cons active
indpc pck PrCtrCons activ
itclg_fi fc_itclg_i Cons chart of accts
sityp_fi fc_sityp_i Subitem category
signc_fi fc_signcfi Co/BA delimiter
igsgb_fi fc_igsgbfi Sequence for Co/BA
hlind fc_hlind Hierarchy levels
pcuind fc_pcuind Substitute partner
revind fc_revind Reverse documents
protyp fc_protyp Apportion. procedure
ciinvcheck fc_ciinvcheck Invt vs. Equity
hrfscat fc_hrfscat FVA frequency
ustpflg fc_ustpflg Univ. Stat. Posting
newll_year fc_newll_year Yr New Lev.Logic
setgenmode fc_setgenmode Set generation
setgencgy fc_setgencgy Year-dep. set gen
docty_acs fc_docty_10 DocTp,Std.Entry
asthfs fc_asthfs Assets for Sale
periv fc_periv_global FYear Variant
dimen_source_s4gr fc_dimen_source_s4gr Src. Mig. S/4H
inv_item_sep fc_investment_item_separated Sep. Inv. Items
docty_item_subst fc_docty_item_subst ItemSubDocType

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.

-- Sichten
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TF150 (
    MANDT,              -- Client [mandt]
    DIMEN,              -- Dimension [fc_dimen]
    IAIND,              -- Status [fc_iaind_d]
    BULGH,              -- Length of cons unit [fc_bulgh]
    CGLGH,              -- Length of CG [fc_cglgh]
    INDGS,              -- Co.cons.active [gsnk]
    INDGB,              -- BA cons active [gsbk]
    INDPC,              -- PrCtrCons activ [pck]
    ITCLG_FI,           -- Cons chart of accts [fc_itclg_i]
    SITYP_FI,           -- Subitem category [fc_sityp_i]
    SIGNC_FI,           -- Co/BA delimiter [fc_signcfi]
    IGSGB_FI,           -- Sequence for Co/BA [fc_igsgbfi]
    HLIND,              -- Hierarchy levels [fc_hlind]
    PCUIND,             -- Substitute partner [fc_pcuind]
    REVIND,             -- Reverse documents [fc_revind]
    PROTYP,             -- Apportion. procedure [fc_protyp]
    CIINVCHECK,         -- Invt vs. Equity [fc_ciinvcheck]
    HRFSCAT,            -- FVA frequency [fc_hrfscat]
    USTPFLG,            -- Univ. Stat. Posting [fc_ustpflg]
    NEWLL_YEAR,         -- Yr New Lev.Logic [fc_newll_year]
    SETGENMODE,         -- Set generation [fc_setgenmode]
    SETGENCGY,          -- Year-dep. set gen [fc_setgencgy]
    DOCTY_ACS,          -- DocTp,Std.Entry [fc_docty_10]
    ASTHFS,             -- Assets for Sale [fc_asthfs]
    PERIV,              -- FYear Variant [fc_periv_global]
    DIMEN_SOURCE_S4GR,  -- Src. Mig. S/4H [fc_dimen_source_s4gr]
    INV_ITEM_SEP,       -- Sep. Inv. Items [fc_investment_item_separated]
    DOCTY_ITEM_SUBST,   -- ItemSubDocType [fc_docty_item_subst]
    PRIMARY KEY (MANDT, DIMEN)
);

Learn More