I_UTILSALLOCOFINSTTOPOD

CDS View

Allocation of Installation to Point of Delivery

I_UTILSALLOCOFINSTTOPOD is a CDS View in S/4HANA. Allocation of Installation to Point of Delivery. It contains 5 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 5 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
CRMS4_IU_C_PODDEV view inner Point of Delivery by Device
CRMS4_IU_P_CONPP view left_outer Conn. Objects, Premise, PoD tuples
CRMS4_IU_P_PODBP view inner Point of Delivery by Business Partner
I_UtilsBillgDocIntAndExtPoD view inner COMPOSITE Internal and External Point of Delivery for Billing Document
I_UtilsInstIntAndExtPtOfDeliv view from COMPOSITE Internal and External PoD for Utilities Installation

Fields (5)

KeyField CDS FieldsUsed in Views
KEY UtilitiesInstallation UtilitiesInstallation 2
KEY UtilsInternalPointOfDelivery INT_UI,UtilsInternalPointOfDelivery 6
_UtilitiesInstallation _UtilitiesInstallation 2
UtilsInstToPoDAllocEndDate UtilsInstToPoDAllocEndDate 1
UtilsInstToPoDAllocEndTime UtilsInstToPoDAllocEndTime 1 
@EndUserText.label: 'Allocation of Installation to Point of Delivery'
@VDM.viewType: #BASIC
// Analytics supports now only date based time dependency and not time based - DIMENSION data category cannot be defined

//@Analytics.dataCategory: #DIMENSION

@AbapCatalog.sqlViewName: 'IEALLOCINSTTOPOD'
//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL //#MASTER

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true
//@Metadata.allowExtensions:true

@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE ]
// Because of key fields date+time it is not possible to set a representative key and use a foreignKey association for UtilsPointOfDelivery

// Analytics supports now only date based time dependency and not time based

//@ObjectModel.representativeKey: 'UtilsInternalPointOfDelivery'

@ObjectModel.modelingPattern: #NONE

define view I_UtilsAllocOfInstToPoD
  as select from euiinstln
  association [1..1] to I_UtilitiesInstallation   as _UtilitiesInstallation   on $projection.UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation
  association [0..*] to I_UtilsAllocOfExtToIntPoD as _UtilsAllocOfExtToIntPoD on $projection.UtilsInternalPointOfDelivery = _UtilsAllocOfExtToIntPoD.UtilsInternalPointOfDelivery
{
  key int_ui        as UtilsInternalPointOfDelivery,
      @ObjectModel.foreignKey.association: '_UtilitiesInstallation'
  key anlage        as UtilitiesInstallation,
      @Semantics.businessDate.to: true
  key dateto        as UtilsInstToPoDAllocEndDate,
      @Semantics.time: true
  key timeto        as UtilsInstToPoDAllocEndTime,
      @Semantics.businessDate.from: true
      datefrom      as UtilsInstToPoDAllocStartDate,
      @Semantics.time: true
      timefrom      as UtilsInstToPoDAllocStartTime,
      @Semantics.booleanIndicator: true
      euirole_tech  as UtilsPtOfDeliveryIsTechnical,
      @Semantics.booleanIndicator: true
      euirole_dereg as UtilsPtOfDeliveryIsDeregulated,
      begru         as AuthorizationGroup,

      _UtilsAllocOfExtToIntPoD,
      _UtilitiesInstallation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EUIINSTLN"
],
"ASSOCIATED":
[
"I_UTILITIESINSTALLATION",
"I_UTILSALLOCOFEXTTOINTPOD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More