| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CCGLC_SCEN | EHS: Labeling Scenarios - Header Table | 9 | RVLID | Validity Area for Labeling Scenario | nvarchar | 10 | 0 | | |
2 | CCGLT_PRTREQ_PAR | EHS: Print Request Parameters | 33 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
3 | EHPRCC_EXPL_P | CP: BOS-Explosion configuration composition priorities | 9 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPDangerous Goods Management |
4 | TDG49 | DG: Permitted Primary Languages | 2 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
5 | TDG51 | DG: Derivation of Secondary Language | 2 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
6 | TDG63 | DG: Derivation of Regulations | 3 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
7 | TDG77 | DG: Priorities for Validity Areas per Regulation | 4 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
8 | TDGA7 | DG: Usage profile for dangerous goods check routines | 4 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPEnvironment, Health and Safety |
9 | /TDAG/CPC_EXPL_P | CP: BOS-Explosion configuration composition priorities | 9 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
10 | DGMSD | DG: Dangerous Goods Document Table DGMSD | 8 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
11 | DGTMD_LKEY | DG: Dummy Table for Lock Object on Log. Key for DGTMD | 4 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
12 | EHSBT_APPL_SCOPE | EHS: General Scope of Application | 20 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPEnvironment, Health and Safety Master Data |
13 | DGTMD | DG: Dangerous Goods Master | 18 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
14 | TCG81 | EHS: Regulatory List | 7 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
15 | TCG91 | EHS: Validity Area | 2 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
16 | TCG92 | EHS: Language-Dependent Description for Validity Area | 3 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
17 | TCG93 | EHS: Validity Area - Country - Region - VA - Assignment | 2 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
18 | THM063 | DG: Dangerous Goods Regulation | 3 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPHazardous Substance Management |
19 | HSMC_021 | EHS: Customizing Priority of Validity Area per Cntry/Region | 4 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPIndustrial Hygiene and Safety |
20 | CCIHT_WAH | EHS: Work Area - Header | 23 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPMaterials Management |
21 | /ISDFPS/DG_EXCPT | DG Management: Exception Requests DG Check OBSOLETE | 7 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPProduct Safety |
22 | CCGLC_DEF_CTY | EHS: Standard Countries for a Plant | 3 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
23 | CCGLC_MPD | EHS: Manual Print Dialog | 17 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
24 | CCGLT_LSRV | EHS: Label Stock - Assigned Validity Area | 16 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
25 | CCGLT_MTLV | EHS: Label Definition - Validity Areas | 10 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
26 | CCRCC_DET | EHS: Data Determination Modules per Regulation/Scenario | 14 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
27 | CVDDP | EHS: Parameter Values for Report Shipping | 44 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
28 | ESTDU | EHS: Additional Information: Value Assignment Usage | 19 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
29 | ESTLP | EHS: Report Variant | 22 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
30 | ESTLV | EHS: Report Variant Language (Labels Only) | 17 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
31 | ESTST | EHS: Specification Status Assignment | 18 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
32 | TCG76RVLID | EHS: Assignment of Component Type to Validity Area | 3 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
33 | TCG98 | EHS: Usage profile-rating-validity area assignments | 4 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
34 | TCGRULPOSUR | EHS: Easy Expert Set of Rules, Usage Entry for Reading | 8 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
35 | TCGRULPOSUW | EHS: Easy Expert Set of Rules, Usage Entry for Writing | 8 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
36 | TCGTPLU | EHS: Inheritance Templates - Usages | 16 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPRecipe |
37 | RCPC_MSC_ASCOPE | Changes to Scope-of-Application Status | 6 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPRecipe Development |
38 | /PLMB/CCK_CUS | Compliance Check: Constraint Usages | 4 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
39 | /PLMB/CCK_PCUS | Compliance Check: Saved Parameters - Constraint Usages | 4 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
40 | /PLMB/CCK_RUS | Compliance Check: Result Usages | 5 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
41 | /PLMI/DEF_PARAM | Default Calculation Parameter | 7 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPResourcen Management |
42 | FRMLC35 | RMGMT Formula: Key Figures | 6 | RVLID | Validity Area of a Key Figure | nvarchar | 10 | 0 | | |
43 | FRMLC50 | RMS-FRM: Data Source | 3 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
44 | FRMLC51 | RMS-FRM: Data Source Texts | 3 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
45 | FRMLC_VIEWPARA | RMS22: Formula View Parameters | 8 | RVLID | Validity Area for Reading and Writing EHS Data | nvarchar | 10 | 0 | | |
46 | PAFRM | RMS-FRM: Alternative Segment for Object Category FRM | 7 | RVLID | Validity Area for Composition of Formula | nvarchar | 10 | 0 | | |
47 | RMSAT_STD_PARA_H | RMS-ATL: Header Table Parameter Standardization | 7 | RVLID | Validity Area | nvarchar | 10 | 0 | | |
TOPWaste Management |
48 | EHSWAT_BPID | MD: Partner - Jurisdiction-Dependent Data | 16 | RVLID | Validity Area | nvarchar | 10 | 0 | | |