SAP Table TCGTPLREL
EHS: Inheritance Relationships
TCGTPLREL (EHS: Inheritance Relationships) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TCGTPLREL to other SAP tables.
TCGTPLREL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
RECN
Sequential Number of Data Record
|
ESERECN |
NUMC
|
20 | 0 | ||||||||||||
|
ACTN
Sequential Number of the Change State
|
ESEACTN |
NUMC
|
20 | 0 | ||||||||||||
|
VALFR
Valid-From Date
|
ESEVALFR |
DATS
|
8 | 0 | ||||||||||||
|
VALTO
Valid-To Date
|
ESEVALTO |
DATS
|
8 | 0 | ||||||||||||
|
AENNR
Change Number
|
ESEAENNR | AENR |
CHAR
|
12 | 0 | |||||||||||
|
DELFLG
Deletion Indicator
|
ESEDELFLG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PARKFLG
Data Record Is Inactive
|
ESEPARKFLG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
CRDAT
Created On
|
ESECRDAT |
DATS
|
8 | 0 | ||||||||||||
|
CRNAM
Created By
|
ESECRNAM |
CHAR
|
12 | 0 | ||||||||||||
|
UPDDAT
Changed On
|
ESEUPDDAT |
DATS
|
8 | 0 | ||||||||||||
|
UPDNAM
Last Changed By
|
ESEUPDNAM |
CHAR
|
12 | 0 | ||||||||||||
|
SRSID
Source of Data
|
ESESRSID | TCG56 |
CHAR
|
10 | 0 | |||||||||||
|
OWNID
Data Provider
|
ESEVENDRID |
CHAR
|
10 | 0 | ||||||||||||
|
RECNROOT
Sequential Number of Data Record
|
ESERECN |
NUMC
|
20 | 0 | ||||||||||||
|
FLG_SRCDEST_REQ
Request from Currently Called Specification
|
ESEFLG_SRCDEST_REQ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
APPRV_STAT
Approval Status of an Inheritance Request
|
ESEAPPRV_STAT |
NUMC
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
CONS_STAT
Status of an Inheritance Relationship
|
ESECONS_STAT |
NUMC
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
FLG_INH
Inheritance Relationship Is Inactive
|
ESEFLG_INH |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
JOB_REQ_TIM
Current Time of an Inheritance Request
|
ESEJOB_REQ_TIM |
TIMS
|
6 | 0 | ||||||||||||
|
JOB_REQ_DAT
Date of an Inheritance Request
|
ESEJOB_REQ_DAT |
DATS
|
8 | 0 | ||||||||||||
|
FLG_SUBCPY
Relationship Is Not Relevant for Inheritance
|
ESEFLG_SUBCPY |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
RECNROOT_SRC
Sequential Number of Data Record
|
ESERECN |
NUMC
|
20 | 0 | ||||||||||||
|
RECNROOT_DST
Sequential Number of Data Record
|
ESERECN |
NUMC
|
20 | 0 | ||||||||||||
|
RECN_TPLH
Sequential Number of Data Record
|
ESERECN |
NUMC
|
20 | 0 | ||||||||||||
|
ESNTFLG
Relevant Change Has Been Made
|
ESEESNTFLG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
TCGTPLREL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TCGTPLREL | AENNR | SY | MANDT |
AENR
Change Master
|
MANDT |
| TCGTPLREL | AENNR | TCGTPLREL | AENNR |
AENR
Change Master
|
AENNR |
| TCGTPLREL | MANDT | TCGTPLREL | MANDT |
T000
Clients
|
MANDT |
| TCGTPLREL | SRSID | * |
TCG56
EHS: Data Origin
|
MANDT | |
| TCGTPLREL | SRSID | TCGTPLREL | SRSID |
TCG56
EHS: Data Origin
|
SRSID |