FINCS_GRPSTR

Transparent Table Customizing Table
17 Fields 2 CDS Views

Consolidation Group Structure

FINCS_GRPSTR is an SAP database table in S/4HANA. Consolidation Group Structure. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CnsldtnGroupStructure view from BASIC Consolidation Group Structure
P_CnsldtnGroupStructure view from BASIC Consolidation Group Structure

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dimen FC_DIMEN Dimension
KEY strvs FC_STRVS Version: Structures
KEY congr FC_CONGR Cons. Group
KEY bunit FINCS_MD_BUNIT Consolidation Unit
KEY fromyearper FINCS_FISCALYEARPER Fiscal Year Period
toyearper FINCS_FISCALYEARPER Fiscal Year Period
fyear FC_FYEAR Year first cons
fperi FC_FPERI Prd first cons
feflg FC_FEFLG 1st cons at EOP
lyear FC_LYEAR Year divest.
lperi FC_LPERI Prd div.acctg
lbflg FC_LBFLG Divest. at BOP
lmergerflg FC_LMERGERFLG DA Due to Merger
coimeth FC_CMETH Method
coitp FC_COITP Acctg technique
etag FINCS_ETAG ETag

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 Group Structure
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_GRPSTR (
    MANDT,        -- Client [MANDT]
    DIMEN,        -- Dimension [FC_DIMEN]
    STRVS,        -- Version: Structures [FC_STRVS]
    CONGR,        -- Cons. Group [FC_CONGR]
    BUNIT,        -- Consolidation Unit [FINCS_MD_BUNIT]
    FROMYEARPER,  -- Fiscal Year Period [FINCS_FISCALYEARPER]
    TOYEARPER,    -- Fiscal Year Period [FINCS_FISCALYEARPER]
    FYEAR,        -- Year first cons [FC_FYEAR]
    FPERI,        -- Prd first cons [FC_FPERI]
    FEFLG,        -- 1st cons at EOP [FC_FEFLG]
    LYEAR,        -- Year divest. [FC_LYEAR]
    LPERI,        -- Prd div.acctg [FC_LPERI]
    LBFLG,        -- Divest. at BOP [FC_LBFLG]
    LMERGERFLG,   -- DA Due to Merger [FC_LMERGERFLG]
    COIMETH,      -- Method [FC_CMETH]
    COITP,        -- Acctg technique [FC_COITP]
    ETAG,         -- ETag [FINCS_ETAG]
    PRIMARY KEY (MANDT, DIMEN, STRVS, CONGR, BUNIT, FROMYEARPER)
);

Learn More