VTB_ASGN_RELAT

Transparent Table Application Table
14 Fields 2 CDS Views

FTR Assignment Management: Assignment Object

VTB_ASGN_RELAT is an SAP database table in S/4HANA. FTR Assignment Management: Assignment Object. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_Ftr_Asgn_Facility view from COMPOSITE
R_FinancialTransactionFacility view inner BASIC Fin Trans Facility Information

Fields (14)

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.
start_date DATS Date
end_date DATS Date
company_code BUKRS Company Code
deal_number TB_RFHA Transaction
credit_line TB_CREDIT_LINE Credit Line
sub_cl_id TB_SUB_CL Facility Credit Line
sub_cl_text TB_CRDT_LINE_TEXT Credit Line (Descr)
partner TB_KUNNR_NEW Partner
currency WAERS Currency
ref_obj TB_RELAT_OBJ Assignment Obj.
ref_obj_cat TB_RELAT_OBJ_CAT Assignment Obj.Cat.

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: Assignment Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTB_ASGN_RELAT (
    MANDT,          -- Client [MANDT]
    RELAT_OBJ,      -- Assignment Obj. [TB_RELAT_OBJ]
    RELAT_OBJ_CAT,  -- Assignment Obj.Cat. [TB_RELAT_OBJ_CAT]
    START_DATE,     -- Date [DATS]
    END_DATE,       -- Date [DATS]
    COMPANY_CODE,   -- Company Code [BUKRS]
    DEAL_NUMBER,    -- Transaction [TB_RFHA]
    CREDIT_LINE,    -- Credit Line [TB_CREDIT_LINE]
    SUB_CL_ID,      -- Facility Credit Line [TB_SUB_CL]
    SUB_CL_TEXT,    -- Credit Line (Descr) [TB_CRDT_LINE_TEXT]
    PARTNER,        -- Partner [TB_KUNNR_NEW]
    CURRENCY,       -- Currency [WAERS]
    REF_OBJ,        -- Assignment Obj. [TB_RELAT_OBJ]
    REF_OBJ_CAT,    -- Assignment Obj.Cat. [TB_RELAT_OBJ_CAT]
    PRIMARY KEY (MANDT, RELAT_OBJ, RELAT_OBJ_CAT)
);

Learn More