SAP ABAP Table CRMT_PRODUCT_I_DB_WRK (Product Data: Structure for Database Buffer)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-SLO (Application Component) Sales Transaction
⤷ CRM_PRODUCT_I (Package) CRM Sales Order: Product Processing Item
⤷ CRM-BTX-SLO (Application Component) Sales Transaction
⤷ CRM_PRODUCT_I (Package) CRM Sales Order: Product Processing Item
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_PRODUCT_I_DB_WRK | Table Relationship Diagram |
Short Description | Product Data: Structure for Database Buffer |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Transaction Item - Product | |||||
2 | .INCLUDE | 0 | 0 | One Order: Key Fields | |||||
3 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
4 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
5 | .INCLUDE | 0 | 0 | Item Data Product - Structure with External Fields | |||||
6 | GROSS_WEIGHT | CRMT_GROSS_WEIGHT | MENG15 | QUAN | 15 | 3 | Gross Weight | ||
7 | NET_WEIGHT | CRMT_NET_WEIGHT | MENG15 | QUAN | 15 | 3 | Net Weight | ||
8 | WEIGHT_UNIT | COMT_WEIGHT_UNIT | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
9 | VOLUME | CRMT_VOLUME | MENG15 | QUAN | 15 | 3 | Volume Occupied by the Product per Volume Unit | ||
10 | VOLUME_UNIT | COMT_VOLUME_UNIT | MEINS | UNIT | 3 | 0 | Unit for the Volume of a Product | * | |
11 | PRICE_PRODUCT | CRMT_PRICE_PRODUCT | SYSUUID | RAW | 16 | 0 | Pricing Reference Product Globally Unique Identifier | ||
12 | PROCESS_QTY_NUM | CRMT_PROCESS_QTY_NUM | CRM_PROCESS_QTY_NUM | INT4 | 10 | 0 | Numerator (factor) for conversion trans. quantity in BME | ||
13 | PROCESS_QTY_DEN | CRMT_PROCESS_QTY_DEN | CRM_PROCESS_QTY_DEN | INT4 | 10 | 0 | Denominator (factor) for conversion trans. quantity in BME | ||
14 | EXPONENT10 | CRMT_EXPONENT10 | CRM_EXPONENT10 | INT2 | 5 | 0 | 10 Exponent for Quantity Conversion | ||
15 | PROCESS_QTY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
16 | COMM_GROUP | CRMT_COMM_GROUP | CRM_COMM_GROUP | CHAR | 2 | 0 | Commission Group | CRMC_COMM_GRP | |
17 | REBATE_GROUP | CRMT_REBATE_GROUP | CRM_REBATE_GROUP | CHAR | 2 | 0 | Volume Rebate Group | CRMC_REBATEGRP | |
18 | CASH_DISC | CRMT_CASH_DISC | XFELD | CHAR | 1 | 0 | Specifies Whether a Cash Discount Can Be Given for the Prod. | ||
19 | PROD_PR_GROUP | CRMT_PROD_PR_GROUP | CRM_PROD_PR_GROUP | CHAR | 2 | 0 | Product Group | CRMC_PRC_PRGRP | |
20 | PRC_GROUP1 | CRMT_PRC_GROUP1 | CRM_PRC_GROUP1 | CHAR | 3 | 0 | Product Group 1 | CRMC_PRC_GRP1 | |
21 | PRC_GROUP2 | CRMT_PRC_GROUP2 | CRM_PRC_GROUP2 | CHAR | 3 | 0 | Product Group 2 | CRMC_PRC_GRP2 | |
22 | PRC_GROUP3 | CRMT_PRC_GROUP3 | CRM_PRC_GROUP3 | CHAR | 3 | 0 | Product Group 3 | CRMC_PRC_GRP3 | |
23 | PRC_GROUP4 | CRMT_PRC_GROUP4 | CRM_PRC_GROUP4 | CHAR | 3 | 0 | Product Group 4 | CRMC_PRC_GRP4 | |
24 | PRC_GROUP5 | CRMT_PRC_GROUP5 | CRM_PRC_GROUP5 | CHAR | 3 | 0 | Product Group 5 | CRMC_PRC_GRP5 | |
25 | PRODUCT_SEGMENT | CRMT_MKTTG_PRSEG_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Product Segment | ||
26 | PROD_HIERARCHY | CRMT_PROD_HIERARCHY | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category | ||
27 | RESID_VALUE_ST | CRMT_RESID_VALUE_ST | CRMT_RESID_VALUE_ST | CHAR | 3 | 0 | Residual Value Strategy | ||
28 | RESID_VALUE_GRP | CRMT_RESID_VALUE_GRP | CRMT_RESID_VALUE_GRP | CHAR | 3 | 0 | Residual Value Curve | * | |
29 | BATCH_ID | CRMT_BATCH_ID | BATCH_ID | CHAR | 10 | 0 | Batch Number | ||
30 | INT_INSPECTION | CRMT_INT_INSPECTION | CRM_ITEM_INSPECTION | CHAR | 4 | 0 | Internal Quality Inspection | * | |
31 | RET_PROC_IND | PROCESS_INDICATOR | PROCESS_INDICATOR | CHAR | 1 | 0 | Process Indicator | ||
32 | .INCLUDE | 0 | 0 | EEW Include | |||||
33 | PRODUCT_I_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
34 | .INCLUDE | 0 | 0 | ||||||
35 | .INCLUDE | 0 | 0 | Item Data Product . Structure of Internal Fields | |||||
36 | BASE_QTY_UNIT | COMT_PRODUCT_BASE_UOM | MEINS | UNIT | 3 | 0 | Base Unit of Measure of Product | * | |
37 | INT_OBJ_NO_BT | CRMT_INT_OBJ_NO_BT | CUOBJ | NUMC | 18 | 0 | Internal Object Number for Batch Properties | ||
38 | EXCH_BUSINESS | CRMT_EXCH_BUSINESS_REL | CRM_EXCH_BUSINESS_REL | CHAR | 1 | 0 | Core Entitlements | ||
39 | IS_GIFTCARD | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
40 | GC_SEND_TYPE | CRM_GC_SEND_TYPE | CRM_GC_SEND_TYPE | CHAR | 1 | 0 | Gift Card Send Type | ||
41 | .INCLUDE | 0 | 0 | Product Data: Dynamic Fields for Database Buffer | |||||
42 | NOREC_FLAG | CRMT_NOREC | CRM_BOOLEAN | CHAR | 1 | 0 | Entry does not Exist in Database |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_PRODUCT_I_DB_WRK | COMM_GROUP | CRMC_COMM_GRP | COMM_GROUP | REF | C | CN |
2 | CRMT_PRODUCT_I_DB_WRK | PRC_GROUP1 | CRMC_PRC_GRP1 | PRC_GROUP1 | REF | C | CN |
3 | CRMT_PRODUCT_I_DB_WRK | PRC_GROUP2 | CRMC_PRC_GRP2 | PRC_GROUP2 | REF | C | CN |
4 | CRMT_PRODUCT_I_DB_WRK | PRC_GROUP3 | CRMC_PRC_GRP3 | PRC_GROUP3 | REF | C | CN |
5 | CRMT_PRODUCT_I_DB_WRK | PRC_GROUP4 | CRMC_PRC_GRP4 | PRC_GROUP4 | REF | C | CN |
6 | CRMT_PRODUCT_I_DB_WRK | PRC_GROUP5 | CRMC_PRC_GRP5 | PRC_GROUP5 | REF | C | CN |
7 | CRMT_PRODUCT_I_DB_WRK | PROD_PR_GROUP | CRMC_PRC_PRGRP | PRC_PR_GROUP | REF | C | CN |
8 | CRMT_PRODUCT_I_DB_WRK | REBATE_GROUP | CRMC_REBATEGRP | REBATE_GROUP | REF | C | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |