/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 |