SAP ABAP View ESD_TCG11A (EHS: Value Assignment Types (only with Category A, B, and C))
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   EHS-SAF (Application Component) Product Safety
     CBUI (Package) Company Environment Information System
Basic Data
View Type D Database View 
Database View ESD_TCG11A  
Short Description EHS: Value Assignment Types (only with Category A, B, and C)    
Root table TCG11   EHS: Value Assignment Type 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 TCG11 TCG11
2 TCG12  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 TCG11 MANDT JL EQ 0 0
2 TCG12 MANDT JR EQ AND 0 0
3 TCG11 ESTCAT JL EQ 0 0
4 TCG12 ESTCAT JR EQ AND 0 0
5 TCG11 ESTTYPE NE 'D' AND 0 0
6 TCG11 ESTTYPE NE 'E' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT TCG11 MANDT   MANDT Client
2 LANGU TCG12 LANGU   LANGU Language Key
3 ESTNAM TCG12 ESTNAM   ESEESTNAM Description of Value Assignment Type
4 ESTCAT TCG11 ESTCAT   ESEESTCAT Value Assignment Type
                 
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  20130529 
SAP Release Created in