CRMS_MKTPL_KPI_PRODUCT SAP (KPI: Product assignment) Structure details

Dictionary Type: Structure
Description: KPI: Product assignment




ABAP Code to SELECT data from CRMS_MKTPL_KPI_PRODUCT
Related tables to CRMS_MKTPL_KPI_PRODUCT
Access table CRMS_MKTPL_KPI_PRODUCT




Structure field list including key, data, relationships and ABAP select examples

CRMS_MKTPL_KPI_PRODUCT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "KPI: Product assignment" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CRMS_MKTPL_KPI_PRODUCT TYPE CRMS_MKTPL_KPI_PRODUCT.

The CRMS_MKTPL_KPI_PRODUCT table consists of various fields, each holding specific information or linking keys about KPI: Product assignment data available in SAP. These include CLIENT (Client), GUID (UUID in X form (binary)), PROJECT_GUID (Project Planning: 16-Character GUID for Projects and Activts), TASK_GUID (Project Planning: 16-Character GUID for Projects and Activts).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP CRMS_MKTPL_KPI_PRODUCT structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDUUID in X form (binary) SYSUUID_XRAW16SYSUUID
PROJECT_GUIDProject Planning: 16-Character GUID for Projects and Activts CGPL_GUID16RAW16CGPL_PROJECTCGPLPCGPL_PROJECT_GUID
TASK_GUIDProject Planning: 16-Character GUID for Projects and Activts CGPL_GUID16RAW16CGPL_TASKCGPLPCGPL_PROJECT_GUID
PRODUCT_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16COMM_PRODUCTSYSUUID
CATEGORY_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
CATEGORY2_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
PRODUCT_GROUPProduct Group CRM_MKTPL_PROD_GROUPCHAR3
ADD_PRODUCTFree Product GUID CRM_MKTPL_FREE_PROD_GUIDRAW16SYSUUID
EXCL_INCL_INDFree Product Inclusion Flag CRM_MKTPL_PROD_INCLCHAR1XFELD
SELECT_FLAGProduct De-selection Flag CRM_MKTPL_PROD_SELCHAR1FLAG
SALES_UOMUnits of Measure of Product COMT_UNITUNIT3Assigned to domainCUNITMEINS
ADD_PRODUCT_UOMUnit of Measure for the Free Product CRM_MKTPL_FREE_PROD_UOMUNIT3Assigned to domainCUNITMEINS
SEL_CATEGORY_GCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
SEL_CATEGORY2_GCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
SEL_PRODUCT_GRPProduct Group CRM_MKTPL_PROD_GROUPCHAR3
PRODUCT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
SHORT_TEXTProduct Description COMT_PRSHTEXTXCHAR40PRSHTEXT40
PRODUCT_TYPEProduct Type COMT_PRODUCT_TYPECHAR2Assigned to domainCOM_PRODUCT_TYPECOM_PRODUCT_TYPECOM_PR_TYPE_ACTIVE
PRODUCT_CATCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
PRODUCT_CAT_TEXTCategory Description 1 CRM_MKTPL_PROD_CAT1_TEXTCHAR80TEXT80
LOGSYSOriginal System COMT_LOGSYSCHAR10Assigned to domainALPHALOGSYSCOM_LOGSYSCOM_PRODUCT_LOGSYS
VALID_FROMValid From (Time Stamp) COMT_VALID_FROMDEC15TSTPSBCOS_TSTMP
VALID_TOValid To (Time Stamp) COMT_VALID_TODEC15TSTPSBCOS_TSTMP
XNOSEARCHProduct Is Not Relevant for Search Help COMT_PRODUCT_XNOSEARCHCHAR1COM_BOOLEAN
CATEGORY2_IDCategory ID 2 CRM_MKTPL_PROD_CATEGORY2_IDCHAR20COM_CATEGORY_ID
CATEGORY2_TEXTCategory Description 2 CRM_MKTPL_PROD_CAT2_TEXTCHAR80TEXT80
PRODUCT_GROUP_DESCDescription CRMT_DESCRIPTIONCHAR40TEXT40
ADD_PRODUCT_IDFree Product ID CRM_MKTPL_FREE_PROD_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
ADD_PRODUCT_DESCFree Product Description CRM_MKTPL_FREE_PROD_DESCCHAR40TEXT40
NOT_CHANGEABLEFlag to Indicate Whether Product Assignment May be Modified CRM_MKTPL_PROD_NOT_CHANGEABLECHAR1
PRC_GROUP1Product Group 1 CRMT_PRC_GROUP1CHAR3Assigned to domainCRM_PRC_GROUP1
PRC_GROUP2Product Group 2 CRMT_PRC_GROUP2CHAR3Assigned to domainCRM_PRC_GROUP2
PRC_GROUP3Product Group 3 CRMT_PRC_GROUP3CHAR3Assigned to domainCRM_PRC_GROUP3
PRC_GROUP4Product Group 4 CRMT_PRC_GROUP4CHAR3Assigned to domainCRM_PRC_GROUP4
PRC_GROUP5Product Group 5 CRMT_PRC_GROUP5CHAR3Assigned to domainCRM_PRC_GROUP5
REFERENCE 0
BASE_UOMUnits of Measure of Product COMT_UNITUNIT3Assigned to domainCUNITMEINS
COND_FLAGCheckbox XFELDCHAR1XFELD
FREE_BASE_UOMUnits of Measure of Product COMT_UNITUNIT3Assigned to domainCUNITMEINS
FREE_SALES_UOMUnits of Measure of Product COMT_UNITUNIT3Assigned to domainCUNITMEINS
UOM_FACTORField of type FLTP FLOATFLTP16(16) FLTP
PRODUCT_GUID32UUID in character form SYSUUID_CCHAR32SYSUUID_C
CATEGORY1_GUID32UUID in character form SYSUUID_CCHAR32SYSUUID_C
CATEGORY2_GUID32UUID in character form SYSUUID_CCHAR32SYSUUID_C
CATEGORY3_GUID32UUID in character form SYSUUID_CCHAR32SYSUUID_C
ADD_PRODUCT_GUID32UUID in character form SYSUUID_CCHAR32SYSUUID_C
ADD_QUANTITYCRM KPI Planning - Key Figure Value CRM_KPI_Y_VALUEDEC20(4) CRM_KPI_VALUE
LISTED_PRICECRM KPI Planning - Key Figure Value CRM_KPI_Y_VALUEDEC20(4) CRM_KPI_VALUE
FREE_GOODS_PRICECRM KPI Planning - Key Figure Value CRM_KPI_Y_VALUEDEC20(4) CRM_KPI_VALUE
FREE_UOM_FACTORField of type FLTP FLOATFLTP16(16) FLTP
START_DATEField of type DATS DATSDATS8DATS
END_DATEField of type DATS DATSDATS8DATS

Key field Non-key field



How do I retrieve data from SAP structure CRMS_MKTPL_KPI_PRODUCT using ABAP code?

As CRMS_MKTPL_KPI_PRODUCT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMS_MKTPL_KPI_PRODUCT as there is no data to select.

How to access SAP table CRMS_MKTPL_KPI_PRODUCT

Within an ECC or HANA version of SAP you can also view further information about CRMS_MKTPL_KPI_PRODUCT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!