SAP ABAP Table CRMS_MKTPL_IB_TPM_PRDCAT (Product Category Attributes of Node TPM (IBOM MKTPL))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL-TPM (Application Component) Trade Promotion Management
⤷ CRM_MKTPL_IB_TPM (Package) CRM Marketing: iBom for Trade Promotion and Deal
⤷ CRM-MKT-MPL-TPM (Application Component) Trade Promotion Management
⤷ CRM_MKTPL_IB_TPM (Package) CRM Marketing: iBom for Trade Promotion and Deal
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_MKTPL_IB_TPM_PRDCAT | Table Relationship Diagram |
Short Description | Product Category Attributes of Node TPM (IBOM MKTPL) |
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 | GUID | SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | ||
2 | .INCLUDE | 0 | 0 | Generic include for Mkting PCAT Assign data structures | |||||
3 | CATEGORY_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
4 | CATEGORY_ID | COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
5 | CATEGORY_TEXT | COMT_CATEGORY_TEXT | TEXT80 | CHAR | 80 | 0 | Category Description | ||
6 | SALES_UOM | COMT_UNIT | MEINS | UNIT | 3 | 0 | Units of Measure of Product | T006 | |
7 | SELECT_FLAG | CRM_MKTSS_PCAT_SELECT_FLAG | XFELD | CHAR | 1 | 0 | Flag indicating if PCat is to be excluded from planning | ||
8 | SEL_CATEG_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
9 | EXCEPTION_EXISTS | CRM_MKTGS_EXCEPTION_EXISTS | XFELD | CHAR | 1 | 0 | Flag indicating Trade Spend Exceptions Exists | ||
10 | RATES_ORIGIN | CRM_MKTGS_RATES_ORIGIN | CRM_MKTGS_RATES_ORIGIN | CHAR | 1 | 0 | Rates Origin | ||
11 | .INCLUDE | 0 | 0 | Display Pallet enhancement (ignore when TP Type <> Pallet) | |||||
12 | QUANTITY | COMT_IL_MINQUAN | MENG13 | QUAN | 13 | 3 | Component Quantity | ||
13 | UNIT_QTY | COMT_UNIT | MEINS | UNIT | 3 | 0 | Units of Measure of Product | * | |
14 | EFFECTIVE_FROM_DATS | CRM_MKTPL_EFF_FROM | DATE | DATS | 8 | 0 | Product Dimension Effective-From Date | ||
15 | EFFECTIVE_TO_DATS | CRM_MKTPL_EFF_TO | DATE | DATS | 8 | 0 | Product Dimension Effective To date | ||
16 | .INCLUDE | 0 | 0 | Fund Association | |||||
17 | FUND_ID | CRM_FM_FND_FUND_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Fund ID | ||
18 | FUND_DESC | CRM_FM_FND_FUND_TYPE_DESC | TEXT40 | CHAR | 40 | 0 | Fund Type Description | ||
19 | FUND_GUID | CRM_FM_FND_FUND_GUID | SYSUUID | RAW | 16 | 0 | GUID of Fund Business Object | ||
20 | .INCLUDE | 0 | 0 | Extension Include - Product Category | |||||
21 | MKTPL_PRCAT | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
22 | .INCLUDE | 0 | 0 | Extension Include - Product Dimension ext. for quick entry | |||||
23 | MKTPL_QE_PRODDIM | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
24 | .INCLUDE | 0 | 0 | Extensibility table for QE Trade Spend Overview | |||||
25 | MKTPL_QE_TSPEND | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMS_MKTPL_IB_TPM_PRDCAT | SALES_UOM | T006 | MSEHI |
History
Last changed by/on | SAP | 20100420 |
SAP Release Created in | 510 |