C_SchedldUtilsContrNotInvcdOvw

DDL: C_SCHEDLDUTILSCONTRNOTINVCDOVW SQL: CESCHCONTRNTINV Type: view CONSUMPTION
30 Fields 1 Data Sources 1 Associations

Scheduled Contract Has not Been Invoiced

C_SchedldUtilsContrNotInvcdOvw is a Consumption CDS View that provides data about "Scheduled Contract Has not Been Invoiced" in SAP S/4HANA. It reads from 1 data source (I_SchedldUtilsContrNotInvcd) and exposes 30 fields with key fields UtilitiesContract, ScheduledUtilitiesBillingDate, UtilitiesPortion, ScheduledMeterReadingDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SchedldUtilsContrNotInvcd SchedldUtilsContrNotInvcd from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ContractAccountPartner _ContractAccountPartner $projection.ContractAccount = _ContractAccountPartner.ContractAccount and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner

Annotations (8)

NameValueLevelField
EndUserText.label Scheduled Contract Has not Been Invoiced view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CESCHCONTRNTINV view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_SchedldUtilsContrNotInvcd UtilitiesContract
KEY ScheduledUtilitiesBillingDate I_SchedldUtilsContrNotInvcd ScheduledUtilitiesBillingDate
KEY UtilitiesPortion I_SchedldUtilsContrNotInvcd UtilitiesPortion
KEY ScheduledMeterReadingDate I_SchedldUtilsContrNotInvcd ScheduledMeterReadingDate
BusinessPartner I_SchedldUtilsContrNotInvcd BusinessPartner Issuing Authority
ContractAccount I_SchedldUtilsContrNotInvcd ContractAccount Contract Acct
CompanyCode I_SchedldUtilsContrNotInvcd CompanyCode Receiver Company Code
Division I_SchedldUtilsContrNotInvcd Division Internal Division ID
UtilitiesInstallation I_SchedldUtilsContrNotInvcd UtilitiesInstallation
UtilitiesAccountDetnCode I_SchedldUtilsContrNotInvcd UtilitiesAccountDetnCode
UtilitiesRateCategory I_SchedldUtilsContrNotInvcd UtilitiesRateCategory
UtilitiesBillingClass I_SchedldUtilsContrNotInvcd UtilitiesBillingClass
AltvContractAcctForCollvBills I_SchedldUtilsContrNotInvcd AltvContractAcctForCollvBills Coll. Bill Acct
CABusinessLockReason I_SchedldUtilsContrNotInvcd CABusinessLockReason Lock Reason
UtilsContrToBeInvcdPrgrsSts I_SchedldUtilsContrNotInvcd UtilsContrToBeInvcdPrgrsSts
UtilsContrToBeInvcdPrgrsStsTxt
AuthorizationGroup I_SchedldUtilsContrNotInvcd AuthorizationGroup AuthorizGroup
NmbrOfUtilsContrToBeInvoiced I_SchedldUtilsContrNotInvcd NmbrOfUtilsContrToBeInvoiced
_UtilitiesPortion I_SchedldUtilsContrNotInvcd _UtilitiesPortion
_BusinessPartner I_SchedldUtilsContrNotInvcd _BusinessPartner
_CompanyCode I_SchedldUtilsContrNotInvcd _CompanyCode
_Division I_SchedldUtilsContrNotInvcd _Division
_UtilitiesInstallation I_SchedldUtilsContrNotInvcd _UtilitiesInstallation
_UtilsAccountDetnCode I_SchedldUtilsContrNotInvcd _UtilsAccountDetnCode
_UtilitiesRateCategory I_SchedldUtilsContrNotInvcd _UtilitiesRateCategory
_UtilsBillingClass I_SchedldUtilsContrNotInvcd _UtilsBillingClass
_AltvContrAcc I_SchedldUtilsContrNotInvcd _AltvContrAcc
_CAInvcgLockReason I_SchedldUtilsContrNotInvcd _CAInvcgLockReason
_UtilsContrToBeInvcdPrgrsSts I_SchedldUtilsContrNotInvcd _UtilsContrToBeInvcdPrgrsSts
_ContractAccountPartner _ContractAccountPartner

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_SchedldUtilsContrNotInvcdOvw.
-- 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: CESCHCONTRNTINV

CREATE VIEW C_SchedldUtilsContrNotInvcdOvw AS
SELECT
  SchedldUtilsContrNotInvcd.UtilitiesContract AS UtilitiesContract,
  SchedldUtilsContrNotInvcd.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  SchedldUtilsContrNotInvcd.UtilitiesPortion AS UtilitiesPortion,
  SchedldUtilsContrNotInvcd.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  SchedldUtilsContrNotInvcd.BusinessPartner AS BusinessPartner,
  SchedldUtilsContrNotInvcd.ContractAccount AS ContractAccount,
  SchedldUtilsContrNotInvcd.CompanyCode AS CompanyCode,
  SchedldUtilsContrNotInvcd.Division AS Division,
  SchedldUtilsContrNotInvcd.UtilitiesInstallation AS UtilitiesInstallation,
  SchedldUtilsContrNotInvcd.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  SchedldUtilsContrNotInvcd.UtilitiesRateCategory AS UtilitiesRateCategory,
  SchedldUtilsContrNotInvcd.UtilitiesBillingClass AS UtilitiesBillingClass,
  SchedldUtilsContrNotInvcd.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
  SchedldUtilsContrNotInvcd.CABusinessLockReason AS CABusinessLockReason,
  SchedldUtilsContrNotInvcd.UtilsContrToBeInvcdPrgrsSts AS UtilsContrToBeInvcdPrgrsSts,
  SchedldUtilsContrNotInvcd._UtilsContrToBeInvcdPrgrsSts._Text[1: Language = $session.system_language].UtilsContrToBeInvcdPrgrsStsTxt AS UtilsContrToBeInvcdPrgrsStsTxt,
  SchedldUtilsContrNotInvcd.AuthorizationGroup AS AuthorizationGroup,
  SchedldUtilsContrNotInvcd.NmbrOfUtilsContrToBeInvoiced AS NmbrOfUtilsContrToBeInvoiced,
  SchedldUtilsContrNotInvcd._UtilitiesPortion AS _UtilitiesPortion,
  SchedldUtilsContrNotInvcd._BusinessPartner AS _BusinessPartner,
  SchedldUtilsContrNotInvcd._CompanyCode AS _CompanyCode,
  SchedldUtilsContrNotInvcd._Division AS _Division,
  SchedldUtilsContrNotInvcd._UtilitiesInstallation AS _UtilitiesInstallation,
  SchedldUtilsContrNotInvcd._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  SchedldUtilsContrNotInvcd._UtilitiesRateCategory AS _UtilitiesRateCategory,
  SchedldUtilsContrNotInvcd._UtilsBillingClass AS _UtilsBillingClass,
  SchedldUtilsContrNotInvcd._AltvContrAcc AS _AltvContrAcc,
  SchedldUtilsContrNotInvcd._CAInvcgLockReason AS _CAInvcgLockReason,
  SchedldUtilsContrNotInvcd._UtilsContrToBeInvcdPrgrsSts AS _UtilsContrToBeInvcdPrgrsSts
FROM I_SchedldUtilsContrNotInvcd AS SchedldUtilsContrNotInvcd
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [1..1]
;

Learn More