SAP ABAP Table /TDAG/CPT_ESTMJ (EHS: Substance - material - allocation)
Hierarchy
☛
TDAGBCA (Software Component) TechniData Basic Components
⤷
EHS (Application Component) Environment, Health and Safety
⤷
/TDAG/CP (Package) Compliance for products
TDAGBCA (Software Component) TechniData Basic Components⤷
EHS (Application Component) Environment, Health and Safety⤷
/TDAG/CP (Package) Compliance for products
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | /TDAG/CPT_ESTMJ |
Table Relationship Diagram 
|
| Short Description | EHS: Substance - material - allocation |
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: Structure for key info of master data | |||||
| 2 | MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 3 | RECN |
ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
| 4 | ACTN |
ESEACTN | ESDACTN | NUMC | 20 | 0 | Sequential Number of the Change State | ||
| 5 | .INCLUDE |
0 | 0 | EHS: Structure for General Administration Information | |||||
| 6 | VALFR |
ESEVALFR | DATUM | DATS | 8 | 0 | Valid-From Date | ||
| 7 | VALTO |
ESEVALTO | DATUM | DATS | 8 | 0 | Valid-To Date | ||
| 8 | AENNR |
ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
| 9 | DELFLG |
ESEDELFLG | ESDFLAG | CHAR | 1 | 0 | Deletion Indicator | ||
| 10 | PARKFLG |
ESEPARKFLG | ESDFLAG | CHAR | 1 | 0 | Data Record Is Inactive | ||
| 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 | SRSID |
ESESRSID | ESDSRSID | CHAR | 10 | 0 | Source of Data | TCG56 | |
| 16 | OWNID |
ESEVENDRID | AD_ADDRNUM | CHAR | 10 | 0 | Data Provider | * | |
| 17 | RECNROOT |
ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
| 18 | WERKS |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 19 | MATNR |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 20 | VALUE |
/TDAG/CPE_QUANR | ESDDEC6_4 | DEC | 10 | 4 | Value for Quantity Rate | ||
| 21 | UOM |
/TDAG/CPE_UOM | MEINS | UNIT | 3 | 0 | Unit of Measurement for Rate | * | |
| 22 | ALTGR |
/TDAG/CPE_ALTGR | CHAR2 | CHAR | 2 | 0 | Alternative Group |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /TDAG/CPT_ESTMJ | AENNR |  AENR |
AENNR |
|||
| 2 | /TDAG/CPT_ESTMJ | MANDT | T000 |
MANDT |
|||
| 3 | /TDAG/CPT_ESTMJ | MATNR | MARA |
MATNR |
REF | 1 | CN |
| 4 | /TDAG/CPT_ESTMJ | SRSID | TCG56 |
SRSID |
REF | 1 | CN |
| 5 | /TDAG/CPT_ESTMJ | WERKS | T001W |
WERKS |
REF | 1 | CN |
History
| Last changed by/on | SAP | 20141109 |
| SAP Release Created in | 0207B0406C |
