FINS_ALLOC_ASGMT

Transparent Table Application Table
7 Fields 2 CDS Views

Top Down Distribution Cycle Template Assignment

FINS_ALLOC_ASGMT is an SAP database table in S/4HANA. Top Down Distribution Cycle Template Assignment. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocTopDwnDistrCycTmpl view from BASIC Allocation Cycle TDD Template
I_UnivAllocTopDwnDistrTemplate view_entity from BASIC TDD Template

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tab DBNAM Table
KEY cycle CYCLE Cycle
KEY sdate SDATE Valid From
template FINS_ALLOC_TEMPLATE Template Name
erkrs ERKRS Operating concern
hash CHAR40 Char

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.

-- Top Down Distribution Cycle Template Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_ALLOC_ASGMT (
    MANDT,     -- Client [MANDT]
    TAB,       -- Table [DBNAM]
    CYCLE,     -- Cycle [CYCLE]
    SDATE,     -- Valid From [SDATE]
    TEMPLATE,  -- Template Name [FINS_ALLOC_TEMPLATE]
    ERKRS,     -- Operating concern [ERKRS]
    HASH,      -- Char [CHAR40]
    PRIMARY KEY (MANDT, TAB, CYCLE, SDATE)
);

Learn More