C_UtilsBillingOrder

DDL: C_UTILSBILLINGORDER SQL: CECBILLGORDER Type: view CONSUMPTION
46 Fields 1 Data Sources 1 Associations

Utilities Billing Order

C_UtilsBillingOrder is a Consumption CDS View that provides data about "Utilities Billing Order" in SAP S/4HANA. It reads from 1 data source (I_UtilsBillingOrder) and exposes 46 fields with key fields UtilitiesContract, UtilitiesInstallation, ScheduledUtilitiesBillingDate, UtilitiesBillingReason. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_UtilsBillingOrder UtilsBillingOrder from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CalendarDate _CalendarDate $projection.ScheduledUtilitiesBillingDate = _CalendarDate.CalendarDate

Annotations (8)

NameValueLevelField
EndUserText.label Utilities Billing Order view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CECBILLGORDER 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 (46)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_UtilsBillingOrder UtilitiesContract
KEY UtilitiesInstallation I_UtilsBillingOrder UtilitiesInstallation
KEY ScheduledUtilitiesBillingDate I_UtilsBillingOrder ScheduledUtilitiesBillingDate
KEY UtilitiesBillingReason I_UtilsBillingOrder UtilitiesBillingReason
UtilitiesPortion I_UtilsBillingOrder UtilitiesPortion
ScheduledMeterReadingDate I_UtilsBillingOrder ScheduledMeterReadingDate
BusinessPartner I_UtilsBillingOrder BusinessPartner Issuing Authority
ContractAccount I_UtilsBillingOrder ContractAccount Contract Acct
UtilsBillgBlockReason I_UtilsBillingOrder UtilsBillgBlockReason
UtilsBillgUnblockReason I_UtilsBillingOrder UtilsBillgUnblockReason
CompanyCode I_UtilsBillingOrder CompanyCode Receiver Company Code
Division I_UtilsBillingOrder Division Internal Division ID
MeterReadingUnit I_UtilsBillingOrder MeterReadingUnit
UtilitiesRateCategory I_UtilsBillingOrder UtilitiesRateCategory
UtilitiesBillingClass I_UtilsBillingOrder UtilitiesBillingClass
UtilsPortionScheduleRecordDate I_UtilsBillingOrder UtilsPortionScheduleRecordDate
UtilsBillingOrderStatus I_UtilsBillingOrder UtilsBillingOrderStatus
UtilsBillingOrderIndicator I_UtilsBillingOrder UtilsBillingOrderIndicator
SuppressedUtilsBillgReason I_UtilsBillingOrder SuppressedUtilsBillgReason
SuppressedUtilsSchedldBillgDte I_UtilsBillingOrder SuppressedUtilsSchedldBillgDte
SuppressedSchedldMtrRdngDte I_UtilsBillingOrder SuppressedSchedldMtrRdngDte
UtilitiesAccountDetnCode I_UtilsBillingOrder UtilitiesAccountDetnCode
CalendarMonth
CalendarMonthName
CalendarYear
AuthorizationGroup I_UtilsBillingOrder AuthorizationGroup AuthorizGroup
NrOfUtilitiesBillingOrders I_UtilsBillingOrder NrOfUtilitiesBillingOrders
_UtilitiesInstallation I_UtilsBillingOrder _UtilitiesInstallation
_UtilitiesBillingReason I_UtilsBillingOrder _UtilitiesBillingReason
_UtilitiesPortion I_UtilsBillingOrder _UtilitiesPortion
_BusinessPartner I_UtilsBillingOrder _BusinessPartner
_ContrAcc I_UtilsBillingOrder _ContrAcc
_UtilsBillgBlockReason I_UtilsBillingOrder _UtilsBillgBlockReason
_UtilsBillgUnblockReason I_UtilsBillingOrder _UtilsBillgUnblockReason
_CompanyCode I_UtilsBillingOrder _CompanyCode
_Division I_UtilsBillingOrder _Division
_MeterReadingUnit I_UtilsBillingOrder _MeterReadingUnit
_UtilitiesRateCategory I_UtilsBillingOrder _UtilitiesRateCategory
_UtilsBillingClass I_UtilsBillingOrder _UtilsBillingClass
_UtilsBillingOrderStatus I_UtilsBillingOrder _UtilsBillingOrderStatus
_UtilsBillingOrderIndicator I_UtilsBillingOrder _UtilsBillingOrderIndicator
_SuppressedUtilsBillgReason I_UtilsBillingOrder _SuppressedUtilsBillgReason
_UtilsAccountDetnCode I_UtilsBillingOrder _UtilsAccountDetnCode
_CalendarDate _CalendarDate
_CalendarMonth _CalendarDate _CalendarMonth
_CalendarYear _CalendarDate _CalendarYear

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_UtilsBillingOrder.
-- 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: CECBILLGORDER

CREATE VIEW C_UtilsBillingOrder AS
SELECT
  UtilsBillingOrder.UtilitiesContract AS UtilitiesContract,
  UtilsBillingOrder.UtilitiesInstallation AS UtilitiesInstallation,
  UtilsBillingOrder.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsBillingOrder.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilsBillingOrder.UtilitiesPortion AS UtilitiesPortion,
  UtilsBillingOrder.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilsBillingOrder.BusinessPartner AS BusinessPartner,
  UtilsBillingOrder.ContractAccount AS ContractAccount,
  UtilsBillingOrder.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilsBillingOrder.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilsBillingOrder.CompanyCode AS CompanyCode,
  UtilsBillingOrder.Division AS Division,
  UtilsBillingOrder.MeterReadingUnit AS MeterReadingUnit,
  UtilsBillingOrder.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilsBillingOrder.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilsBillingOrder.UtilsPortionScheduleRecordDate AS UtilsPortionScheduleRecordDate,
  UtilsBillingOrder.UtilsBillingOrderStatus AS UtilsBillingOrderStatus,
  UtilsBillingOrder.UtilsBillingOrderIndicator AS UtilsBillingOrderIndicator,
  UtilsBillingOrder.SuppressedUtilsBillgReason AS SuppressedUtilsBillgReason,
  UtilsBillingOrder.SuppressedUtilsSchedldBillgDte AS SuppressedUtilsSchedldBillgDte,
  UtilsBillingOrder.SuppressedSchedldMtrRdngDte AS SuppressedSchedldMtrRdngDte,
  UtilsBillingOrder.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  cast(_CalendarDate.CalendarMonth as e_schdldmnth_vdm preserving type ) AS CalendarMonth,
  _CalendarDate._CalendarMonth._Text[1: Language = $session.system_language].CalendarMonthName AS CalendarMonthName,
  cast(_CalendarDate.CalendarYear as e_schdldyr_vdm preserving type ) AS CalendarYear,
  UtilsBillingOrder.AuthorizationGroup AS AuthorizationGroup,
  UtilsBillingOrder.NrOfUtilitiesBillingOrders AS NrOfUtilitiesBillingOrders,
  UtilsBillingOrder._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsBillingOrder._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilsBillingOrder._UtilitiesPortion AS _UtilitiesPortion,
  UtilsBillingOrder._BusinessPartner AS _BusinessPartner,
  UtilsBillingOrder._ContrAcc AS _ContrAcc,
  UtilsBillingOrder._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilsBillingOrder._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilsBillingOrder._CompanyCode AS _CompanyCode,
  UtilsBillingOrder._Division AS _Division,
  UtilsBillingOrder._MeterReadingUnit AS _MeterReadingUnit,
  UtilsBillingOrder._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsBillingOrder._UtilsBillingClass AS _UtilsBillingClass,
  UtilsBillingOrder._UtilsBillingOrderStatus AS _UtilsBillingOrderStatus,
  UtilsBillingOrder._UtilsBillingOrderIndicator AS _UtilsBillingOrderIndicator,
  UtilsBillingOrder._SuppressedUtilsBillgReason AS _SuppressedUtilsBillgReason,
  UtilsBillingOrder._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  _CalendarDate._CalendarMonth AS _CalendarMonth,
  _CalendarDate._CalendarYear AS _CalendarYear
FROM I_UtilsBillingOrder AS UtilsBillingOrder
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON ScheduledUtilitiesBillingDate = _CalendarDate.CalendarDate  -- association [1..1]
;

Learn More