SAP ABAP Table TCGQUE (EHS: Queries)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ EHS-SAF (Application Component) Product Safety
⤷ CBUI (Package) Company Environment Information System
⤷ EHS-SAF (Application Component) Product Safety
⤷ CBUI (Package) Company Environment Information System
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | TCGQUE | Table Relationship Diagram |
Short Description | EHS: Queries |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | EHS: General object key for group objects | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | RECN_GRP | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
4 | .INCLUDE | 0 | 0 | EHS: Administration Fields for Group Objects | |||||
5 | AENNR | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
6 | SEARCHMODE | ESESEARCHMODE | ESDSEARCHMODE | CHAR | 1 | 0 | Search mode to find historical data | ||
7 | VALDAT | ESEDIAGVD | DATUM | DATS | 8 | 0 | Key Date | ||
8 | .INCLUDE | 0 | 0 | EHS: Struct. for searching via time frame (historical data) | |||||
9 | VALFR | ESEDIAGVF | DATUM | DATS | 8 | 0 | From-Date for Specification Search Over Time Period | ||
10 | VALTO | ESEDIAGVT | DATUM | DATS | 8 | 0 | To-Date for Specification Search Over Time Period | ||
11 | CRDAT | ESECRDAT | DATUM | DATS | 8 | 0 | Created On | ||
12 | CRNAM | ESECRNAM | USNAM | CHAR | 12 | 0 | Created By | ||
13 | UPDDAT | ESEUPDDAT | DATUM | DATS | 8 | 0 | Changed On | ||
14 | UPDNAM | ESEUPDNAM | USNAM | CHAR | 12 | 0 | Last Changed By | ||
15 | OBJID | ESEGRPOBJID | ESDGRPOBJID | CHAR | 10 | 0 | Group Entry | ||
16 | GRPID | ESEGRPID | ESDGRPID | CHAR | 10 | 0 | Group | TCGGRP | |
17 | ORD | ESEORD | NUMC4 | NUMC | 4 | 0 | Sort Sequence |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TCGQUE | AENNR | AENR | AENNR | |||
2 | TCGQUE | GRPID | TCGGRP | GRPID | 1 | CN | |
3 | TCGQUE | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20011002 |
SAP Release Created in |