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