I_EHSAmountsCube

Environmental Data - Cube | view: IEHSAMNTCUBE | TRAN | 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
EHSSubjectType Subject Type Show values
EHSAmountIsReplaced Substituted Value Show values
EHSAmountIsPreliminary Preliminary Result Show values
EHSAmountStatus Amount Status Show values
EHSLocationStatus Location Status Show values
Column Name Description Domain name
EHSAmountUUID NodeID
EHSSubjectUUID Reference to Subject Type BO Root Node ID
EHSAmountUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
EHSAmountUTCYearMonth Calendar Year and Month EHFND_YEARMONTH
EHSAmountUTCYear Year EHFND_YEAR
EHSAmountValue Amount Value EHFND_AMNS_VALUE_NC
UnitOfMeasureDimension Physical Dimension EHFND_UNIT_DIMENSION_NC
EHSAmountDeviationID Business Object ID
EHSAmountExternalSource External Source CHAR80
EHSComplianceScenActivityUUID NodeID
EHSComplianceScenActivityID Data Collection Definition ID
EHSComplianceScenActivityName Data Collection Definition Name
EHSComplianceScenActivityTitle Description (Long)
DataUsagePeriodicity Data Period of Data Collection Definition
EHSLocationUUID Location
EHSAmountIssueType Amount Issue Type Values
EHSAmountSourceTypeName Text Field in OTR
UnitOfMeasureName Unit of Measurement Text (Maximum 10 Characters)
UnitOfMeasureDimensionName Dimension text TEXT20
EHSAmountStatusName Short Text for Fixed Values
EHSDataPeriodText Short Text for Fixed Values
EHSAmountIssueTypeText Short Text for Fixed Values
EHSLocationName Location
EHSLocationType Location Type EHFND_LOC_TYPE_CODE_NC
EHSLocationTypeText Location Type Description
Country Country/Region LAND1
CountryName Country/Region Name TEXT50
Region Region REGIO
RegionName Description
Plant Plant ID WERKS
PlantName Plant Name TEXT30
OrganizationalUnit Organizational Unit ID EHFND_ORG_UNIT_ID_NC
OrganizationalUnitName Short Text of Organizational Unit
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
EHSLocationAuthorizationGroup Location Authorization Group EHFND_LOC_AUTH_GROUP_NC
BusinessArea Business Area GSBER
EHSLocationID Location ID EHFND_BO_ID
EHSLocClassifiersText List of Classifiers (Comma Separated) - short EHFND_DESCRIPTION_XL
EHSDataClassifiersText Data Classifiers EHFND_DESCRIPTION_XL
EHSSubjectID ID
CASNumber CAS Number TEXT20
EHSSubjectText Name
EHSDataClassifierID Data Classifier for Location Aggregation EHENV_AGGR_CLASSIFIER
EHSLocClassifierID BCO ID
EHSMainLocationID Location ID
NumberOfRecords null
EHSAmountDataMaxQuantity Amount Value
EHSAmountDataMinQuantity Amount Value