C_UtilitiesInstallationHistDP

DDL: C_UTILITIESINSTALLATIONHISTDP Type: view_entity CONSUMPTION
22 Fields 1 Data Sources

Data Provider for utils inst history

C_UtilitiesInstallationHistDP is a Consumption CDS View that provides data about "Data Provider for utils inst history" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesInstallationHist) and exposes 22 fields with key fields UtilitiesInstallation, UtilsInstHistValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesInstallationHist I_UtilitiesInstallationHist from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
EndUserText.label Data Provider for utils inst history view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name UtilitiesInstallationHistory view
ObjectModel.representativeKey UtilitiesInstallation view
VDM.viewType #CONSUMPTION view
DataIntegration.deltaReplication.intended true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesInstallation UtilitiesInstallation Installation
KEY UtilsInstHistValidityEndDate UtilsInstHistValidityEndDate
UtilsInstHistValidityStartDate UtilsInstHistValidityStartDate
UtilitiesRateCategory UtilitiesRateCategory Rate category
UtilitiesBillingSchema UtilitiesBillingSchema Billing schema
UtilitiesBillingClass UtilitiesBillingClass Billing Class
MeterReadingUnit MeterReadingUnit MR unit
UtilitiesTemperatureArea UtilitiesTemperatureArea Temp. area
UtilsInstIsExmptFrmFrnchsFee UtilsInstIsExmptFrmFrnchsFee No franch. fee
UtilsInstDvceAllctnIsNotAllwd UtilsInstDvceAllctnIsNotAllwd No dev. alloc.
UtilitiesFranchiseContract UtilitiesFranchiseContract Franchise cont.
UtilitiesBillingParty UtilitiesBillingParty Billing ServPr.
UtilitiesInvoicingParty UtilitiesInvoicingParty Supplier
ObligatorySupUtilsSrvcProvider ObligatorySupUtilsSrvcProvider Supply Obligatn
PrimaryUtilitiesInstallation PrimaryUtilitiesInstallation Primary Inst.
UtilsInstallationGroupRole UtilsInstallationGroupRole Installtn Role
UtilsInstallationGroupType UtilsInstallationGroupType Grouping Type
HigherLevelUtilsInstallation HigherLevelUtilsInstallation High.-Level Installn
UnbilldRevnXtrapltnType UnbilldRevnXtrapltnType Extrapol. type
UtilsRegDepdntValdtnGroup UtilsRegDepdntValdtnGroup ValGrp dep.vals
_UtilitiesInstallation _UtilitiesInstallation
_UtilitiesInstallationDP _UtilitiesInstallationDP

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 C_UtilitiesInstallationHistDP.
-- 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.

CREATE VIEW C_UtilitiesInstallationHistDP AS
SELECT
  UtilitiesInstallation,
  UtilsInstHistValidityEndDate,
  UtilsInstHistValidityStartDate,
  UtilitiesRateCategory,
  UtilitiesBillingSchema,
  UtilitiesBillingClass,
  MeterReadingUnit,
  UtilitiesTemperatureArea,
  UtilsInstIsExmptFrmFrnchsFee,
  UtilsInstDvceAllctnIsNotAllwd,
  UtilitiesFranchiseContract,
  UtilitiesBillingParty,
  UtilitiesInvoicingParty,
  ObligatorySupUtilsSrvcProvider,
  PrimaryUtilitiesInstallation,
  UtilsInstallationGroupRole,
  UtilsInstallationGroupType,
  HigherLevelUtilsInstallation,
  UnbilldRevnXtrapltnType,
  UtilsRegDepdntValdtnGroup
FROM I_UtilitiesInstallationHist
;

Learn More