ALLO_TAG_ASSIGN

Transparent Table Application Table
12 Fields 2 CDS Views

Allocation Tag assignment table

ALLO_TAG_ASSIGN is an SAP database table in S/4HANA. Allocation Tag assignment table. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AllocTagObjectAssignment view from BASIC Assign tag to cycle and segment
I_UnivAllocTagObjectAssignment view_entity from BASIC Tag to Allocation Object Assignment

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY allocationtagid FCO_TAG_ID Allocation Tags
KEY allocationtype DBNAM Table
KEY allocationcycle CYCLE Cycle
KEY allocationcyclestartdate FCO_ALLOC_VALID_FROM Valid From
KEY allocationcyclesegment FCO_ALLOC_SEGMENT_NUMBER Segment Number
allocationtagcreatedbyuser FCO_TAG_CREATED_USER Created By
allocationtagchangedbyuser FCO_TAG_CHANGED_USER Changed By
lastchangedatetime TIMESTAMPL Time Stamp
creationdatetime TIMESTAMPL Time Stamp
allocationcreatedate ERFDT Entered On
lastchangedate AENDT Changed On

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.

-- Allocation Tag assignment table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ALLO_TAG_ASSIGN (
    MANDT,                       -- Client [MANDT]
    ALLOCATIONTAGID,             -- Allocation Tags [FCO_TAG_ID]
    ALLOCATIONTYPE,              -- Table [DBNAM]
    ALLOCATIONCYCLE,             -- Cycle [CYCLE]
    ALLOCATIONCYCLESTARTDATE,    -- Valid From [FCO_ALLOC_VALID_FROM]
    ALLOCATIONCYCLESEGMENT,      -- Segment Number [FCO_ALLOC_SEGMENT_NUMBER]
    ALLOCATIONTAGCREATEDBYUSER,  -- Created By [FCO_TAG_CREATED_USER]
    ALLOCATIONTAGCHANGEDBYUSER,  -- Changed By [FCO_TAG_CHANGED_USER]
    LASTCHANGEDATETIME,          -- Time Stamp [TIMESTAMPL]
    CREATIONDATETIME,            -- Time Stamp [TIMESTAMPL]
    ALLOCATIONCREATEDATE,        -- Entered On [ERFDT]
    LASTCHANGEDATE,              -- Changed On [AENDT]
    PRIMARY KEY (MANDT, ALLOCATIONTAGID, ALLOCATIONTYPE, ALLOCATIONCYCLE, ALLOCATIONCYCLESTARTDATE, ALLOCATIONCYCLESEGMENT)
);

Learn More