/dmbe/c_Deal_Search

Deal Search Consumption View | view: /DMBE/CDEALSRCH | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: /DMBE/TM_DETACT, /DMBE/TM_DEALHDR, /DMBE/TM_ACCOUNT, /DMBE/TM_ACCO_TX, /DMBE/TM_BILLLOC, /DMBE/TM_BILLLOT, BUT050, BUT000, CVI_VEND_LINK, LFA1, T001K, T001W, BUT100, TBAC_PHYSCOMMT, TBAC_DCST, CPEC_QUOTRULE, /DMBE/TM_QUOTR_T, CPEC_QUOTRULE_T, TBAC_MICT, TW56T, /DMBE/TM_QUOTRUL, CPEC_ROUNDRULE_T, /DMBE/TM_CREDCL, /DMBE/TM_CREDCLT, TCURX, TCURT, /DMBE/TM_DEALINK, /DMBE/TM_DEALTYP, /DMBE/TM_DEALT_T, /DMBE/TM_EVGCANC, /DMBE/TM_EVGRENW, /DMBE/TM_EVGCN_T, /DMBE/TM_EVGRN_T, /DMBE/TM_IEREC, /DMBE/TM_FASCODE, /DMBE/TM_FASCODT, /DMBE/TM_FRG_PAY, /DMBE/TM_FRGPY_T, /DMBE/TM_PROVIS, /DMBE/TM_PROVIST, /DMBE/TM_LAWS, /DMBE/TM_LAWS_T, /DMBE/TM_GOVPT_T, /DMBE/TM_GOVPRTY, /DMBE/TM_IEREC_T, /DMBE/TM_LAYTIME, /DMBE/TM_LAY_T, /DMBE/TM_LNKRS, /DMBE/TM_LNKRS_T, ADRC, OIFSPBL, OIJLOC, MARA, /DMBE/TM_MTHDMEA, /DMBE/TM_MTHDM_T, TVTRT, OIGV, TOIGV, /DMBE/TM_VEHPROV, /DMBE/TM_VEHPR_T, OIGVT, TVZBT, T052U, /DMBE/TM_PRDTP, /DMBE/TM_PRDTP_T, /DMBE/TM_SCHEDLR, /DMBE/TM_SCHED_T, /DMBE/TM_STATUS, /DMBE/TM_TRANSF, /DMBE/TM_TRANS_T, T052, T000, T006, T006A, ADRP, USR21, T001, TKA02, TVZB, TINC, TINCT, MAKT, /DMBE/TM_BPROLE, /DMBE/TM_BP_COMP, /DMBE/TM_BPRELAT, /DMBE/TM_COMPCOD, TBAC_DCS_LOF, /DMBE/TM_ROUND, /DMBE/TM_CURC, /DMBE/TM_FTFLAG, /DMBE/TM_INCOTRM, /DMBE/TM_MOT, /DMBE/TM_PAYTFIL, /DMBE/TM_PMT_DD, /DMBE/TM_TRTNAME
Column Name Description
dealUuid UUID in X form (binary)
dealItemUuid UUID in X form (binary)
Column Name Description
💲 Settlement Currency (settlementCurrency):
motAmount Demurrage Amount
Column Name Description
quantity null
📏 Tolerance Unit of Measurement (toleranceUom):
convertedQuantity Converted Quantity
ciQuantity Carbon Intensity Quantity
Column Name Description
tradeDate Trade Date
effectiveFrom Effective From
effectiveTo Effective To
notificationDate Evergreen Notification Date
deemedDate Deemed Payment Date
loadingFrom Loading From
loadingTo Loading To
dischargeFrom Discharge From
dischargeTo Discharge To
dlvEffectiveFrom Detail Effective From Date
dlvEffectiveTo Detail Effective To Date
initialTermFrom Initial Term From
initialTermTo Initial Term To
createdAt Created On - Header
createdTime Created Time - Header
changedAt Changed On
changedTime Changed On (Time)
Column Name Description
status Deal Status Show values
Industry Industry Type Show values
areOptionalitiesInLine Truth Value: True/False Show values
isComplexPricing Truth Value: True/False Show values
transactionType Transaction Type Show values
governingParty Governing Paper Show values
arbitration Arbitration Show values
schedulingAllowed Scheduling allowed Show values
periodicity Periodicity Show values
toleranceType Tolerance Type Show values
pricingMethod Pricing Method Show values
ciObligation Low Carbon Fuel Standard Obligation Show values
ciOption Carbon Intensity Option Show values
ciPeriodicity Carbon Intensity Periodicity Show values
ciPriced Carbon Intensity Priced Show values
ciPricingMethod Carbon Intensity Pricing Method Show values
fallBackFlag Fallback Flag for Complex Scenarios Show values
rinsPriced Renewable Identification Number Priced Show values
rinsPricingMethod Renewable Identification Number Pricing Method Show values
toleranceOption Tolerance Option Show values
toleranceLower Tolerance Percentage Below Show values
toleranceHigher Tolerance Percentage Above Show values
efpPricingCategory Pricing Category for Exchange Futures for Physicals Show values
renewDetail Renewal Detail Show values
workflowProgress Workflow in progress Show values
Column Name Description Domain name
smartId Deal Number /DMBE/DM_SMART_ID
amendCounter Amendment Counter /DMBE/DM_AMEND_COUNTER
internalCompanyName Internal Company /DMBE/DM_COMPANY_NAME_35C
contractAnalyst Contract Analyst USNAM
contractAnalystDescr Contract Analyst TEXT80
contractStatus Deal Paper Contract Status
contractStatusDesc Deal Paper Contract Status /DMBE/DM_DESCRIPTION
statusName Deal Status DDTEXT
productTypeDescr Product Type /DMBE/DM_PRODUCT_TYPE_DESCR
dealTypeDescr Deal Type /DMBE/DM_DEAL_TYPE_DESC
transactionTypeDescr Transaction Type DDTEXT
headerAccountTypeDescr Header Accounting Type /DMBE/DM_ACCOUNTINGTYPE_DESCR
fasCodeHeaderDescr Financial Accounting Standards Code /DMBE/DM_FAS_CODE_TEXT
counterparty Counterparty BU_PARTNER
counterpartyName Counterparty CHAR80
counterpartyContact Counterparty Contact Business Partner
counterpartyContactName Counterparty Contact Business Partner CHAR80
internalContact Deal Trader USNAM
internalContactDescr Deal Trader TEXT80
responsibleTrader Responsible Trader USNAM
responsibleTraderDescr Responsible Limit Of Authority TEXT80
governingLawDescr Governing Law /DMBE/DM_GOVERNING_LAW_DESCR40
provisUuid General Provision SYSUUID
provisDescr General Provision /DMBE/DM_GENERAL_TERMS_DESCR
governingPartyName Governing Paper /DMBE/DM_GOVERNING_PARTY_DESCR
importerOfRecord Importer of Record /DMBE/DM_IMPORTED_RECORD
importerOfRecordDescr Importer of Record /DMBE/DM_IMPORTED_RECORD_DESCR
exporterOfRecord Exporter of Record /DMBE/DM_IMPORTED_RECORD
exporterOfRecordDescr Exporter of Record /DMBE/DM_IMPORTED_RECORD_DESCR
buyingTrader Buying Trader USNAM
buyingTraderDescr Deal Trader TEXT80
sellingTrader Selling Trader USNAM
sellingTraderDescr Deal Trader TEXT80
baseLocation Base Location OIA_BASELO
dealClass Deal Class /DMBE/DM_DEALCLASS
dealBlocked null
settlementCurrencyName Settlement Currency TEXT40
strategy Strategy /DMBE/DM_DEAL_STRATEGY_30C
strategyDescr Strategy /DMBE/DM_DEAL_STRATEGY_30C
dealItemName Detail Name /DMBE/DM_DETAIL_DESCRIPTION
detailTrnType Detail Transaction Type
detailTrnTypeDescr Transaction Type DDTEXT
tLink T-Link /DMBE/DM_TLINK
tLinkDescr Transaction Link Description /DMBE/DM_TLINK_DESCR
linkedDetail Linked Detail /DMBE/DM_LINKED_DETAIL
detailClass Deal Detail Class /DMBE/DM_DEALDETCLASS
location Location OIJ_LOCID
detailSchedulingDesk Scheduling Desk
detailSchedulingDeskDescr Scheduling Desk Description /DMBE/DM_SCHEDULERS_DESK_DESC
periodicityName Periodicity CHAR30LOW
toleranceTypeDescr Tolerance Type DDTEXT
toleranceMaxValue Detail Maximum Quantity
toleranceMinValue Detail Minimum Quantity
qualitySpecification Quality Specifications
motLaytime Deal Laytime /DMBE/DM_LAYTIME
motLaytimeDescr Deal Laytime /DMBE/DM_LAYTIME_DESCR
motFreightPayer Freight Payer /DMBE/DM_FREIGHT_PAYER
motFreightPayerDescr Freight Payer /DMBE/DM_FREIGHT_PAYER_DESCR
motVehicleProvider Truck Provider /DMBE/DM_VEHICLEPROVIDER
motVehicleProviderDescr Truck Provider /DMBE/DM_VEHICLEPROVIDER_DESCR
pricingMethodDescr Pricing Method DDTEXT
priceRoundingRule Price Precision
priceRoundingRuleDescr Invoice Price Precision TEXT40
detailAccountType Detail Accounting Type
detailAccountTypeDescr Detail Accounting Type /DMBE/DM_ACCOUNTINGTYPE_DESCR
detailFasCode Financial Accounting Standards Code
detailFasCodeDescr Financial Accounting Standards Code /DMBE/DM_FAS_CODE_TEXT
methodMeasure Method of Measure /DMBE/DM_METHOD_MEASURE
methodMeasureDescr Method of Measure /DMBE/DM_METHOD_MEASURE_DESCR
inspectionCharges Inspection Charge /DMBE/DM_INSPECTION_CHARGE
material Product MATNR
materialDescr Product TEXT40
UOMDescr Detail Unit of Measure TEXT10
billingFrequency Billing Frequency WFCID
creditOption Credit Option /DMBE/DM_CREDIT_OPTION
creditOptionDescr Credit Option /DMBE/DM_CREDITCLAUSETEXT
paymentTerm Payment Term ZTERM
paymentTermDescr Payment Term TEXT50
lcfsRelevancy Detail Relevancy for Regulations ABAP_BOOL
lcfsRelevancyConfirmation Detail Relevancy Confirmation for LCFS ABAP_BOOL
ciObligationDescr Low Carbon Fuel Standard Obligation DDTEXT
ciOptionDescr Carbon Intensity Option DDTEXT
ciSpecificValue Carbon Intensity Specific Value /DMBE/DM_CI_VALUE
ciMininum Carbon Intensity Minimum Value /DMBE/DM_CI_VALUE
ciMaximum Carbon Intensity Maximum Value /DMBE/DM_CI_VALUE
ciAverage Carbon Intensity Average /DMBE/DM_CI_VALUE
ciPeriodicityDescr Carbon Intensity Periodicity CHAR30LOW
ciPricedDescr Carbon Intensity Priced CHAR3
ciPricingMethodDescr Carbon Intensity Pricing Method DDTEXT
ciRoundingRule Carbon Intensity Price Precision
ciRoundingRuleDescr Carbon Intensity Price Precision TEXT40
fallBackInstructions Fallback Instructions for Complex Scenarios STRING
rinsRelevancy Detail Relevancy for RINs ABAP_BOOL
rinsRelevancyConfirmation Detail Relevancy confirmation for RINs ABAP_BOOL
rinsPricedDescr Renewable Identification Number Priced CHAR3
rinsRoundingRule Renewable Identification Number Price Precision
rinsRoundingRuleDescr Renewable Identification Number Price Precision TEXT40
rinsPricingMethodDescr Renewable Identification Number Pricing Method DDTEXT
rinAttachedIndicator Renewable Identification Number Attached Indicator
rinAttachedIndicatorDescr Renewable Identification Number Attached Indicator Desc DDTEXT
rinDCodeDescr Renewable Identification Number D-Code /DMBE/DM_DCODE_DESCR
rinVintageYear Renewables or Carbon Intensity Vintage Year /DMBE/DM_VINTAGE_YEAR
rinMultiplier Multiplier Select /DMBE/DM_MULTIPLIER_SELECT
detailNumber Detail Number /DMBE/DM_OPTIONALITY_KEY
optionalityFor Optionality For /DMBE/DM_OPTIONALITY_KEY
termsOfTransfer Terms of Transfer /DMBE/DM_TERMS_TRANSFER
termsOfTransferDescr Terms of Transfer /DMBE/DM_TERMS_TRANSFER_DESCR
incoterms Incoterms INCO1
incotermsDescr Incoterms TEXT30
toleranceOptionDescription Tolerance Option DDTEXT
origin Origin OIJ_LOCID
originDescr Origin OIJ_LOCNAM
originBP Origin Intercompany BU_PARTNER
originBPDescr Origin Intercompany CHAR80
destination Destination Trader Scheduler Workbench OIJ_LOCID
destinationDescr Destination Name OIJ_LOCNAM
motDescr Mode of Transport CHAR20
billingQtLoc Billing Quantity Location ID CHAR4
billingQtLocDescr Billing Quantity Location Text TEXT30
motVessel Vessel Name OIG_VHLNMR
motVesselText Vessel Name /DMBE/DM_VEHICLE_TEXT_40C
motPipeline Pipeline Name OIG_VHLNMR
motPipelineText Pipeline Name CHAR40
contractNumber Contract Number /DMBE/DM_CONTRACTNUMBER
contractType Generated Contract Document Type
contractItem Contract Item
efpPricingCategoryDescr Pricing Category for Exchange Futures for Physicals DDTEXT
provisionalPaymentTerm Provisional Payment Term
provisionalPaymentTermDescr Provisional Payment Term TEXT50
efpFixIndex Exchange Futures for Physicals Mercantile Instrument Type CPE_RULE
efpFixIndexDescr Exchange Futures for Physicals Mercantile Instrument Type /DMBE/DM_DESCRIPTION
schedulingDesk Scheduling Desk /DMBE/DM_SCHEDULERS_DESK
schedulingDeskDescr Scheduling Desk Description /DMBE/DM_SCHEDULERS_DESK_DESC
evgIdRenewal Evergreen Renewal Period /DMBE/DM_EVERGREEN_ID
evgDescRenewal Evergreen Renewal Period /DMBE/DM_EVERGREEN_DESCR
evgIdCancel Evergreen Cancellation Period
evgIdCancelDescr Evergreen Cancellation Period /DMBE/DM_EVERGREEN_DESCR
buyingCompany Buying Company I/C BUKRS
buyingCompanyDescr Buying Company I/C /DMBE/DM_COMPANY_NAME_40C
sellingCompany Selling Company I/C BUKRS
sellingCompanyDescr Selling Company I/C /DMBE/DM_COMPANY_NAME_40C
createdBy Created By - Header SYCHAR12
linkedDeal Linked Deal /DMBE/DM_SMART_ID
changedBy Changed By SYCHAR12
lcfsRegulation Renewables or Carbon Intensity Regulation Code
rinsRegulation Renewables or Carbon Intensity Regulation Code
contractTypeType Type of Contract Type /DMBE/DM_CONTRACT_TYPE_TYPE
Master Data Relations Join Conditions
Deal Type
  • Client
  • Deal Type
Financial Accounting Standards Code
  • Financial Accounting Standards Code
  • Client
Governing Law
  • Governing Law
  • Client
Header Accounting Type
  • Header Accounting Type
  • Client
Mode of Transport
  • Mode of Transport
  • Client
  • /DMBE/C_DEAL_SEARCH.MOT == TVTR.VKTRA
  • /DMBE/C_DEAL_SEARCH.MANDT == TVTR.MANDT
Product Type
  • Client
  • Product Type
Renewable Identification Number D-Code
  • Client
  • Renewable Identification Number D-Code
Other Relations | to Master Data Relations ↑ Join Conditions
Internal Company
  • Internal Company
  • Client