SAP Table CRMD_MKTPL_PROD_D stores Assignment of Product Marketing Planning + Attributesdata

  

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


SAP CRMD_MKTPL_PROD_D dictionary attributes

Object Name: CRMD_MKTPL_PROD_D
Dictionary Type: Structure
Description: Assignment of Product Marketing Planning + Attributes


CRMD_MKTPL_PROD_D 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
GUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUIDCRM
PROJECT_GUIDCGPL_GUID16RAW16(0) CGPL_PROJECTProject Planning: 16-Character GUID for Projects and ActivtsCGPL_PROJECT_GUIDCRM
TASK_GUIDCGPL_GUID16RAW16(0) CGPL_TASKProject Planning: 16-Character GUID for Projects and ActivtsCGPL_PROJECT_GUIDCRM
PRODUCT_GUIDCOMT_PRODUCT_GUIDRAW16(0) COMM_PRODUCTInternal Unique ID of ProductSYSUUIDCRM
CATEGORY_GUIDCOMT_CATEGORY_GUIDRAW16(0) Category GUIDSYSUUIDCRM
CATEGORY2_GUIDCOMT_CATEGORY_GUIDRAW16(0) Category GUIDSYSUUIDCRM
PRODUCT_GROUPCRM_MKTPL_PROD_GROUPCHAR3(0) Product GroupCRM
ADD_PRODUCTCRM_MKTPL_FREE_PROD_GUIDRAW16(0) Free Product GUIDSYSUUIDCRM
EXCL_INCL_INDCRM_MKTPL_PROD_INCLCHAR1(0) Free Product Inclusion FlagXFELDCRM
SELECT_FLAGCRM_MKTPL_PROD_SELCHAR1(0) Product De-selection FlagFLAGCRM
SALES_UOMCOMT_UNITUNIT3(0) *Units of Measure of ProductMEINSCRM
ADD_PRODUCT_UOMCRM_MKTPL_FREE_PROD_UOMUNIT3(0) *Unit of Measure for the Free ProductMEINSCRM
SEL_CATEGORY_GCOMT_CATEGORY_GUIDRAW16(0) Category GUIDSYSUUIDCRM
SEL_CATEGORY2_GCOMT_CATEGORY_GUIDRAW16(0) Category GUIDSYSUUIDCRM
SEL_PRODUCT_GRPCRM_MKTPL_PROD_GROUPCHAR3(0) Product GroupCRM
PRODUCT_IDCOMT_PRODUCT_IDCHAR40(0) Product IDCOM_PRODUCT_IDCOM_PR_COLLECTIONPRODUCT_IDCRM
SHORT_TEXTCOMT_PRSHTEXTXCHAR40(0) Product DescriptionPRSHTEXT40CRM
PRODUCT_TYPECOMT_PRODUCT_TYPECHAR2(0) *Product TypeCOM_PRODUCT_TYPECOM_PRODUCT_TYPECOM_PR_TYPE_ACTIVEPRODUCT_TYPECRM
PRODUCT_CATCOMT_CATEGORY_IDCHAR20(0) Category IDCOM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIERCATEGORY_IDCRM
PRODUCT_CAT_TEXTCRM_MKTPL_PROD_CAT1_TEXTCHAR80(0) Category Description 1TEXT80CRM
LOGSYSCOMT_LOGSYSCHAR10(0) *Original SystemLOGSYSCOM_LOGSYSCOM_PRODUCT_LOGSYSLOGSYSCRM
VALID_FROMCOMT_VALID_FROMDEC15(0) Valid From (Time Stamp)BCOS_TSTMPCRM
VALID_TOCOMT_VALID_TODEC15(0) Valid To (Time Stamp)BCOS_TSTMPCRM
XNOSEARCHCOMT_PRODUCT_XNOSEARCHCHAR1(0) Product Is Not Relevant for Search HelpCOM_BOOLEANCRM
CATEGORY2_IDCRM_MKTPL_PROD_CATEGORY2_IDCHAR20(0) Category ID 2COM_CATEGORY_IDCRM
CATEGORY2_TEXTCRM_MKTPL_PROD_CAT2_TEXTCHAR80(0) Category Description 2TEXT80CRM
PRODUCT_GROUP_DESCCRMT_DESCRIPTIONCHAR40(0) DescriptionTEXT40CRM
ADD_PRODUCT_IDCRM_MKTPL_FREE_PROD_IDCHAR40(0) Free Product IDCOM_PRODUCT_IDCOM_PR_COLLECTIONPRODUCT_IDCRM
ADD_PRODUCT_DESCCRM_MKTPL_FREE_PROD_DESCCHAR40(0) Free Product DescriptionTEXT40CRM
NOT_CHANGEABLECRM_MKTPL_PROD_NOT_CHANGEABLECHAR1(0) Flag to Indicate Whether Product Assignment May be ModifiedCRM


View list of all tables