C_BlkdUtilsContrToBeBlld

DDL: C_BLKDUTILSCONTRTOBEBLLD SQL: CECONTRBLOCKED Type: view CONSUMPTION
33 Fields 1 Data Sources

Blocked Utilities Contract to be Billed

C_BlkdUtilsContrToBeBlld is a Consumption CDS View that provides data about "Blocked Utilities Contract to be Billed" in SAP S/4HANA. It reads from 1 data source (I_UtilsContrToBeBlld) and exposes 33 fields with key fields UtilitiesContract, ScheduledUtilitiesBillingDate, UtilitiesPortion, ScheduledMeterReadingDate.

Data Sources (1)

SourceAliasJoin Type
I_UtilsContrToBeBlld UtilsContrToBeBlld from

Annotations (8)

NameValueLevelField
EndUserText.label Blocked Utilities Contract to be Billed view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CECONTRBLOCKED 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_UtilsContrToBeBlld UtilitiesContract
KEY ScheduledUtilitiesBillingDate I_UtilsContrToBeBlld ScheduledUtilitiesBillingDate
KEY UtilitiesPortion I_UtilsContrToBeBlld UtilitiesPortion
KEY ScheduledMeterReadingDate I_UtilsContrToBeBlld ScheduledMeterReadingDate
UtilitiesBillingReason I_UtilsContrToBeBlld UtilitiesBillingReason
BusinessPartner I_UtilsContrToBeBlld BusinessPartner Issuing Authority
ContractAccount I_UtilsContrToBeBlld ContractAccount Contract Acct
UtilsBillgBlockReason I_UtilsContrToBeBlld UtilsBillgBlockReason
UtilsBillgBlockReasonName
UtilsBillgUnblockReason I_UtilsContrToBeBlld UtilsBillgUnblockReason
CompanyCode I_UtilsContrToBeBlld CompanyCode Receiver Company Code
Division I_UtilsContrToBeBlld Division Internal Division ID
UtilitiesInstallation I_UtilsContrToBeBlld UtilitiesInstallation
MeterReadingUnit I_UtilsContrToBeBlld MeterReadingUnit
UtilitiesRateCategory I_UtilsContrToBeBlld UtilitiesRateCategory
UtilitiesBillingClass I_UtilsContrToBeBlld UtilitiesBillingClass
UtilsPortionScheduleRecordDate I_UtilsContrToBeBlld UtilsPortionScheduleRecordDate
UtilitiesAccountDetnCode I_UtilsContrToBeBlld UtilitiesAccountDetnCode
AuthorizationGroup I_UtilsContrToBeBlld AuthorizationGroup AuthorizGroup
NmbrOfUtilsContrBlkdForBillg I_UtilsContrToBeBlld NmbrOfUtilsContrBlkdForBillg
_UtilitiesPortion I_UtilsContrToBeBlld _UtilitiesPortion
_UtilitiesBillingReason I_UtilsContrToBeBlld _UtilitiesBillingReason
_BusinessPartner I_UtilsContrToBeBlld _BusinessPartner
_ContrAcc I_UtilsContrToBeBlld _ContrAcc
_UtilsBillgBlockReason I_UtilsContrToBeBlld _UtilsBillgBlockReason
_UtilsBillgUnblockReason I_UtilsContrToBeBlld _UtilsBillgUnblockReason
_CompanyCode I_UtilsContrToBeBlld _CompanyCode
_Division I_UtilsContrToBeBlld _Division
_UtilitiesInstallation I_UtilsContrToBeBlld _UtilitiesInstallation
_MeterReadingUnit I_UtilsContrToBeBlld _MeterReadingUnit
_UtilitiesRateCategory I_UtilsContrToBeBlld _UtilitiesRateCategory
_UtilsBillingClass I_UtilsContrToBeBlld _UtilsBillingClass
_UtilsAccountDetnCode I_UtilsContrToBeBlld _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_BlkdUtilsContrToBeBlld.
-- 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: CECONTRBLOCKED

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

Learn More