SAP Table RCG_ESTVA
EHS: Structure for ESTVA
RCG_ESTVA (EHS: Structure for ESTVA) 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 RCG_ESTVA to other SAP tables.
RCG_ESTVA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | |||||||
| RECNTVH | Reference to Value Assignment Header | ESERECNTVH | ESTVH | NUMC | 20 | 0 | ||||||
| ORD | Sort Sequence | ESEORD | NUMC | 4 | 0 | |||||||
| COMPREL | Reference Quantity for Component Specification | ESECOMPREL | TCG74 | CHAR | 10 | 0 | ||||||
| FLG_INHSRC | Truth Value | ESEBOOLE | CHAR | 1 | 0 |
Possible values
|
||||||
| FLG_INHOVR | EHS: Indicator for Temporary Inheritance Overwriting | ESEINHOVR | CHAR | 1 | 0 |
Possible values
|
||||||
| FLG_INHEXCL | EHS: Indicator for Permanent Inheritance Overwriting | ESEINHEXCL | CHAR | 1 | 0 |
Possible values
|
||||||
| RECN_TPLH | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| RECNTVA_SRC | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| RECNTVA_ORIG | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| RECNROOT_ORIG | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| TPL_ORD | Sort Sequence | ESEORD | NUMC | 4 | 0 | |||||||
| FLG_INT | Truth Value | ESEBOOLE | CHAR | 1 | 0 |
Possible values
|
||||||
RCG_ESTVA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| RCG_ESTVA | AENNR | SY | MANDT | AENR | Change Master | MANDT |
| RCG_ESTVA | AENNR | RCG_ESTVA | AENNR | AENR | Change Master | AENNR |
| RCG_ESTVA | COMPREL | RCG_ESTVA | MANDT | TCG74 | EHS: Reference Quantities for Composition | MANDT |
| RCG_ESTVA | COMPREL | RCG_ESTVA | COMPREL | TCG74 | EHS: Reference Quantities for Composition | COMPREL |
| RCG_ESTVA | COMPREL | * | TCG74 | EHS: Reference Quantities for Composition | COMPDIMID | |
| RCG_ESTVA | MANDT | RCG_ESTVA | MANDT | T000 | Clients | MANDT |
| RCG_ESTVA | RECNTVH | RCG_ESTVA | MANDT | ESTVH | EHS: Specification - Value Assignment Type Assignment | .INCLUDE |
| RCG_ESTVA | RECNTVH | RCG_ESTVA | RECNTVH | ESTVH | EHS: Specification - Value Assignment Type Assignment | MANDT |
| RCG_ESTVA | RECNTVH | * | ESTVH | EHS: Specification - Value Assignment Type Assignment | RECN | |
| RCG_ESTVA | SRSID | * | TCG56 | EHS: Data Origin | MANDT | |
| RCG_ESTVA | SRSID | RCG_ESTVA | SRSID | TCG56 | EHS: Data Origin | SRSID |
