/DMBE/TM_DETDFT - Deal Detail Draft

Deal Detail Draft information is stored in SAP table /DMBE/TM_DETDFT.
It is part of development package /DMBE/BO_COMMON in software component LO-CMM-DC. This development package consists of objects that can be grouped under "Core Business Common Objects".

Fields for table /DMBE/TM_DETDFT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DEALITEMUUIDUUID in X form (binary)XSYSUUID_XRAW16
.INCLUDE/DMBE/SM_DEALDETAIL_UUID0
DEALUUIDUUID in X form (binary)SYSUUID_XRAW16
.INCLUDE/DMBE/SM_MIXED_PRODUCT_UUID0
MIXEDPRODUCTDETAILUUIDUUID in X form (binary)SYSUUID_XRAW16
.INCLUDEDATA/DMBE/SM_DEALDETAIL0
DEALITEMNAMEDetail Name/DMBE/EM_DETAIL_DESCRIPTIONCHAR80
DETAILTYPEDetail Type/DMBE/EM_DETAIL_TYPECHAR4
ACCOUNTTYPEDetail Accounting Type/DMBE/EM_ACCOUNT_TYPECHAR4*
RENEWDETAILRenewal Detail/DMBE/EM_RENEW_DETAILCHAR2
PRICINGPROCEDUREProcedure (Pricing, Output Control, Acct. Det., Costing,...)KALSM_DCHAR12*
.INCLUDE/DMBE/SM_DEALMAINDETAIL0
BUYINGSTRATEGYBuying Strategy/DMBE/EM_BUYINGSTRATEGYCHAR100
BUYINGSTRATEGYDESCRBuying Strategy Description/DMBE/EM_BUYINGSTRATEGY_DESCRCHAR510
SELLINGSTRATEGYSelling Strategy/DMBE/EM_SELLINGSTRATEGYCHAR100
SELLINGSTRATEGYDESCRSelling Strategy Description/DMBE/EM_SELLINGSTRATEGY_DESCRCHAR510
TLINKT-Link/DMBE/EM_TLINKCHAR60
LINKEDDETAILLinked Detail/DMBE/EM_LINKED_DETAILNUMC8
DETAILCLASSDeal Detail Class/DMBE/EM_DEALDETCLASSCHAR4
BUYINGTLINKBuying Transaction Link/DMBE/EM_BUYING_TLINKCHAR60
SELLINGTLINKSelling Transaction Link/DMBE/EM_SELLING_TLINKCHAR60
.INCLUDEMEASUREMENT/DMBE/SM_DEALDETAILMEASUREMENT0
MATERIALProduct/DMBE/EM_PRODUCTCHAR80
BASEPRODUCTBase Product/DMBE/EM_BASE_PRODUCTCHAR80
QUANTITYDetail Quantity/DMBE/EM_DEAL_MENGEQUAN7
UOMDetail Unit of Measure/DMBE/EM_DEAL_MEINSUNIT6*
DETAILTRNTYPEDetail Transaction Type/DMBE/EM_DETAIL_TRN_TYPECHAR2
TOLERANCEOPTIONTolerance Option/DMBE/EM_TOLERANCECHAR2
TOLERANCELOWERTolerance Percentage Below/DMBE/EM_TOLERANCE_VALUE_LOWDEC3
TOLERANCEHIGHERTolerance Percentage Above/DMBE/EM_TOLERANCE_VALUE_HIGHDEC3
METHODMEASUREMethod of Measure/DMBE/EM_METHOD_MEASURECHAR8
INSPECTIONCHARGESInspection Charge/DMBE/EM_INSPECTION_CHARGECHAR8
PERIODICITYPeriodicity/DMBE/EM_PERIODICITYCHAR2
DISTRIBUTIONMETHODDistribution method of scheduling quantities/DMBE/EM_DISTRIBUTION_METHODCHAR4
TOLERANCETYPETolerance Type/DMBE/EM_TOLERANCETYPECHAR2
TOLERANCEMINVALUEDetail Minimum Quantity/DMBE/EM_TOLERANCEMINIMUMVALUEDEC11
TOLERANCEMAXVALUEDetail Maximum Quantity/DMBE/EM_TOLERANCEMAXIMUMVALUEDEC11
TOLERANCEUOMTolerance Unit of Measurement/DMBE/EM_TOLERANCEUOMUNIT6*
CONVERTEDQUANTITYConverted Quantity/DMBE/EM_CONVERTEDQUANTITYQUAN7
CONVERTEDUOMConverted Unit of Measure/DMBE/EM_CONVERTEDUOMUNIT6*
COPIEDMEASUREMENTFROMMASTEROptional Detail Measurement Is Copied from Source Detail/DMBE/EM_COPIED_MEASUREMENTCHAR2
INVOICEUOMInvoice Unit of Measure/DMBE/EM_INVOICEUOMUNIT6*
MATERIALALIASProduct Alias/DMBE/EM_PRODUCT_ALIASCHAR20
.INCLUDE/DMBE/SM_QUALITY_SPECIFICATION0
QUALITYSPECIFICATIONQuality Specifications/DMBE/EM_QUALITY_SPECIFICATIONSTRG8
.INCLUDEDELIVERY/DMBE/SM_DEALDETAILDELIVERY0
INCOTERMSIncoterms (Part 1)INCO1CHAR6*
INCOTERMS2Incoterms Part 2/DMBE/EM_INCO2CHAR56
ORIGINOrigin/DMBE/EM_ORIGIN_TSWCHAR20
DESTINATIONDestination Trader Scheduler Workbench/DMBE/EM_DESTINATION_TSWCHAR20
MOTMode of Transport/DMBE/EM_MOTCHAR4TVTR
TERMSOFTRANSFERTerms of Transfer/DMBE/EM_TERMS_TRANSFERCHAR4
CYCLESELECTIONCycle ID From/DMBE/EM_CYCLE_SELECTIONCHAR20
CYCLESELECTIONTOCycle ID To/DMBE/EM_CYCLE_SELECTION_TOCHAR20
LOADINGFROMLoading From/DMBE/EM_LOADING_FROMDATS16
LOADINGTOLoading To/DMBE/EM_LOADING_TODATS16
DISCHARGEFROMDischarge From/DMBE/EM_DISCHARGE_FROMDATS16
DISCHARGETODischarge To/DMBE/EM_DISCHARGE_TODATS16
DLVEFFECTIVEFROMDetail Effective From Date/DMBE/EM_DLV_EFFECTIVE_FROMDATS16
DLVEFFECTIVETODetail Effective To Date/DMBE/EM_DLV_EFFECTIVE_TODATS16
MOTVESSELVessel Name/DMBE/EM_MOTVESSELCHAR20*
MOTVESSELTEXTVessel Free Text/DMBE/EM_MOTVESSELTEXTCHAR200
MOTPIPELINEPipeline Name/DMBE/EM_MOTPIPELINECHAR20*
MOTPIPELINETEXTPipeline Name Text/DMBE/EM_MOTPIPELINETEXTCHAR200
MOTVEHICLEVehicle/DMBE/EM_VEHICLECHAR20*
MOTVEHICLETEXTFree Text/DMBE/EM_VEHICLE_TEXTCHAR200
MOTAMOUNTDemurrage Amount/DMBE/EM_MOT_AMOUNTCURR6
MOTCURRENCYDemurrage Currency/DMBE/EM_MOT_CURRENCYCUKY10*
MOTQUANTITYDemurrage per Quantity/DMBE/EM_MOT_QUANTITYQUAN7
MOTUOMDemurrage Unit of Measure/DMBE/EM_MOT_UOMUNIT6*
MOTLAYTIMEDeal Laytime/DMBE/EM_LAYTIMECHAR22
MOTFREIGHTPAYERFreight Payer/DMBE/EM_FREIGHT_PAYERCHAR2
MOTVEHICLEPROVIDERTruck Provider/DMBE/EM_VEHICLEPROVIDERCHAR2
CONNECTINGCARRIERConnecting Carrier/DMBE/EM_CONNECTING_CARRIERCHAR20
BILLINGQTLOCBilling Quantity Location ID/DMBE/EM_BILLINGQTLOCCHAR8
DETAILSCHEDULINGDESKScheduling Desk/DMBE/EM_SCHEDULERS_DESKCHAR12
LOCATIONLocation/DMBE/EM_LOCATIONCHAR20*
DLVEFFECTIVEDATEDetail Effective Date/DMBE/EM_DLV_EFFECTIVE_DATEDATS16
.INCLUDEACCOUNTING/DMBE/SM_DEALDETAILACCOUNTING0
CREDITOPTIONCredit Option/DMBE/EM_CREDIT_OPTIONCHAR6
PAYMENTTERMPayment Term/DMBE/EM_PAYMENTTERMSCHAR8
CREDITCLAUSECredit Clause Code/DMBE/EM_CREDITCLAUSECODECHAR6
DEEMEDDATEDeemed Payment Date/DMBE/EM_DEEMEDDATEDATS16
STRATEGYDeal Strategy/DMBE/EM_DEAL_STRATEGYCHAR100
STRATEGYDESCRIPTIONDeal Strategy/DMBE/EM_DEAL_STRT_DESCRIPTIONCHAR510
PROVISIONALPAYMENTTERMPayment Term/DMBE/EM_PAYMENTTERMSCHAR8
BILLINGFREQUENCYBilling Frequency/DMBE/EM_BILLING_FREQUENCYCHAR4*
FASCODEFinancial Accounting Standards Code/DMBE/EM_FAS_CODECHAR8
.INCLUDELCFS/DMBE/SM_DEALDETAILLCFS0
LCFSRELEVANCYDetail Relevancy for Regulations/DMBE/EM_LCFS_RELEVANCYCHAR2
CIOPTIONCarbon Intensity Option/DMBE/EM_CI_OPTIONCHAR2
LCFSOBLIGATIONLow Carbon Fuel Standard Obligation/DMBE/EM_LCFS_OBLIGATIONCHAR2
CISPECIFICVALUECarbon Intensity Specific Value/DMBE/EM_CI_SPECIFIC_VALUEDEC3
CIMINIMUMCarbon Intensity Minimum Value/DMBE/EM_CI_MIN_VALUEDEC3
CIMAXIMUMCarbon Intensity Maximum Value/DMBE/EM_CI_MAX_VALUEDEC3
CIAVERAGECarbon Intensity Average/DMBE/EM_CI_AVERAGEDEC3
LCFSIMPEXPImporter/Exporter/DMBE/EM_IMPORTER_EXPORTERCHAR2
LCFSGREENDIESELGreen Diesel/DMBE/EM_GREEN_DIESELCHAR2
CIPRICEDCarbon Intensity Priced/DMBE/EM_CI_PRICEDCHAR2
CIPRICINGMETHODCarbon Intensity Pricing Method/DMBE/EM_CI_PRICING_METHODCHAR2
CIPRICEPRECISIONCarbon Intensity Price Precision/DMBE/EM_CI_PRICE_PRECISIONNUMC2
CIUOMCarbon Intensity Unit of Measure/DMBE/EM_CIUOMUNIT6*
CIQUANTITYCarbon Intensity Quantity/DMBE/EM_CIQUANTITYQUAN7
LCFSPROGRAMLow Carbon Fuel Standard Program/DMBE/EM_LCFS_PROGCHAR6
FUELPATHWAYLow Carbon Fuel Standard Fuel Pathway/DMBE/EM_FUEL_PATHWAY_EXTCHAR30
PHYSICALPATHWAYPhysical Path for Low Carbon Fuel Standard Determination/DMBE/EM_PHYSICAL_PATH_EXTCHAR20
FUELPHYSICALPATHWAYFuel Physical Pathway/DMBE/EM_FUEL_PHYSICAL_PATHWAYCHAR60
.INCLUDE/DMBE/SM_INVENTORY0
COMPANYIDCompany Identification Extention/DMBE/EM_COMPANY_ID_EXTCHAR8
FACILITYIDFacility Identifier/DMBE/EM_FACILITY_ID_EXTCHAR10
UNIONCIINVENTORYComposite Key for Carbon Intensity Inventory/DMBE/EM_UNION_CI_INVENTORYCHAR150
ACTUALCIActual Carbon Intensity (gCO2/MJ)/DMBE/E_ACTUAL_CI_VALDEC3
INVENTORYCarbon Intensity Inventory/DMBE/EM_CI_INVENTORYQUAN7
INVENTORYUOMCarbon Intensity Unit of Measure/DMBE/EM_CIUOMUNIT6*
CIPERIODICITYCarbon Intensity Periodicity/DMBE/EM_CI_PERIODICITYCHAR2
CIROUNDINGRULECarbon Intensity Price Precision/DMBE/EM_CI_ROUNDING_RULECHAR20
LCFSRELEVANCYCONFIRMATIONDetail Relevancy Confirmation for LCFS/DMBE/EM_LCFS_RELEVANCY_CONFCHAR2
LCFSREGULATIONRenewables or Carbon Intensity Regulation Code/DMBE/EM_REGULATION_CODECHAR12
LCFSVINTAGEYEARRenewables or Carbon Intensity Vintage Year/DMBE/EM_VINTAGE_YEARNUMC8
REDUCTIONPERCENTAGEDeprecatedDEC3
GHGOBLIGATIONGHG Obligation/DMBE/EM_GHG_OBLIGATIONCHAR6
.INCLUDERINS/DMBE/SM_DEALDETAILRINS0
RINSRELEVANCYDetail Relevancy for RINs/DMBE/EM_RINS_RELEVANCYCHAR2
RINOBLIGATIONRenewable Identification Number Obligation/DMBE/EM_RIN_OBLIGATIONCHAR2
ATTACHEDINDICATORRenewable Identification Number Attached Indicator/DMBE/EM_ATTACHED_INDICATORCHAR2
CODERenewable Identification Number D-Code/DMBE/EM_DCODECHAR4/DMBE/TM_DCODE
VINTAGEYEARRenewables or Carbon Intensity Vintage Year/DMBE/EM_VINTAGE_YEARNUMC8
MULTIPLIERSELECTMultiplier Select/DMBE/EM_MULTIPLIER_SELECTDEC3*
QAPCODEQuality Assurance Plan Certified Code/DMBE/EM_QAP_CODECHAR2
RINSGENERATORRenewable Identification Number Generator/DMBE/EM_RINS_GENERATORCHAR20*
RINSIMPEXPRenewable Identification Number Importer/Exporter/DMBE/EM_RINSIMPORTER_EXPORTERCHAR2
RINSGREENDIESELOcean Going Vessels/DMBE/EM_RINS_GREEN_DIESELCHAR2
RINSPRICEDRenewable Identification Number Priced/DMBE/EM_RINS_PRICEDCHAR2
RINSPRICINGMETHODRenewable Identification Number Pricing Method/DMBE/EM_RINS_PRICING_METHODCHAR2
RINSPRICEPRECISIONPrice Precision/DMBE/EM_RINS_PRICE_PRECISIONNUMC2
RINSROUNDINGRULERenewable Identification Number Price Precision/DMBE/EM_RINS_ROUNDING_RULECHAR20
RINSRELEVANCYCONFIRMATIONDetail Relevancy confirmation for RINs/DMBE/EM_RINS_RELEVANCY_CONFCHAR2
RINSREGULATIONRenewables or Carbon Intensity Regulation Code/DMBE/EM_REGULATION_CODECHAR12
RINSCREDITCATEGORYCredit Category/DMBE/EM_CREDIT_CATEGORYCHAR4
.INCLUDEBTC/DMBE/SR_DEALDETAILBTC0
BTCRELEVANCYDetail Relevancy for Blender Tax Credit/DMBE/EM_BTC_RELEVANCYCHAR2
BTCINDICATORBlenders Tax Credit Indicator/DMBE/EM_BTC_INDICATORCHAR2
BTCTYPEBlenders Tax Credit Type/DMBE/EM_BTC_TYPECHAR2
BTCPERCENTAGEBlenders Tax Credit Percentage/DMBE/EM_BTC_PERCENTAGEDEC3
.INCLUDEREFCONTRACT/DMBE/SM_DEALDETREFCONTRACT0
CONTRACTTYPEGenerated Contract Document Type/DMBE/EM_CONTRACTTYPECHAR8
CONTRACTNUMBERContract Number/DMBE/EM_CONTRACTNUMBERCHAR20
CONTRACTITEMContract Item/DMBE/EM_CONTRACTITEMNUMC12
RINSCONTRACTITEMRINS Contract Item/DMBE/EM_RINSCONTRACTITEMNUMC12
LCFSCONTRACTITEMLCFS Contract Item/DMBE/EM_LCFSCONTRACTITEMNUMC12
.INCLUDEPRICING/DMBE/SM_DEALDETAILPRICING0
PRICINGMETHODPricing Method/DMBE/EM_PRICING_METHODCHAR2
PRICEPRECISIONPrice Precision/DMBE/EM_PRICE_PRECISIONNUMC2
FALLBACKFLAGFallback Flag for Complex Scenarios/DMBE/EM_FALLBACK_FLAGCHAR2
FALLBACKINSTRUCTIONSFallback Instructions for Complex Scenarios/DMBE/EM_FALLBACK_INSTRUCTIONSSTRG8
MERCMONTHMercantile Month/DMBE/EM_MERCMONTHCHAR10
RISKPERIODMONTHRisk Period Month/DMBE/EM_RISKPERIODMONTHNUMC4
RISKPERIODYEARRisk Period Year/DMBE/EM_RISKPERIODYEARNUMC8
EFPPRICINGCATEGORYPricing Category for Exchange Futures for Physicals/DMBE/EM_EFP_CATEGORYCHAR4
INSTRUMENTTYPEInstrument Type/DMBE/EM_INSTRUMENT_TYPECHAR20
EFPFIXINDEXIndex/DMBE/EM_QUOTATION_RULECHAR20
EFPFIXKEYDATEContract Month/DMBE/EM_MATURITY_KEYDATECHAR16
FLOORBROKERDETAILFloor Broker/DMBE/EM_FLOORBROKERCHAR20*
PRICEROUNDINGRULEPrice Precision/DMBE/EM_ROUNDING_RULECHAR20
.INCLUDEOPTIONALITY/DMBE/SM_DEALDETAILOPTIONALITY0
OPTIONALITYKEYDetail Number/DMBE/EM_OPTIONALITY_KEYNUMC8
OPTIONALITYFOROptionality For/DMBE/EM_OPTIONALITY_FORNUMC8
.INCLUDEMIXEDPRODUCT/DMBE/SM_DEALDETAILMIXPRODUCT0
COMPONENTFORMixed Product Main Detail Number/DMBE/EM_COMPONENT_FORNUMC8
COMPONENTPERCENTAGEComponent Percentage in Mixed Products/DMBE/EM_COMPONENT_PERCENTAGEDEC3
PRICEDATCOMPONENTLEVELMixed Product is priced at the component level/DMBE/EM_PRICED_AT_COMPONENTSCHAR2
COMPONENTQUANTITYFORMATFormat used to quantify the mixed products components/DMBE/EM_COMPONENT_QTY_FORMATCHAR2
.INCLUDEINTERCOMP/DMBE/SM_DEALDETAILINTERCOMP0
ORIGINBUSPARTNEROrigin Intercompany/DMBE/EM_ORIGINBUSPARTNERCHAR20*
.INCLUDECI_DEALDETAIL0
.INCLUDEADMIN/DMBE/SM_ADMIN_DATA0
CREATEDBYUser Name/DMBE/EM_SYUNAMECHAR24
CREATEDATUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC11
CHANGEDBYUser Name/DMBE/EM_SYUNAMECHAR24
CHANGEDATUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)TIMESTAMPLDEC11
ETAGETAG/DMBE/EM_ETAG_ADMDATACHAR64
DELETEDDeleted Indicator/DMBE/EM_DELETEDCHAR2
ACTIVEUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
Privacy Policy