SAP ABAP Table /TDAG/CPS_ESTRH_MATCAT (CP: ESTRH & Matcat)
Hierarchy
☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP (Package) Compliance for products
Basic Data
Table Category INTTAB    Structure 
Structure /TDAG/CPS_ESTRH_MATCAT   Table Relationship Diagram
Short Description CP: ESTRH & Matcat    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   EHS: Specification Header  
2 .INCLUDE       0   0   EHS: Structure for key info of master data  
3 MANDT MANDT MANDT CLNT 3   0   Client T000
4 RECN ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
5 ACTN ESEACTN ESDACTN NUMC 20   0   Sequential Number of the Change State  
6 .INCLUDE       0   0   EHS: Structure for General Administration Information  
7 VALFR ESEVALFR DATUM DATS 8   0   Valid-From Date  
8 VALTO ESEVALTO DATUM DATS 8   0   Valid-To Date  
9 AENNR ESEAENNR AENNR CHAR 12   0   Change Number AENR
10 DELFLG ESEDELFLG ESDFLAG CHAR 1   0   Deletion Indicator  
11 PARKFLG ESEPARKFLG ESDFLAG CHAR 1   0   Data Record Is Inactive  
12 CRDAT ESECRDAT DATUM DATS 8   0   Created On  
13 CRNAM ESECRNAM USNAM CHAR 12   0   Created By  
14 UPDDAT ESEUPDDAT DATUM DATS 8   0   Changed On  
15 UPDNAM ESEUPDNAM USNAM CHAR 12   0   Last Changed By  
16 SRSID ESESRSID ESDSRSID CHAR 10   0   Source of Data TCG56
17 OWNID ESEVENDRID AD_ADDRNUM CHAR 10   0   Data Provider *
18 RECNROOT ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
19 UPDDATS ESEUPDDATS DATUM DATS 8   0   Date of Last Change to Specification As a Whole  
20 UPDNAMS ESEUPDNAMS USNAM CHAR 12   0   Name of Person Who Last Changed Specification  
21 SUBID ESESUBID ESDSUBID CHAR 12   0   Specification  
22 SUBCAT ESESUBCAT ESDSUBCAT CHAR 10   0   Specification Type TCG31
23 AUTHGRP ESEAUTHGRP ESDAUTHGRP CHAR 10   0   Authorization Group TCG36
24 REM ESEREM TEXT60 CHAR 60   0   Note  
25 SUBCHAR ESESUBCHAR ESDSUBCHAR CHAR 10   0   Identification of Substance Nature TCG34
26 MATCAT /TDAG/CPE_MATCAT /TDAG/CPD_MATCAT CHAR 12   0   Material Category *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /TDAG/CPS_ESTRH_MATCAT AENNR AENR AENNR    
2 /TDAG/CPS_ESTRH_MATCAT AUTHGRP TCG36 AUTHGRP REF 1 CN
3 /TDAG/CPS_ESTRH_MATCAT MANDT T000 MANDT    
4 /TDAG/CPS_ESTRH_MATCAT SRSID TCG56 SRSID REF 1 CN
5 /TDAG/CPS_ESTRH_MATCAT SUBCAT TCG31 SUBCAT REF 1 CN
6 /TDAG/CPS_ESTRH_MATCAT SUBCHAR TCG34 SUBCHAR REF    
History
Last changed by/on SAP  20141109 
SAP Release Created in 222_46C