I_UtilsInstIntAndExtPtOfDeliv

DDL: I_UTILSINSTINTANDEXTPTOFDELIV SQL: IEUINSINTEXTPOD Type: view COMPOSITE

Internal and External PoD for Utilities Installation

I_UtilsInstIntAndExtPtOfDeliv is a Composite CDS View that provides data about "Internal and External PoD for Utilities Installation" in SAP S/4HANA. It reads from 2 data sources (I_UtilsAllocOfExtToIntPoD, I_UtilsAllocOfInstToPoD) and exposes 8 fields with key fields UtilsInternalPointOfDelivery, UtilitiesInstallation, UtilsPoDAllocValidityEndDate, UtilsPoDAllocValidityEndTime.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_UtilsAllocOfExtToIntPoD UtilsAllocOfExtToIntPoD inner
I_UtilsAllocOfInstToPoD UtilsAllocOfInstToPoD from

Annotations (8)

NameValueLevelField
EndUserText.label Internal and External PoD for Utilities Installation view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IEUINSINTEXTPOD view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY UtilsInternalPointOfDelivery I_UtilsAllocOfInstToPoD UtilsInternalPointOfDelivery
KEY UtilitiesInstallation I_UtilsAllocOfInstToPoD UtilitiesInstallation
KEY UtilsPoDAllocValidityEndDate I_UtilsAllocOfExtToIntPoD UtilsPoDAllocValidityEndDate
KEY UtilsPoDAllocValidityEndTime I_UtilsAllocOfExtToIntPoD UtilsPoDAllocValidityEndTime
UtilsPoDAllocValidityStartDate I_UtilsAllocOfExtToIntPoD UtilsPoDAllocValidityStartDate
UtilsPoDAllocValidityStartTime I_UtilsAllocOfExtToIntPoD UtilsPoDAllocValidityStartTime
UtilsExternalPointOfDelivery I_UtilsAllocOfExtToIntPoD UtilsExternalPointOfDelivery
_UtilitiesInstallation I_UtilsAllocOfInstToPoD _UtilitiesInstallation 
@EndUserText.label: 'Internal and External PoD for Utilities Installation'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IEUINSINTEXTPOD'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_UtilsInstIntAndExtPtOfDeliv  
  as select from I_UtilsAllocOfInstToPoD   as UtilsAllocOfInstToPoD
    inner join   I_UtilsAllocOfExtToIntPoD as UtilsAllocOfExtToIntPoD on UtilsAllocOfExtToIntPoD.UtilsInternalPointOfDelivery = UtilsAllocOfInstToPoD.UtilsInternalPointOfDelivery
{ 
  key UtilsAllocOfInstToPoD.UtilsInternalPointOfDelivery,

      @ObjectModel.foreignKey.association: '_UtilitiesInstallation'
  key UtilsAllocOfInstToPoD.UtilitiesInstallation,

  key UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityEndDate,

      @Semantics.time: true
  key UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityEndTime,

      UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityStartDate,

      UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityStartTime,

      UtilsAllocOfExtToIntPoD.UtilsExternalPointOfDelivery,

      /* Associations */
      UtilsAllocOfInstToPoD._UtilitiesInstallation
}
where
  UtilsAllocOfInstToPoD.UtilsPtOfDeliveryIsDeregulated = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILSALLOCOFEXTTOINTPOD",
"I_UTILSALLOCOFINSTTOPOD"
],
"ASSOCIATED":
[
"I_UTILITIESINSTALLATION"
],
"BASE":
[
"I_UTILSALLOCOFINSTTOPOD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More