/DMBE/TM_DETACT - Deal Detail
Deal Detail information is stored in SAP table /DMBE/TM_DETACT.
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".
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_DETACT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DEALITEMUUID | UUID in X form (binary) | X | SYSUUID_X | RAW | 16 | |
| .INCLUDE | /DMBE/SM_DEALDETAIL_UUID | 0 | ||||
| DEALUUID | UUID in X form (binary) | SYSUUID_X | RAW | 16 | ||
| .INCLUDE | /DMBE/SM_MIXED_PRODUCT_UUID | 0 | ||||
| MIXEDPRODUCTDETAILUUID | UUID in X form (binary) | SYSUUID_X | RAW | 16 | ||
| .INCLUDE | DATA | /DMBE/SM_DEALDETAIL | 0 | |||
| DEALITEMNAME | Detail Name | /DMBE/EM_DETAIL_DESCRIPTION | CHAR | 80 | ||
| DETAILTYPE | Detail Type | /DMBE/EM_DETAIL_TYPE | CHAR | 4 | ||
| ACCOUNTTYPE | Detail Accounting Type | /DMBE/EM_ACCOUNT_TYPE | CHAR | 4 | * | |
| RENEWDETAIL | Renewal Detail | /DMBE/EM_RENEW_DETAIL | CHAR | 2 | ||
| PRICINGPROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 12 | * | |
| .INCLUDE | /DMBE/SM_DEALMAINDETAIL | 0 | ||||
| BUYINGSTRATEGY | Buying Strategy | /DMBE/EM_BUYINGSTRATEGY | CHAR | 100 | ||
| BUYINGSTRATEGYDESCR | Buying Strategy Description | /DMBE/EM_BUYINGSTRATEGY_DESCR | CHAR | 510 | ||
| SELLINGSTRATEGY | Selling Strategy | /DMBE/EM_SELLINGSTRATEGY | CHAR | 100 | ||
| SELLINGSTRATEGYDESCR | Selling Strategy Description | /DMBE/EM_SELLINGSTRATEGY_DESCR | CHAR | 510 | ||
| TLINK | T-Link | /DMBE/EM_TLINK | CHAR | 60 | ||
| LINKEDDETAIL | Linked Detail | /DMBE/EM_LINKED_DETAIL | NUMC | 8 | ||
| DETAILCLASS | Deal Detail Class | /DMBE/EM_DEALDETCLASS | CHAR | 4 | ||
| BUYINGTLINK | Buying Transaction Link | /DMBE/EM_BUYING_TLINK | CHAR | 60 | ||
| SELLINGTLINK | Selling Transaction Link | /DMBE/EM_SELLING_TLINK | CHAR | 60 | ||
| .INCLUDE | MEASUREMENT | /DMBE/SM_DEALDETAILMEASUREMENT | 0 | |||
| MATERIAL | Product | /DMBE/EM_PRODUCT | CHAR | 80 | ||
| BASEPRODUCT | Base Product | /DMBE/EM_BASE_PRODUCT | CHAR | 80 | ||
| QUANTITY | Detail Quantity | /DMBE/EM_DEAL_MENGE | QUAN | 7 | ||
| UOM | Detail Unit of Measure | /DMBE/EM_DEAL_MEINS | UNIT | 6 | * | |
| DETAILTRNTYPE | Detail Transaction Type | /DMBE/EM_DETAIL_TRN_TYPE | CHAR | 2 | ||
| TOLERANCEOPTION | Tolerance Option | /DMBE/EM_TOLERANCE | CHAR | 2 | ||
| TOLERANCELOWER | Tolerance Percentage Below | /DMBE/EM_TOLERANCE_VALUE_LOW | DEC | 3 | ||
| TOLERANCEHIGHER | Tolerance Percentage Above | /DMBE/EM_TOLERANCE_VALUE_HIGH | DEC | 3 | ||
| METHODMEASURE | Method of Measure | /DMBE/EM_METHOD_MEASURE | CHAR | 8 | ||
| INSPECTIONCHARGES | Inspection Charge | /DMBE/EM_INSPECTION_CHARGE | CHAR | 8 | ||
| PERIODICITY | Periodicity | /DMBE/EM_PERIODICITY | CHAR | 2 | ||
| DISTRIBUTIONMETHOD | Distribution method of scheduling quantities | /DMBE/EM_DISTRIBUTION_METHOD | CHAR | 4 | ||
| TOLERANCETYPE | Tolerance Type | /DMBE/EM_TOLERANCETYPE | CHAR | 2 | ||
| TOLERANCEMINVALUE | Detail Minimum Quantity | /DMBE/EM_TOLERANCEMINIMUMVALUE | DEC | 11 | ||
| TOLERANCEMAXVALUE | Detail Maximum Quantity | /DMBE/EM_TOLERANCEMAXIMUMVALUE | DEC | 11 | ||
| TOLERANCEUOM | Tolerance Unit of Measurement | /DMBE/EM_TOLERANCEUOM | UNIT | 6 | * | |
| CONVERTEDQUANTITY | Converted Quantity | /DMBE/EM_CONVERTEDQUANTITY | QUAN | 7 | ||
| CONVERTEDUOM | Converted Unit of Measure | /DMBE/EM_CONVERTEDUOM | UNIT | 6 | * | |
| COPIEDMEASUREMENTFROMMASTER | Optional Detail Measurement Is Copied from Source Detail | /DMBE/EM_COPIED_MEASUREMENT | CHAR | 2 | ||
| INVOICEUOM | Invoice Unit of Measure | /DMBE/EM_INVOICEUOM | UNIT | 6 | * | |
| MATERIALALIAS | Product Alias | /DMBE/EM_PRODUCT_ALIAS | CHAR | 20 | ||
| .INCLUDE | /DMBE/SM_QUALITY_SPECIFICATION | 0 | ||||
| QUALITYSPECIFICATION | Quality Specifications | /DMBE/EM_QUALITY_SPECIFICATION | STRG | 8 | ||
| .INCLUDE | DELIVERY | /DMBE/SM_DEALDETAILDELIVERY | 0 | |||
| INCOTERMS | Incoterms (Part 1) | INCO1 | CHAR | 6 | * | |
| INCOTERMS2 | Incoterms Part 2 | /DMBE/EM_INCO2 | CHAR | 56 | ||
| ORIGIN | Origin | /DMBE/EM_ORIGIN_TSW | CHAR | 20 | ||
| DESTINATION | Destination Trader Scheduler Workbench | /DMBE/EM_DESTINATION_TSW | CHAR | 20 | ||
| MOT | Mode of Transport | /DMBE/EM_MOT | CHAR | 4 | TVTR | |
| TERMSOFTRANSFER | Terms of Transfer | /DMBE/EM_TERMS_TRANSFER | CHAR | 4 | ||
| CYCLESELECTION | Cycle ID From | /DMBE/EM_CYCLE_SELECTION | CHAR | 20 | ||
| CYCLESELECTIONTO | Cycle ID To | /DMBE/EM_CYCLE_SELECTION_TO | CHAR | 20 | ||
| LOADINGFROM | Loading From | /DMBE/EM_LOADING_FROM | DATS | 16 | ||
| LOADINGTO | Loading To | /DMBE/EM_LOADING_TO | DATS | 16 | ||
| DISCHARGEFROM | Discharge From | /DMBE/EM_DISCHARGE_FROM | DATS | 16 | ||
| DISCHARGETO | Discharge To | /DMBE/EM_DISCHARGE_TO | DATS | 16 | ||
| DLVEFFECTIVEFROM | Detail Effective From Date | /DMBE/EM_DLV_EFFECTIVE_FROM | DATS | 16 | ||
| DLVEFFECTIVETO | Detail Effective To Date | /DMBE/EM_DLV_EFFECTIVE_TO | DATS | 16 | ||
| MOTVESSEL | Vessel Name | /DMBE/EM_MOTVESSEL | CHAR | 20 | * | |
| MOTVESSELTEXT | Vessel Free Text | /DMBE/EM_MOTVESSELTEXT | CHAR | 200 | ||
| MOTPIPELINE | Pipeline Name | /DMBE/EM_MOTPIPELINE | CHAR | 20 | * | |
| MOTPIPELINETEXT | Pipeline Name Text | /DMBE/EM_MOTPIPELINETEXT | CHAR | 200 | ||
| MOTVEHICLE | Vehicle | /DMBE/EM_VEHICLE | CHAR | 20 | * | |
| MOTVEHICLETEXT | Free Text | /DMBE/EM_VEHICLE_TEXT | CHAR | 200 | ||
| MOTAMOUNT | Demurrage Amount | /DMBE/EM_MOT_AMOUNT | CURR | 6 | ||
| MOTCURRENCY | Demurrage Currency | /DMBE/EM_MOT_CURRENCY | CUKY | 10 | * | |
| MOTQUANTITY | Demurrage per Quantity | /DMBE/EM_MOT_QUANTITY | QUAN | 7 | ||
| MOTUOM | Demurrage Unit of Measure | /DMBE/EM_MOT_UOM | UNIT | 6 | * | |
| MOTLAYTIME | Deal Laytime | /DMBE/EM_LAYTIME | CHAR | 22 | ||
| MOTFREIGHTPAYER | Freight Payer | /DMBE/EM_FREIGHT_PAYER | CHAR | 2 | ||
| MOTVEHICLEPROVIDER | Truck Provider | /DMBE/EM_VEHICLEPROVIDER | CHAR | 2 | ||
| CONNECTINGCARRIER | Connecting Carrier | /DMBE/EM_CONNECTING_CARRIER | CHAR | 20 | ||
| BILLINGQTLOC | Billing Quantity Location ID | /DMBE/EM_BILLINGQTLOC | CHAR | 8 | ||
| DETAILSCHEDULINGDESK | Scheduling Desk | /DMBE/EM_SCHEDULERS_DESK | CHAR | 12 | ||
| LOCATION | Location | /DMBE/EM_LOCATION | CHAR | 20 | * | |
| DLVEFFECTIVEDATE | Detail Effective Date | /DMBE/EM_DLV_EFFECTIVE_DATE | DATS | 16 | ||
| .INCLUDE | ACCOUNTING | /DMBE/SM_DEALDETAILACCOUNTING | 0 | |||
| CREDITOPTION | Credit Option | /DMBE/EM_CREDIT_OPTION | CHAR | 6 | ||
| PAYMENTTERM | Payment Term | /DMBE/EM_PAYMENTTERMS | CHAR | 8 | ||
| CREDITCLAUSE | Credit Clause Code | /DMBE/EM_CREDITCLAUSECODE | CHAR | 6 | ||
| DEEMEDDATE | Deemed Payment Date | /DMBE/EM_DEEMEDDATE | DATS | 16 | ||
| STRATEGY | Deal Strategy | /DMBE/EM_DEAL_STRATEGY | CHAR | 100 | ||
| STRATEGYDESCRIPTION | Deal Strategy | /DMBE/EM_DEAL_STRT_DESCRIPTION | CHAR | 510 | ||
| PROVISIONALPAYMENTTERM | Payment Term | /DMBE/EM_PAYMENTTERMS | CHAR | 8 | ||
| BILLINGFREQUENCY | Billing Frequency | /DMBE/EM_BILLING_FREQUENCY | CHAR | 4 | * | |
| FASCODE | Financial Accounting Standards Code | /DMBE/EM_FAS_CODE | CHAR | 8 | ||
| .INCLUDE | LCFS | /DMBE/SM_DEALDETAILLCFS | 0 | |||
| LCFSRELEVANCY | Detail Relevancy for Regulations | /DMBE/EM_LCFS_RELEVANCY | CHAR | 2 | ||
| CIOPTION | Carbon Intensity Option | /DMBE/EM_CI_OPTION | CHAR | 2 | ||
| LCFSOBLIGATION | Low Carbon Fuel Standard Obligation | /DMBE/EM_LCFS_OBLIGATION | CHAR | 2 | ||
| CISPECIFICVALUE | Carbon Intensity Specific Value | /DMBE/EM_CI_SPECIFIC_VALUE | DEC | 3 | ||
| CIMINIMUM | Carbon Intensity Minimum Value | /DMBE/EM_CI_MIN_VALUE | DEC | 3 | ||
| CIMAXIMUM | Carbon Intensity Maximum Value | /DMBE/EM_CI_MAX_VALUE | DEC | 3 | ||
| CIAVERAGE | Carbon Intensity Average | /DMBE/EM_CI_AVERAGE | DEC | 3 | ||
| LCFSIMPEXP | Importer/Exporter | /DMBE/EM_IMPORTER_EXPORTER | CHAR | 2 | ||
| LCFSGREENDIESEL | Green Diesel | /DMBE/EM_GREEN_DIESEL | CHAR | 2 | ||
| CIPRICED | Carbon Intensity Priced | /DMBE/EM_CI_PRICED | CHAR | 2 | ||
| CIPRICINGMETHOD | Carbon Intensity Pricing Method | /DMBE/EM_CI_PRICING_METHOD | CHAR | 2 | ||
| CIPRICEPRECISION | Carbon Intensity Price Precision | /DMBE/EM_CI_PRICE_PRECISION | NUMC | 2 | ||
| CIUOM | Carbon Intensity Unit of Measure | /DMBE/EM_CIUOM | UNIT | 6 | * | |
| CIQUANTITY | Carbon Intensity Quantity | /DMBE/EM_CIQUANTITY | QUAN | 7 | ||
| LCFSPROGRAM | Low Carbon Fuel Standard Program | /DMBE/EM_LCFS_PROG | CHAR | 6 | ||
| FUELPATHWAY | Low Carbon Fuel Standard Fuel Pathway | /DMBE/EM_FUEL_PATHWAY_EXT | CHAR | 30 | ||
| PHYSICALPATHWAY | Physical Path for Low Carbon Fuel Standard Determination | /DMBE/EM_PHYSICAL_PATH_EXT | CHAR | 20 | ||
| FUELPHYSICALPATHWAY | Fuel Physical Pathway | /DMBE/EM_FUEL_PHYSICAL_PATHWAY | CHAR | 60 | ||
| .INCLUDE | /DMBE/SM_INVENTORY | 0 | ||||
| COMPANYID | Company Identification Extention | /DMBE/EM_COMPANY_ID_EXT | CHAR | 8 | ||
| FACILITYID | Facility Identifier | /DMBE/EM_FACILITY_ID_EXT | CHAR | 10 | ||
| UNIONCIINVENTORY | Composite Key for Carbon Intensity Inventory | /DMBE/EM_UNION_CI_INVENTORY | CHAR | 150 | ||
| ACTUALCI | Actual Carbon Intensity (gCO2/MJ) | /DMBE/E_ACTUAL_CI_VAL | DEC | 3 | ||
| INVENTORY | Carbon Intensity Inventory | /DMBE/EM_CI_INVENTORY | QUAN | 7 | ||
| INVENTORYUOM | Carbon Intensity Unit of Measure | /DMBE/EM_CIUOM | UNIT | 6 | * | |
| CIPERIODICITY | Carbon Intensity Periodicity | /DMBE/EM_CI_PERIODICITY | CHAR | 2 | ||
| CIROUNDINGRULE | Carbon Intensity Price Precision | /DMBE/EM_CI_ROUNDING_RULE | CHAR | 20 | ||
| LCFSRELEVANCYCONFIRMATION | Detail Relevancy Confirmation for LCFS | /DMBE/EM_LCFS_RELEVANCY_CONF | CHAR | 2 | ||
| LCFSREGULATION | Renewables or Carbon Intensity Regulation Code | /DMBE/EM_REGULATION_CODE | CHAR | 12 | ||
| LCFSVINTAGEYEAR | Renewables or Carbon Intensity Vintage Year | /DMBE/EM_VINTAGE_YEAR | NUMC | 8 | ||
| REDUCTIONPERCENTAGE | Deprecated | DEC | 3 | |||
| GHGOBLIGATION | GHG Obligation | /DMBE/EM_GHG_OBLIGATION | CHAR | 6 | ||
| .INCLUDE | RINS | /DMBE/SM_DEALDETAILRINS | 0 | |||
| RINSRELEVANCY | Detail Relevancy for RINs | /DMBE/EM_RINS_RELEVANCY | CHAR | 2 | ||
| RINOBLIGATION | Renewable Identification Number Obligation | /DMBE/EM_RIN_OBLIGATION | CHAR | 2 | ||
| ATTACHEDINDICATOR | Renewable Identification Number Attached Indicator | /DMBE/EM_ATTACHED_INDICATOR | CHAR | 2 | ||
| CODE | Renewable Identification Number D-Code | /DMBE/EM_DCODE | CHAR | 4 | /DMBE/TM_DCODE | |
| VINTAGEYEAR | Renewables or Carbon Intensity Vintage Year | /DMBE/EM_VINTAGE_YEAR | NUMC | 8 | ||
| MULTIPLIERSELECT | Multiplier Select | /DMBE/EM_MULTIPLIER_SELECT | DEC | 3 | * | |
| QAPCODE | Quality Assurance Plan Certified Code | /DMBE/EM_QAP_CODE | CHAR | 2 | ||
| RINSGENERATOR | Renewable Identification Number Generator | /DMBE/EM_RINS_GENERATOR | CHAR | 20 | * | |
| RINSIMPEXP | Renewable Identification Number Importer/Exporter | /DMBE/EM_RINSIMPORTER_EXPORTER | CHAR | 2 | ||
| RINSGREENDIESEL | Ocean Going Vessels | /DMBE/EM_RINS_GREEN_DIESEL | CHAR | 2 | ||
| RINSPRICED | Renewable Identification Number Priced | /DMBE/EM_RINS_PRICED | CHAR | 2 | ||
| RINSPRICINGMETHOD | Renewable Identification Number Pricing Method | /DMBE/EM_RINS_PRICING_METHOD | CHAR | 2 | ||
| RINSPRICEPRECISION | Price Precision | /DMBE/EM_RINS_PRICE_PRECISION | NUMC | 2 | ||
| RINSROUNDINGRULE | Renewable Identification Number Price Precision | /DMBE/EM_RINS_ROUNDING_RULE | CHAR | 20 | ||
| RINSRELEVANCYCONFIRMATION | Detail Relevancy confirmation for RINs | /DMBE/EM_RINS_RELEVANCY_CONF | CHAR | 2 | ||
| RINSREGULATION | Renewables or Carbon Intensity Regulation Code | /DMBE/EM_REGULATION_CODE | CHAR | 12 | ||
| RINSCREDITCATEGORY | Credit Category | /DMBE/EM_CREDIT_CATEGORY | CHAR | 4 | ||
| .INCLUDE | BTC | /DMBE/SR_DEALDETAILBTC | 0 | |||
| BTCRELEVANCY | Detail Relevancy for Blender Tax Credit | /DMBE/EM_BTC_RELEVANCY | CHAR | 2 | ||
| BTCINDICATOR | Blenders Tax Credit Indicator | /DMBE/EM_BTC_INDICATOR | CHAR | 2 | ||
| BTCTYPE | Blenders Tax Credit Type | /DMBE/EM_BTC_TYPE | CHAR | 2 | ||
| BTCPERCENTAGE | Blenders Tax Credit Percentage | /DMBE/EM_BTC_PERCENTAGE | DEC | 3 | ||
| .INCLUDE | REFCONTRACT | /DMBE/SM_DEALDETREFCONTRACT | 0 | |||
| CONTRACTTYPE | Generated Contract Document Type | /DMBE/EM_CONTRACTTYPE | CHAR | 8 | ||
| CONTRACTNUMBER | Contract Number | /DMBE/EM_CONTRACTNUMBER | CHAR | 20 | ||
| CONTRACTITEM | Contract Item | /DMBE/EM_CONTRACTITEM | NUMC | 12 | ||
| RINSCONTRACTITEM | RINS Contract Item | /DMBE/EM_RINSCONTRACTITEM | NUMC | 12 | ||
| LCFSCONTRACTITEM | LCFS Contract Item | /DMBE/EM_LCFSCONTRACTITEM | NUMC | 12 | ||
| .INCLUDE | PRICING | /DMBE/SM_DEALDETAILPRICING | 0 | |||
| PRICINGMETHOD | Pricing Method | /DMBE/EM_PRICING_METHOD | CHAR | 2 | ||
| PRICEPRECISION | Price Precision | /DMBE/EM_PRICE_PRECISION | NUMC | 2 | ||
| FALLBACKFLAG | Fallback Flag for Complex Scenarios | /DMBE/EM_FALLBACK_FLAG | CHAR | 2 | ||
| FALLBACKINSTRUCTIONS | Fallback Instructions for Complex Scenarios | /DMBE/EM_FALLBACK_INSTRUCTIONS | STRG | 8 | ||
| MERCMONTH | Mercantile Month | /DMBE/EM_MERCMONTH | CHAR | 10 | ||
| RISKPERIODMONTH | Risk Period Month | /DMBE/EM_RISKPERIODMONTH | NUMC | 4 | ||
| RISKPERIODYEAR | Risk Period Year | /DMBE/EM_RISKPERIODYEAR | NUMC | 8 | ||
| EFPPRICINGCATEGORY | Pricing Category for Exchange Futures for Physicals | /DMBE/EM_EFP_CATEGORY | CHAR | 4 | ||
| INSTRUMENTTYPE | Instrument Type | /DMBE/EM_INSTRUMENT_TYPE | CHAR | 20 | ||
| EFPFIXINDEX | Index | /DMBE/EM_QUOTATION_RULE | CHAR | 20 | ||
| EFPFIXKEYDATE | Contract Month | /DMBE/EM_MATURITY_KEYDATE | CHAR | 16 | ||
| FLOORBROKERDETAIL | Floor Broker | /DMBE/EM_FLOORBROKER | CHAR | 20 | * | |
| PRICEROUNDINGRULE | Price Precision | /DMBE/EM_ROUNDING_RULE | CHAR | 20 | ||
| .INCLUDE | OPTIONALITY | /DMBE/SM_DEALDETAILOPTIONALITY | 0 | |||
| OPTIONALITYKEY | Detail Number | /DMBE/EM_OPTIONALITY_KEY | NUMC | 8 | ||
| OPTIONALITYFOR | Optionality For | /DMBE/EM_OPTIONALITY_FOR | NUMC | 8 | ||
| .INCLUDE | MIXEDPRODUCT | /DMBE/SM_DEALDETAILMIXPRODUCT | 0 | |||
| COMPONENTFOR | Mixed Product Main Detail Number | /DMBE/EM_COMPONENT_FOR | NUMC | 8 | ||
| COMPONENTPERCENTAGE | Component Percentage in Mixed Products | /DMBE/EM_COMPONENT_PERCENTAGE | DEC | 3 | ||
| PRICEDATCOMPONENTLEVEL | Mixed Product is priced at the component level | /DMBE/EM_PRICED_AT_COMPONENTS | CHAR | 2 | ||
| COMPONENTQUANTITYFORMAT | Format used to quantify the mixed products components | /DMBE/EM_COMPONENT_QTY_FORMAT | CHAR | 2 | ||
| .INCLUDE | INTERCOMP | /DMBE/SM_DEALDETAILINTERCOMP | 0 | |||
| ORIGINBUSPARTNER | Origin Intercompany | /DMBE/EM_ORIGINBUSPARTNER | CHAR | 20 | * | |
| .INCLUDE | CI_DEALDETAIL | 0 | ||||
| .INCLUDE | ADMIN | /DMBE/SM_ADMIN_DATA | 0 | |||
| CREATEDBY | User Name | /DMBE/EM_SYUNAME | CHAR | 24 | ||
| CREATEDAT | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| CHANGEDBY | User Name | /DMBE/EM_SYUNAME | CHAR | 24 | ||
| CHANGEDAT | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| ETAG | ETAG | /DMBE/EM_ETAG_ADMDATA | CHAR | 64 | ||
| DELETED | Deleted Indicator | /DMBE/EM_DELETED | CHAR | 2 |