@EndUserText.label: 'Information Record History And Installation' //same as DDL description
//@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IEINFRECHANDINST'
@ObjectModel.usageType.serviceQuality: 'C'
@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.dataClass: 'MIXED'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
define view I_UtilsInfoRecdHistAndInst
as select from I_UtilsDeviceRateData
inner join I_UtilsDvceInfoRecordHistory on I_UtilsDeviceRateData.UtilitiesLogicalDeviceNumber = I_UtilsDvceInfoRecordHistory.UtilitiesLogicalDeviceNumber
inner join I_UtilitiesInstallationHist on I_UtilsDeviceRateData.UtilsInstallationDvceRateData = I_UtilitiesInstallationHist.UtilitiesInstallation
association [1..1] to I_UtilitiesInstallation as _UtilitiesInstallation on $projection.UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation
{
I_UtilsDeviceRateData.UtilitiesInstallation,
I_UtilsDeviceRateData.UtilitiesLogicalDeviceNumber,
@Semantics.businessDate.at: true
I_UtilsDeviceRateData.UtilsDvceRateDataValdtyEndDte,
//Rate data
@Semantics.businessDate.at: true
I_UtilsDeviceRateData.UtilsDvceRateDataValdtyStrtDte,
@ObjectModel.foreignKey.association: '_UtilsDevicePriceClass'
I_UtilsDeviceRateData.UtilsDevicePriceClass,
I_UtilsDeviceRateData.UtilsDvceIsRelevantForRntlPrc,
@ObjectModel.foreignKey.association: '_UtilsDeviceRateType'
I_UtilsDeviceRateData.UtilsDeviceRateType,
@ObjectModel.foreignKey.association: '_UtilsDeviceRateFactGrp'
I_UtilsDeviceRateData.UtilsDeviceRateFactGroup,
I_UtilsDeviceRateData.UtilsDvceIsNotBillingRelevant,
I_UtilsDeviceRateData._UtilsDevicePriceClass,
I_UtilsDeviceRateData._UtilsDeviceRateFactGrp,
I_UtilsDeviceRateData._UtilsDeviceRateType,
// Device Info Record
I_UtilsDvceInfoRecordHistory.UtilitiesDeviceInfoRecord,
@Semantics.businessDate.at: true
I_UtilsDvceInfoRecordHistory.UtilsDeviceValidityEndDate,
@Semantics.businessDate.at: true
I_UtilsDvceInfoRecordHistory.UtilsDeviceValidityStartDate,
@ObjectModel.foreignKey.association: '_UtilsRegisterGroupInfoText'
I_UtilsDvceInfoRecordHistory.UtilitiesRegisterGroup,
I_UtilsDvceInfoRecordHistory.UtilitiesDeviceCategory,
I_UtilsDvceInfoRecordHistory.UtilsDeviceBscCatCombination,
@Semantics.businessDate.at: true
I_UtilsDvceInfoRecordHistory.UtilsDeviceInstallationDate,
@Semantics.businessDate.at: true
I_UtilsDvceInfoRecordHistory.UtilsDeviceRemovalDate,
I_UtilsDvceInfoRecordHistory.UtilsDeviceGroup,
I_UtilsDvceInfoRecordHistory.UtilitiesPrepaymentMeterType,
@ObjectModel.foreignKey.association: '_UtilsDvceLossDetnGroup'
I_UtilsDvceInfoRecordHistory.UtilsDeviceLossDetnGroup,
I_UtilsDvceInfoRecordHistory.DvcePwrTrnsfrmtrPrimVoltVal,
I_UtilsDvceInfoRecordHistory.DvcePwrTrnsfrmtrSecdryVoltVal,
I_UtilsDvceInfoRecordHistory.DvcePwrTrnsfrmtrTrnsfRatingVal,
@ObjectModel.foreignKey.association: '_UtilsAdvncdMeteringSystem'
I_UtilsDvceInfoRecordHistory.AdvancedMeteringSystem,
I_UtilsDvceInfoRecordHistory.AdvancedMeterCapabilityGroup,
I_UtilsDvceInfoRecordHistory.UniqueItemIdentifier,
I_UtilsDvceInfoRecordHistory.UtilsDeviceWindingGroup,
I_UtilsDvceInfoRecordHistory.UtilsDeviceInfoRecdSrvcPrvd,
I_UtilsDvceInfoRecordHistory.SerialNumber,
I_UtilsDvceInfoRecordHistory.UtilsInfoRecdAuthorizationGrp,
I_UtilsDvceInfoRecordHistory._UtilsAdvncdMeteringSystem,
I_UtilsDvceInfoRecordHistory._UtilsDvceLossDetnGroup,
I_UtilsDvceInfoRecordHistory._UtilsRegisterGroupInfoText,
// Installation
@ObjectModel.foreignKey.association: '_UtilsInstallationType'
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesInstallationType,
@ObjectModel.foreignKey.association: '_UtilsInstVltgLevel'
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesInstVoltageLevel,
@ObjectModel.foreignKey.association: '_UtilsInstGasPressureLvl'
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesInstGasPrssrLvl,
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstTimeZone,
@ObjectModel.foreignKey.association: '_UtilsInstGuarOfSupRsn'
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstGuarOfSupReason,
@ObjectModel.foreignKey.association: '_UtilsInstDeregulationSts'
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstDeregulationSts,
@ObjectModel.foreignKey.association: '_UtilsInstDataReleaseSts'
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstDataReleaseStatus,
@ObjectModel.foreignKey.association: '_UtilsServiceProviderRole'
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesSrvcProviderRole,
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstIsForEnergyFeedIn,
@Semantics.businessDate.createdAt: true
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstCreationDate,
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstCreatedByUser,
@Semantics.businessDate.lastChangedAt: true
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstLastChangeDate,
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilsInstLastChangedByUser,
@ObjectModel.foreignKey.association: '_UtilsMtrRdngBlockReason'
I_UtilitiesInstallationHist._UtilitiesInstallation.MeterReadingBlockingReason,
@ObjectModel.foreignKey.association: '_UtilsMtrRdngBasePerdCat'
I_UtilitiesInstallationHist._UtilitiesInstallation.MeterReadingBasePeriodCat,
@ObjectModel.foreignKey.association: '_UtilsNmbrOfAllwdMRCtrlCode'
I_UtilitiesInstallationHist._UtilitiesInstallation.NmbrOfAllwdMtrRdngsCntrlCode,
I_UtilitiesInstallationHist._UtilitiesInstallation.IsMarkedForDeletion,
I_UtilitiesInstallationHist._UtilitiesInstallation.UtilitiesPremise,
I_UtilitiesInstallationHist._UtilitiesInstallation.AuthorizationGroup,
@ObjectModel.foreignKey.association: '_Division'
I_UtilitiesInstallationHist._UtilitiesInstallation.Division,
I_UtilitiesInstallationHist._UtilitiesInstallation._Division,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstallationType,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstCreatedByUser,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstDataReleaseSts,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstDeregulationSts,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstGasPressureLvl,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstGuarOfSupRsn,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstLastChangedByUser,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsInstVltgLevel,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsMtrRdngBasePerdCat,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsMtrRdngBlockReason,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsNmbrOfAllwdMRCtrlCode,
I_UtilitiesInstallationHist._UtilitiesInstallation._UtilsServiceProviderRole,
_UtilitiesInstallation,
// Installation Hist
@Semantics.businessDate.at: true
I_UtilitiesInstallationHist.UtilsInstHistValidityEndDate,
@Semantics.businessDate.at: true
I_UtilitiesInstallationHist.UtilsInstHistValidityStartDate,
I_UtilitiesInstallationHist.UtilitiesRateCategory,
I_UtilitiesInstallationHist.UtilitiesBillingSchema,
@ObjectModel.foreignKey.association: '_UtilsBillingClass'
I_UtilitiesInstallationHist.UtilitiesBillingClass,
I_UtilitiesInstallationHist.MeterReadingUnit,
@ObjectModel.foreignKey.association: '_UtilsTemperatureArea'
I_UtilitiesInstallationHist.UtilitiesTemperatureArea,
I_UtilitiesInstallationHist.UtilsInstIsExmptFrmFrnchsFee,
I_UtilitiesInstallationHist.UtilsInstDvceAllctnIsNotAllwd,
I_UtilitiesInstallationHist.UtilitiesFranchiseContract,
I_UtilitiesInstallationHist.UtilitiesBillingParty,
I_UtilitiesInstallationHist.UtilitiesInvoicingParty,
I_UtilitiesInstallationHist.ObligatorySupUtilsSrvcProvider,
I_UtilitiesInstallationHist.PrimaryUtilitiesInstallation,
@ObjectModel.foreignKey.association: '_UtilsInstGroupRole'
I_UtilitiesInstallationHist.UtilsInstallationGroupRole,
@ObjectModel.foreignKey.association: '_UtilsInstGroupType'
I_UtilitiesInstallationHist.UtilsInstallationGroupType,
I_UtilitiesInstallationHist.HigherLevelUtilsInstallation,
@ObjectModel.foreignKey.association: '_UtilsUnbilldRevnXtrapltnType'
I_UtilitiesInstallationHist.UnbilldRevnXtrapltnType,
@ObjectModel.foreignKey.association: '_UtilsDepdntValdtnGroup'
I_UtilitiesInstallationHist.UtilsRegDepdntValdtnGroup,
I_UtilitiesInstallationHist._UtilsBillingClass,
I_UtilitiesInstallationHist._UtilsDepdntValdtnGroup,
I_UtilitiesInstallationHist._UtilsInstGroupRole,
I_UtilitiesInstallationHist._UtilsInstGroupType,
I_UtilitiesInstallationHist._UtilsTemperatureArea,
I_UtilitiesInstallationHist._UtilsUnbilldRevnXtrapltnType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILITIESINSTALLATION",
"I_UTILITIESINSTALLATIONHIST",
"I_UTILSDEVICERATEDATA",
"I_UTILSDVCEINFORECORDHISTORY"
],
"ASSOCIATED":
[
"I_DIVISION",
"I_USER",
"I_UTILITIESINSTALLATION",
"I_UTILSADVNCDMETERINGSYSTEM",
"I_UTILSBILLINGCLASS",
"I_UTILSDEPDNTVALDTNGROUP",
"I_UTILSDEVICEPRICECLASS",
"I_UTILSDEVICERATEFACTGRP",
"I_UTILSDEVICERATETYPE",
"I_UTILSDVCELOSSDETNGROUP",
"I_UTILSINSTALLATIONTYPE",
"I_UTILSINSTDATARELEASESTS",
"I_UTILSINSTDEREGULATIONSTS",
"I_UTILSINSTGASPRESSURELVL",
"I_UTILSINSTGROUPROLE",
"I_UTILSINSTGROUPTYPE",
"I_UTILSINSTGUAROFSUPRSN",
"I_UTILSINSTVLTGLEVEL",
"I_UTILSMTRRDNGBASEPERDCAT",
"I_UTILSMTRRDNGBLOCKREASON",
"I_UTILSNMBROFALLWDMRCTRLCODE",
"I_UTILSREGISTERGROUPINFOTEXT",
"I_UTILSSERVICEPROVIDERROLE",
"I_UTILSTEMPERATUREAREA",
"I_UTILSUNBILLDREVNXTRAPLTNTYPE"
],
"BASE":
[
"I_UTILITIESINSTALLATION",
"I_UTILITIESINSTALLATIONHIST",
"I_UTILSDEVICERATEDATA",
"I_UTILSDVCEINFORECORDHISTORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/