I_UtilitiesInstallationHist

DDL: I_UTILITIESINSTALLATIONHIST SQL: IEINSTHISTORY Type: view BASIC

Installation History

I_UtilitiesInstallationHist is a Basic CDS View (Dimension) that provides data about "Installation History" in SAP S/4HANA. It reads from 1 data source (eanlh) and exposes 30 fields with key fields UtilitiesInstallation, UtilsInstHistValidityEndDate. It has 9 associations to related views.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
eanlh eanlh from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_UtilitiesInstallation _UtilitiesInstallation $projection.UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation
[0..1] I_UtilsDepdntValdtnGroup _UtilsDepdntValdtnGroup $projection.UtilsRegDepdntValdtnGroup = _UtilsDepdntValdtnGroup.UtilsRegDepdntValdtnGroup
[0..1] I_UtilsUnbilldRevnXtrapltnType _UtilsUnbilldRevnXtrapltnType $projection.UnbilldRevnXtrapltnType = _UtilsUnbilldRevnXtrapltnType.UnbilldRevnXtrapltnType
[0..1] I_UtilsInstGroupType _UtilsInstGroupType $projection.UtilsInstallationGroupType = _UtilsInstGroupType.UtilsInstallationGroupType
[0..1] I_UtilsInstGroupRole _UtilsInstGroupRole $projection.UtilsInstallationGroupRole = _UtilsInstGroupRole.UtilsInstallationGroupRole
[0..1] I_UtilsTemperatureArea _UtilsTemperatureArea $projection.UtilitiesTemperatureArea = _UtilsTemperatureArea.UtilitiesTemperatureArea
[0..1] I_UtilsBillingClass _UtilsBillingClass $projection.UtilitiesBillingClass = _UtilsBillingClass.UtilitiesBillingClass
[1..1] I_UtilitiesRateCategory _UtilitiesRateCategory $projection.UtilitiesRateCategory = _UtilitiesRateCategory.UtilitiesRateCategory
[1..1] I_MeterReadingUnit _MeterReadingUnit $projection.MeterReadingUnit = _MeterReadingUnit.MeterReadingUnit

Annotations (14)

NameValueLevelField
EndUserText.label Installation History view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey UtilitiesInstallation view
AbapCatalog.sqlViewName IEINSTHISTORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesInstallation eanlh anlage
KEY UtilsInstHistValidityEndDate
UtilsInstHistValidityStartDate
UtilitiesRateCategory eanlh tariftyp
UtilitiesBillingSchema eanlh schemanr
UtilitiesBillingClass eanlh aklasse
MeterReadingUnit eanlh ableinh
UtilitiesTemperatureArea eanlh temp_area
UtilsInstIsExmptFrmFrnchsFee eanlh konzbefr
UtilsInstDvceAllctnIsNotAllwd eanlh pauschal
UtilitiesFranchiseContract eanlh konzver
UtilitiesBillingParty eanlh billing_party
UtilitiesInvoicingParty eanlh invoicing_party
ObligatorySupUtilsSrvcProvider eanlh prov_last_res
PrimaryUtilitiesInstallation eanlh maininst
UtilsInstallationGroupRole eanlh instrole
UtilsInstallationGroupType eanlh instgrtype
HigherLevelUtilsInstallation eanlh highlevinst
UnbilldRevnXtrapltnType eanlh hochart
UtilsRegDepdntValdtnGroup eanlh pruefgr
IndustrySector
_UtilsDepdntValdtnGroup _UtilsDepdntValdtnGroup
_UtilsUnbilldRevnXtrapltnType _UtilsUnbilldRevnXtrapltnType
_UtilsInstGroupType _UtilsInstGroupType
_UtilsInstGroupRole _UtilsInstGroupRole
_UtilsTemperatureArea _UtilsTemperatureArea
_UtilsBillingClass _UtilsBillingClass
_UtilitiesInstallation _UtilitiesInstallation
_UtilitiesRateCategory _UtilitiesRateCategory
_MeterReadingUnit _MeterReadingUnit 
@EndUserText.label: 'Installation History'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.representativeKey: 'UtilitiesInstallation'
@AbapCatalog.sqlViewName: 'IEINSTHISTORY'
//@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
@Metadata.allowExtensions:true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION

define view I_UtilitiesInstallationHist
  as select from eanlh
  association [1..1] to I_UtilitiesInstallation        as _UtilitiesInstallation        on $projection.UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation

  association [0..1] to I_UtilsDepdntValdtnGroup       as _UtilsDepdntValdtnGroup       on $projection.UtilsRegDepdntValdtnGroup = _UtilsDepdntValdtnGroup.UtilsRegDepdntValdtnGroup
  association [0..1] to I_UtilsUnbilldRevnXtrapltnType as _UtilsUnbilldRevnXtrapltnType on $projection.UnbilldRevnXtrapltnType = _UtilsUnbilldRevnXtrapltnType.UnbilldRevnXtrapltnType
  association [0..1] to I_UtilsInstGroupType           as _UtilsInstGroupType           on $projection.UtilsInstallationGroupType = _UtilsInstGroupType.UtilsInstallationGroupType
  association [0..1] to I_UtilsInstGroupRole           as _UtilsInstGroupRole           on $projection.UtilsInstallationGroupRole = _UtilsInstGroupRole.UtilsInstallationGroupRole
  association [0..1] to I_UtilsTemperatureArea         as _UtilsTemperatureArea         on $projection.UtilitiesTemperatureArea = _UtilsTemperatureArea.UtilitiesTemperatureArea
  association [0..1] to I_UtilsBillingClass            as _UtilsBillingClass            on $projection.UtilitiesBillingClass = _UtilsBillingClass.UtilitiesBillingClass
  //association [0..1] to I_Industries  as _Industries on $projection.IndustrySector = _Industries.IndustrySector

  association [1..1] to I_UtilitiesRateCategory        as _UtilitiesRateCategory        on $projection.UtilitiesRateCategory = _UtilitiesRateCategory.UtilitiesRateCategory
  association [1..1] to I_MeterReadingUnit             as _MeterReadingUnit             on $projection.MeterReadingUnit = _MeterReadingUnit.MeterReadingUnit
{
  key eanlh.anlage                                            as UtilitiesInstallation,
      @Semantics.businessDate.to: true
  key cast(eanlh.bis as e_inst_end_vdm preserving type)       as UtilsInstHistValidityEndDate,
      @Semantics.businessDate.from: true
      cast(eanlh.ab  as e_inst_start_vdm preserving type)     as UtilsInstHistValidityStartDate,
      //    key eanlh.anlage as UtilitiesInstallation,

      //    @Semantics.businessDate.to: true

      //    key eanlh.bis                                      as UtilsInstHistValidityEndDate,

      //        @Semantics.businessDate.from: true

      //        eanlh.ab                                       as UtilsInstHistValidityStartDate,

      @ObjectModel.foreignKey.association: '_UtilitiesRateCategory'
      eanlh.tariftyp                                          as UtilitiesRateCategory,
      eanlh.schemanr                                          as UtilitiesBillingSchema,
      @ObjectModel.foreignKey.association: '_UtilsBillingClass'
      eanlh.aklasse                                           as UtilitiesBillingClass,
      @ObjectModel.foreignKey.association: '_MeterReadingUnit'
      eanlh.ableinh                                           as MeterReadingUnit,
      @ObjectModel.foreignKey.association: '_UtilsTemperatureArea'
      eanlh.temp_area                                         as UtilitiesTemperatureArea,
      @Semantics.booleanIndicator: true
      eanlh.konzbefr                                          as UtilsInstIsExmptFrmFrnchsFee,
      @Semantics.booleanIndicator: true
      eanlh.pauschal                                          as UtilsInstDvceAllctnIsNotAllwd,
      eanlh.konzver                                           as UtilitiesFranchiseContract,
      eanlh.billing_party                                     as UtilitiesBillingParty,
      eanlh.invoicing_party                                   as UtilitiesInvoicingParty,
      eanlh.prov_last_res                                     as ObligatorySupUtilsSrvcProvider,
      eanlh.maininst                                          as PrimaryUtilitiesInstallation,
      @ObjectModel.foreignKey.association: '_UtilsInstGroupRole'
      eanlh.instrole                                          as UtilsInstallationGroupRole,
      @ObjectModel.foreignKey.association: '_UtilsInstGroupType'
      eanlh.instgrtype                                        as UtilsInstallationGroupType,
      eanlh.highlevinst                                       as HigherLevelUtilsInstallation,
      @ObjectModel.foreignKey.association: '_UtilsUnbilldRevnXtrapltnType'
      eanlh.hochart                                           as UnbilldRevnXtrapltnType,
      @ObjectModel.foreignKey.association: '_UtilsDepdntValdtnGroup'
      eanlh.pruefgr                                           as UtilsRegDepdntValdtnGroup,
      cast ( eanlh.branche as bu_ind_sector preserving type ) as IndustrySector,

      _UtilsDepdntValdtnGroup,
      _UtilsUnbilldRevnXtrapltnType,
      _UtilsInstGroupType,
      _UtilsInstGroupRole,
      _UtilsTemperatureArea,
      _UtilsBillingClass,
      _UtilitiesInstallation,
      //    _Industries

      _UtilitiesRateCategory,
      _MeterReadingUnit

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EANLH"
],
"ASSOCIATED":
[
"I_METERREADINGUNIT",
"I_UTILITIESINSTALLATION",
"I_UTILITIESRATECATEGORY",
"I_UTILSBILLINGCLASS",
"I_UTILSDEPDNTVALDTNGROUP",
"I_UTILSINSTGROUPROLE",
"I_UTILSINSTGROUPTYPE",
"I_UTILSTEMPERATUREAREA",
"I_UTILSUNBILLDREVNXTRAPLTNTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More