C_NonBllbleUtilsBillgOrd

DDL: C_NONBLLBLEUTILSBILLGORD SQL: CECNBLLBLEORDER Type: view CONSUMPTION

Non-Billable Utilities Billing Order

C_NonBllbleUtilsBillgOrd is a Consumption CDS View that provides data about "Non-Billable Utilities Billing Order" in SAP S/4HANA. It reads from 1 data source (I_NonBllbleUtilsBillgOrd) and exposes 45 fields with key fields UtilitiesContract, UtilitiesInstallation, ScheduledUtilitiesBillingDate, UtilitiesBillingReason, MeterReadingDocument.

Data Sources (1)

SourceAliasJoin Type
I_NonBllbleUtilsBillgOrd NonBllbleUtilsBillgOrd from

Annotations (10)

NameValueLevelField
EndUserText.label Non-Billable Utilities Billing Order view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CECNBLLBLEORDER 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
UI.selectionVariant.qualifier periodicoverviews1_card07 view
UI.selectionVariant.filter UtilitiesBillingReason = "01" view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_NonBllbleUtilsBillgOrd UtilitiesContract
KEY UtilitiesInstallation I_NonBllbleUtilsBillgOrd UtilitiesInstallation
KEY ScheduledUtilitiesBillingDate I_NonBllbleUtilsBillgOrd ScheduledUtilitiesBillingDate
KEY UtilitiesBillingReason I_NonBllbleUtilsBillgOrd UtilitiesBillingReason
KEY MeterReadingDocument I_NonBllbleUtilsBillgOrd MeterReadingDocument
UtilitiesPortion I_NonBllbleUtilsBillgOrd UtilitiesPortion
ScheduledMeterReadingDate I_NonBllbleUtilsBillgOrd ScheduledMeterReadingDate
BusinessPartner I_NonBllbleUtilsBillgOrd BusinessPartner Issuing Authority
ContractAccount I_NonBllbleUtilsBillgOrd ContractAccount Contract Acct
UtilsBillgBlockReason I_NonBllbleUtilsBillgOrd UtilsBillgBlockReason
UtilsBillgUnblockReason I_NonBllbleUtilsBillgOrd UtilsBillgUnblockReason
CompanyCode I_NonBllbleUtilsBillgOrd CompanyCode Receiver Company Code
Division I_NonBllbleUtilsBillgOrd Division Internal Division ID
MeterReadingUnit I_NonBllbleUtilsBillgOrd MeterReadingUnit
MeterReadingUnitName
UtilitiesRateCategory I_NonBllbleUtilsBillgOrd UtilitiesRateCategory
UtilitiesBillingClass I_NonBllbleUtilsBillgOrd UtilitiesBillingClass
UtilsBillingOrderStatus I_NonBllbleUtilsBillgOrd UtilsBillingOrderStatus
UtilsBillingOrderIndicator I_NonBllbleUtilsBillgOrd UtilsBillingOrderIndicator
SuppressedUtilsBillgReason I_NonBllbleUtilsBillgOrd SuppressedUtilsBillgReason
SuppressedUtilsSchedldBillgDte I_NonBllbleUtilsBillgOrd SuppressedUtilsSchedldBillgDte
SuppressedSchedldMtrRdngDte I_NonBllbleUtilsBillgOrd SuppressedSchedldMtrRdngDte
UtilitiesAccountDetnCode I_NonBllbleUtilsBillgOrd UtilitiesAccountDetnCode
ImplausibleMeterReadingDoc I_NonBllbleUtilsBillgOrd ImplausibleMeterReadingDoc
MissingMeterReadingDoc I_NonBllbleUtilsBillgOrd MissingMeterReadingDoc
UtilsInstAndSchedldBillgDate I_NonBllbleUtilsBillgOrd UtilsInstAndSchedldBillgDate
AuthorizationGroup I_NonBllbleUtilsBillgOrd AuthorizationGroup AuthorizGroup
NmbrOfNonBllbleUtilsBillgOrds I_NonBllbleUtilsBillgOrd NmbrOfNonBllbleUtilsBillgOrds
_UtilitiesInstallation I_NonBllbleUtilsBillgOrd _UtilitiesInstallation
_UtilitiesBillingReason I_NonBllbleUtilsBillgOrd _UtilitiesBillingReason
_MtrReadingDocument I_NonBllbleUtilsBillgOrd _MtrReadingDocument
_UtilitiesPortion I_NonBllbleUtilsBillgOrd _UtilitiesPortion
_BusinessPartner I_NonBllbleUtilsBillgOrd _BusinessPartner
_ContrAcc I_NonBllbleUtilsBillgOrd _ContrAcc
_UtilsBillgBlockReason I_NonBllbleUtilsBillgOrd _UtilsBillgBlockReason
_UtilsBillgUnblockReason I_NonBllbleUtilsBillgOrd _UtilsBillgUnblockReason
_CompanyCode I_NonBllbleUtilsBillgOrd _CompanyCode
_Division I_NonBllbleUtilsBillgOrd _Division
_MeterReadingUnit I_NonBllbleUtilsBillgOrd _MeterReadingUnit
_UtilitiesRateCategory I_NonBllbleUtilsBillgOrd _UtilitiesRateCategory
_UtilsBillingClass I_NonBllbleUtilsBillgOrd _UtilsBillingClass
_UtilsBillingOrderStatus I_NonBllbleUtilsBillgOrd _UtilsBillingOrderStatus
_UtilsBillingOrderIndicator I_NonBllbleUtilsBillgOrd _UtilsBillingOrderIndicator
_SuppressedUtilsBillgReason I_NonBllbleUtilsBillgOrd _SuppressedUtilsBillgReason
_UtilsAccountDetnCode I_NonBllbleUtilsBillgOrd _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_NonBllbleUtilsBillgOrd.
-- 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: CECNBLLBLEORDER

CREATE VIEW C_NonBllbleUtilsBillgOrd AS
SELECT
  NonBllbleUtilsBillgOrd.UtilitiesContract AS UtilitiesContract,
  NonBllbleUtilsBillgOrd.UtilitiesInstallation AS UtilitiesInstallation,
  NonBllbleUtilsBillgOrd.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  NonBllbleUtilsBillgOrd.UtilitiesBillingReason AS UtilitiesBillingReason,
  NonBllbleUtilsBillgOrd.MeterReadingDocument AS MeterReadingDocument,
  NonBllbleUtilsBillgOrd.UtilitiesPortion AS UtilitiesPortion,
  NonBllbleUtilsBillgOrd.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  NonBllbleUtilsBillgOrd.BusinessPartner AS BusinessPartner,
  NonBllbleUtilsBillgOrd.ContractAccount AS ContractAccount,
  NonBllbleUtilsBillgOrd.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  NonBllbleUtilsBillgOrd.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  NonBllbleUtilsBillgOrd.CompanyCode AS CompanyCode,
  NonBllbleUtilsBillgOrd.Division AS Division,
  NonBllbleUtilsBillgOrd.MeterReadingUnit AS MeterReadingUnit,
  NonBllbleUtilsBillgOrd._MeterReadingUnit.MeterReadingUnitName AS MeterReadingUnitName,
  NonBllbleUtilsBillgOrd.UtilitiesRateCategory AS UtilitiesRateCategory,
  NonBllbleUtilsBillgOrd.UtilitiesBillingClass AS UtilitiesBillingClass,
  NonBllbleUtilsBillgOrd.UtilsBillingOrderStatus AS UtilsBillingOrderStatus,
  NonBllbleUtilsBillgOrd.UtilsBillingOrderIndicator AS UtilsBillingOrderIndicator,
  NonBllbleUtilsBillgOrd.SuppressedUtilsBillgReason AS SuppressedUtilsBillgReason,
  NonBllbleUtilsBillgOrd.SuppressedUtilsSchedldBillgDte AS SuppressedUtilsSchedldBillgDte,
  NonBllbleUtilsBillgOrd.SuppressedSchedldMtrRdngDte AS SuppressedSchedldMtrRdngDte,
  NonBllbleUtilsBillgOrd.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  NonBllbleUtilsBillgOrd.ImplausibleMeterReadingDoc AS ImplausibleMeterReadingDoc,
  NonBllbleUtilsBillgOrd.MissingMeterReadingDoc AS MissingMeterReadingDoc,
  NonBllbleUtilsBillgOrd.UtilsInstAndSchedldBillgDate AS UtilsInstAndSchedldBillgDate,
  NonBllbleUtilsBillgOrd.AuthorizationGroup AS AuthorizationGroup,
  NonBllbleUtilsBillgOrd.NmbrOfNonBllbleUtilsBillgOrds AS NmbrOfNonBllbleUtilsBillgOrds,
  NonBllbleUtilsBillgOrd._UtilitiesInstallation AS _UtilitiesInstallation,
  NonBllbleUtilsBillgOrd._UtilitiesBillingReason AS _UtilitiesBillingReason,
  NonBllbleUtilsBillgOrd._MtrReadingDocument AS _MtrReadingDocument,
  NonBllbleUtilsBillgOrd._UtilitiesPortion AS _UtilitiesPortion,
  NonBllbleUtilsBillgOrd._BusinessPartner AS _BusinessPartner,
  NonBllbleUtilsBillgOrd._ContrAcc AS _ContrAcc,
  NonBllbleUtilsBillgOrd._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  NonBllbleUtilsBillgOrd._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  NonBllbleUtilsBillgOrd._CompanyCode AS _CompanyCode,
  NonBllbleUtilsBillgOrd._Division AS _Division,
  NonBllbleUtilsBillgOrd._MeterReadingUnit AS _MeterReadingUnit,
  NonBllbleUtilsBillgOrd._UtilitiesRateCategory AS _UtilitiesRateCategory,
  NonBllbleUtilsBillgOrd._UtilsBillingClass AS _UtilsBillingClass,
  NonBllbleUtilsBillgOrd._UtilsBillingOrderStatus AS _UtilsBillingOrderStatus,
  NonBllbleUtilsBillgOrd._UtilsBillingOrderIndicator AS _UtilsBillingOrderIndicator,
  NonBllbleUtilsBillgOrd._SuppressedUtilsBillgReason AS _SuppressedUtilsBillgReason,
  NonBllbleUtilsBillgOrd._UtilsAccountDetnCode AS _UtilsAccountDetnCode
FROM I_NonBllbleUtilsBillgOrd AS NonBllbleUtilsBillgOrd
;