@AbapCatalog.sqlViewName: 'IEHSDATASET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Data Sets'
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'EHSComplianceScenActivityUUID'
@ObjectModel:
{
usageType:
{
dataClass: #MIXED,
sizeCategory: #XL, // < 100.000.000 for OTRs
serviceQuality: #D
}
}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_EHSDataSet
as select from I_DataCollectionRootBasic as DataCollectionRootBasic
left outer to one join I_EHSCmplncScenDataColl as EHSScenDataColl on DataCollectionRootBasic.DataCollectionUUID = EHSScenDataColl.DataCollectionUUID
left outer to one join I_EHSCmplncScenRoot as EHSScenRoot on EHSScenDataColl.EHSComplianceScenarioRootUUID = EHSScenRoot.EHSComplianceScenarioRootUUID
association [1..1] to I_EHSLocationRoot as _EHSLocationRoot on $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID
association [0..*] to I_EHSLocationRevisionBasic as _EHSLocationRevisionBasic on $projection.EHSLocationUUID = _EHSLocationRevisionBasic.EHSLocationUUID
association [1..1] to I_LocationDescFallbackLang as _LocTextDesc on $projection.EHSLocationUUID = _LocTextDesc.EHSLocationUUID
association [0..1] to I_EHSLocationTypeText as _EHSLocationTypeText on $projection.EHSLocationType = _EHSLocationTypeText.EHSLocationType
and _EHSLocationTypeText.Language = $session.system_language
association [0..*] to I_OTRText as _OTRText on _OTRText.Language = $session.system_language
{
key DataCollectionRootBasic.DataCollectionUUID as EHSComplianceScenActivityUUID,
DataCollectionRootBasic.DataCollectionTitle as EHSClassifiedDataTitle,
DataCollectionRootBasic.DataCollectionName as EHSClassifiedDataName,
_LocTextDesc.EHSLocationName as EHSLocationName,
_LocTextDesc.EHSLocationType as EHSLocationType,
DataCollectionRootBasic.EHSLocationUUID,
cast( '02' as char2 ) as EHSAmountSourceType,
_OTRText[1: OnlnTxtRpstryConceptID = '005056B252701EE3978D93FD8D4489AA'].Text as EHSAmountSourceTypeName,
_EHSLocationRoot,
_EHSLocationRevisionBasic,
_LocTextDesc,
_EHSLocationTypeText
}
where
EHSScenRoot.EHSComplianceScenarioStatus <> '03' //Exclude historic
union select from I_CalcDefResultHeader as CalcDefResultHeader
left outer to one join I_EHSCalculationDefinitionRoot as EHSCalculationDefinitionRoot on CalcDefResultHeader.CalculationRootUUID = EHSCalculationDefinitionRoot.CalculationRootUUID
left outer to one join I_EHSCmplncScenCalc as EHSScenCalc on EHSCalculationDefinitionRoot.CalculationRootUUID = EHSScenCalc.CalculationRootUUID
left outer to one join I_EHSCmplncScenRoot as EHSScenRoot on EHSScenCalc.EHSComplianceScenarioRootUUID = EHSScenRoot.EHSComplianceScenarioRootUUID
association [1..1] to I_EHSLocationRoot as _EHSLocationRoot on $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID
association [0..*] to I_EHSLocationRevisionBasic as _EHSLocationRevisionBasic on $projection.EHSLocationUUID = _EHSLocationRevisionBasic.EHSLocationUUID
association [1..1] to I_LocationDescFallbackLang as _LocTextDesc on $projection.EHSLocationUUID = _LocTextDesc.EHSLocationUUID
association [0..1] to I_EHSLocationTypeText as _EHSLocationTypeText on $projection.EHSLocationType = _EHSLocationTypeText.EHSLocationType
and _EHSLocationTypeText.Language = $session.system_language
association [0..*] to I_OTRText as _OTRText on _OTRText.Language = $session.system_language
{
key CalcDefResultHeader.CalculationResultHeaderUUID as EHSComplianceScenActivityUUID,
CalcDefResultHeader.CalculationResultHeaderTitle as EHSClassifiedDataTitle,
CalcDefResultHeader.CalculationResultHeaderName as EHSClassifiedDataName,
_LocTextDesc.EHSLocationName as EHSLocationName,
_LocTextDesc.EHSLocationType as EHSLocationType,
CalcDefResultHeader.EHSLocationUUID,
cast( '04' as char2 ) as EHSAmountSourceType,
_OTRText[1: OnlnTxtRpstryConceptID = '005056BA2F5A1ED4A6E0C82797B9CDB9'].Text as EHSAmountSourceTypeName,
_EHSLocationRoot,
_EHSLocationRevisionBasic,
_LocTextDesc,
_EHSLocationTypeText
}
where
EHSScenRoot.EHSComplianceScenarioStatus <> '03' //Exclude historic
union select from I_SamplingHeader as SamplingHeader
left outer to one join I_SamplingDefinitionRoot as SamplingDefinitionRoot on SamplingHeader.SamplingDefinitionUUID = SamplingDefinitionRoot.SamplingDefinitionUUID
left outer to one join I_EHSCmplncScenSmplg as EHSScenSmplg on SamplingDefinitionRoot.SamplingDefinitionUUID = EHSScenSmplg.SamplingDefinitionUUID
left outer to one join I_EHSCmplncScenRoot as EHSScenRoot on EHSScenSmplg.EHSComplianceScenarioRootUUID = EHSScenRoot.EHSComplianceScenarioRootUUID
association [1..1] to I_EHSLocationRoot as _EHSLocationRoot on $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID
association [0..*] to I_EHSLocationRevisionBasic as _EHSLocationRevisionBasic on $projection.EHSLocationUUID = _EHSLocationRevisionBasic.EHSLocationUUID
association [1..1] to I_LocationDescFallbackLang as _LocTextDesc on $projection.EHSLocationUUID = _LocTextDesc.EHSLocationUUID
association [0..1] to I_EHSLocationTypeText as _EHSLocationTypeText on $projection.EHSLocationType = _EHSLocationTypeText.EHSLocationType
and _EHSLocationTypeText.Language = $session.system_language
association [0..*] to I_OTRText as _OTRText on _OTRText.Language = $session.system_language
{
key SamplingHeader.SamplingHeaderUUID as EHSComplianceScenActivityUUID,
SamplingHeader.SamplingHeaderTitle as EHSClassifiedDataTitle,
SamplingDefinitionRoot.SamplingDefinitionName as EHSClassifiedDataName,
_LocTextDesc.EHSLocationName as EHSLocationName,
_LocTextDesc.EHSLocationType as EHSLocationType,
SamplingDefinitionRoot.EHSLocationUUID,
cast( '05' as char2 ) as EHSAmountSourceType,
_OTRText[1: OnlnTxtRpstryConceptID = 'CEE10E4D29800E2BE10000000A4288A0'].Text as EHSAmountSourceTypeName,
_EHSLocationRoot,
_EHSLocationRevisionBasic,
_LocTextDesc,
_EHSLocationTypeText
}
where
EHSScenRoot.EHSComplianceScenarioStatus <> '03' //Exclude historic
union select from I_LocAggregationRoot as LocAggregation
left outer to one join I_EHSCmplncScenLocAggrgn as EHSScenAggrgn on LocAggregation.LocAggregationUUID = EHSScenAggrgn.LocAggregationUUID
left outer to one join I_EHSCmplncScenRoot as EHSScenRoot on EHSScenAggrgn.EHSComplianceScenarioRootUUID = EHSScenRoot.EHSComplianceScenarioRootUUID
association [1..1] to I_EHSLocationRoot as _EHSLocationRoot on $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID
association [0..*] to I_EHSLocationRevisionBasic as _EHSLocationRevisionBasic on $projection.EHSLocationUUID = _EHSLocationRevisionBasic.EHSLocationUUID
association [1..1] to I_LocationDescFallbackLang as _LocTextDesc on $projection.EHSLocationUUID = _LocTextDesc.EHSLocationUUID
association [0..1] to I_EHSLocationTypeText as _EHSLocationTypeText on $projection.EHSLocationType = _EHSLocationTypeText.EHSLocationType
and _EHSLocationTypeText.Language = $session.system_language
association [0..*] to I_OTRText as _OTRText on _OTRText.Language = $session.system_language
{
key LocAggregation.LocAggregationUUID as EHSComplianceScenActivityUUID,
LocAggregation.LocAggregationTitle as EHSClassifiedDataTitle,
LocAggregation.LocAggregationName as EHSClassifiedDataName,
_LocTextDesc.EHSLocationName as EHSLocationName,
_LocTextDesc.EHSLocationType as EHSLocationType,
LocAggregation.EHSLocationUUID,
cast( '06' as char2 ) as EHSAmountSourceType,
_OTRText[1: OnlnTxtRpstryConceptID = '005056BA2F5A1ED58995A0C9EBC58643'].Text as EHSAmountSourceTypeName,
_EHSLocationRoot,
_EHSLocationRevisionBasic,
_LocTextDesc,
_EHSLocationTypeText
}
where
EHSScenRoot.EHSComplianceScenarioStatus <> '03' //Exclude historic
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALCDEFRESULTHEADER",
"I_DATACOLLECTIONROOTBASIC",
"I_EHSCALCULATIONDEFINITIONROOT",
"I_EHSCMPLNCSCENCALC",
"I_EHSCMPLNCSCENDATACOLL",
"I_EHSCMPLNCSCENLOCAGGRGN",
"I_EHSCMPLNCSCENROOT",
"I_EHSCMPLNCSCENSMPLG",
"I_LOCAGGREGATIONROOT",
"I_LOCATIONDESCFALLBACKLANG",
"I_OTRTEXT",
"I_SAMPLINGDEFINITIONROOT",
"I_SAMPLINGHEADER"
],
"ASSOCIATED":
[
"I_EHSLOCATIONREVISIONBASIC",
"I_EHSLOCATIONROOT",
"I_EHSLOCATIONTYPETEXT",
"I_LOCATIONDESCFALLBACKLANG",
"I_OTRTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/