What is I_UtilsPremiseKeyDateAnalysis in SAP S/4HANA?

I_UtilsPremiseKeyDateAnalysis is a composite CDS view in SAP S/4HANA. Key Date-Based Premise Analysis It contains 57 fields.

Which tables does I_UtilsPremiseKeyDateAnalysis read from?

I_UtilsPremiseKeyDateAnalysis reads data from: I_UtilitiesPremise, I_UtilitiesPremise.

What VDM layer is I_UtilsPremiseKeyDateAnalysis?

I_UtilsPremiseKeyDateAnalysis is classified as a Composite view that combines data from multiple basic views.

I_UtilsPremiseKeyDateAnalysis

DDL: I_UTILSPREMISEKEYDATEANALYSIS SQL: IEPREMISEANLYS Type: view COMPOSITE

57 Fields 2 Data Sources 1 Associations

Key Date-Based Premise Analysis

I_UtilsPremiseKeyDateAnalysis (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Utilities

I_UtilsPremiseKeyDateAnalysis is a Composite CDS View (Cube) that provides data about "Key Date-Based Premise Analysis" in SAP S/4HANA. It reads from 2 data sources (I_UtilitiesPremise, I_UtilitiesPremise) and exposes 57 fields with key field UtilitiesPremise. It has 1 association to related views.

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-MD
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Utilities for SAP S/4HANA
Description	<p>This cube provides the prerequisites that enable you to answer the following business questions:</p> <ul> <li><p>How many premises exist for a specific key date (in the past or today)?</p></li> <li><p>Which addresses do these premises have and can they be shown on a map for better visualization?</p></li> <li><p>What specific characteristics do the premises have, for example do they have an owner allocation?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA, onpremise edition — Explore SAP S/4HANA Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA
View Browser — Search, browse and tag CDS Views

Data Sources (2)

Source	Alias	Join Type
I_UtilitiesPremise	UtilitiesPremise	from
I_UtilitiesPremise	UtilitiesPremise	union_all

Parameters (1)

Name	Type	Default
P_KeyDate	sydate

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_NmbrOfOwnrOfUtilitiesPremise	_NmbrOfOwnrOfUtilitiesPremise	`$projection.UtilitiesPremise = _NmbrOfOwnrOfUtilitiesPremise.UtilitiesPremise`

Annotations (14)

Name	Value	Level
EndUserText.label	Key Date-Based Premise Analysis	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.sqlViewName	IEPREMISEANLYS	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.allowExtensions	true	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view

Fields (57)

Key	Field	Source Table	Source Field	Description
KEY	UtilitiesPremise	I_UtilitiesPremise	UtilitiesPremise	Premise
	AuthorizationGroup	I_UtilitiesPremise	AuthorizationGroup	Authorization Group
	FunctionalLocation	I_UtilitiesPremise	FunctionalLocation	Functional location
	NumberOfPersons	I_UtilitiesPremise	NumberOfPersons	Number of persons
	UtilitiesConnectionObject	I_UtilitiesPremise	UtilitiesConnectionObject	Connection Object
	UtilitiesOwnerendasUtilitiesOwner
	UtilitiesPremiseType	I_UtilitiesPremise	UtilitiesPremiseType	Type of premise
	UtilsPremiseIsMainResidence	I_UtilitiesPremise	UtilsPremiseIsMainResidence	Main residence
	DeletionIndicator	I_UtilitiesPremise	DeletionIndicator	Deletion Indicator
	AddressID			Address Number
	_Address
	_Address2
	Country			Country/Region Key
	Region			Region (State, Province, County)
	CityName			City
	StreetName			Street
	HouseNumber			House Number
	PostalCode			City postal code
	LocationSupplement	I_UtilitiesPremise	LocationSupplement	Additional Information on Location
	Floor	I_UtilitiesPremise	Floor	Floor in building
	HouseNumberSupplementText	I_UtilitiesPremise	HouseNumberSupplementText	House number supplement
	RoomNumber	I_UtilitiesPremise	RoomNumber	Room or Apartment Number
	StreetSupplement1	I_UtilitiesPremise	StreetSupplement1	Street 3
	StreetSupplement2	I_UtilitiesPremise	StreetSupplement2	Street 5
	NumberOfUtilitiesPremises			Number of Premises
	UtilitiesAnalysisKeyDate			Premise Analysis Key Date
	_UtilitiesPremiseType	I_UtilitiesPremise	_UtilitiesPremiseType
	_UtilsPremiseIsMainResidence	I_UtilitiesPremise	_UtilsPremiseIsMainResidence
	UtilitiesPremise			Premise
	AuthorizationGroup	I_UtilitiesPremise	AuthorizationGroup	Authorization Group
	FunctionalLocation	I_UtilitiesPremise	FunctionalLocation	Functional location
	NumberOfPersons	I_UtilitiesPremise	NumberOfPersons	Number of persons
	UtilitiesConnectionObject	I_UtilitiesPremise	UtilitiesConnectionObject	Connection Object
	UtilitiesOwner	I_UtilitiesPremise	UtilitiesOwner	Owner
	UtilitiesPremiseType	I_UtilitiesPremise	UtilitiesPremiseType	Type of premise
	UtilsPremiseIsMainResidence	I_UtilitiesPremise	UtilsPremiseIsMainResidence	Main residence
	DeletionIndicator	I_UtilitiesPremise	DeletionIndicator	Deletion Indicator
	AddressID			Address Number
	_Address
	_Address2
	Country			Country/Region Key
	Region			Region (State, Province, County)
	CityName			City
	StreetName			Street
	HouseNumber			House Number
	PostalCode			City postal code
	LocationSupplement	I_UtilitiesPremise	LocationSupplement	Additional Information on Location
	Floor	I_UtilitiesPremise	Floor	Floor in building
	HouseNumberSupplementText	I_UtilitiesPremise	HouseNumberSupplementText	House number supplement
	RoomNumber	I_UtilitiesPremise	RoomNumber	Room or Apartment Number
	StreetSupplement1	I_UtilitiesPremise	StreetSupplement1	Street 3
	StreetSupplement2	I_UtilitiesPremise	StreetSupplement2	Street 5
	NumberOfUtilitiesPremises			Number of Premises
	UtilitiesAnalysisKeyDate			Premise Analysis Key Date
	_UtilitiesPremiseType	I_UtilitiesPremise	_UtilitiesPremiseType
	_UtilsPremiseIsMainResidence	I_UtilitiesPremise	_UtilsPremiseIsMainResidence
	_UtilsTechObjLocationAddr	I_UtilitiesPremise	_UtilsTechObjLocationAddr

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_UtilsPremiseKeyDateAnalysis.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IEPREMISEANLYS
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_UtilsPremiseKeyDateAnalysis AS
SELECT
  UtilitiesPremise.UtilitiesPremise AS UtilitiesPremise,
  UtilitiesPremise.AuthorizationGroup AS AuthorizationGroup,
  UtilitiesPremise.FunctionalLocation AS FunctionalLocation,
  UtilitiesPremise.NumberOfPersons AS NumberOfPersons,
  UtilitiesPremise.UtilitiesConnectionObject AS UtilitiesConnectionObject,
  case when _NmbrOfOwnrOfUtilitiesPremise( P_KeyDate:$parameters.P_KeyDate ).NumberOfUtilitiesPremiseOwners >= 2 or (_NmbrOfOwnrOfUtilitiesPremise( P_KeyDate:$parameters.P_KeyDate ).NumberOfUtilitiesPremiseOwners = 1 and UtilitiesPremise.UtilitiesOwner <> '' ) then '*' else UtilitiesPremiseOwner.UtilitiesOwner end as UtilitiesOwner AS UtilitiesOwnerendasUtilitiesOwner,
  UtilitiesPremise.UtilitiesPremiseType AS UtilitiesPremiseType,
  UtilitiesPremise.UtilsPremiseIsMainResidence AS UtilsPremiseIsMainResidence,
  UtilitiesPremise.DeletionIndicator AS DeletionIndicator,
  UtilitiesPremise._UtilsTechObjLocationAddr.AddressID AS AddressID,
  UtilitiesPremise._UtilsTechObjLocationAddr._Address AS _Address,
  UtilitiesPremise._UtilsTechObjLocationAddr._Address2 AS _Address2,
  UtilitiesPremise._UtilsTechObjLocationAddr._Address2.Country AS Country,
  UtilitiesPremise._UtilsTechObjLocationAddr._Address2.Region AS Region,
  UtilitiesPremise._UtilsTechObjLocationAddr._Address2.CityName AS CityName,
  UtilitiesPremise._UtilsTechObjLocationAddr._Address2.StreetName AS StreetName,
  UtilitiesPremise._UtilsTechObjLocationAddr._Address2.HouseNumber AS HouseNumber,
  UtilitiesPremise._UtilsTechObjLocationAddr._Address2.PostalCode AS PostalCode,
  UtilitiesPremise.LocationSupplement AS LocationSupplement,
  UtilitiesPremise.Floor AS Floor,
  UtilitiesPremise.HouseNumberSupplementText AS HouseNumberSupplementText,
  UtilitiesPremise.RoomNumber AS RoomNumber,
  UtilitiesPremise.StreetSupplement1 AS StreetSupplement1,
  UtilitiesPremise.StreetSupplement2 AS StreetSupplement2,
  cast(1 as e_nroutilspremises_vdm) AS NumberOfUtilitiesPremises,
  cast($parameters.P_KeyDate as e_utilspremisekeydate_vdm preserving type ) AS UtilitiesAnalysisKeyDate,
  UtilitiesPremise._UtilitiesPremiseType AS _UtilitiesPremiseType,
  UtilitiesPremise._UtilsPremiseIsMainResidence AS _UtilsPremiseIsMainResidence,
  UtilitiesPremise.UtilitiesOwner AS UtilitiesOwner,
  UtilitiesPremise._UtilsTechObjLocationAddr AS _UtilsTechObjLocationAddr
FROM I_UtilitiesPremise AS UtilitiesPremise
LEFT OUTER JOIN I_NmbrOfOwnrOfUtilitiesPremise AS _NmbrOfOwnrOfUtilitiesPremise ON UtilitiesPremise = _NmbrOfOwnrOfUtilitiesPremise.UtilitiesPremise  -- association [0..1]
-- UNION ALL with additional select branch(es): I_UtilitiesPremise
;

Depth:

I_UtilsPremiseKeyDateAnalysis view

I_UtilitiesPremise view
I_UtilitiesPremise view

C_UtilsPremiseKeyDateAnalysisQ view