VTB_ASGN_POS

Transparent Table Application Table

FTR Assignment Management: Assigned Position Changes

VTB_ASGN_POS is an SAP database table in S/4HANA. FTR Assignment Management: Assigned Position Changes. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_Ftr_Asgn_Pos view from COMPOSITE

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY relat_obj tb_relat_obj Assignment Obj.
KEY relat_obj_cat tb_relat_obj_cat Assignment Obj.Cat.
KEY position_obj tb_pos_obj Position Object
KEY pos_obj_cat tb_pos_obj_cat Object Category
KEY chg_date tb_pos_date Profile Change Date
KEY chg_currency tb_pos_curr Currency
chg_amount tb_pos_amount Amount Change
pos_amount tb_pos_amount Amount Change

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.

-- FTR Assignment Management: Assigned Position Changes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTB_ASGN_POS (
    MANDT,          -- Client [mandt]
    RELAT_OBJ,      -- Assignment Obj. [tb_relat_obj]
    RELAT_OBJ_CAT,  -- Assignment Obj.Cat. [tb_relat_obj_cat]
    POSITION_OBJ,   -- Position Object [tb_pos_obj]
    POS_OBJ_CAT,    -- Object Category [tb_pos_obj_cat]
    CHG_DATE,       -- Profile Change Date [tb_pos_date]
    CHG_CURRENCY,   -- Currency [tb_pos_curr]
    CHG_AMOUNT,     -- Amount Change [tb_pos_amount]
    POS_AMOUNT,     -- Amount Change [tb_pos_amount]
    PRIMARY KEY (MANDT, RELAT_OBJ, RELAT_OBJ_CAT, POSITION_OBJ, POS_OBJ_CAT, CHG_DATE, CHG_CURRENCY)
);