EHPRCD_CMP_ROOT SAP (Campaign Root) Table details

Dictionary Type: Table
Description: Campaign Root




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




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

EHPRCD_CMP_ROOT is a standard SAP Table which is used to store Campaign Root data and is available within R/3 SAP systems depending on the version and release level.

The EHPRCD_CMP_ROOT table consists of various fields, each holding specific information or linking keys about Campaign Root data available in SAP. These include DB_KEY (NodeID), DATETIME_CR (Date/Time of Item Creation), USER_ID_CR (Object Created By), DATETIME_CH (Date/Time of Item Change).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EHPRCD_CMP_ROOT table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
DB_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

Key field Non-key field



How do I retrieve data from SAP table EHPRCD_CMP_ROOT using ABAP code

The following ABAP code Example will allow you to do a basic selection on EHPRCD_CMP_ROOT to SELECT all data from the table
DATA: WA_EHPRCD_CMP_ROOT TYPE EHPRCD_CMP_ROOT.

SELECT SINGLE *
FROM EHPRCD_CMP_ROOT
INTO CORRESPONDING FIELDS OF WA_EHPRCD_CMP_ROOT
WHERE...

How to access SAP table EHPRCD_CMP_ROOT

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