/dmbe/i_Template

Deal Header Template | view: /DMBE/ITEMPLATE | TRAN | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: /DMBE/TM_DEALHDRBUT000
Column Name Description
dealUuid UUID in X form (binary)
Column Name Description
Column Name Description
📏 Total Contract Volume Unit of Measure (totalcontractvolumeuom):
brokerFeeQty Broker Fee Per Quantity
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
status Deal Status Show values
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
autorenewalflag Auto Renewal Show values
originDocumentType 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
priceMode Price Mode Show values
Column Name Description Domain name
smartid Deal Number /DMBE/DM_SMART_ID
contractAnalyst Contract Analyst USNAM
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
provisUuid General Provision
provisDescr General Provision /DMBE/DM_GENERAL_TERMS_DESCR
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
referenceSmartID Smart Identifier of Reference Document /DMBE/DM_SMART_ID
referenceUUID Identifier of Reference Document SYSUUID
brokerFeeVolTypeDescr 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
deleted Deleted Indicator ABAP_BOOL
baseLocation Base Location OIA_BASELO
dealBlocked null
Master Data Relations Join Conditions
Header Accounting Type
  • Header Accounting Type
  • Client
Broker Fee Volume Type
  • Broker Fee Volume Type
  • Client
Deal Type
  • Client
  • Deal Type
Financial Accounting Standards Code
  • Client
  • Financial Accounting Standards Code
Governing Law
  • Client
  • Governing Law
Product Type
  • Product Type
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Internal Company
  • Client
  • Internal Company