/DMBE/i_DealDetailSearch

Deal Detail Search for active and draft | view: /DMBE/IDTLSRCH | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: /DMBE/TM_DETACT, /DMBE/TM_DEALHDR, /DMBE/TM_ACCOUNT, /DMBE/TM_ACCO_TX, BUT000, TBAC_PHYSCOMMT, TBAC_DCST, CPEC_QUOTRULE, /DMBE/TM_QUOTR_T, CPEC_QUOTRULE_T, TBAC_MICT, TW56T, /DMBE/TM_QUOTRUL, CPEC_QUOTRULE, CPEC_QUOTRULE_T, /DMBE/TM_EVGRENW, /DMBE/TM_EVGRN_T, /DMBE/TM_PRDTP, /DMBE/TM_PRDTP_T, /DMBE/TM_STATUS, TBAC_DCS_LOF
Column Name Description
Uuid UUID in X form (binary)
ParentUuid UUID in X form (binary)
Column Name Description
💲 Demurrage Currency (MotCurrency):
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
TransactionType Transaction Type Show values
GoverningParty Governing Paper Show values
Arbitration Arbitration Show values
SchedulingAllowed Scheduling allowed Show values
DetailTrnType Detail Transaction Type 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
RinAttachedIndicator Renewable Identification Number Attached Indicator 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
DealUuid UUID in X form (binary) SYSUUID
DealItemUuid UUID in X form (binary) SYSUUID
EditingStatus Character Field with Length 10 CHAR10
HierLevel null
DrillDownState null
SmartId Deal Number /DMBE/DM_SMART_ID
AmendCounter Amendment Counter /DMBE/DM_AMEND_COUNTER
ContractAnalyst Contract Analyst USNAM
ContractStatus Deal Paper Contract Status /DMBE/DM_PAPER_CONTRACT_STATUS
Counterparty Counterparty BU_PARTNER
CounterpartyContact Counterparty Contact Business Partner BU_PARTNER
InternalContact Deal Trader USNAM
ResponsibleTrader Responsible Trader USNAM
ProvisUuid General Provision SYSUUID
ImporterOfRecord Importer of Record /DMBE/DM_IMPORTED_RECORD
ExporterOfRecord Exporter of Record /DMBE/DM_IMPORTED_RECORD
BuyingTrader Buying Trader USNAM
SellingTrader Selling Trader USNAM
BaseLocation Base Location OIA_BASELO
DealClass Deal Class /DMBE/DM_DEALCLASS
Strategy Strategy /DMBE/DM_DEAL_STRATEGY_30C
StrategyDescription Deal Strategy /DMBE/DM_DEAL_STRT_DESCRIPTION
DealItemName Detail Name /DMBE/DM_DETAIL_DESCRIPTION
TLink T-Link /DMBE/DM_TLINK
LinkedDetail Linked Detail /DMBE/DM_LINKED_DETAIL
DetailClass Deal Detail Class /DMBE/DM_DEALDETCLASS
Location Location OIJ_LOCID
DetailSchedulingDesk Scheduling Desk /DMBE/DM_SCHEDULERS_DESK
ToleranceMaxValue Detail Maximum Quantity /DMBE/DM_TOLERANCEMAXIMUMVALUE
ToleranceMinValue Detail Minimum Quantity /DMBE/DM_TOLERANCEMINIMUMVALUE
MotLaytime Deal Laytime /DMBE/DM_LAYTIME
MotFreightPayer Freight Payer /DMBE/DM_FREIGHT_PAYER
MotVehicleProvider Truck Provider /DMBE/DM_VEHICLEPROVIDER
PriceRoundingRule Price Precision CPE_RULE
DetailAccountType Detail Accounting Type /DMBE/DM_ACCOUNT_TYPE
DetailFasCode Financial Accounting Standards Code /DMBE/DM_FAS_CODE
MethodMeasure Method of Measure /DMBE/DM_METHOD_MEASURE
InspectionCharges Inspection Charge /DMBE/DM_INSPECTION_CHARGE
Material Product MATNR
BillingFrequency Billing Frequency WFCID
CreditOption Credit Option /DMBE/DM_CREDIT_OPTION
PaymentTerm Payment Term ZTERM
LcfsRelevancy Detail Relevancy for Regulations ABAP_BOOL
LcfsRelevancyConfirmation Detail Relevancy Confirmation for LCFS ABAP_BOOL
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
CiRoundingRule Carbon Intensity Price Precision CPE_RULE
RinsRelevancy Detail Relevancy for RINs ABAP_BOOL
RinsRelevancyConfirmation Detail Relevancy confirmation for RINs ABAP_BOOL
RinsRoundingRule Renewable Identification Number Price Precision CPE_RULE
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
Incoterms Incoterms INCO1
Origin Origin OIJ_LOCID
OriginBP Origin Intercompany BU_PARTNER
Destination Destination Trader Scheduler Workbench OIJ_LOCID
BillingQtLoc Billing Quantity Location ID CHAR4
MotVessel Vessel Name OIG_VHLNMR
MotPipeline Pipeline Name OIG_VHLNMR
ContractNumber Contract Number /DMBE/DM_CONTRACTNUMBER
ContractType Generated Contract Document Type
ContractItem Contract Item
ProvisionalPaymentTerm Provisional Payment Term ZTERM
EfpFixIndex Exchange Futures for Physicals Mercantile Instrument Type CPE_RULE
SchedulingDesk Scheduling Desk /DMBE/DM_SCHEDULERS_DESK
EvgIdRenewal Evergreen Renewal Period /DMBE/DM_EVERGREEN_ID
EvgDescRenewal Evergreen Renewal Period /DMBE/DM_EVERGREEN_DESCR
EvgIdCancel Evergreen Cancellation Period /DMBE/DM_EVERGREEN_ID
BuyingCompany Buying Company I/C BUKRS
SellingCompany Selling Company I/C BUKRS
CreatedBy Created By - Header SYCHAR12
LinkedDeal null
ChangedBy Changed By SYCHAR12
LcfsRegulation Renewables or Carbon Intensity Regulation Code /DMBE/DM_REGULATION_CODE
RinsRegulation Renewables or Carbon Intensity Regulation Code /DMBE/DM_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
  • Client
  • Financial Accounting Standards Code
Governing Law
  • Governing Law
  • Client
Header Accounting Type
  • Header Accounting Type
  • Client
Mode of Transport
  • Client
  • Mode of Transport
  • /DMBE/I_DEALDETAILSEARCH.MANDT == TVTR.MANDT
  • /DMBE/I_DEALDETAILSEARCH.MOT == TVTR.VKTRA
Product Type
  • Client
  • Product Type
Renewable Identification Number D-Code
  • Renewable Identification Number D-Code
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Internal Company
  • Client
  • Internal Company