FINS_ALLOC_TMPLV

Transparent Table Customizing Table
13 Fields 1 CDS Views

One Allocation Template: Information for Field Groups

FINS_ALLOC_TMPLV is an SAP database table in S/4HANA. One Allocation Template: Information for Field Groups. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AllocTopDownDistrFldGroup view from BASIC Top Down Distribution Field Group

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY tab fco_allocation_context Allocation Context
KEY name fins_alloc_template Template Name
KEY fieldname fvalueal30c Data Field
fielddescr fins_alloc_fld_descr Field Description
checked fins_alloc_val_fld_checked Checked
formula fins_alloc_tmp_formula Formula
field1 fins_alloc_por_field Portion Field
portion1 fins_alloc_percent Share Portion
field2 fins_alloc_por_field Portion Field
portion2 fins_alloc_percent Share Portion
customfield fins_alloc_cust_field Custom Field
type fins_alloc_refkeyfigure_type Type

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.

-- One Allocation Template: Information for Field Groups
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_ALLOC_TMPLV (
    MANDT,        -- Client [mandt]
    TAB,          -- Allocation Context [fco_allocation_context]
    NAME,         -- Template Name [fins_alloc_template]
    FIELDNAME,    -- Data Field [fvalueal30c]
    FIELDDESCR,   -- Field Description [fins_alloc_fld_descr]
    CHECKED,      -- Checked [fins_alloc_val_fld_checked]
    FORMULA,      -- Formula [fins_alloc_tmp_formula]
    FIELD1,       -- Portion Field [fins_alloc_por_field]
    PORTION1,     -- Share Portion [fins_alloc_percent]
    FIELD2,       -- Portion Field [fins_alloc_por_field]
    PORTION2,     -- Share Portion [fins_alloc_percent]
    CUSTOMFIELD,  -- Custom Field [fins_alloc_cust_field]
    TYPE,         -- Type [fins_alloc_refkeyfigure_type]
    PRIMARY KEY (MANDT, TAB, NAME, FIELDNAME)
);

Learn More