C_EHSAmountsQuery

Environmental Data - Query | view: CEHSAMNTSQUERY | Extraction: Not supported | Component: Environment Management
Tables used: EHFNDD_LOC_CLSF, EHENVD_CDEF_RESH, EHENVD_CDEF_ROOT, EHFNDD_CHM_BINFO, EHFNDD_CHM_BINFO, EHFNDD_CHM_NAME, EHFNDD_CHM_REV, EHFNDD_CHM_ROOT, T001, TKA02, TKA01, CSKS, CSKS, CSKT, T005, T005T, EHENVD_MDEF_ROOT, EHENVD_CDEF_ACLA, EHFNDD_PHPR_RT, EHFNDD_PHPR_NM, EHFNDD_CLSF_RT, EHENVD_ACLA_ROOT, EHENVD_MDEF_ACLA, EHFNDD_LHR_REV, EHFNDD_LOC_RESP, EHFNDD_LOC_REV, EHFNDD_LOC_TEXT, EHFNDD_LOC_ROOT, EHFNDC_LOC_TYP, EHFNDC_LOC_TYP_T, EHFNDD_LHR_PATH, EHENVC_MDEF_RO, EHFNDD_LOC_RESP, EHFNDD_LISU_RT, EHFNDD_LISU_NAME, EHENVD_ADEF_ROOT, SOTR_TEXT, T001W, MAKT, T005S, T005U, EHENVD_SDEF_ROOT, EHENVD_SDEF_HEAD, EHENVD_SDEF_SAMP, T000, T006, T006T, T006A, EHFNDD_LISU_NAME, EHFNDD_LISU_RT, HRP1000, EHFNDI_LISU_RT, EHFNDI_LISU_NAME, T527X, T527X, EHFNDI_LISU_RT
Column Name Description
Column Name Description
Column Name Description
Column Name Description
EHSAmountUTCDate Date
Column Name Description
EHSAmountSourceType Data Source Type Show values
EHSAmountIsReplaced Substituted Value Show values
EHSAmountIsPreliminary Preliminary Result Show values
EHSAmountStatus Amount Status Show values
DataUsagePeriodicity Data Period of Data Collection Definition Show values
EHSAmountIssueType Amount Issue Type Values Show values
EHSSubjectType Subject Type Show values
Column Name Description Domain name
EHSAmountUUID NodeID /BOBF/CONF_KEY
EHSAmountSourceTypeName Text Field in OTR SOTR_TXT
EHSAmountUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
EHSAmountUTCYearMonth Calendar Year and Month EHFND_YEARMONTH
EHSAmountUTCYear Year EHFND_YEAR
EHSAmountValue Amount Value EHFND_AMNS_VALUE_NC
UnitOfMeasureName Unit of Measurement Text (Maximum 10 Characters) TEXT10
UnitOfMeasureDimension Physical Dimension EHFND_UNIT_DIMENSION_NC
UnitOfMeasureDimensionName Dimension text TEXT20
EHSAmountDeviationID Business Object ID EHFND_BO_ID
EHSAmountStatusName Short Text for Fixed Values DDTEXT
EHSAmountExternalSource External Source CHAR80
EHSComplianceScenActivityID Data Collection Definition ID EHFND_BO_ID
EHSComplianceScenActivityName Data Collection Definition Name EHFND_DESCRIPTION_L
EHSComplianceScenActivityTitle Description (Long) EHFND_DESCRIPTION_L
EHSDataPeriodText Short Text for Fixed Values DDTEXT
EHSAmountIssueTypeText Short Text for Fixed Values DDTEXT
EHSLocationName Location EHFND_DESCRIPTION_S
EHSLocationType Location Type EHFND_LOC_TYPE_CODE_NC
EHSLocationTypeText Location Type Description EHFND_DESCRIPTION_XS
Country Country/Region LAND1
CountryName Country/Region Name TEXT50
Region Region REGIO
RegionName Description TEXT20
Plant Plant ID WERKS
PlantName Plant Name TEXT30
OrganizationalUnit Organizational Unit ID EHFND_ORG_UNIT_ID_NC
OrganizationalUnitName Short Text of Organizational Unit TEXT25
ControllingArea Controlling Area CACCD
ControllingAreaName Controlling Area Name TEXT25
CostCenter Cost Center KOSTL
CostCenterName Cost Center Name TEXT20
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
EHSLocationID Location ID EHFND_BO_ID
EHSLocClassifiersText List of Classifiers (Comma Separated) - short EHFND_DESCRIPTION_XL
EHSSubjectText Name EHFND_DESCRIPTION_S
EHSSubjectID ID EHFND_BO_ID
CASNumber CAS Number TEXT20
EHSDataClassifierID Data Classifier for Location Aggregation EHENV_AGGR_CLASSIFIER
EHSDataClassifiersText Data Classifiers EHFND_DESCRIPTION_XL
EHSLocClassifierID BCO ID
EHSMainLocationID Location ID EHFND_BO_ID
NumberOfRecords null
EHSAmountDataSumQuantity null
EHSAmountDataMaxQuantity Amount Value EHFND_AMNS_VALUE_NC
EHSAmountDataMinQuantity Amount Value EHFND_AMNS_VALUE_NC
EHSAmountDataAvgQuantity null