EHPRCD_COD_DEC SAP (Declarable Substance Information) Table details

Dictionary Type: Table
Description: Declarable Substance Information




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




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

EHPRCD_COD_DEC is a standard SAP Table which is used to store Declarable Substance Information data and is available within R/3 SAP systems depending on the version and release level.

The EHPRCD_COD_DEC table consists of various fields, each holding specific information or linking keys about Declarable Substance Information data available in SAP. These include DB_KEY (NodeID), ROOT_KEY (NodeID), PARENT_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: 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_COD_DEC 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
ROOT_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
PARENT_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
CONTAIN_CODEContained Substance EHPRC_DECSCONTCHAR3EHPRC_DECSCONT
VALUEMean Value for Declarable Substance (Homog. Mat) EHPRC_DECSVAVGQUAN15(7) EHPRC_DECSV
VUNITUnit of Proportion EHPRC_PROP_UNITUNIT3Assigned to domainCUNITMEINS
ORIGINSource of Declarable Substance EHPRC_DECSORIGINCHAR1EHPRC_DECSORIGIN
EXEMPTION_IDExemption for Declarable Substance EHPRC_DECSUB_EXEMPTIONCHAR30TEXT30
CLASSClassification for Compliance EHPRC_CLASSIFICATIONCHAR1Assigned to domainEHPRC_CLASSIFICATION
CHECKOBJ_KEY_REFCompliance Data Object Root Key EHPRC_CDO_ROOT_KEYRAW16/BOBF/CONF_KEY
CHECKOBJ_NAMECheck Object Name EHPRC_COD_CHECKOBJ_NAMECHAR132EHFND_DESCRIPTION_L
LISU_REF_KEYListed Substance Refernce Root Key EHFND_LISU_ROOT_REF_KEYRAW16/BOBF/CONF_KEY
EEW_COD_DECSUB_DDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
QUESTION_1 0
QUESTION_1_COM 0
QUESTION_2 0
QUESTION_2_COM 0
QUESTION_3 0
QUESTION_3_COM 0
QUESTION_4 0
QUESTION_4_COM 0
QUESTION_5 0
QUESTION_5_COM 0
QUESTION_6 0
QUESTION_6_COM 0

Key field Non-key field



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

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

SELECT SINGLE *
FROM EHPRCD_COD_DEC
INTO CORRESPONDING FIELDS OF WA_EHPRCD_COD_DEC
WHERE...

How to access SAP table EHPRCD_COD_DEC

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