C_ReversedUtilsBillingDocQuery

DDL: C_REVERSEDUTILSBILLINGDOCQUERY SQL: CERVSDBILLGDOCQ Type: view CONSUMPTION
18 Fields 1 Data Sources

Reversed Billing Document Query

C_ReversedUtilsBillingDocQuery (Consumption)

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

Utilities

C_ReversedUtilsBillingDocQuery is a Consumption CDS View that provides data about "Reversed Billing Document Query" in SAP S/4HANA. It reads from 1 data source (I_ReversedUtilsBillingDocument) and exposes 18 fields with key field UtilitiesBillingDocument.

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_ReversedUtilsBillingDocument _ReversedUtilsBillingDocument from

Parameters (1)

NameTypeDefault
P_Language syst_langu

Annotations (12)

NameValueLevelField
EndUserText.label Reversed Billing Document Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CERVSDBILLGDOCQ view
AccessControl.authorizationCheck #PRIVILEGED_ONLY 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 (18)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesBillingDocument UtilitiesBillingDocument Number of Billing Document
BusinessPartner BusinessPartner Business Partner Number
ContractAccount ContractAccount Contract Account Number
UtilitiesContract UtilitiesContract Contract
Division Division Internal Division ID
DivisionName Division Description
UtilitiesPortion UtilitiesPortion Portion
UtilitiesPortionName _UtilitiesPortion UtilitiesPortionName Portion Name
ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate Scheduled Billing Date
UtilsBillgDocReversalRsn UtilsBillgDocReversalRsn Reason for Reversal
UtilsBillgDocReversalRsnName Text, Length 40
MeterReadingUnit MeterReadingUnit Meter Reading Unit
MeterReadingUnitName _MeterReadingUnit MeterReadingUnitName Meter Reading Unit Name
ScheduledMeterReadingDate ScheduledMeterReadingDate Scheduled Meter Reading Date
UtilsBillgDocReversalDate UtilsBillgDocReversalDate Reversal date
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Name of Company Code or Company
NmbrOfReversedUtilsBillgDocs NmbrOfReversedUtilsBillgDocs Number of Reversed Billing Documents

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_ReversedUtilsBillingDocQuery.
-- 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: CERVSDBILLGDOCQ
-- Parameters: P_Language : syst_langu

CREATE VIEW C_ReversedUtilsBillingDocQuery AS
SELECT
  UtilitiesBillingDocument,
  BusinessPartner,
  ContractAccount,
  UtilitiesContract,
  Division,
  _Division._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
  UtilitiesPortion,
  _UtilitiesPortion.UtilitiesPortionName AS UtilitiesPortionName,
  ScheduledUtilitiesBillingDate,
  UtilsBillgDocReversalRsn,
  _UtilsBillingDocReversalRsn._Text[1: Language=$parameters.P_Language].UtilsBillgDocReversalRsnName AS UtilsBillgDocReversalRsnName,
  MeterReadingUnit,
  _MeterReadingUnit.MeterReadingUnitName AS MeterReadingUnitName,
  ScheduledMeterReadingDate,
  UtilsBillgDocReversalDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  NmbrOfReversedUtilsBillgDocs
FROM I_ReversedUtilsBillingDocument AS _ReversedUtilsBillingDocument
;

Learn More