SAP ABAP Table CRMS_MKTPL_PROD (Table type for Product Assignments)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL_APPL_BASE_DB (Package) CRM Marketing Planning - APIs with direct Database Access
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL_APPL_BASE_DB (Package) CRM Marketing Planning - APIs with direct Database Access
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_MKTPL_PROD | Table Relationship Diagram |
Short Description | Table type for Product Assignments |
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 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | GUID | SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | ||
3 | PROJECT_GUID | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts | ||
4 | TASK_GUID | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts | ||
5 | PRODUCT_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
6 | .INCLUDE | 0 | 0 | CRM Marketing Planning: Include Structure Appl. Product | |||||
7 | CATEGORY_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
8 | CATEGORY2_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
9 | PRODUCT_GROUP | CRM_MKTPL_PROD_GROUP | CHAR | 3 | 0 | Product Group | |||
10 | ADD_PRODUCT | CRM_MKTPL_FREE_PROD_GUID | SYSUUID | RAW | 16 | 0 | Free Product GUID | ||
11 | EXCL_INCL_IND | CRM_MKTPL_PROD_INCL | XFELD | CHAR | 1 | 0 | Free Product Inclusion Checkbox | ||
12 | SELECT_FLAG | CRM_MKTPL_PROD_SEL | FLAG | CHAR | 1 | 0 | Product Exclusion Checkbox | ||
13 | QUANTITY | CRM_MKTPL_PROD_QUANTITY | MENG13 | QUAN | 13 | 3 | Product Quantity | ||
14 | SALES_UOM | COMT_UNIT | MEINS | UNIT | 3 | 0 | Units of Measure of Product | * | |
15 | ADD_PRODUCT_UOM | CRM_MKTPL_FREE_PROD_UOM | MEINS | UNIT | 3 | 0 | Unit of Measure for the Free Product | * | |
16 | SEL_CATEGORY_G | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
17 | SEL_CATEGORY2_G | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
18 | SEL_PRODUCT_GRP | CRM_MKTPL_PROD_GROUP | CHAR | 3 | 0 | Product Group | |||
19 | PROMO_PCAT_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
20 | PROMO_PGRP_ID | CRM_MKTPL_PROD_GROUP | CHAR | 3 | 0 | Product Group | |||
21 | .INCLUDE | 0 | 0 | Quick Entry fields persisted in product dimensions DB tables | |||||
22 | LIST_PRICE | CRM_MKTPL_LIST_PRICE | CRM_MKTPL_LIST_PRICE | DEC | 20 | 2 | List Price | ||
23 | RETAIL_PRICE | CRM_MKTPL_RETAIL_PRICE | CRM_MKTPL_RETAIL_PRICE | DEC | 20 | 2 | Retail Price | ||
24 | PROD_DIM_VOLUME | CRM_MKTPL_PROD_DIM_VOLUME | CRM_MKTPL_PROD_DIM_VOLUME | DEC | 22 | 0 | Volume field | ||
25 | EFFECTIVE_FROM | CRM_MKTPL_START_DATE_RANGES | BCOS_TSTMP | DEC | 15 | 0 | Additional Start Date Range | ||
26 | EFFECTIVE_TO | CRM_MKTPL_END_DATE_RANGES | BCOS_TSTMP | DEC | 15 | 0 | Additional End Date Range | ||
27 | PRODUCT_PRICE | CRM_MKTPL_PROD_PRICE | CRM_MKTPL_PROD_PRICE | DEC | 15 | 2 | Suggested Retail Price | ||
28 | PARTNER_PRICE | CRM_MKTPL_PARTNER_PRICE | CRM_MKTPL_PARTNER_PRICE | DEC | 15 | 2 | Partner Retail Price | ||
29 | .INCLUDE | 0 | 0 | Extension Include - Product | |||||
30 | MKTPL_PRD | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
31 | .INCLUDE | 0 | 0 | Extension Include - Product Dimension ext. for quick entry | |||||
32 | MKTPL_QE_PRODDIM | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
33 | .INCLUDE | 0 | 0 | CRM: Account Plan Extension Include - Product | |||||
34 | ACCPL_PRD | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
35 | .INCLUDE | 0 | 0 | Extensibility table for QE Trade Spend Overview | |||||
36 | MKTPL_QE_TSPEND | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
37 | NOREC_FLAG | CRMT_NOREC | CRM_BOOLEAN | CHAR | 1 | 0 | Entry does not Exist in Database |
History
Last changed by/on | SAP | 20131122 |
SAP Release Created in | 500 |