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