C_OpenUtilsBillgBlkdContr

DDL: C_OPENUTILSBILLGBLKDCONTR SQL: CECBLKDCONTR Type: view CONSUMPTION
33 Fields 1 Data Sources

Blocked Utilities Contract with Open Billing

C_OpenUtilsBillgBlkdContr is a Consumption CDS View that provides data about "Blocked Utilities Contract with Open Billing" in SAP S/4HANA. It reads from 1 data source (I_OpenUtilsBillgDocAndOrd) and exposes 33 fields with key fields UtilitiesContract, UtilitiesInstallation, ScheduledUtilitiesBillingDate, UtilitiesBillingReason.

Data Sources (1)

SourceAliasJoin Type
I_OpenUtilsBillgDocAndOrd OpenUtilsBillgDocAndOrd from

Annotations (8)

NameValueLevelField
EndUserText.label Blocked Utilities Contract with Open Billing view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CECBLKDCONTR view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_OpenUtilsBillgDocAndOrd UtilitiesContract
KEY UtilitiesInstallation I_OpenUtilsBillgDocAndOrd UtilitiesInstallation
KEY ScheduledUtilitiesBillingDate I_OpenUtilsBillgDocAndOrd ScheduledUtilitiesBillingDate
KEY UtilitiesBillingReason I_OpenUtilsBillgDocAndOrd UtilitiesBillingReason
UtilitiesPortion I_OpenUtilsBillgDocAndOrd UtilitiesPortion
ScheduledMeterReadingDate I_OpenUtilsBillgDocAndOrd ScheduledMeterReadingDate
BusinessPartner I_OpenUtilsBillgDocAndOrd BusinessPartner Issuing Authority
ContractAccount I_OpenUtilsBillgDocAndOrd ContractAccount Contract Acct
UtilsBillgBlockReason I_OpenUtilsBillgDocAndOrd UtilsBillgBlockReason
UtilsBillgBlockReasonName
UtilsBillgUnblockReason I_OpenUtilsBillgDocAndOrd UtilsBillgUnblockReason
CompanyCode I_OpenUtilsBillgDocAndOrd CompanyCode Receiver Company Code
Division I_OpenUtilsBillgDocAndOrd Division Internal Division ID
MeterReadingUnit I_OpenUtilsBillgDocAndOrd MeterReadingUnit
UtilitiesRateCategory I_OpenUtilsBillgDocAndOrd UtilitiesRateCategory
UtilitiesBillingClass I_OpenUtilsBillgDocAndOrd UtilitiesBillingClass
UtilsPortionScheduleRecordDate I_OpenUtilsBillgDocAndOrd UtilsPortionScheduleRecordDate
UtilitiesAccountDetnCode I_OpenUtilsBillgDocAndOrd UtilitiesAccountDetnCode
AuthorizationGroup I_OpenUtilsBillgDocAndOrd AuthorizationGroup AuthorizGroup
NmbrOfUtilsContrBlkdForBillg I_OpenUtilsBillgDocAndOrd NmbrOfUtilsContrBlkdForBillg
_UtilitiesInstallation I_OpenUtilsBillgDocAndOrd _UtilitiesInstallation
_UtilitiesBillingReason I_OpenUtilsBillgDocAndOrd _UtilitiesBillingReason
_UtilitiesPortion I_OpenUtilsBillgDocAndOrd _UtilitiesPortion
_BusinessPartner I_OpenUtilsBillgDocAndOrd _BusinessPartner
_ContrAcc I_OpenUtilsBillgDocAndOrd _ContrAcc
_UtilsBillgBlockReason I_OpenUtilsBillgDocAndOrd _UtilsBillgBlockReason
_UtilsBillgUnblockReason I_OpenUtilsBillgDocAndOrd _UtilsBillgUnblockReason
_CompanyCode I_OpenUtilsBillgDocAndOrd _CompanyCode
_Division I_OpenUtilsBillgDocAndOrd _Division
_MeterReadingUnit I_OpenUtilsBillgDocAndOrd _MeterReadingUnit
_UtilitiesRateCategory I_OpenUtilsBillgDocAndOrd _UtilitiesRateCategory
_UtilsBillingClass I_OpenUtilsBillgDocAndOrd _UtilsBillingClass
_UtilsAccountDetnCode I_OpenUtilsBillgDocAndOrd _UtilsAccountDetnCode

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_OpenUtilsBillgBlkdContr.
-- 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: CECBLKDCONTR

CREATE VIEW C_OpenUtilsBillgBlkdContr AS
SELECT
  OpenUtilsBillgDocAndOrd.UtilitiesContract AS UtilitiesContract,
  OpenUtilsBillgDocAndOrd.UtilitiesInstallation AS UtilitiesInstallation,
  OpenUtilsBillgDocAndOrd.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  OpenUtilsBillgDocAndOrd.UtilitiesBillingReason AS UtilitiesBillingReason,
  OpenUtilsBillgDocAndOrd.UtilitiesPortion AS UtilitiesPortion,
  OpenUtilsBillgDocAndOrd.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  OpenUtilsBillgDocAndOrd.BusinessPartner AS BusinessPartner,
  OpenUtilsBillgDocAndOrd.ContractAccount AS ContractAccount,
  OpenUtilsBillgDocAndOrd.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  OpenUtilsBillgDocAndOrd._UtilsBillgBlockReason._Text[1: Language=$session.system_language].UtilsBillgBlockReasonName AS UtilsBillgBlockReasonName,
  OpenUtilsBillgDocAndOrd.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  OpenUtilsBillgDocAndOrd.CompanyCode AS CompanyCode,
  OpenUtilsBillgDocAndOrd.Division AS Division,
  OpenUtilsBillgDocAndOrd.MeterReadingUnit AS MeterReadingUnit,
  OpenUtilsBillgDocAndOrd.UtilitiesRateCategory AS UtilitiesRateCategory,
  OpenUtilsBillgDocAndOrd.UtilitiesBillingClass AS UtilitiesBillingClass,
  OpenUtilsBillgDocAndOrd.UtilsPortionScheduleRecordDate AS UtilsPortionScheduleRecordDate,
  OpenUtilsBillgDocAndOrd.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  OpenUtilsBillgDocAndOrd.AuthorizationGroup AS AuthorizationGroup,
  OpenUtilsBillgDocAndOrd.NmbrOfUtilsContrBlkdForBillg AS NmbrOfUtilsContrBlkdForBillg,
  OpenUtilsBillgDocAndOrd._UtilitiesInstallation AS _UtilitiesInstallation,
  OpenUtilsBillgDocAndOrd._UtilitiesBillingReason AS _UtilitiesBillingReason,
  OpenUtilsBillgDocAndOrd._UtilitiesPortion AS _UtilitiesPortion,
  OpenUtilsBillgDocAndOrd._BusinessPartner AS _BusinessPartner,
  OpenUtilsBillgDocAndOrd._ContrAcc AS _ContrAcc,
  OpenUtilsBillgDocAndOrd._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  OpenUtilsBillgDocAndOrd._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  OpenUtilsBillgDocAndOrd._CompanyCode AS _CompanyCode,
  OpenUtilsBillgDocAndOrd._Division AS _Division,
  OpenUtilsBillgDocAndOrd._MeterReadingUnit AS _MeterReadingUnit,
  OpenUtilsBillgDocAndOrd._UtilitiesRateCategory AS _UtilitiesRateCategory,
  OpenUtilsBillgDocAndOrd._UtilsBillingClass AS _UtilsBillingClass,
  OpenUtilsBillgDocAndOrd._UtilsAccountDetnCode AS _UtilsAccountDetnCode
FROM I_OpenUtilsBillgDocAndOrd AS OpenUtilsBillgDocAndOrd
;

Learn More