MDG_MLT_ASSGMNT

Transparent Table Application Table
8 Fields 6 CDS Views

Multiple Assignments

MDG_MLT_ASSGMNT is an SAP database table in S/4HANA. Multiple Assignments. It contains 8 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_BPMultipleAssignment view from BASIC Business Partner Multiple Assignments
MDGI_BusinessPartnerMultiassgn view from Business Partner Multiple Assignment
P_MDChgProcCustClAssgmtWthNmbr view inner BASIC
P_MDChgProcCustValnWthBusPart view inner BASIC
P_MDChgProcSuplrClAssmtWthNmbr view inner BASIC
P_MDChgProcSuplrValnWthBusPart view inner BASIC

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY partner bu_partner Busn. Partner
KEY assignment_id mdg_bp_assignment_id Assignment ID
assignment_cat mdg_bp_assignment_cat Assignment Category
object_id mdg_bp_object_id Object ID
standard flag Indicator
reason_id mdg_bp_reason_id Reason
addrno ad_addrnum Address Number

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.

-- Multiple Assignments
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDG_MLT_ASSGMNT (
    CLIENT,          -- Client [mandt]
    PARTNER,         -- Busn. Partner [bu_partner]
    ASSIGNMENT_ID,   -- Assignment ID [mdg_bp_assignment_id]
    ASSIGNMENT_CAT,  -- Assignment Category [mdg_bp_assignment_cat]
    OBJECT_ID,       -- Object ID [mdg_bp_object_id]
    STANDARD,        -- Indicator [flag]
    REASON_ID,       -- Reason [mdg_bp_reason_id]
    ADDRNO,          -- Address Number [ad_addrnum]
    PRIMARY KEY (CLIENT, PARTNER, ASSIGNMENT_ID)
);

Learn More