C_OutsrtdUtilsBillgDocBscDataQ

DDL: C_OUTSRTDUTILSBILLGDOCBSCDATAQ SQL: CEOUTSRTDBDBSCDQ Type: view CONSUMPTION
19 Fields 1 Data Sources

Outsorted Billing Document Basic Data Query

Outsorted Billing Document Basic Data - Query

C_OutsrtdUtilsBillgDocBscDataQ (Consumption)

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

Utilities

C_OutsrtdUtilsBillgDocBscDataQ is a Consumption CDS View that provides data about "Outsorted Billing Document Basic Data Query" in SAP S/4HANA. It reads from 1 data source (I_OutsrtdUtilsBillgDocBscData) and exposes 19 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_OutsrtdUtilsBillgDocBscData _OutsrtdUtilsBillgDocBscData from

Parameters (1)

NameTypeDefault
P_Language syst_langu

Annotations (9)

NameValueLevelField
EndUserText.label Outsorted Billing Document Basic Data Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CEOUTSRTDBDBSCDQ 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

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesBillingDocument UtilitiesBillingDocument Number of Billing Document
BusinessPartner BusinessPartner Business Partner Number
ContractAccount ContractAccount Contract Account Number
UtilitiesContract UtilitiesContract Contract
UtilsBusTransactionType UtilsBusTransactionType Main Transaction for Line Item
UtilitiesPortion UtilitiesPortion Portion
UtilitiesPortionName _UtilitiesPortion UtilitiesPortionName Portion Name
ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate Scheduled Billing Date
UtilitiesBillingReason UtilitiesBillingReason Billing Reason
UtilitiesBillingReasonName Billing Reason Name
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Name of Company Code or Company
Division Division Internal Division ID
DivisionName Division Description
MeterReadingUnit MeterReadingUnit Meter Reading Unit
UtilsBillgPeriodStartDate UtilsBillgPeriodStartDate Billing Period Start
UtilsBillgPeriodEndDate UtilsBillgPeriodEndDate Billing Period End
ScheduledMeterReadingDate ScheduledMeterReadingDate Scheduled Meter Reading Date
NmbrOfOutsortedUtilsBillgDocs NmbrOfOutsortedUtilsBillgDocs Number of Outsorted 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_OutsrtdUtilsBillgDocBscDataQ.
-- 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: CEOUTSRTDBDBSCDQ
-- Parameters: P_Language : syst_langu

CREATE VIEW C_OutsrtdUtilsBillgDocBscDataQ AS
SELECT
  UtilitiesBillingDocument,
  BusinessPartner,
  ContractAccount,
  UtilitiesContract,
  UtilsBusTransactionType,
  UtilitiesPortion,
  _UtilitiesPortion.UtilitiesPortionName AS UtilitiesPortionName,
  ScheduledUtilitiesBillingDate,
  UtilitiesBillingReason,
  _UtilitiesBillingReason._Text[1: Language=$parameters.P_Language].UtilitiesBillingReasonName AS UtilitiesBillingReasonName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Division,
  _Division._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
  MeterReadingUnit,
  UtilsBillgPeriodStartDate,
  UtilsBillgPeriodEndDate,
  ScheduledMeterReadingDate,
  NmbrOfOutsortedUtilsBillgDocs
FROM I_OutsrtdUtilsBillgDocBscData AS _OutsrtdUtilsBillgDocBscData
;

Learn More