C_MissingUtilsBillingOrderQ

DDL: C_MISSINGUTILSBILLINGORDERQ SQL: CEMISGBILLGORDQ Type: view CONSUMPTION
9 Fields 1 Data Sources

Missing Billing Order Query

C_MissingUtilsBillingOrderQ (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Utilities

C_MissingUtilsBillingOrderQ is a Consumption CDS View that provides data about "Missing Billing Order Query" in SAP S/4HANA. It reads from 1 data source (I_MissingUtilsBillingOrder) and exposes 9 fields.

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-BI
CapabilitiesAnalytical Query
PackageUtilities for SAP S/4HANA

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MissingUtilsBillingOrder I_MissingUtilsBillingOrder from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (12)

NameValueLevelField
EndUserText.label Missing Billing Order Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CEMISGBILLGORDQ view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view

Fields (9)

KeyFieldSource TableSource FieldDescription
UtilitiesContract UtilitiesContract Contract
UtilitiesPortion UtilitiesPortion Portion
UtilitiesPortionName _UtilitiesPortion UtilitiesPortionName Portion Name
ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate Scheduled Billing Date
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Name of Company Code or Company
UtilitiesDivision UtilitiesDivision Division
DivisionName Division Description
NmbrOfContrWithMissingBillgOrd NmbrOfContrWithMissingBillgOrd Number of Contracts with Missing Billing Orders

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_MissingUtilsBillingOrderQ.
-- 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: CEMISGBILLGORDQ
-- Parameters: P_Language : sylangu

CREATE VIEW C_MissingUtilsBillingOrderQ AS
SELECT
  UtilitiesContract,
  UtilitiesPortion,
  _UtilitiesPortion.UtilitiesPortionName AS UtilitiesPortionName,
  ScheduledUtilitiesBillingDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  UtilitiesDivision,
  _Division._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
  NmbrOfContrWithMissingBillgOrd
FROM I_MissingUtilsBillingOrder
;

Learn More