/DMBE/TM_DEALHDR

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.

-- Deal Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /DMBE/TM_DEALHDR (
    MANDT,                    -- Client [MANDT]
    DEALUUID,                 -- UUID [SYSUUID_X]
    SMARTID,                  -- Deal Number [/DMBE/EM_SMART_ID]
    INTERNALCOMPANY,          -- Internal Company [/DMBE/EM_INTERNAL_COMPANY]
    TRADEDATE,                -- Trade Date [/DMBE/EM_TRADE_DATE]
    PRODUCTTYPE,              -- Product Type [/DMBE/EM_PRODUCT_TYPE]
    DEALTYPE,                 -- Deal Type [/DMBE/EM_DEAL_TYPE]
    TRANSACTIONTYPE,          -- Trans. Type - Header [/DMBE/EM_TRANSACTION_TYPE]
    ACCOUNTINGTYPE,           -- Accounting Type(hdr) [/DMBE/EM_HDR_ACCOUNT_TYPE]
    FASCODEHEADER,            -- FAS Code - Header [/DMBE/EM_FAS_CODE]
    COUNTERPARTY,             -- Counterparty [/DMBE/EM_COUNTERPARTY]
    COUNTERPARTYCONTACT,      -- Count Contact - BP [/DMBE/EM_COUNTERPARTY_CONTACT]
    CONTACTNAME,              -- Counterparty Contact [/DMBE/EM_CONTACT_NAME]
    INTERNALCONTACT,          -- Trader [/DMBE/EM_INTERNAL_CONTACT]
    BROKER,                   -- Broker [/DMBE/EM_BROKER_ID]
    BROKERFEEOPTION,          -- Broker Fee Option [/DMBE/EM_BROKER_FEE_OPTION]
    BROKERFEEID,              -- Broker Fee Id [/DMBE/EM_BROKER_FEE_ID]
    BROKERFEEAMOUNT,          -- Broker Fee Amount [/DMBE/EM_BROKER_FEE_AMOUNT]
    BROKERFEECURR,            -- Broker Fee Currency [/DMBE/EM_BROKER_FEE_CUKY]
    BROKERFEEQTY,             -- Broker Fee Per Qty [/DMBE/EM_BROKER_FEE_QUANTITY]
    BROKERFEEUOM,             -- Broker Fee UOM [/DMBE/EM_BROKER_FEE_UOM]
    AUTHORIZINGTRADER,        -- Authorizing Trader [/DMBE/EM_AUTHORIZINGTRADER]
    RESPONSIBLETRADER,        -- Responsible LOA [/DMBE/EM_RESPONSIBLE_TRADER]
    TOTALCONTRACTVOLUME,      -- Total Contr Volume [/DMBE/EM_TOTAL_CONTRACT_VOLUME]
    TOTALCONTRACTVOLUMEUOM,   -- TotContrVolUOM [/DMBE/EM_TOTAL_CONTR_VOL_UOM]
    GOVERNINGLAW,             -- Governing Law [/DMBE/EM_GOVERNING_LAW]
    GOVERNINGLAWDESCR,        -- Governing Law Descr. [/DMBE/EM_GOVERNING_LAW_DESCR]
    GOVERNINGPARTY,           -- Governing Party [/DMBE/EM_GOVERNING_PARTY]
    ARBITRATION,              -- Arbitration [/DMBE/EM_ARBITRATION]
    IMPORTEDRECORD,           -- Imp/Exp of Record [/DMBE/EM_IMPORTED_RECORD]
    IMPORTEROFRECORD,         -- Importer of Record [/DMBE/EM_IMPORTER_OF_RECORD]
    EXPORTEROFRECORD,         -- Exporter of Record [/DMBE/EM_EXPORTER_OF_RECORD]
    COUNTERPARTYEPA,          -- Counterparty EPA [/DMBE/EM_COUNTERPARTY_EPA]
    SETTLEMENTCURRENCY,       -- Settlement Currency [/DMBE/EM_CURRENCY]
    GENERALTERM,              -- Gen.Tern [/DMBE/EM_GENERAL_TERMS]
    GENERALTERMDESCR,         -- Gen.Terms Desc [/DMBE/EM_GENERAL_TERMS_DESCR]
    PROVISUUID,               -- General Provision [/DMBE/EM_GENERAL_PROVISION]
    PROVISDESCR,              -- General Provision [/DMBE/EM_GENERAL_PROVISION_TXT]
    TEMPLATE,                 -- Template [/DMBE/EM_DEAL_TEMPLATE]
    EFFECTIVEFROM,            -- Effective From [/DMBE/EM_EFFECTIVE_FROM]
    EFFECTIVETO,              -- Effective To [/DMBE/EM_EFFECTIVE_TO]
    STATUS,                   -- Status [/DMBE/EM_DEAL_STATUS]
    AMENDCOUNTER,             -- Amendment Counter [/DMBE/EM_AMEND_COUNTER]
    CONTRACTANALYST,          -- Contract Analyst [/DMBE/EM_CONTRACT_ANALYST]
    CONTRACTSTATUS,           -- Paper Contr Status [/DMBE/EM_PAPER_CONTRACT_STATUS]
    EXTERNALNUMBER,           -- External Number [/DMBE/EM_EXTERNAL_NUBER]
    ORIGINDOCTYPE,            -- Origin Document Type [/DMBE/EM_ORIG_DOCUMENT_TYPE]
    REFSMARTID,               -- Ref. Doc. (Smart) [/DMBE/EM_ORIGIN_SMART_ID]
    REFUUID,                  -- Ref. Doc. (UUID) [/DMBE/EM_ORIGIN_UUID]
    BRKFEEVOLTYPE,            -- Broker Fee Vol. Type [/DMBE/EM_BROKER_FEE_VOL_TYPE]
    BRKFEEVOLTYPEDESC,        -- Brk Fee Type Desc [/DMBE/EM_BRKFEEVOLTYPE_DESCR]
    SCHEDULINGDESK,           -- Scheduling Desk [/DMBE/EM_SCHEDULERS_DESK]
    BUYINGTRADER,             -- Buying Trader [/DMBE/EM_BUYINGTRADER]
    SELLINGTRADER,            -- Selling Trader [/DMBE/EM_SELLINGTRADER]
    DEALCLASS,                -- Deal Class [/DMBE/EM_DEALCLASS]
    SCHEDULINGALLOWED,        -- Scheduling allowed [/DMBE/EF_SCHEDULINGALLOWED]
    REPORTINGPERIODTODATE,    -- Reporting Period To [/DMBE/EM_REPORTING_PERIOD_TO]
    REPORTINGPERIODFROMDATE,  -- Reporting Per. From [/DMBE/EM_REPORTING_PERIOD_FROM]
    AUTOMATICALLYCREATED,     -- Auto. Created [/DMBE/EM_AUTOMATICALLY_CREATED]
    WORKFLOWID,               -- Workflow ID [/DMBE/EM_WORKFLOW_ID]
    HASSENSITIVEFIELDS,       -- Sensitive Fields [/DMBE/EF_HAS_SENSITIVE_FIELDS]
    PARTNERREF,               -- Partner ref. [OIA_PTRREF]
    PRICEMODE,                -- Price Mode [/DMBE/EM_PRICE_MODE]
    ISINMEMORYDEAL,           -- Is In-Memory Deal [/DMBE/EM_IS_IN_MEMORY_DEAL]
    VOIDREASONKEY,            -- Rejection Reason Key [/DMBE/EM_DEAL_REJCT_REASON_KEY]
    INITIALTERMFROM,          -- Initial Term From [/DMBE/EM_INITTERMFROM]
    INITIALTERMTO,            -- Initial Term To [/DMBE/EM_INITTERMTO]
    EVGIDRENEWAL,             -- Renewal Period - EG [/DMBE/EM_EVERGREEN_ID]
    EVGIDCANCEL,              -- Cancellation Period [/DMBE/EM_EVGIDCANCEL]
    AUTORENEWALFLAG,          -- Auto Renewal [/DMBE/EM_EVGFLAG]
    NOTIFICATIONDATE,         -- Notification Date [/DMBE/EM_NOTIFDATE]
    BUYINGCOMPANY,            -- Buying Company I/C [/DMBE/EM_BUYING_COMPANY]
    SELLINGCOMPANY,           -- Selling Company I/C [/DMBE/EM_SELLING_COMPANY]
    BASELOCATION,             -- Base Location [/DMBE/OIA_BASELO]
    EXCHANGEAGREEMENTNUMBER,  -- Exchange no. [OIA_EXGNUM]
    NOTICEPERIOD,             -- Notice Period [/DMBE/OIA_NOTPER]
    EXCHANGEENABLED,          -- Exchange Enabled [/DMBE/EM_EXCHANGE_ENABLED]
    CREDITOPTIONHEADER,       -- Credit Option [/DMBE/EM_CREDIT_OPTION]
    PAYMENTTERMHEADER,        -- Payment Term [/DMBE/EM_PAYMENTTERMS]
    LOCKID,                   -- NodeID [/BOBF/CONF_KEY]
    TEMPLATENAME,             -- Template Name [/DMBE/EM_TEMPLATE_NAME]
    CREATEDBY,                -- User Name [/DMBE/EM_SYUNAME]
    CREATEDAT,                -- Time Stamp [TIMESTAMPL]
    CHANGEDBY,                -- User Name [/DMBE/EM_SYUNAME]
    CHANGEDAT,                -- Time Stamp [TIMESTAMPL]
    ETAG,                     -- ETAG [/DMBE/EM_ETAG_ADMDATA]
    DELETED,                  -- Deleted [/DMBE/EM_DELETED]
    PRIMARY KEY (MANDT, DEALUUID)
);