ESTRH is a standard Product Safety Transparent Table in SAP Environment, Health and Safety application, which stores EHS: Specification Header data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for ESTRH. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

ESTRH — Meta Data

Description: EHS: Specification Header
Main Category: Environment, Health and Safety
Sub Category: Product Safety
Table type: Transparent Table (TRANSP)

ESTRH — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 .INCLUDE X 0
    2 MANDT Client X CLNT 3 T000
    3 RECN Unique ID Number X NUMC 20
    4 ACTN General Flag X NUMC 20
    5 .INCLUDE 0
    6 VALFR Valid From (Time Stamp) DATS 8
    7 VALTO Valid To (Time Stamp) DATS 8
    8 AENNR Change Number CHAR 12 AENR
    9 DELFLG Deletion Indicator CHAR 1
    10 PARKFLG Data Record Is Inactive CHAR 1
    11 CRDAT Date of creation DATS 8
    12 CRNAM User who created the object CHAR 12
    13 UPDDAT Date on which control record was last changed DATS 8
    14 UPDNAM Last Changed By CHAR 12
    15 SRSID Source of Data CHAR 10 TCG56
    16 OWNID 4 Blank Characters + BACS User Number CHAR 10 *
    17 RECNROOT Data Record ID (GUID) NUMC 20 *
    18 UPDDATS Date of Last Change to Specification As a Whole DATS 8
    19 UPDNAMS Name of Person Who Last Changed Specification CHAR 12
    20 SUBID Subkey of the Request CHAR 12
    21 SUBCAT Substance Category CHAR 10 TCG31
    22 AUTHGRP Authorization Group for Closing Cockpit CHAR 10 TCG36
    23 REM Alerts: Indicator ('X' or SPACE ) CHAR 60
    24 SUBCHAR Character Field Length = 10 CHAR 10 TCG34

SAP Help, Wiki Resources, and Forum Discussions on ESTRH


Related Tables

TABLE Description Functional Area
ESTVA EHS: Value Assignment Environment, Health and Safety - Product Safety
ESTRI EHS: Identifier (Numbers, Names, Chemical Formulas) Environment, Health and Safety - Product Safety
ESTMJ EHS: Specification-Material Assignment Environment, Health and Safety - Product Safety
MARA General Material Data Logistics - Material Master
AENR Change Master Cross Application - Engineering Change Management
ESTDU EHS: Additional Information: Value Assignment Usage Environment, Health and Safety - Product Safety
ESTLP EHS: Report Variant Environment, Health and Safety - Product Safety

Transaction Codes for SAP Table ESTRH

TCODE Description Functional Area
CG02 Substance Workbench EHS - Product Safety
CG33 Import Specifications EHS - Product Safety
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
RECN Process Contract RE - Real Estate Contract
WE19 Test tool Basis - ALE Integration Technology
DC10 Define document types CA - Dokumentenverwaltung
SM37 Overview of job selection Basis - Background Processing
MSDS LTP Evaluation Report Coverages PP - Master Data

ABAP Reports for SAP Table ESTRH

ABAP REPORT Description Functional Area
RC1PHDEL EHS: Set Missing Deletion Indicators and Physically Delete Data Environment, Health and Safety - Product Safety
SBAL_DELETE Application Log: Delete Expired Logs Basis - Basis Application Log
REHS_AUDIT_TRAIL_REORG EHS: Reorganization and Printout of Audit Trail Data Environment, Health and Safety - Product Safety
RSSCD110 Display change documents (cross-client) Basis - Change Documents
RMCF2600 Material usage analysis: repetitive manufacturing PP - Information System
BDLIBUS Tool to maintain IBU entries Service - Service Data Download
SAPMH5A0 Module Pool for PD Transactions Basis - Organizational Management
CONDDATA Include CONDDATA Logistics Execution - Freight Processing

Authorization Objects for SAP Table ESTRH

AUTHORIZATION OBJECT Description Functional Area
CRM_CATT Authorization for CRM eCATT Based Unit Testing
CMS_CAG Authorization object for CAG
J_1ITDS Authorization object for TDS transaction J1IN
J_1IRG23D Authorisation object for Depo Transactions
ECM_REQ Change Management: Change Request
ECM_ORD Change Management: Change Order
ECM_VAL Change Management: Validity
J_1IEWT_HC health check for Migration to EWT