I_MissingUtilsBillingOrder

DDL: I_MISSINGUTILSBILLINGORDER SQL: IEMISGBILLGORDER Type: view COMPOSITE
11 Fields 1 Data Sources

Missing Billing Order

I_MissingUtilsBillingOrder (Composite)

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

Utilities

I_MissingUtilsBillingOrder is a Composite CDS View (Cube) that provides data about "Missing Billing Order" in SAP S/4HANA. It reads from 1 data source (I_UtilsContractToBeBilled) and exposes 11 fields with key fields UtilitiesContract, UtilitiesPortion, ScheduledUtilitiesBillingDate.

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-BI
CapabilitiesData Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageUtilities for SAP S/4HANA

Documentation

Data Sources (1)

SourceAliasJoin Type
I_UtilsContractToBeBilled UtilsContractToBeBilled from

Annotations (13)

NameValueLevelField
EndUserText.label Missing Billing Order view
Analytics.dataCategory #CUBE view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IEMISGBILLGORDER view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_UtilsContractToBeBilled UtilitiesContract Contract
KEY UtilitiesPortion I_UtilsContractToBeBilled UtilitiesPortion Portion
KEY ScheduledUtilitiesBillingDate I_UtilsContractToBeBilled ScheduledUtilitiesBillingDate Scheduled Billing Date
CompanyCode I_UtilsContractToBeBilled CompanyCode Receiver Company Code
UtilitiesDivision I_UtilsContractToBeBilled UtilitiesDivision Division
AuthorizationGroup I_UtilsContractToBeBilled AuthorizationGroup Authorization Group
NmbrOfContrWithMissingBillgOrd Number of Contracts with Missing Billing Orders
_UtilitiesContract I_UtilsContractToBeBilled _UtilitiesContract
_UtilitiesPortion I_UtilsContractToBeBilled _UtilitiesPortion
_CompanyCode I_UtilsContractToBeBilled _CompanyCode
_Division I_UtilsContractToBeBilled _Division

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 I_MissingUtilsBillingOrder.
-- 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: IEMISGBILLGORDER

CREATE VIEW I_MissingUtilsBillingOrder AS
SELECT
  UtilsContractToBeBilled.UtilitiesContract AS UtilitiesContract,
  UtilsContractToBeBilled.UtilitiesPortion AS UtilitiesPortion,
  UtilsContractToBeBilled.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsContractToBeBilled.CompanyCode AS CompanyCode,
  UtilsContractToBeBilled.UtilitiesDivision AS UtilitiesDivision,
  UtilsContractToBeBilled.AuthorizationGroup AS AuthorizationGroup,
  cast(1 as e_contrwithmisgbillgord_vdm) AS NmbrOfContrWithMissingBillgOrd,
  UtilsContractToBeBilled._UtilitiesContract AS _UtilitiesContract,
  UtilsContractToBeBilled._UtilitiesPortion AS _UtilitiesPortion,
  UtilsContractToBeBilled._CompanyCode AS _CompanyCode,
  UtilsContractToBeBilled._Division AS _Division
FROM I_UtilsContractToBeBilled AS UtilsContractToBeBilled
;

Learn More