SAP Table CRMD_MKTPL_DRES stores Value Distribution for Hierarchy Nodesdata

  

In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_dres 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_DRES 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_DRES....Right lets get started!


SAP CRMD_MKTPL_DRES dictionary attributes

Object Name: CRMD_MKTPL_DRES
Dictionary Type: Transparent table
Description: Value Distribution for Hierarchy Nodes


CRMD_MKTPL_DRES field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
DRESLINEGUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUIDCRM
DISTLINEGUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUIDCRM
PROJECT_GUIDCGPL_PROJECT_GUIDRAW16(0) Project Planning: 16 Character GUID for ProjectsCGPL_PROJECT_GUIDCRM
TASK_GUIDCGPL_TASK_GUIDRAW16(0) Project Planning: 16 Character GUID for TasksCGPL_PROJECT_GUIDCRM
LINECRMT_MKTVL_LINNOINT410(0) Line NumberCRM
RESULT_LINECRMT_MKTVL_LINNOINT410(0) Line NumberCRM
OBJECT_TYPECGPL_OBJECT_TYPECHAR3(0) Object Type in Project PlanningCHAR3CRM
DISTRIBTYPECRMT_MKTVL_DISTRCHAR4(0) Distribution CategoryCRM
COCRMT_COUNTRYCHAR3(0) T005CountryLAND1CRM
SOCRMT_SALES_ORGCHAR14(0) Sales OrganizationHROBJEC_14CRM_ORGMAN_SALES_ORGSALES_ORGCRM
MOCRM_MKTPL_MORGCHAR14(0) Marketing OrganizationHROBJEC_14CRM_MKTPL_MORGMKT_ORGCRM
DCCRMT_DISTRIBUTION_CHANNELCHAR2(0) CRMC_DISTCHANDistribution ChannelCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNELDIS_CHANNELCRM
DVCRMT_DIVISIONCHAR2(0) CRMC_DIVISIONDivisionCRM_DIVISIONCRM_DIVISIONDIVISIONCRM
PGCRMT_PRC_GROUP1CHAR3(0) CRMC_PRC_GRP1Product Group 1CRM_PRC_GROUP1CRM
CG1CRMT_CUST_GROUP1CHAR3(0) CRMC_CUSTGRP1Customer Group 1CRM_CUST_GROUP1CRM
CG4CRMT_CUST_GROUP4CHAR3(0) *Customer Group 4CRM_CUST_GROUP4CRM
PRH1COMT_CATEGORY_IDCHAR20(0) Category IDCOM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIERCATEGORY_IDCRM
PRH2COMT_CATEGORY_IDCHAR20(0) Category IDCOM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIERCATEGORY_IDCRM
PRH3COMT_CATEGORY_IDCHAR20(0) Category IDCOM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIERCATEGORY_IDCRM
BPH1BU_NODE_SEARCH_TERMCHAR20(0) Hierarchy Node IDBUHI_NODE_SEARCH_TERM2SEARCH_TERMCRM
BPH2BU_NODE_SEARCH_TERMCHAR20(0) Hierarchy Node IDBUHI_NODE_SEARCH_TERM2SEARCH_TERMCRM
BPH3BU_NODE_SEARCH_TERMCHAR20(0) Hierarchy Node IDBUHI_NODE_SEARCH_TERM2SEARCH_TERMCRM
PRODCOMT_PRODUCT_IDCHAR40(0) Product IDCOM_PRODUCT_IDCOM_PR_COLLECTIONPRODUCT_IDCRM
BPBU_PARTNERCHAR10(0) *Business Partner NumberBU_PARTNERBPABUPAPARTNERCRM
PRODUCT_GUIDCOMT_PRODUCT_GUIDRAW16(0) Internal Unique ID of ProductSYSUUIDCRM
PARTNER_GUIDBU_PARTNER_GUIDRAW16(0) Business Partner GUIDSYSUUIDCRM
CATEGORY1_GUIDCOMT_CATEGORY_GUIDRAW16(0) Category GUIDSYSUUIDCRM
CATEGORY2_GUIDCOMT_CATEGORY_GUIDRAW16(0) Category GUIDSYSUUIDCRM
CATEGORY3_GUIDCOMT_CATEGORY_GUIDRAW16(0) Category GUIDSYSUUIDCRM
NODE1_GUIDBU_NODE_GUIDRAW16(0) GUID of Hierarchy NodeSYSUUIDCRM
NODE2_GUIDBU_NODE_GUIDRAW16(0) GUID of Hierarchy NodeSYSUUIDCRM
NODE3_GUIDBU_NODE_GUIDRAW16(0) GUID of Hierarchy NodeSYSUUIDCRM


View list of all tables