EHPRCS_CMP_ROOT SAP (Campaign Root) Structure details

Dictionary Type: Structure
Description: Campaign Root




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




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

EHPRCS_CMP_ROOT 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 "Campaign Root" 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_EHPRCS_CMP_ROOT TYPE EHPRCS_CMP_ROOT.

The EHPRCS_CMP_ROOT table consists of various fields, each holding specific information or linking keys about Campaign Root data available in SAP. These include KEY (NodeID), PARENT_KEY (NodeID), ROOT_KEY (NodeID), DATETIME_CR (Date/Time of Item Creation).. 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 EHPRCS_CMP_ROOT 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
KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
PARENT_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
ROOT_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
DATETIME_CRDate/Time of Item Creation /BOBF/DATETIME_CRDEC15TSTLC/BOBF/TIMESTAMP
USER_ID_CRObject Created By /BOBF/USER_ID_CRCHAR12UNAMEUSER_COMP
DATETIME_CHDate/Time of Item Change /BOBF/DATETIME_CHDEC15TSTLC/BOBF/TIMESTAMP
USER_ID_CHObject Changed By /BOBF/USER_ID_CHCHAR12UNAME
IDCampaign Name EHPRC_CMP_IDCHAR40EHPRC_CMP_ID
ID_NORMCampaign Name EHPRC_CMP_IDCHAR40EHPRC_CMP_ID
RESPONSIBLE_USERPerson Responsible for Campaign EHPRC_CMP_RESP_USERCHAR12USNAMUSER_COMP
TYPECampaign Type EHPRC_CMP_TYPE_CODECHAR10EHPRC_CMP_TYPE_CODE
STATUSStatus of Campaign EHPRC_CMP_STATUS_CODECHAR10EHPRC_CMP_STATUS_CODE
BP_SCENARIOBusiness Partner Type EHPRC_CMP_BP_SCENARIO_CODECHAR1EHPRC_CMP_BP_SCENARIO_CODE
EMAIL_NOE-Mail Text EHPRC_CMP_EMAIL_CODECHAR3Assigned to domainALPHAEHPRC_EMLNOEHPRC_ELM_EMLNO
EMAIL_ATTTemplate for E-Mail Attachment EHPRC_CMP_TEMPL_CODECHAR10Assigned to domainEHPRC_TEMPLIDEHPRC_ELM_UEC_TPL
EMAIL_DOCDocument as E-Mail Attachment EHPRC_CMP_DOC_CODECHAR10Assigned to domainEHPRC_UEC_DOCIDEHPRC_ELM_UEC_DOC
CREATION_DATECampaign Creation Date EHPRC_CMP_CREATION_DATEDATS8DATUM
REVIEW_DATECampaign Review Date EHPRC_CMP_REVIEW_DATEDATS8DATUM
COMPL_DATECampaign Completion Date EHPRC_CMP_COMPLETION_DATEDATS8DATUM
COMPL_PLAN_DATEPlanned Completion Date for Campaign EHPRC_CMP_COMPLETION_PLAN_DATEDATS8DATUM
CAMP_DESCCampaign Description EHPRC_CMP_DESCCHAR255EHFND_DESCRIPTION_XL
CAMP_NORM_DESCCampaign Description EHPRC_CMP_DESCCHAR255EHFND_DESCRIPTION_XL
REMARKRemark EHPRC_CMP_REMARKCHAR255EHPRC_CMP_REMARK
COMM_TYPECommunication Type EHPRC_CMP_COMM_TYPECHAR2EHPRC_CMP_COMM_TYPE
COLL_TYPECollaboration Type EHPRC_CMP_COLL_TYPECHAR2EHPRC_CMP_COLL_TYPE
SCC_BUPA_TYPEBusiness Partner Type EHPRC_CMP_BUPA_TYPECHAR2EHPRC_CMP_BUPA_TYPE
IS_SCC_INDCampaign is for SCC Use EHPRC_CMP_IS_SCC_INDCHAR1BOOLEAN
SEL_INVAL_INDData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
EEW_CMP_ROOT_DDummy function in length 1 DUMMYCHAR1DUMMY
RESPONSIBLE_NAMEUser Name of Person Responsible for Campaign EHPRC_CMP_RESP_NAMECHAR80TEXT80
COMM_STATUS_VALUNumber of Positions with Communication Status EHPRC_CMP_COMM_STATUS_VALUNUMC4NUMC4
TYPE_DESCCampaign Type Description EHPRC_CMP_TYPE_DESCCHAR60EHFND_DESCRIPTION_S
STATUS_DESCCampaign Status Description EHPRC_CMP_STATUS_DESCCHAR60EHFND_DESCRIPTION_S
BP_SCENARIO_DESCDescription of Business Partner Type EHPRC_CMP_BP_SCENARIO_DESCCHAR60EHFND_DESCRIPTION_S
SCC_BUPA_TYPE_DESCDescription of Business Partner Type EHPRC_CMP_BP_SCENARIO_DESCCHAR60EHFND_DESCRIPTION_S
EMAIL_NO_DESCE-Mail Text Description EHPRC_CMP_EMAIL_DESCCHAR60EHFND_DESCRIPTION_S
EMAIL_ATT_DESCDescription of Template for E-Mail Attachment EHPRC_CMP_TEMPL_DESCCHAR60EHFND_DESCRIPTION_S
EMAIL_DOC_DESCDescription of Document as E-Mail Attachment EHPRC_CMP_DOC_DESCCHAR60EHFND_DESCRIPTION_S
REC_ADDRGRPAddress Group (Key) (Business Address Services) AD_GROUPCHAR4Assigned to domainAD_GROUP
REC_SEARCHTERMGeneric Search Term for Addresses EHPRC_CMP_SRCH_TERMSTRG0STRING
REC_MAX_RESULTMaximum Number of Selected Addresses EHPRC_CMP_MAX_ADDRNUMC3NUMC3
COLL_TYPE_DESCCollaboration Type EHPRC_CMP_COLL_TYPE_DESCCHAR60EHFND_DESCRIPTION_S
INCL_PRODSTRUCTUse subordinate levels in product structure EHPRC_CMP_EXPLODE_STRUC_INDCHAR1EHFND_INDICATOR
EEW_CMP_ROOT_DTDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



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

As EHPRCS_CMP_ROOT 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 EHPRCS_CMP_ROOT as there is no data to select.

How to access SAP table EHPRCS_CMP_ROOT

Within an ECC or HANA version of SAP you can also view further information about EHPRCS_CMP_ROOT 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!