TF167

Transparent Table Customizing Table
10 Fields 2 CDS Views

Konsolidierungseinheiten versions-/periodenabhängig

TF167 is an SAP database table in S/4HANA. Konsolidierungseinheiten versions-/periodenabhängig. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FINCS_MD_167 view from
FINCS_MD_TF167 view from

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY dimen fc_dimen Dimension
KEY rvers fc_ctrvs Version Translation
KEY bunit fc_bunit Cons. Unit
KEY ryear fc_fryear From Year
KEY perid fc_frperid Period Effect.
ctrgr fc_ctrgr Transl. Method
taxrt fc_taxrt Tax Rate
iaind fc_iaind_b Inactive
foctr fc_foctr Transl. LC = GC

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.

-- Konsolidierungseinheiten versions-/periodenabhängig
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TF167 (
    MANDT,  -- Client [mandt]
    DIMEN,  -- Dimension [fc_dimen]
    RVERS,  -- Version Translation [fc_ctrvs]
    BUNIT,  -- Cons. Unit [fc_bunit]
    RYEAR,  -- From Year [fc_fryear]
    PERID,  -- Period Effect. [fc_frperid]
    CTRGR,  -- Transl. Method [fc_ctrgr]
    TAXRT,  -- Tax Rate [fc_taxrt]
    IAIND,  -- Inactive [fc_iaind_b]
    FOCTR,  -- Transl. LC = GC [fc_foctr]
    PRIMARY KEY (MANDT, DIMEN, RVERS, BUNIT, RYEAR, PERID)
);

Learn More