CCIHS_MJIOT SAP (EHS: IOTAB for Measurements (CCIHT_MJ)) Structure details

Dictionary Type: Structure
Description: EHS: IOTAB for Measurements (CCIHT_MJ)




ABAP Code to SELECT data from CCIHS_MJIOT
Related tables to CCIHS_MJIOT
Access table CCIHS_MJIOT




Structure field list including key, data, relationships and ABAP select examples

CCIHS_MJIOT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "EHS: IOTAB for Measurements (CCIHT_MJ)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CCIHS_MJIOT TYPE CCIHS_MJIOT.

The CCIHS_MJIOT table consists of various fields, each holding specific information or linking keys about EHS: IOTAB for Measurements (CCIHT_MJ) data available in SAP. These include MARKFLG (Row Is Selected), SELEFLG (Step Loop Line Selected), LINENO (General Auxiliary Counter), LINEMOD (Processing status or mode of a record/step loop line).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CCIHS_MJIOT structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MARKFLGRow Is Selected ESEMARKFLGCHAR1ESDFLAG
SELEFLGStep Loop Line Selected ESESELEFLGCHAR1ESDFLAG
LINENOGeneral Auxiliary Counter ESECOUNTERNUMC10NUMC10
LINEMODProcessing status or mode of a record/step loop line ESELINEMODCHAR1CHAR1
CHCOFLGIndicator: Change number collision ESECHCOFLGCHAR1ESDFLAG
LOCKMODLock Mode (Shared, Exclusive) ESELOCKMODCHAR1CHAR1
INTRFLGFlag for Internal Use ESEINTRFLGCHAR1ESDFLAG
MANDTClient MANDTCLNT3T000MANDT
RECNSequential Number of Data Record ESERECNNUMC20ALPHAESDRECN
ACTNSequential Number of the Change State ESEACTNNUMC20ALPHAESDACTN
VALFRValid-From Date ESEVALFRDATS8DATUM
VALTOValid-To Date ESEVALTODATS8DATUM
AENNRChange Number ESEAENNRCHAR12AENRAENNRAENNRAEN
DELFLGDeletion Indicator ESEDELFLGCHAR1ESDFLAG
PARKFLGData Record Is Inactive ESEPARKFLGCHAR1ESDFLAG
CRDATCreated On ESECRDATDATS8DATUM
CRNAMCreated By ESECRNAMCHAR12USNAM
UPDDATChanged On ESEUPDDATDATS8DATUM
UPDNAMLast Changed By ESEUPDNAMCHAR12USNAM
SRSIDSource of Data ESESRSIDCHAR10TCG56ESDSRSID
OWNIDData Provider ESEVENDRIDCHAR10Assigned to domainALPHAAD_ADDRNUM
RECNROOTSequential Number of Data Record ESERECNNUMC20ALPHAESDRECN
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
MJIDMeasurement Number CCIHE_MJIDCHAR30CCIHD_MJID
MJCATSampling Type CCIHE_MJCATCHAR3CCIHC_MJCATCCIHD_MJCAT
MJSTATStatus EHSBE_STATUSCHAR5J_STATUS
EPTYPEAgent Type CCIHE_EPTYPECHAR10CCIHV_HAZTYPEESDSUBCAT
EPIDAgent CCIHE_EPIDCHAR20CCIHD_EPID
RECNTMPWAReference to Assigned Work Area CCIHE_RECNTMPWANUMC20ALPHAESDRECN
MJVALFRStart of Validity of Measurement CCIHE_MJVALFRDATS8DATUM
MJVALTOEnd of Validity of Measurement CCIHE_MJVALTODATS8DATUM
MSRBGNDATEDate of Start of Measurement CCIHE_MSRBGNDATEDATS8DATUM
MSRBGNTIMETime of Start of Measurement CCIHE_MSRBGNTIMETIMS6UZEIT
MSRENDDATEDate of End of Measurement CCIHE_MSRENDDATEDATS8DATUM
MSRENDTIMETime of End of Measurement CCIHE_MSRENDTIMETIMS6UZEIT
MDURATIONActual Duration of Measurement CCIHE_MDURATIONTIMS6CCIHD_MDURATION
MPLDURATIONPlanned Measurement Duration CCIHE_MPLDURATIONTIMS6CCIHD_MDURATION
MEXCHANGEPerform Conversion CCIHE_MEXCHANGECHAR1ESDFLAG
MSOURCEIDSampling Location CCIHE_MSOURCEIDCHAR3CCIHC_MSOURCECCIHD_MSOURCEID
MSOURCENOTEDescription for Sampling Location CCIHE_MSOURCENOTECHAR255CCIHD_MSOURCENOTE
FIXLOCFLGFixed-Location Measurement CCIHE_FIXLOCFLGCHAR1ESDFLAG
MPERIODRepetition of Measurement in Months CCIHE_MPERIODNUMC2CCIHD_MPERIOD
FLOWFlow Quantity of Measuring Device CCIHE_FLOWDEC5(2) CCIHD_FLOW
FLOWUNITFlow Unit CCIHE_FLOWUNITUNIT3Assigned to domainCUNITMEINS
DVNRNumber of the Measuring Device CCIHE_DVNRCHAR20CHAR20
MDEVTYPEMeasuring Device Type CCIHE_DVTYPECHAR3CCIHC_DVTYPECCIHD_DVTYPE
METHODMeasurement Method CCIHE_METHODCHAR5CCIHC_METHODCCIHD_METHOD
MPERSONTest Person CCIHE_MJPERSONCHAR10CCIHD_MJPERSON
MPERSONGRPPerson Group CCIHE_PERSGRPCHAR1CCIHD_PERSGRP
MPERSONNAMEFull Name of Person CCIHE_FULLNAMECHAR80TEXT80
MJNOTE1Remarks on Measurement CCIHE_MJNOTECHAR72CCIHD_MNOTE
MJNOTEFLG1Long Text ESELTXTFLGCHAR1ESDFLAG
MJNOTE2Remarks on Measurement CCIHE_MJNOTECHAR72CCIHD_MNOTE
MJNOTEFLG2Long Text ESELTXTFLGCHAR1ESDFLAG
RESPIRATORRespiratory Protection CCIHE_RESPIRATORCHAR1CCIHD_RESPIRATOR
SAMPLENRContainer or Filter CCIHE_SAMPLENRCHAR30CCIHD_SAMPLENR
MJCOSTACCost Center for Measurement Project CCIHE_MPCOSTACCHAR10Assigned to domainALPHAKOSTL
MJCTRAREAControlling Area CCIHE_MPCTRAREACHAR4TKA01CACCD
RECNTMJReference to Partial Measurement CCIHE_RECNTREFMJNUMC20ALPHAESDRECN
LIMEXCEEDFLGReference Value Exceeded CCIHE_LIMEXCEEDFLGCHAR1ESDFLAG
STMFLGShort-Term Sample CCIHE_STMFLGCHAR1ESDFLAG
METCOASTSCost of Analysis CCIHE_MCOSTSCURR10(2) CCIHD_METCOASTS
METCUKYCurrency Key for Costs CCIHE_METCUKYCUKY5Assigned to domainWAERS
VOLUMETotal Volume in Liters CCIHE_VOLUMEFLTP16(16) FLTP
VOLDECIMALSDecimal Places for a Measured Physical Variable Value CCIHE_HQVALDECIMALSINT410INT4
MJCOCODECompany Code CCIHE_MPCOCODECHAR4Assigned to domainBUKRS
FLGEXPLOCKObject Is in Export CCIHE_FLGEXPLCKCHAR1ESDFLAG
OPCONDOperation Status of Work Area/Pattern CCIHE_OPCONDCHAR3CCIHC_OC01CCIHD_OPCOND
PLBEGDATEPlanned Measurement Start Date CCIHE_MSRPLBEGDATEDATS8DATUM
PLENDDATEPlanned Measurement End Date CCIHE_MSRPLENDDATEDATS8DATUM
MSRTEMPTemperature During Measurement CCIHE_MSRTEMPDEC7(2) DEC5_2
MSRTEMPUNITTemperature Unit During Measurement CCIHE_MSRTEMPUNITUNIT3Assigned to domainCUNITMEINS
AIRHUMAir Humidity During Measurement CCIHE_AIRHUMDEC7(2) DEC5_2
AIRHUMUNITAir Humidity Unit During Measurement CCIHE_AIRHUMUNITUNIT3Assigned to domainCUNITMEINS
AIRCONDVentilation During Measurement CCIHE_AIRCONDCHAR21CHAR21
AIRCHNGRATEAir Change Rate During Measurement CCIHE_AIRCHNGRATEDEC5(2) DECV5_2
PROTEQUISafety Device During Measurement CCIHE_PROTEQUICHAR21CHAR21
FLG_NIGHTNight Measurement CCIHE_FLG_NIGHTCHAR1ESDFLAG
PLBEGTIMEPlanned Measurement Start Time CCIHE_MSRPLBEGTIMETIMS6UZEIT
PLENDTIMEPlanned Measurement End Time CCIHE_MSRPLENDTIMETIMS6UZEIT
MJCATTXTDescription of Sampling Type CCIHE_MJCATTXTCHAR60TEXT60
MJSHSTATNAMIndividual status of an object (short form) J_TXT04CHAR4TEXT4
MJSTATNAMObject status J_TXT30CHAR30TEXT30
EPTYPENAMDescription of Agent Type CCIHE_EPTYPENAMCHAR40TEXT40
EPNAMDescription of Agent CCIHE_EPNAMCHAR60TEXT60
MSOURCETXTDescription of Sampling Location CCIHE_MSOURCECHAR120CCIHD_MSOURCE
DVTYPETXTDescription of Measuring Device Type CCIHE_DVTYPETXTCHAR60TEXT60
METHODTXTDescription of Measurement Method CCIHE_METHODTXTCHAR60TEXT60
COSTCNAMDescription of Cost Center CCIHE_COSTCNAMCHAR20CHAR20
REF_MJIDMeasurement Number CCIHE_MJIDCHAR30CCIHD_MJID
MPH_WAIDWork Area or Pattern CCIHE_WAIDCHAR20CHRIDCCIHD_WAID
MPH_WANAMLanguage-Dependent Description of Work Area/Pattern CCIHE_WANAMCHAR60TEXT60
MPH_RECNTWAHReference to Work Area CCIHE_RECNTWAHNUMC20ALPHAESDRECN
MPW_WAIDWork Area or Pattern CCIHE_WAIDCHAR20CHRIDCCIHD_WAID
MPW_WANAMLanguage-Dependent Description of Work Area/Pattern CCIHE_WANAMCHAR60TEXT60
MPW_RECNTWAHReference to Work Area CCIHE_RECNTWAHNUMC20ALPHAESDRECN
BUILDINGSBuilding CCIHE_BUILDINGSCHAR120CCIHD_BUILDINGS
ANLABAnalysis Laboratory CCIHE_ANLABCHAR10Assigned to domainALPHABU_PARTNER
ANLABNAMDescription of Analysis Lab CCIHE_ANLABNAMCHAR40BU_NAME
REMARKInstructions for Measurement Method CCIHE_METINSTRUCTCHAR132CCIHD_METINSTRUCT
MPTYPEMeasurement Project Type CCIHE_MPTYPECHAR3Assigned to domainCCIHD_MPTYPE
EPQUNITNAMUnit of Measurement CCIHE_EPQUNITNAMCHAR6MSEH6
HQVCHAR12Total Volume in Liters CCIHE_VOLUME_CHARCHAR12CHAR12
MDURATION_MINActual Measurement Duration (in Minutes) CCIHE_MDURATION_MINCHAR4CHAR4
MPLDURATION_MINPlanned Measurement Duration in Minutes CCIHE_MPLDURATION_MINCHAR4CHAR4
CTAREANAMDescription of Controlling Area CCIHE_CTRAREANAMCHAR25TEXT25
OPCONDTXTDescription of Operation Status CCIHE_OPCONDTXTCHAR30TEXT30
AIRCONDTXTDescription of Ventilation During Measurement CCIHE_AIRCONDTXTCHAR132TEXT132
PROTEQUITXTName of Safety Device During Measurement CCIHE_PROTEQUITXTCHAR132TEXT132
FLOWUNITNAMFlow Unit CCIHE_FLOWUNITNAMCHAR6CCIHV_UNITMSEH6
MSRTEMPUNITNAMTemperature Unit During Measurement CCIHE_MSRTEMPUNITNAMCHAR6CCIHV_UNITMSEH6
AIRHUMUNITNAMAir Humidity Unit During Measurement CCIHE_AIRHUMUNITNAMCHAR6CCIHV_UNITMSEH6

Key field Non-key field



How do I retrieve data from SAP structure CCIHS_MJIOT using ABAP code?

As CCIHS_MJIOT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CCIHS_MJIOT as there is no data to select.

How to access SAP table CCIHS_MJIOT

Within an ECC or HANA version of SAP you can also view further information about CCIHS_MJIOT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!