I_UtilitiesInstallation

@EndUserText.label: 'Installation'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.representativeKey: 'UtilitiesInstallation'
@AbapCatalog.sqlViewName: 'IEINSTALLATION'
//@AbapCatalog.preserveKey: true

@ObjectModel.usageType.serviceQuality: 'B'
@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.dataClass: 'MASTER'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #ANALYTICAL_DIMENSION, #ANALYTICAL_PROVIDER, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE ]
@AbapCatalog.compiler.compareFilter:true
//Privileged associations specified

@AccessControl.privilegedAssociations:  [ '_UtilsInstCreatedByUser', '_UtilsInstLastChangedByUser' ]
@Metadata.allowExtensions: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION

define view I_UtilitiesInstallation
  as select from eanl
  association [1..*] to I_UtilitiesInstallationHist  as _UtilitiesInstallationHist  on $projection.UtilitiesInstallation = _UtilitiesInstallationHist.UtilitiesInstallation
  association [0..1] to I_UtilsNmbrOfAllwdMRCtrlCode as _UtilsNmbrOfAllwdMRCtrlCode on $projection.NmbrOfAllwdMtrRdngsCntrlCode = _UtilsNmbrOfAllwdMRCtrlCode.NmbrOfAllwdMtrRdngsCntrlCode
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
  association [0..1] to I_UtilsMtrRdngBasePerdCat    as _UtilsMtrRdngBasePerdCat    on $projection.MeterReadingBasePeriodCat = _UtilsMtrRdngBasePerdCat.MeterReadingBasePeriodCat
  association [0..1] to I_UtilsMtrRdngBlockReason    as _UtilsMtrRdngBlockReason    on $projection.MeterReadingBlockingReason = _UtilsMtrRdngBlockReason.MeterReadingBlockingReason
  association [0..1] to I_UtilsServiceProviderRole   as _UtilsServiceProviderRole   on $projection.UtilitiesSrvcProviderRole = _UtilsServiceProviderRole.UtilitiesSrvcProviderRole
  association [0..1] to I_UtilsInstDataReleaseSts    as _UtilsInstDataReleaseSts    on $projection.UtilsInstDataReleaseStatus = _UtilsInstDataReleaseSts.UtilsInstDataReleaseStatus
  association [0..1] to I_UtilsInstDeregulationSts   as _UtilsInstDeregulationSts   on $projection.UtilsInstDeregulationSts = _UtilsInstDeregulationSts.UtilsInstDeregulationSts
  association [0..1] to I_UtilsInstGuarOfSupRsn      as _UtilsInstGuarOfSupRsn      on $projection.UtilsInstGuarOfSupReason = _UtilsInstGuarOfSupRsn.UtilsInstGuarOfSupReason
  association [0..1] to I_UtilsInstGasPressureLvl    as _UtilsInstGasPressureLvl    on $projection.UtilitiesInstGasPrssrLvl = _UtilsInstGasPressureLvl.UtilitiesInstGasPrssrLvl
  association [0..1] to I_UtilsInstVltgLevel         as _UtilsInstVltgLevel         on $projection.UtilitiesInstVoltageLevel = _UtilsInstVltgLevel.UtilitiesInstVoltageLevel
  association [0..1] to I_Division                   as _Division                   on $projection.Division = _Division.Division
  association [0..1] to I_UtilsInstallationType      as _UtilsInstallationType      on $projection.UtilitiesInstallationType = _UtilsInstallationType.UtilitiesInstallationType
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
  association [0..1] to I_User                       as _UtilsInstCreatedByUser     on $projection.UtilsInstCreatedByUser = _UtilsInstCreatedByUser.UserID
  association [0..1] to I_User                       as _UtilsInstLastChangedByUser on $projection.UtilsInstLastChangedByUser = _UtilsInstLastChangedByUser.UserID
  association [0..1] to I_UtilitiesPremise           as _UtilitiesPremise           on $projection.UtilitiesPremise = _UtilitiesPremise.UtilitiesPremise
  association [0..*] to I_UtilsAllocOfInstToPoD      as _UtilsAllocOfInstToPoD      on $projection.UtilitiesInstallation = _UtilsAllocOfInstToPoD.UtilitiesInstallation
{

  key eanl.anlage     as UtilitiesInstallation,
      @ObjectModel.foreignKey.association: '_UtilsInstallationType'
      eanl.anlart     as UtilitiesInstallationType,
      @ObjectModel.foreignKey.association: '_Division'
      eanl.sparte     as Division,
      @ObjectModel.foreignKey.association: '_UtilsInstVltgLevel'
      eanl.spebene    as UtilitiesInstVoltageLevel,
      @ObjectModel.foreignKey.association: '_UtilsInstGasPressureLvl'
      eanl.drckstuf   as UtilitiesInstGasPrssrLvl,
      eanl.etimezone  as UtilsInstTimeZone,
      @ObjectModel.foreignKey.association: '_UtilsInstGuarOfSupRsn'
      eanl.nodisconct as UtilsInstGuarOfSupReason,
      @ObjectModel.foreignKey.association: '_UtilsInstDeregulationSts'
      eanl.deregstat  as UtilsInstDeregulationSts,
      @ObjectModel.foreignKey.association: '_UtilsInstDataReleaseSts'
      eanl.inforel    as UtilsInstDataReleaseStatus,
      @ObjectModel.foreignKey.association: '_UtilsServiceProviderRole'
      eanl.service    as UtilitiesSrvcProviderRole,
      @Semantics.booleanIndicator: true
      eanl.bezug      as UtilsInstIsForEnergyFeedIn,
      @Semantics.businessDate.at: true
      eanl.erdat      as UtilsInstCreationDate,
      @Semantics.user.createdBy: true
      eanl.ernam      as UtilsInstCreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      eanl.aedat      as UtilsInstLastChangeDate,
      @Semantics.user.lastChangedBy: true
      eanl.aenam      as UtilsInstLastChangedByUser,
      @ObjectModel.foreignKey.association: '_UtilsMtrRdngBlockReason'
      eanl.ablsperr   as MeterReadingBlockingReason,
      @ObjectModel.foreignKey.association: '_UtilsMtrRdngBasePerdCat'
      eanl.bapertyp   as MeterReadingBasePeriodCat,
      @ObjectModel.foreignKey.association: '_UtilsNmbrOfAllwdMRCtrlCode'
      eanl.ablesartst as NmbrOfAllwdMtrRdngsCntrlCode,
      eanl.begru      as AuthorizationGroup,
      eanl.loevm      as IsMarkedForDeletion,
      @ObjectModel.foreignKey.association: '_UtilitiesPremise'
      eanl.vstelle    as UtilitiesPremise,
      eanl.altitude   as UtilitiesGeoLocAltitudeValue,

      /* Associations */
      _UtilsNmbrOfAllwdMRCtrlCode,
      _UtilsMtrRdngBasePerdCat,
      _UtilsMtrRdngBlockReason,
      _UtilsServiceProviderRole,
      _UtilsInstDataReleaseSts,
      _UtilsInstDeregulationSts,
      _UtilsInstGuarOfSupRsn,
      _UtilsInstGasPressureLvl,
      _UtilsInstVltgLevel,
      _Division,
      _UtilsInstallationType,
      _UtilsInstCreatedByUser,
      _UtilsInstLastChangedByUser,
      _UtilitiesInstallationHist,
      _UtilitiesPremise,
      _UtilsAllocOfInstToPoD

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EANL"
],
"ASSOCIATED":
[
"I_DIVISION",
"I_USER",
"I_UTILITIESINSTALLATIONHIST",
"I_UTILITIESPREMISE",
"I_UTILSALLOCOFINSTTOPOD",
"I_UTILSINSTALLATIONTYPE",
"I_UTILSINSTDATARELEASESTS",
"I_UTILSINSTDEREGULATIONSTS",
"I_UTILSINSTGASPRESSURELVL",
"I_UTILSINSTGUAROFSUPRSN",
"I_UTILSINSTVLTGLEVEL",
"I_UTILSMTRRDNGBASEPERDCAT",
"I_UTILSMTRRDNGBLOCKREASON",
"I_UTILSNMBROFALLWDMRCTRLCODE",
"I_UTILSSERVICEPROVIDERROLE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/