SAP ABAP View ESV_TCG11_ATNAM (EHS: Assignment Value Assignment Types, Classes, and Charac.)
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
View Type | D | Database View |
Database View | ESV_TCG11_ATNAM | |
Short Description | EHS: Assignment Value Assignment Types, Classes, and Charac. | |
Root table | TCG11 | EHS: Value Assignment Type |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TCG11 | TCG11 | ||
2 | KLAH | |||
3 | KLAT | |||
4 | KSML | |||
5 | CABN | |||
6 | CABNT |
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 | KLAH | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | TCG11 | CLVANAM | JL | EQ | 0 | 0 | ||||
4 | KLAH | CLASS | JR | EQ | AND | 0 | 0 | |||
5 | KLAH | MANDT | JL | EQ | 0 | 0 | ||||
6 | KLAT | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | KLAH | CLINT | JL | EQ | 0 | 0 | ||||
8 | KLAT | CLINT | JR | EQ | AND | 0 | 0 | |||
9 | KLAH | MANDT | JL | EQ | 0 | 0 | ||||
10 | KSML | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | KLAH | CLINT | JL | EQ | 0 | 0 | ||||
12 | KSML | CLINT | JR | EQ | AND | 0 | 0 | |||
13 | KSML | MANDT | JL | EQ | 0 | 0 | ||||
14 | CABN | MANDT | JR | EQ | AND | 0 | 0 | |||
15 | KSML | IMERK | JL | EQ | 0 | 0 | ||||
16 | CABN | ATINN | JR | EQ | AND | 0 | 0 | |||
17 | CABN | MANDT | JL | EQ | 0 | 0 | ||||
18 | CABNT | MANDT | JR | EQ | AND | 0 | 0 | |||
19 | CABN | ATINN | JL | EQ | 0 | 0 | ||||
20 | CABNT | ATINN | JR | EQ | AND | 0 | 0 | |||
21 | KLAT | SPRAS | JL | EQ | 0 | 0 | ||||
22 | CABNT | SPRAS | JR | EQ | AND | 0 | 0 | |||
23 | KLAH | KLART | EQ | '100' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | TCG11 | MANDT | MANDT | Client | |||
2 | SPRAS | KLAT | SPRAS | LANGU | Language Key | |||
3 | ESTTYPE | TCG11 | ESTTYPE | ESEESTTYPE | Value Assignment Category | |||
4 | ESTCAT | TCG11 | ESTCAT | ESEESTCAT | Value Assignment Type | |||
5 | CLINT | KLAH | CLINT | CLINT | Internal Class Number | |||
6 | CLASS | KLAH | CLASS | KLASSE_D | Class number | |||
7 | TXTBZ | KLAT | TXTBZ | TEXTBEZ | Long Text Description | |||
8 | ATNAM | CABN | ATNAM | ATNAM | Characteristic Name | |||
9 | ATBEZ | CABNT | ATBEZ | ATBEZ | Characteristic description | |||
Maintenance Status
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 | 600 |