MDG_BUS_SYS_TECH

Transparent Table Customizing Table
10 Fields 5 CDS Views

Technical information of a Business System

MDG_BUS_SYS_TECH is an SAP database table in S/4HANA. Technical information of a Business System. It contains 10 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_AddlOwnrReplicationStatus view_entity inner BASIC Replication status of messages
I_BPSystemReplicationStatus view_entity inner COMPOSITE Status of BP Replication to a single system
I_CFinSourceBusinessSystem view_entity from BASIC CFin Source Business System
I_MDOCURRENTDISTRIBUTIONSTATUS view inner Latest Distribution Status
I_MDODRFDistributionStatus view inner Distribution Status

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY business_system MDG_BUSINESS_SYSTEM Business System
bus_sys_id MDG_BUSINESS_SYSTEM_ID Business System ID
logsys LOGSYS Logical system
rfcdest RFCDEST Destination
file_path MDG_PATH_NAME Logical Path
def_storage_serv MDG_STORAGE_SERVER Download to PS
unicode_system MDG_UNICODE_SYSTEM Unicode Supported
unicode_code_pag MDG_TREX_CODEPAGE_CHAR Unicode Code Page
disabled MDG_BUS_SYS_DISABLED Disabled

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.

-- Technical information of a Business System
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDG_BUS_SYS_TECH (
    MANDT,             -- Client [MANDT]
    BUSINESS_SYSTEM,   -- Business System [MDG_BUSINESS_SYSTEM]
    BUS_SYS_ID,        -- Business System ID [MDG_BUSINESS_SYSTEM_ID]
    LOGSYS,            -- Logical system [LOGSYS]
    RFCDEST,           -- Destination [RFCDEST]
    FILE_PATH,         -- Logical Path [MDG_PATH_NAME]
    DEF_STORAGE_SERV,  -- Download to PS [MDG_STORAGE_SERVER]
    UNICODE_SYSTEM,    -- Unicode Supported [MDG_UNICODE_SYSTEM]
    UNICODE_CODE_PAG,  -- Unicode Code Page [MDG_TREX_CODEPAGE_CHAR]
    DISABLED,          -- Disabled [MDG_BUS_SYS_DISABLED]
    PRIMARY KEY (MANDT, BUSINESS_SYSTEM)
);

Learn More