TF150

Transparent Table Customizing Table
28 Fields 2 CDS Views

Dimensions

TF150 is an SAP database table in S/4HANA. Dimensions. 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.

-- Dimensions
-- 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