SAP ABAP View U_25005 (Substance identification)
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   EHS (Application Component) Environment, Health and Safety
     CBDMDL (Package) EH&S Data Models
Basic Data
View Type D Database View 
Database View U_25005  
Short Description Substance identification    
Root table ESTRI   EHS: Identifier (Numbers, Names, Chemical Formulas) 
Entity TypeDM02L 
Short text Substance identification
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 ESTRI ESTRI
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT ESTRI MANDT   MANDT Client
2 RECN ESTRI RECN   ESERECN Sequential Number of Data Record
3 ACTN ESTRI ACTN   ESEACTN Sequential Number of the Change State
4 VALFR ESTRI VALFR   ESEVALFR Valid-From Date
5 VALTO ESTRI VALTO   ESEVALTO Valid-To Date
6 AENNR ESTRI AENNR   ESEAENNR Change Number
7 DELFLG ESTRI DELFLG   ESEDELFLG Deletion Indicator
8 PARKFLG ESTRI PARKFLG   ESEPARKFLG Data Record Is Inactive
9 CRDAT ESTRI CRDAT   ESECRDAT Created On
10 CRNAM ESTRI CRNAM   ESECRNAM Created By
11 UPDDAT ESTRI UPDDAT   ESEUPDDAT Changed On
12 UPDNAM ESTRI UPDNAM   ESEUPDNAM Last Changed By
13 SRSID ESTRI SRSID   ESESRSID Source of Data
14 RECNROOT ESTRI RECNROOT   ESERECN Sequential Number of Data Record
15 IDTYPE ESTRI IDTYPE   ESEIDTYPE Identification Category
16 IDCAT ESTRI IDCAT   ESEIDCAT Identification Type
17 LANGU ESTRI LANGU   ESELANGU Language
18 IDENT ESTRI IDENT   ESEIDENT Identifier
19 IDENTNM ESTRI IDENTNM   ESEIDENTNM Normed identification (upper case, no special characters)
20 LTXTFLG ESTRI LTXTFLG   ESELTXTFLG Long Text
21 ORD ESTRI ORD   ESEORD Sort Sequence
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20110901 
SAP Release Created in