/DMBE/TM_PRDDFT - Deal draft product
Deal draft product information is stored in SAP table /DMBE/TM_PRDDFT.
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_PRDDFT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| PRODUCTUUID | UUID in X form (binary) | X | SYSUUID_X | RAW | 16 | |
| .INCLUDE | FOREIGN_KEYS | /DMBE/SM_PRODUCT_UUID | 0 | |||
| LOCATIONUUID | UUID in X form (binary) | SYSUUID_X | RAW | 16 | ||
| DEALUUID | UUID in X form (binary) | SYSUUID_X | RAW | 16 | ||
| .INCLUDE | DATA | /DMBE/SM_PRODUCT | 0 | |||
| PRODUCT | 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 | * | |
| EFFECTIVEFROM | Product Effective From Date | /DMBE/EM_PRD_EFFECTIVE_FROM | DATS | 16 | ||
| EFFECTIVETO | Productl Effective To Date | /DMBE/EM_PRD_EFFECTIVE_TO | DATS | 16 | ||
| SEQUENCE | Represents an Order Sequence | /DMBE/EM_SEQUENCE_INT | NUMC | 6 | ||
| .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 | ||
| PRODUCTRINSRELEVANT | Detail Relevancy for RINs | /DMBE/EM_RINS_RELEVANCY | CHAR | 2 | ||
| PRODUCTLCFSOBLIGATION | Low Carbon Fuel Standard Obligation | /DMBE/EM_LCFS_OBLIGATION | CHAR | 2 | ||
| ASMUTUALLYAGREED | Mutually Agreed | /DMBE/EM_AS_MUTUALLY_AGREED | CHAR | 2 | ||
| STRATEGY | Deal Strategy | /DMBE/EM_DEAL_STRATEGY | CHAR | 100 | ||
| STRATEGYDESCRIPTION | Deal Strategy | /DMBE/EM_DEAL_STRT_DESCRIPTION | CHAR | 510 | ||
| TOLERANCELOWER | Tolerance Percentage Below | /DMBE/EM_TOLERANCE_VALUE_LOW | DEC | 3 | ||
| TOLERANCEHIGHER | Tolerance Percentage Above | /DMBE/EM_TOLERANCE_VALUE_HIGH | DEC | 3 | ||
| 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 | * | |
| MATERIALALIAS | Product Alias | /DMBE/EM_PRODUCT_ALIAS | CHAR | 20 | ||
| PRODUCTGHGOBLIGATION | GHG Obligation | /DMBE/EM_GHG_OBLIGATION | CHAR | 6 | ||
| PRODUCTRINSREGULATION | Renewables or Carbon Intensity Regulation Code | /DMBE/EM_REGULATION_CODE | CHAR | 12 | ||
| PRODUCTLCFSREGULATION | Renewables or Carbon Intensity Regulation Code | /DMBE/EM_REGULATION_CODE | CHAR | 12 | ||
| BASEPRODUCTALIAS | Base Product Alias | /DMBE/EM_BASE_PRODUCT_ALIAS | CHAR | 20 | ||
| .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 | ||
| ACTIVEUUID | UUID in X form (binary) | SYSUUID_X | RAW | 16 | ||
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 |