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 Facility Information
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