/dmbe/c_Template_Search

Template Search Consumption View | view: /DMBE/CDEALSRCHT | 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_ACCOUNT, TFACT, /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_QUOTRULE, CPEC_QUOTRULE_T, CPEC_ROUNDRULE_T, /DMBE/TM_CREDCL, /DMBE/TM_CREDCLT, TCURX, TCURT, /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_IEREC, /DMBE/TM_LAYTIME, /DMBE/TM_LAY_T, ADRC, OIFSPBL, OIJLOC, MARA, /DMBE/TM_MTHDMEA, /DMBE/TM_MTHDM_T, TVTRT, OIGV, TOIGV, /DMBE/TM_VEHPROV, /DMBE/TM_VEHPR_T, OIGVT, OIGV, TOIGV, TVZBT, T052U, /DMBE/TM_PRDTP, /DMBE/TM_PRDTP_T, /DMBE/TM_SCHEDLR, /DMBE/TM_SCHED_T, /DMBE/TM_TRANSF, /DMBE/TM_TRANS_T, T052, T000, T006, T006A, ADRP, USR21, BUT000, BUT100, T001, TKA02, TVZB, TINC, TINCT, MAKT, /DMBE/TM_BILLING, /DMBE/TM_BPROLE, /DMBE/TM_BP_COMP, /DMBE/TM_BPRELAT, /DMBE/TM_BPROLE, /DMBE/TM_COMPCOD, TBAC_DCS_LOF, /DMBE/TM_ROUND, /DMBE/TM_CURC, /DMBE/TM_FTFLAG, /DMBE/TM_INCOTRM, /DMBE/TM_MOT, /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):
ciQuantity Carbon Intensity Quantity
convertedQuantity Converted Quantity
Column Name Description
tradeDate Trade Date
effectiveFrom Effective From
effectiveTo Effective To
initialTermFrom Initial Term From
initialTermTo Initial Term 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
createdAt Created On - Header
createdTime Created Time - Header
changedAt Changed On
changedTime Changed On (Time)
Column Name Description
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
toleranceOption Tolerance Option Show values
toleranceHigher Tolerance Percentage Above Show values
toleranceLower Tolerance Percentage Below Show values
periodicity Periodicity Show values
toleranceType Tolerance Type Show values
ciOption Carbon Intensity Option Show values
ciPeriodicity Carbon Intensity Periodicity Show values
pricingMethod Pricing Method Show values
efpPricingCategory Pricing Category for Exchange Futures for Physicals Show values
ciObligation Low Carbon Fuel Standard Obligation Show values
ciPriced Carbon Intensity Priced Show values
ciPricingMethod Carbon Intensity Pricing Method Show values
rinsPriced Renewable Identification Number Priced Show values
rinsPricingMethod Renewable Identification Number Pricing Method Show values
fallBackFlag Fallback Flag for Complex Scenarios Show values
renewDetail Renewal Detail Show values
Column Name Description Domain name
smartId Template Number /DMBE/DM_SMART_ID
templateName Template Name /DMBE/DM_TEMPLATE_NAME_70C
internalCompanyDescr Internal Company /DMBE/DM_COMPANY_NAME_35C
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
contractAnalyst Contract Analyst USNAM
contractAnalystDescr Contract Analyst TEXT80
internalContact Deal Trader USNAM
internalContactDescr Deal Trader TEXT80
broker Broker BU_PARTNER
responsibleTrader Responsible Trader USNAM
responsibleTraderDescr Responsible Limit Of Authority TEXT80
governingPartyName Governing Paper /DMBE/DM_GOVERNING_PARTY_DESCR
governingLawDescr Governing Law /DMBE/DM_GOVERNING_LAW_DESCR40
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
settlementCurrencyName Settlement Currency TEXT40
provisUuid General Provision SYSUUID
provisDescr General Provision /DMBE/DM_GENERAL_TERMS_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
schedulingDesk Scheduling Desk /DMBE/DM_SCHEDULERS_DESK
schedulingDeskDescr Scheduling Desk Description /DMBE/DM_SCHEDULERS_DESK_DESC
dealBlocked null
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
strategy Strategy /DMBE/DM_DEAL_STRATEGY_30C
strategyDescr Strategy /DMBE/DM_DEAL_STRATEGY_30C
dealItemName Detail Name /DMBE/DM_DETAIL_DESCRIPTION
material Product MATNR
materialDescr Product TEXT40
UOMDescr Detail Unit of Measure TEXT10
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
toleranceOptionDescription Tolerance Option DDTEXT
methodMeasure Method of Measure /DMBE/DM_METHOD_MEASURE
methodMeasureDescr Method of Measure /DMBE/DM_METHOD_MEASURE_DESCR
inspectionCharges Inspection Charge /DMBE/DM_INSPECTION_CHARGE
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
ciOptionDescr Carbon Intensity Option DDTEXT
ciPeriodicityDescr Carbon Intensity Periodicity CHAR30LOW
pricingMethodDescr Pricing Method DDTEXT
priceRoundingRule Price Precision CPE_RULE
priceRoundingRuleDescr Invoice Price Precision TEXT40
efpPricingCategoryDescr Pricing Category for Exchange Futures for Physicals DDTEXT
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
incoterms Incoterms INCO1
incotermsDescr Incoterms TEXT30
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
lcfsRelevancy Detail Relevancy for Regulations ABAP_BOOL
lcfsRelevancyConfirmation Detail Relevancy Confirmation for LCFS ABAP_BOOL
motDescr Mode of Transport CHAR20
termsOfTransfer Terms of Transfer /DMBE/DM_TERMS_TRANSFER
termsOfTransferDescr Terms of Transfer /DMBE/DM_TERMS_TRANSFER_DESCR
billingFrequency Billing Frequency WFCID
billingFrequencyDescr Billing Frequency TEXT60
creditOption Credit Option /DMBE/DM_CREDIT_OPTION
creditOptionDescr Credit Option /DMBE/DM_CREDITCLAUSETEXT
paymentTerm Payment Term ZTERM
paymentTermDescr Payment Term TEXT50
provisionalPaymentTerm Provisional Payment Term
provisionalPaymentTermDescr Provisional Payment Term TEXT50
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
ciObligationDescr Low Carbon Fuel Standard Obligation 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
ciPricedDescr Carbon Intensity Priced CHAR3
ciPricingMethodDescr Carbon Intensity Pricing Method DDTEXT
ciRoundingRule Carbon Intensity Price Precision CPE_RULE
ciRoundingRuleDescr Carbon Intensity Price Precision TEXT40
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 CPE_RULE
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
fallBackInstructions Fallback Instructions for Complex Scenarios STRING
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
contractNumber Contract Number /DMBE/DM_CONTRACTNUMBER
contractType Generated Contract Document Type
contractItem Contract Item
efpFixIndex Exchange Futures for Physicals Mercantile Instrument Type CPE_RULE
efpFixIndexDescr Exchange Futures for Physicals Mercantile Instrument Type /DMBE/DM_DESCRIPTION
createdBy Created By - Header SYCHAR12
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
createDealButton Character Field of Length 1
Master Data Relations Join Conditions
Deal Type
  • Client
  • Deal Type
Financial Accounting Standards Code
  • Financial Accounting Standards Code
  • Client
Governing Law
  • Client
  • Governing Law
Header Accounting Type
  • Client
  • Header Accounting Type
Mode of Transport
  • Client
  • Mode of Transport
  • /DMBE/C_TEMPLATE_SEARCH.MANDT == TVTR.MANDT
  • /DMBE/C_TEMPLATE_SEARCH.MOT == TVTR.VKTRA
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