TF167

Transparent Table Customizing Table
10 Fields 2 CDS Views

Consolidation Units Version- and Period-Dependent

TF167 is an SAP database table in S/4HANA. Consolidation Units Version- and Period-Dependent. 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.

-- Consolidation Units Version- and Period-Dependent
-- 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