In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_prod table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_MKTPL_PROD what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_MKTPL_PROD....Right lets get started!
Object Name: CRMD_MKTPL_PROD
Dictionary Type: Transparent table
Description: Assignment of Product in Marketing Planning
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | SYSUUID_X | RAW | 16(0) | UUID in X form (binary) | SYSUUID | CRM | ||||||
| PROJECT_GUID | CGPL_GUID16 | RAW | 16(0) | CGPL_PROJECT | Project Planning: 16-Character GUID for Projects and Activts | CGPL_PROJECT_GUID | CRM | |||||
| TASK_GUID | CGPL_GUID16 | RAW | 16(0) | CGPL_TASK | Project Planning: 16-Character GUID for Projects and Activts | CGPL_PROJECT_GUID | CRM | |||||
| PRODUCT_GUID | COMT_PRODUCT_GUID | RAW | 16(0) | COMM_PRODUCT | Internal Unique ID of Product | SYSUUID | CRM | |||||
| CATEGORY_GUID | COMT_CATEGORY_GUID | RAW | 16(0) | Category GUID | SYSUUID | CRM | ||||||
| CATEGORY2_GUID | COMT_CATEGORY_GUID | RAW | 16(0) | Category GUID | SYSUUID | CRM | ||||||
| PRODUCT_GROUP | CRM_MKTPL_PROD_GROUP | CHAR | 3(0) | Product Group | CRM | |||||||
| ADD_PRODUCT | CRM_MKTPL_FREE_PROD_GUID | RAW | 16(0) | Free Product GUID | SYSUUID | CRM | ||||||
| EXCL_INCL_IND | CRM_MKTPL_PROD_INCL | CHAR | 1(0) | Free Product Inclusion Flag | XFELD | CRM | ||||||
| SELECT_FLAG | CRM_MKTPL_PROD_SEL | CHAR | 1(0) | Product De-selection Flag | FLAG | CRM | ||||||
| SALES_UOM | COMT_UNIT | UNIT | 3(0) | * | Units of Measure of Product | MEINS | CRM | |||||
| ADD_PRODUCT_UOM | CRM_MKTPL_FREE_PROD_UOM | UNIT | 3(0) | * | Unit of Measure for the Free Product | MEINS | CRM | |||||
| SEL_CATEGORY_G | COMT_CATEGORY_GUID | RAW | 16(0) | Category GUID | SYSUUID | CRM | ||||||
| SEL_CATEGORY2_G | COMT_CATEGORY_GUID | RAW | 16(0) | Category GUID | SYSUUID | CRM | ||||||
| SEL_PRODUCT_GRP | CRM_MKTPL_PROD_GROUP | CHAR | 3(0) | Product Group | CRM |