SAP ABAP Table CCIHS_MJBUF (EHS: Buffer for Measurement Job Data)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ EHS-IHS (Application Component) Industrial Hygiene and Safety
⤷ CBIH (Package) EH&S: Industrial Hygiene and Safety
⤷ EHS-IHS (Application Component) Industrial Hygiene and Safety
⤷ CBIH (Package) EH&S: Industrial Hygiene and Safety
Basic Data
Table Category | INTTAB | Structure |
Structure | CCIHS_MJBUF | Table Relationship Diagram |
Short Description | EHS: Buffer for Measurement Job Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | EHS: Standard fields for buffer table | |||||
2 | VALFLG | ESEVALFLG | ESDFLAG | CHAR | 1 | 0 | Indicator: Data record is currently valid | ||
3 | CHCOFLG | ESECHCOFLG | ESDFLAG | CHAR | 1 | 0 | Indicator: Change number collision | ||
4 | LOCKMOD | ESELOCKMOD | CHAR1 | CHAR | 1 | 0 | Lock Mode (Shared, Exclusive) | ||
5 | LOGLOCKMOD | ESELGLCKMD | CHAR1 | CHAR | 1 | 0 | Logical Lock Mode | ||
6 | SAVEMOD | ESESAVEMOD | CHAR1 | CHAR | 1 | 0 | Processing type when saving: INSERT, UPDATE, DELETE | ||
7 | SPLIT | ESESPLIT | ESDSPLIT | CHAR | 1 | 0 | Record Split Indicator of a Buffer Record | ||
8 | BUF_ORIG_INDEX | SYTABIX | SYST_LONG | INT4 | 10 | 0 | Row Index of Internal Tables | ||
9 | CHANGENO | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | * | |
10 | KEYDATE | ESEDIAGVD | DATUM | DATS | 8 | 0 | Key Date | ||
11 | .INCLUDE | 0 | 0 | EHS: Measurement | |||||
12 | .INCLUDE | 0 | 0 | EHS: Structure for key info of master data | |||||
13 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
14 | RECN | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
15 | ACTN | ESEACTN | ESDACTN | NUMC | 20 | 0 | Sequential Number of the Change State | ||
16 | .INCLUDE | 0 | 0 | EHS: Structure for General Administration Information | |||||
17 | VALFR | ESEVALFR | DATUM | DATS | 8 | 0 | Valid-From Date | ||
18 | VALTO | ESEVALTO | DATUM | DATS | 8 | 0 | Valid-To Date | ||
19 | AENNR | ESEAENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
20 | DELFLG | ESEDELFLG | ESDFLAG | CHAR | 1 | 0 | Deletion Indicator | ||
21 | PARKFLG | ESEPARKFLG | ESDFLAG | CHAR | 1 | 0 | Data Record Is Inactive | ||
22 | CRDAT | ESECRDAT | DATUM | DATS | 8 | 0 | Created On | ||
23 | CRNAM | ESECRNAM | USNAM | CHAR | 12 | 0 | Created By | ||
24 | UPDDAT | ESEUPDDAT | DATUM | DATS | 8 | 0 | Changed On | ||
25 | UPDNAM | ESEUPDNAM | USNAM | CHAR | 12 | 0 | Last Changed By | ||
26 | SRSID | ESESRSID | ESDSRSID | CHAR | 10 | 0 | Source of Data | TCG56 | |
27 | OWNID | ESEVENDRID | AD_ADDRNUM | CHAR | 10 | 0 | Data Provider | * | |
28 | RECNROOT | ESERECN | ESDRECN | NUMC | 20 | 0 | Sequential Number of Data Record | ||
29 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
30 | MJID | CCIHE_MJID | CCIHD_MJID | CHAR | 30 | 0 | Measurement Number | ||
31 | MJCAT | CCIHE_MJCAT | CCIHD_MJCAT | CHAR | 3 | 0 | Sampling Type | CCIHC_MJCAT | |
32 | MJSTAT | EHSBE_STATUS | J_STATUS | CHAR | 5 | 0 | Status | ||
33 | EPTYPE | CCIHE_EPTYPE | ESDSUBCAT | CHAR | 10 | 0 | Agent Type | CCIHV_HAZTYPE | |
34 | EPID | CCIHE_EPID | CCIHD_EPID | CHAR | 20 | 0 | Agent | ||
35 | RECNTMPWA | CCIHE_RECNTMPWA | ESDRECN | NUMC | 20 | 0 | Reference to Assigned Work Area | ||
36 | MJVALFR | CCIHE_MJVALFR | DATUM | DATS | 8 | 0 | Start of Validity of Measurement | ||
37 | MJVALTO | CCIHE_MJVALTO | DATUM | DATS | 8 | 0 | End of Validity of Measurement | ||
38 | MSRBGNDATE | CCIHE_MSRBGNDATE | DATUM | DATS | 8 | 0 | Date of Start of Measurement | ||
39 | MSRBGNTIME | CCIHE_MSRBGNTIME | UZEIT | TIMS | 6 | 0 | Time of Start of Measurement | ||
40 | MSRENDDATE | CCIHE_MSRENDDATE | DATUM | DATS | 8 | 0 | Date of End of Measurement | ||
41 | MSRENDTIME | CCIHE_MSRENDTIME | UZEIT | TIMS | 6 | 0 | Time of End of Measurement | ||
42 | MDURATION | CCIHE_MDURATION | CCIHD_MDURATION | TIMS | 6 | 0 | Actual Duration of Measurement | ||
43 | MPLDURATION | CCIHE_MPLDURATION | CCIHD_MDURATION | TIMS | 6 | 0 | Planned Measurement Duration | ||
44 | MEXCHANGE | CCIHE_MEXCHANGE | ESDFLAG | CHAR | 1 | 0 | Perform Conversion | ||
45 | MSOURCEID | CCIHE_MSOURCEID | CCIHD_MSOURCEID | CHAR | 3 | 0 | Sampling Location | CCIHC_MSOURCE | |
46 | MSOURCENOTE | CCIHE_MSOURCENOTE | CCIHD_MSOURCENOTE | CHAR | 255 | 0 | Description for Sampling Location | ||
47 | FIXLOCFLG | CCIHE_FIXLOCFLG | ESDFLAG | CHAR | 1 | 0 | Fixed-Location Measurement | ||
48 | MPERIOD | CCIHE_MPERIOD | CCIHD_MPERIOD | NUMC | 2 | 0 | Repetition of Measurement in Months | ||
49 | FLOW | CCIHE_FLOW | CCIHD_FLOW | DEC | 5 | 2 | Flow Quantity of Measuring Device | ||
50 | FLOWUNIT | CCIHE_FLOWUNIT | MEINS | UNIT | 3 | 0 | Flow Unit | * | |
51 | DVNR | CCIHE_DVNR | CHAR20 | CHAR | 20 | 0 | Number of the Measuring Device | ||
52 | MDEVTYPE | CCIHE_DVTYPE | CCIHD_DVTYPE | CHAR | 3 | 0 | Measuring Device Type | CCIHC_DVTYPE | |
53 | METHOD | CCIHE_METHOD | CCIHD_METHOD | CHAR | 5 | 0 | Measurement Method | CCIHC_METHOD | |
54 | MPERSON | CCIHE_MJPERSON | CCIHD_MJPERSON | CHAR | 10 | 0 | Test Person | ||
55 | MPERSONGRP | CCIHE_PERSGRP | CCIHD_PERSGRP | CHAR | 1 | 0 | Person Group | ||
56 | MPERSONNAME | CCIHE_FULLNAME | TEXT80 | CHAR | 80 | 0 | Full Name of Person | ||
57 | MJNOTE1 | CCIHE_MJNOTE | CCIHD_MNOTE | CHAR | 72 | 0 | Remarks on Measurement | ||
58 | MJNOTEFLG1 | ESELTXTFLG | ESDFLAG | CHAR | 1 | 0 | Long Text | ||
59 | MJNOTE2 | CCIHE_MJNOTE | CCIHD_MNOTE | CHAR | 72 | 0 | Remarks on Measurement | ||
60 | MJNOTEFLG2 | ESELTXTFLG | ESDFLAG | CHAR | 1 | 0 | Long Text | ||
61 | RESPIRATOR | CCIHE_RESPIRATOR | CCIHD_RESPIRATOR | CHAR | 1 | 0 | Respiratory Protection | ||
62 | SAMPLENR | CCIHE_SAMPLENR | CCIHD_SAMPLENR | CHAR | 30 | 0 | Container or Filter | ||
63 | MJCOSTAC | CCIHE_MPCOSTAC | KOSTL | CHAR | 10 | 0 | Cost Center for Measurement Project | * | |
64 | MJCTRAREA | CCIHE_MPCTRAREA | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
65 | RECNTMJ | CCIHE_RECNTREFMJ | ESDRECN | NUMC | 20 | 0 | Reference to Partial Measurement | ||
66 | LIMEXCEEDFLG | CCIHE_LIMEXCEEDFLG | ESDFLAG | CHAR | 1 | 0 | Reference Value Exceeded | ||
67 | STMFLG | CCIHE_STMFLG | ESDFLAG | CHAR | 1 | 0 | Short-Term Sample | ||
68 | METCOASTS | CCIHE_MCOSTS | CCIHD_METCOASTS | CURR | 10 | 2 | Cost of Analysis | ||
69 | METCUKY | CCIHE_METCUKY | WAERS | CUKY | 5 | 0 | Currency Key for Costs | * | |
70 | VOLUME | CCIHE_VOLUME | FLTP | FLTP | 16 | 16 | Total Volume in Liters | ||
71 | VOLDECIMALS | CCIHE_HQVALDECIMALS | INT4 | INT4 | 10 | 0 | Decimal Places for a Measured Physical Variable Value | ||
72 | MJCOCODE | CCIHE_MPCOCODE | BUKRS | CHAR | 4 | 0 | Company Code | * | |
73 | FLGEXPLOCK | CCIHE_FLGEXPLCK | ESDFLAG | CHAR | 1 | 0 | Object Is in Export | ||
74 | OPCOND | CCIHE_OPCOND | CCIHD_OPCOND | CHAR | 3 | 0 | Operation Status of Work Area/Pattern | CCIHC_OC01 | |
75 | PLBEGDATE | CCIHE_MSRPLBEGDATE | DATUM | DATS | 8 | 0 | Planned Measurement Start Date | ||
76 | PLENDDATE | CCIHE_MSRPLENDDATE | DATUM | DATS | 8 | 0 | Planned Measurement End Date | ||
77 | MSRTEMP | CCIHE_MSRTEMP | DEC5_2 | DEC | 7 | 2 | Temperature During Measurement | ||
78 | MSRTEMPUNIT | CCIHE_MSRTEMPUNIT | MEINS | UNIT | 3 | 0 | Temperature Unit During Measurement | * | |
79 | AIRHUM | CCIHE_AIRHUM | DEC5_2 | DEC | 7 | 2 | Air Humidity During Measurement | ||
80 | AIRHUMUNIT | CCIHE_AIRHUMUNIT | MEINS | UNIT | 3 | 0 | Air Humidity Unit During Measurement | * | |
81 | AIRCOND | CCIHE_AIRCOND | CHAR21 | CHAR | 21 | 0 | Ventilation During Measurement | ||
82 | AIRCHNGRATE | CCIHE_AIRCHNGRATE | DECV5_2 | DEC | 5 | 2 | Air Change Rate During Measurement | ||
83 | PROTEQUI | CCIHE_PROTEQUI | CHAR21 | CHAR | 21 | 0 | Safety Device During Measurement | ||
84 | FLG_NIGHT | CCIHE_FLG_NIGHT | ESDFLAG | CHAR | 1 | 0 | Night Measurement | ||
85 | PLBEGTIME | CCIHE_MSRPLBEGTIME | UZEIT | TIMS | 6 | 0 | Planned Measurement Start Time | ||
86 | PLENDTIME | CCIHE_MSRPLENDTIME | UZEIT | TIMS | 6 | 0 | Planned Measurement End Time |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CCIHS_MJBUF | AENNR | AENR | AENNR | |||
2 | CCIHS_MJBUF | EPTYPE | CCIHV_HAZTYPE | SUBCAT | |||
3 | CCIHS_MJBUF | MANDT | T000 | MANDT | |||
4 | CCIHS_MJBUF | MDEVTYPE | CCIHC_DVTYPE | DVTYPE | KEY | 1 | CN |
5 | CCIHS_MJBUF | METHOD | CCIHC_METHOD | METHOD | 1 | CN | |
6 | CCIHS_MJBUF | MJCAT | CCIHC_MJCAT | MJCAT | |||
7 | CCIHS_MJBUF | MJCTRAREA | TKA01 | KOKRS | |||
8 | CCIHS_MJBUF | MSOURCEID | CCIHC_MSOURCE | MSOURCEID | |||
9 | CCIHS_MJBUF | OPCOND | CCIHC_OC01 | OPCOND | REF | 1 | CN |
10 | CCIHS_MJBUF | SRSID | TCG56 | SRSID | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |