SAP ABAP View ESD_ESTRI (EHS: Identifiers for Nondeleted Specification Headers)
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 | ESD_ESTRI | |
Short Description | EHS: Identifiers for Nondeleted Specification Headers | |
Root table | ESTRI | EHS: Identifier (Numbers, Names, Chemical Formulas) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ESTRI | ESTRI | ||
2 | ESTRH |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ESTRI | MANDT | JL | EQ | 0 | 0 | ||||
2 | ESTRH | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ESTRI | RECNROOT | JL | EQ | 0 | 0 | ||||
4 | ESTRH | RECN | JR | EQ | AND | 0 | 0 | |||
5 | ESTRH | DELFLG | EQ | ' ' | 0 | 0 | ||||
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 | OWNID | ESTRI | OWNID | ESEVENDRID | Data Provider | |||
15 | RECNROOT | ESTRI | RECNROOT | ESERECN | Sequential Number of Data Record | |||
16 | IDTYPE | ESTRI | IDTYPE | ESEIDTYPE | Identification Category | |||
17 | IDCAT | ESTRI | IDCAT | ESEIDCAT | Identification Type | |||
18 | LANGU | ESTRI | LANGU | ESELANGU | Language | |||
19 | IDENT | ESTRI | IDENT | ESEIDENT | Identifier | |||
20 | IDENTNM | ESTRI | IDENTNM | ESEIDENTNM | Normed identification (upper case, no special characters) | |||
21 | LTXTFLG | ESTRI | LTXTFLG | ESELTXTFLG | Long Text | |||
22 | ORD | ESTRI | ORD | ESEORD | Sort Sequence | |||
23 | DOKAR | ESTRI | DOKAR | DOKAR | Document Type | |||
24 | DOKNR | ESTRI | DOKNR | DOKNR | Document number | |||
25 | DOKVR | ESTRI | DOKVR | DOKVR | Document version | |||
26 | DOKTL | ESTRI | DOKTL | DOKTL_D | Document part | |||
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 |