In this post, I will try and describe everything you need to know about the SAP crmd_acc_pl_pcat_d 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_ACC_PL_PCAT_D 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_ACC_PL_PCAT_D....Right lets get started!
Object Name: CRMD_ACC_PL_PCAT_D
Dictionary Type: Structure
Description: Assignment of product category and attributes
| 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) | Project Planning: 16-Character GUID for Projects and Activts | CGPL_PROJECT_GUID | CRM | ||||||
| CATEGORY_GUID | COMT_CATEGORY_GUID | RAW | 16(0) | Category GUID | SYSUUID | CRM | ||||||
| PPR_HEADER_GUID | CRMT_PRP_GUID | RAW | 16(0) | Internal, Unique Identifier for PPR Objects | SYSUUID | PRP_GUID | CRM | |||||
| BASE_UOM | COMT_UNIT | UNIT | 3(0) | * | Units of Measure of Product | MEINS | CRM | |||||
| SALES_UOM | COMT_UNIT | UNIT | 3(0) | * | Units of Measure of Product | MEINS | CRM | |||||
| SELECT_FLAG | CRM_ACC_PL_PROD_SEL | CHAR | 1(0) | Product Selection | XFELD | CRM | ||||||
| CATEGORY_ID | COMT_CATEGORY_ID | CHAR | 20(0) | Category ID | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | CATEGORY_ID | CRM | |||
| CATEGORY_TEXT | COMT_CATEGORY_TEXT | CHAR | 80(0) | Category Description | TEXT80 | CRM | ||||||
| LOGSYS | COMT_LOGSYS | CHAR | 10(0) | * | Original System | LOGSYS | COM_LOGSYS | COM_PRODUCT_LOGSYS | LOGSYS | CRM | ||
| XNOSEARCH | COMT_PRODUCT_XNOSEARCH | CHAR | 1(0) | Product Is Not Relevant for Search Help | COM_BOOLEAN | CRM | ||||||
| NOT_CHANGEABLE | CRM_ACC_PL_PCAT_NOT_CHANGEABLE | CHAR | 1(0) | Product Category Can Be Modified | FLAG | CRM | ||||||
| SHORT_TEXT | COMT_CATEGORY_TEXT | CHAR | 80(0) | Category Description | TEXT80 | CRM |