/dmbe/i_Deal

Deal | view: /DMBE/IDEAL | TRAN | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: /DMBE/TM_DEALHDR
Column Name Description
Column Name Description
Column Name Description
📏 Broker Fee Unit of Measure (brokerfeeuom):
brokerfeeqty Broker Fee Per Quantity
📏 Total Contract Volume Unit of Measure (totalcontractvolumeuom):
totalcontractvolume Total Contract Volume
Column Name Description
tradedate Trade Date
effectivefrom Effective From
effectiveto Effective To
initialtermfrom Initial Term From
initialtermto Initial Term To
notificationdate Evergreen Notification Date
reportingperiodtodate Reporting period to date
reportingperiodfromdate Reporting period from date
Column Name Description
transactiontype Transaction Type Show values
brokerfeeoption Broker Fee Option Show values
governingparty Governing Paper Show values
arbitration Arbitration Show values
template Is a Template Show values
status Deal Status Show values
autorenewalflag Auto Renewal Show values
origindoctype Origin Document Type Show values
schedulingallowed Scheduling allowed Show values
exchangeenabled Exchange Enabled Show values
automaticallycreated Flag if Draft is auto-created and should be deleted Show values
hassensitivefields Deal has sensitive fields Show values
pricemode Price Mode Show values
isinmemorydeal Is In-Memory Deal Show values
Column Name Description Domain name
dealuuid UUID in X form (binary) SYSUUID
smartid Deal Number /DMBE/DM_SMART_ID
counterparty Counterparty BU_PARTNER
counterpartycontact Counterparty Contact Business Partner BU_PARTNER
contactname Counterparty Contact /DMBE/DM_CONTACT_NAME
internalcontact Deal Trader USNAM
broker Broker BU_PARTNER
brokerfeeid Broker Fee Identifier /DMBE/DM_BROKER_FEE_ID
brokerfeeamount Broker Fee Amount /DMBE/DM_BROKER_FEE_AMOUNT
authorizingtrader Authorizing Trader USNAM
responsibletrader Responsible Trader USNAM
governinglawdescr Governing Law /DMBE/DM_GOVERNING_LAW_DESCR
importedrecord Importer/Exporter of Record /DMBE/DM_IMPORTED_RECORD
importerofrecord Importer of Record /DMBE/DM_IMPORTED_RECORD
exporterofrecord Exporter of Record /DMBE/DM_IMPORTED_RECORD
counterpartyepa Counterparty Environmental Protection Agency /DMBE/DM_COUNTERPARTY_EPA
generaltermdescr General Terms /DMBE/DM_GENERAL_TERMS_DESCR
provisuuid General Provision SYSUUID
provisdescr General Provision /DMBE/DM_GENERAL_TERMS_DESCR
contractanalyst Contract Analyst USNAM
contractstatus Deal Paper Contract Status /DMBE/DM_PAPER_CONTRACT_STATUS
amendcounter Amendment Counter /DMBE/DM_AMEND_COUNTER
evgidrenewal Evergreen Renewal Period /DMBE/DM_EVERGREEN_ID
evgidcancel Evergreen Cancellation Period /DMBE/DM_EVERGREEN_ID
buyingcompany Buying Company I/C BUKRS
sellingcompany Selling Company I/C BUKRS
externalnumber External Number /DMBE/DM_SMART_ID
refsmartid Smart Identifier of Reference Document /DMBE/DM_SMART_ID
refuuid Identifier of Reference Document SYSUUID
brkfeevoltypedesc Broker Fee Volume Type /DMBE/DM_BRKFEEVOLTYPE_DESCR
schedulingdesk Scheduling Desk /DMBE/DM_SCHEDULERS_DESK
buyingtrader Buying Trader USNAM
sellingtrader Selling Trader USNAM
dealclass Deal Class /DMBE/DM_DEALCLASS
templatename Template Name /DMBE/DM_TEMPLATE_NAME
createdby User Name SYCHAR12
createdat UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
changedby User Name SYCHAR12
changedat UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
etag ETAG CHAR32
deleted Deleted Indicator ABAP_BOOL
baselocation Base Location OIA_BASELO
exchangeagreementnumber Exchange agreement number OIA_EXGNUM
noticeperiod Notice Period for Exchange Agreement (with Change Control) OIA_DURAT
workflowid Workflow ID SIBFINSTID
creditoptionheader Credit Option /DMBE/DM_CREDIT_OPTION
paymenttermheader Payment Term ZTERM
partnerref Exchange partner reference code OIA_PTRREF
Master Data Relations Join Conditions
Header Accounting Type
  • Client
  • Header Accounting Type
Broker Fee Volume Type
  • Client
  • Broker Fee Volume Type
Deal Type
  • Client
  • Deal Type
Financial Accounting Standards Code
  • Client
  • Financial Accounting Standards Code
General Term
  • Client
  • General Term
Governing Law
  • Client
  • Governing Law
Product Type
  • Client
  • Product Type
Other Relations | to Master Data Relations ↑ Join Conditions
Internal Company
  • Client
  • Internal Company