/DMBE/TM_DEALHDR - Deal Header
Deal Header information is stored in SAP table /DMBE/TM_DEALHDR.
It is part of development package /DMBE/BO_COMMON in software component LO-CMM-DC. This development package consists of objects that can be grouped under "Core Business Common Objects".
It is part of development package /DMBE/BO_COMMON in software component LO-CMM-DC. This development package consists of objects that can be grouped under "Core Business Common Objects".
Fields for table /DMBE/TM_DEALHDR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DEALUUID | UUID in X form (binary) | X | SYSUUID_X | RAW | 16 | |
| .INCLUDE | DATA | /DMBE/SM_DEALHEADER | 0 | |||
| SMARTID | Deal Number | /DMBE/EM_SMART_ID | CHAR | 24 | ||
| INTERNALCOMPANY | Internal Company | /DMBE/EM_INTERNAL_COMPANY | CHAR | 8 | /DMBE/TM_COMPCOD | |
| TRADEDATE | Trade Date | /DMBE/EM_TRADE_DATE | DATS | 16 | ||
| PRODUCTTYPE | Product Type | /DMBE/EM_PRODUCT_TYPE | CHAR | 8 | /DMBE/TM_PRDTP | |
| DEALTYPE | Deal Type | /DMBE/EM_DEAL_TYPE | CHAR | 4 | /DMBE/TM_DEALTYP | |
| TRANSACTIONTYPE | Transaction Type | /DMBE/EM_TRANSACTION_TYPE | CHAR | 2 | ||
| ACCOUNTINGTYPE | Header Accounting Type | /DMBE/EM_HDR_ACCOUNT_TYPE | CHAR | 4 | /DMBE/TM_ACCOUNT | |
| FASCODEHEADER | Financial Accounting Standards Code | /DMBE/EM_FAS_CODE | CHAR | 8 | /DMBE/TM_FASCODE | |
| COUNTERPARTY | Counterparty | /DMBE/EM_COUNTERPARTY | CHAR | 20 | ||
| COUNTERPARTYCONTACT | Counterparty Contact Business Partner | /DMBE/EM_COUNTERPARTY_CONTACT | CHAR | 20 | * | |
| CONTACTNAME | Counterparty Contact | /DMBE/EM_CONTACT_NAME | CHAR | 80 | ||
| INTERNALCONTACT | Deal Trader | /DMBE/EM_INTERNAL_CONTACT | CHAR | 24 | ||
| BROKER | Broker | /DMBE/EM_BROKER_ID | CHAR | 20 | * | |
| BROKERFEEOPTION | Broker Fee Option | /DMBE/EM_BROKER_FEE_OPTION | CHAR | 2 | ||
| BROKERFEEID | Broker Fee Identifier | /DMBE/EM_BROKER_FEE_ID | CHAR | 4 | ||
| BROKERFEEAMOUNT | Broker Fee Amount | /DMBE/EM_BROKER_FEE_AMOUNT | DEC | 8 | ||
| BROKERFEECURR | Broker Fee Currency | /DMBE/EM_BROKER_FEE_CUKY | CUKY | 10 | * | |
| BROKERFEEQTY | Broker Fee Per Quantity | /DMBE/EM_BROKER_FEE_QUANTITY | QUAN | 7 | ||
| BROKERFEEUOM | Broker Fee Unit of Measure | /DMBE/EM_BROKER_FEE_UOM | UNIT | 6 | * | |
| AUTHORIZINGTRADER | Authorizing Trader | /DMBE/EM_AUTHORIZINGTRADER | CHAR | 24 | ||
| RESPONSIBLETRADER | Responsible Trader | /DMBE/EM_RESPONSIBLE_TRADER | CHAR | 24 | ||
| TOTALCONTRACTVOLUME | Total Contract Volume | /DMBE/EM_TOTAL_CONTRACT_VOLUME | QUAN | 7 | ||
| TOTALCONTRACTVOLUMEUOM | Total Contract Volume Unit of Measure | /DMBE/EM_TOTAL_CONTR_VOL_UOM | UNIT | 6 | * | |
| GOVERNINGLAW | Governing Law | /DMBE/EM_GOVERNING_LAW | CHAR | 8 | /DMBE/TM_LAWS | |
| GOVERNINGLAWDESCR | Governing Law | /DMBE/EM_GOVERNING_LAW_DESCR | CHAR | 240 | ||
| GOVERNINGPARTY | Governing Paper | /DMBE/EM_GOVERNING_PARTY | CHAR | 2 | ||
| ARBITRATION | Arbitration | /DMBE/EM_ARBITRATION | CHAR | 2 | ||
| IMPORTEDRECORD | Importer/Exporter of Record | /DMBE/EM_IMPORTED_RECORD | CHAR | 6 | ||
| IMPORTEROFRECORD | Importer of Record | /DMBE/EM_IMPORTER_OF_RECORD | CHAR | 6 | ||
| EXPORTEROFRECORD | Exporter of Record | /DMBE/EM_EXPORTER_OF_RECORD | CHAR | 6 | ||
| COUNTERPARTYEPA | Counterparty Environmental Protection Agency | /DMBE/EM_COUNTERPARTY_EPA | NUMC | 20 | ||
| SETTLEMENTCURRENCY | Settlement Currency | /DMBE/EM_CURRENCY | CUKY | 10 | * | |
| GENERALTERM | General Term | /DMBE/EM_GENERAL_TERMS | CHAR | 8 | /DMBE/TM_TERMS | |
| GENERALTERMDESCR | General Terms | /DMBE/EM_GENERAL_TERMS_DESCR | CHAR | 120 | ||
| PROVISUUID | General Provision | /DMBE/EM_GENERAL_PROVISION | RAW | 16 | ||
| PROVISDESCR | General Provision | /DMBE/EM_GENERAL_PROVISION_TXT | CHAR | 120 | ||
| TEMPLATE | Is a Template | /DMBE/EM_DEAL_TEMPLATE | CHAR | 2 | ||
| EFFECTIVEFROM | Effective From | /DMBE/EM_EFFECTIVE_FROM | DATS | 16 | ||
| EFFECTIVETO | Effective To | /DMBE/EM_EFFECTIVE_TO | DATS | 16 | ||
| STATUS | Deal Status | /DMBE/EM_DEAL_STATUS | CHAR | 2 | ||
| AMENDCOUNTER | Amendment Counter | /DMBE/EM_AMEND_COUNTER | INT2 | 2 | ||
| CONTRACTANALYST | Contract Analyst | /DMBE/EM_CONTRACT_ANALYST | CHAR | 24 | ||
| CONTRACTSTATUS | Deal Paper Contract Status | /DMBE/EM_PAPER_CONTRACT_STATUS | CHAR | 4 | ||
| EXTERNALNUMBER | External Number | /DMBE/EM_EXTERNAL_NUBER | CHAR | 24 | ||
| ORIGINDOCTYPE | Origin Document Type | /DMBE/EM_ORIG_DOCUMENT_TYPE | CHAR | 6 | ||
| REFSMARTID | Smart Identifier of Reference Document | /DMBE/EM_ORIGIN_SMART_ID | CHAR | 24 | ||
| REFUUID | Identifier of Reference Document | /DMBE/EM_ORIGIN_UUID | RAW | 16 | ||
| BRKFEEVOLTYPE | Broker Fee Volume Type | /DMBE/EM_BROKER_FEE_VOL_TYPE | CHAR | 8 | /DMBE/TM_BRKVOL | |
| BRKFEEVOLTYPEDESC | Broker Fee Volume Type | /DMBE/EM_BRKFEEVOLTYPE_DESCR | CHAR | 60 | ||
| SCHEDULINGDESK | Scheduling Desk | /DMBE/EM_SCHEDULERS_DESK | CHAR | 12 | ||
| BUYINGTRADER | Buying Trader | /DMBE/EM_BUYINGTRADER | CHAR | 24 | ||
| SELLINGTRADER | Selling Trader | /DMBE/EM_SELLINGTRADER | CHAR | 24 | ||
| DEALCLASS | Deal Class | /DMBE/EM_DEALCLASS | CHAR | 4 | ||
| SCHEDULINGALLOWED | Scheduling allowed | /DMBE/EF_SCHEDULINGALLOWED | CHAR | 2 | ||
| REPORTINGPERIODTODATE | Reporting period to date | /DMBE/EM_REPORTING_PERIOD_TO | DATS | 16 | ||
| REPORTINGPERIODFROMDATE | Reporting period from date | /DMBE/EM_REPORTING_PERIOD_FROM | DATS | 16 | ||
| AUTOMATICALLYCREATED | Flag if Draft is auto-created and should be deleted | /DMBE/EM_AUTOMATICALLY_CREATED | CHAR | 2 | ||
| WORKFLOWID | Workflow ID | /DMBE/EM_WORKFLOW_ID | CHAR | 64 | ||
| HASSENSITIVEFIELDS | Deal has sensitive fields | /DMBE/EF_HAS_SENSITIVE_FIELDS | CHAR | 2 | ||
| PARTNERREF | Exchange partner reference code | OIA_PTRREF | CHAR | 40 | ||
| PRICEMODE | Price Mode | /DMBE/EM_PRICE_MODE | CHAR | 2 | ||
| ISINMEMORYDEAL | Is In-Memory Deal | /DMBE/EM_IS_IN_MEMORY_DEAL | CHAR | 2 | ||
| .INCLUDE | /DMBE/SM_EVERGREEN | 0 | ||||
| INITIALTERMFROM | Initial Term From | /DMBE/EM_INITTERMFROM | DATS | 16 | ||
| INITIALTERMTO | Initial Term To | /DMBE/EM_INITTERMTO | DATS | 16 | ||
| EVGIDRENEWAL | Evergreen Renewal Period | /DMBE/EM_EVERGREEN_ID | CHAR | 8 | ||
| EVGIDCANCEL | Evergreen Cancellation Period | /DMBE/EM_EVGIDCANCEL | CHAR | 8 | ||
| AUTORENEWALFLAG | Auto Renewal | /DMBE/EM_EVGFLAG | CHAR | 2 | ||
| NOTIFICATIONDATE | Evergreen Notification Date | /DMBE/EM_NOTIFDATE | DATS | 16 | ||
| .INCLUDE | /DMBE/SM_DEALHDRINTERCOMPANY | 0 | ||||
| BUYINGCOMPANY | Buying Company I/C | /DMBE/EM_BUYING_COMPANY | CHAR | 8 | * | |
| SELLINGCOMPANY | Selling Company I/C | /DMBE/EM_SELLING_COMPANY | CHAR | 8 | * | |
| .INCLUDE | /DMBE/SM_EXG_AGREEMENT | 0 | ||||
| BASELOCATION | Base Location | /DMBE/OIA_BASELO | CHAR | 30 | ||
| EXCHANGEAGREEMENTNUMBER | Exchange agreement number | OIA_EXGNUM | CHAR | 20 | ||
| NOTICEPERIOD | Notice Period for Exchange Agreement (with Change Control) | /DMBE/OIA_NOTPER | DEC | 2 | ||
| EXCHANGEENABLED | Exchange Enabled | /DMBE/EM_EXCHANGE_ENABLED | CHAR | 2 | ||
| CREDITOPTIONHEADER | Credit Option | /DMBE/EM_CREDIT_OPTION | CHAR | 6 | ||
| PAYMENTTERMHEADER | Payment Term | /DMBE/EM_PAYMENTTERMS | CHAR | 8 | ||
| .INCLUDE | /DMBE/SM_LOCK_ID | 0 | ||||
| LOCKID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| .INCLUDE | CI_DEALHEADER | 0 | ||||
| .INCLUDE | TEMPLATE_DESCRIPTION | /DMBE/SM_TEMPLATE_DESCRIPTION | 0 | |||
| TEMPLATENAME | Template Name | /DMBE/EM_TEMPLATE_NAME | CHAR | 200 | ||
| .INCLUDE | ADMIN | /DMBE/SM_ADMIN_DATA | 0 | |||
| CREATEDBY | User Name | /DMBE/EM_SYUNAME | CHAR | 24 | ||
| CREATEDAT | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| CHANGEDBY | User Name | /DMBE/EM_SYUNAME | CHAR | 24 | ||
| CHANGEDAT | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| ETAG | ETAG | /DMBE/EM_ETAG_ADMDATA | CHAR | 64 | ||
| DELETED | Deleted Indicator | /DMBE/EM_DELETED | CHAR | 2 |