EHPRCD_ICMDS SAP (Customer MDS) Table details

Dictionary Type: Table
Description: Customer MDS




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




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

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

The EHPRCD_ICMDS table consists of various fields, each holding specific information or linking keys about Customer MDS data available in SAP. These include MANDT (Client), GUID (Globally Unique Identifier), CRDAT (Creation Date), CRNAM (Creation User).. 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: Cannot Be Enhanced


SAP EHPRCD_ICMDS 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
GUIDGlobally Unique Identifier GUIDRAW16
CRDATCreation Date EHPRC_CRDATDATS8DATUM
CRNAMCreation User EHPRC_CRNAMCHAR12USNAM
CRTSTMPCreation Time Stamp EHPRC_CRTSTMPDEC15TZNTSTMPS
UPDDATUpdate Date EHPRC_UPDDATDATS8DATUM
UPDNAMUpdate User EHPRC_UPDNAMCHAR12USNAM
UPDTSTMPUpdate Time Stamp EHPRC_UPDTSTMPDEC15TZNTSTMPS
DELFLGDeletion Indicator ESEDELFLGCHAR1ESDFLAG
CDO_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
SPEC_IDAssignment of a Specification to a Customer MDS EHPRC_CUS_SPEC_IDCHAR12SPEC1ESDSUBIDES0
MODULE_IDIMDS Module ID EHPRC_IMDSIDCHAR18
MODULE_VERSIONModule Version EHPRC_MODULE_VERSDEC6(3) DEC
NODE_IDIMDS Node ID EHPRC_IMDSNODECHAR18
MDS_TYPEMDS Type EHPRC_MDS_TYPECHAR1EHPRC_REQ_MDS_TYPE
PART_NOPart/Item/Material Number EHPRC_PARTNOCHAR50TEXT50
PART_NO_NORMPart/Item/Material Number EHPRC_PARTNOCHAR50TEXT50
PART_NAMEArticle Name EHPRC_PARTNAMECHAR250TEXT_250
PART_NAME_NORMArticle Name EHPRC_PARTNAMECHAR250TEXT_250
MDS_STATUSMDS Status EHPRC_MDS_STATUSCHAR1EHPRC_MDS_STATUS
PREC_MDS_STATUSMDS Status EHPRC_MDS_STATUSCHAR1EHPRC_MDS_STATUS
SEND_DATETransmission Date EHPRC_SEND_DATEDATS8DATE
SEND_TIMETransmission Time EHPRC_SEND_TIMETIMS6TIME
DEVSAMPLEREPDevelopment Sample Report EHPRC_DEVSAMPLEREPCHAR1YESNO
SF_DOCTYPEDocument Type DOKARCHAR3Assigned to domainDOKARCV2
SF_DOCNUMBERDocument number DOKNRCHAR25Assigned to domainALPHADOKNRCV1
SF_DOCPARTDocument Part DOKTL_DCHAR3DOKTLCV4
SF_DOCVERSIONDocument Version DOKVRCHAR2DOKVRCV3
SF_ARCHSTATUSArchiving Status EHPRC_ARCHIVING_STATUSCHAR2EHPRC_ARCHIVING_STATUS
RF_DOCTYPEDocument Type DOKARCHAR3Assigned to domainDOKARCV2
RF_DOCNUMBERDocument number DOKNRCHAR25Assigned to domainALPHADOKNRCV1
RF_DOCPARTDocument Part DOKTL_DCHAR3DOKTLCV4
RF_DOCVERSIONDocument Version DOKVRCHAR2DOKVRCV3
RF_ARCHSTATUSArchiving Status EHPRC_ARCHIVING_STATUSCHAR2EHPRC_ARCHIVING_STATUS
OWN_ORGIDOwn Organizational Unit ID EHPRC_ORGIDOWNCHAR9Assigned to domainEHPRC_ORGIDEHPRC_CP02EHPRC_ELM_ORGIDS
OWN_CONTPERSOwn Contact Person ID EHPRC_OWN_CONT_IDCHAR9Assigned to domainEHPRC_PERSIDEHPRC_CP01EHPRC_ELM_OWN_CONTPERS
COMM_STATUSCommunication Status EHPRC_COMM_STATUSCHAR1EHPRC_COMM_STATUS
IMPORT_STATUSFile Status EHPRC_FILE_STATUSCHAR1EHPRC_FILE_STATUS
APPL_LOGApplication Log EHPRC_APPLOGCHAR22SYSUUID_22
OUTG_TEMPLOutgoing Template EHPRC_TEMPL_IDCHAR10Assigned to domainEHPRC_TEMPLIDEHPRC_SHLP_TEMPLID
CREATE_DATECreation Date EHPRC_CREATE_DATEDATS8DATE
CHECK_DATECheck Date EHPRC_CHECK_DATEDATS8DATE
CHANGE_DATEChange Date EHPRC_CHG_DATEDATS8DATE
RELEASE_DATERelease Date EHPRC_RELEASE_DATEDATS8DATE
DATASH_TYPEData Sheet Type EHPRC_DATASHEET_TYPECHAR1EHPRC_DATASHEET_TYPE
APPL_LOG_DELETEDelete Application Log EHPRC_DEL_APP_LOGCHAR1BOOLE

Key field Non-key field



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

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

SELECT SINGLE *
FROM EHPRCD_ICMDS
INTO CORRESPONDING FIELDS OF WA_EHPRCD_ICMDS
WHERE...

How to access SAP table EHPRCD_ICMDS

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