MDC_IMPORT

Transparent Table Application Table
23 Fields 2 CDS Views

Import Persistence

MDC_IMPORT is an SAP database table in S/4HANA. Import Persistence. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MasterDataImportTP view from TRANSACTIONAL Master Data Import
I_MDImportUser view from BASIC Users of Import

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY masterdataimportuuid /BOBF/CONF_KEY NodeID
masterdataimportdescription MDC_LOAD_NAME Load Name
masterdataimportstatus MDC_LOAD_STATUS Status
masterdataimportobjecttypecode MDC_OBJECT_TYPE_CODE Bus. Obj. Type
masterdataimportworklist MDC_WORKLIST_GUID Worklist GUID
masterdataimportseparatorsign MDC_LOAD_SEPARATOR Separator
masterdataimportescapesign MDC_LOAD_ESCAPE_SIGN Escape Sign
masterdatachangeprocess MDC_PROCESS_ID Process ID
mdchgprocessgoal MDC_PROCESS_GOAL Process Goal
mdimprtisskipconflictrecdreqd MDC_IMPORT_SKIP_CONFLICT_RECS Skip Records
masterdataimportcreator MDC_IMPORT_USER Import Creator
mdimportcreationdatetime MDC_IMPORT_CREATE_DATETIME Creation Date Time
masterdataimportlastaction /BOBF/ACT_KEY Action
masterdataimportactnstatus MDC_IMPORT_ACTION_STATUS Master Data Import last triggered Action Status
systemmessageidentification MSGID Message ID
systemmessagetype MSGTY Message Type
systemmessagenumber MSGNR Message
systemmessagevariable1 MSGV1 Message var.
systemmessagevariable2 MSGV2 Message var.
systemmessagevariable3 MSGV2 Message var.
systemmessagevariable4 MSGV4 Message var.
systemmessagetext NATXT Message Text

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.

-- Import Persistence
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDC_IMPORT (
    CLIENT,                          -- Client [MANDT]
    MASTERDATAIMPORTUUID,            -- NodeID [/BOBF/CONF_KEY]
    MASTERDATAIMPORTDESCRIPTION,     -- Load Name [MDC_LOAD_NAME]
    MASTERDATAIMPORTSTATUS,          -- Status [MDC_LOAD_STATUS]
    MASTERDATAIMPORTOBJECTTYPECODE,  -- Bus. Obj. Type [MDC_OBJECT_TYPE_CODE]
    MASTERDATAIMPORTWORKLIST,        -- Worklist GUID [MDC_WORKLIST_GUID]
    MASTERDATAIMPORTSEPARATORSIGN,   -- Separator [MDC_LOAD_SEPARATOR]
    MASTERDATAIMPORTESCAPESIGN,      -- Escape Sign [MDC_LOAD_ESCAPE_SIGN]
    MASTERDATACHANGEPROCESS,         -- Process ID [MDC_PROCESS_ID]
    MDCHGPROCESSGOAL,                -- Process Goal [MDC_PROCESS_GOAL]
    MDIMPRTISSKIPCONFLICTRECDREQD,   -- Skip Records [MDC_IMPORT_SKIP_CONFLICT_RECS]
    MASTERDATAIMPORTCREATOR,         -- Import Creator [MDC_IMPORT_USER]
    MDIMPORTCREATIONDATETIME,        -- Creation Date Time [MDC_IMPORT_CREATE_DATETIME]
    MASTERDATAIMPORTLASTACTION,      -- Action [/BOBF/ACT_KEY]
    MASTERDATAIMPORTACTNSTATUS,      -- Master Data Import last triggered Action Status [MDC_IMPORT_ACTION_STATUS]
    SYSTEMMESSAGEIDENTIFICATION,     -- Message ID [MSGID]
    SYSTEMMESSAGETYPE,               -- Message Type [MSGTY]
    SYSTEMMESSAGENUMBER,             -- Message [MSGNR]
    SYSTEMMESSAGEVARIABLE1,          -- Message var. [MSGV1]
    SYSTEMMESSAGEVARIABLE2,          -- Message var. [MSGV2]
    SYSTEMMESSAGEVARIABLE3,          -- Message var. [MSGV2]
    SYSTEMMESSAGEVARIABLE4,          -- Message var. [MSGV4]
    SYSTEMMESSAGETEXT,               -- Message Text [NATXT]
    PRIMARY KEY (CLIENT, MASTERDATAIMPORTUUID)
);

Learn More