C_LockedUtilsContrToBeInvcdOvw

DDL: C_LOCKEDUTILSCONTRTOBEINVCDOVW SQL: CELCONTRTBINVCDO Type: view CONSUMPTION
28 Fields 1 Data Sources 1 Associations

Locked Contract to Be Invoiced

C_LockedUtilsContrToBeInvcdOvw is a Consumption CDS View that provides data about "Locked Contract to Be Invoiced" in SAP S/4HANA. It reads from 1 data source (I_LockedUtilsContrToBeInvcd) and exposes 28 fields with key fields UtilitiesContract, ScheduledUtilitiesBillingDate, UtilitiesPortion, ScheduledMeterReadingDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_LockedUtilsContrToBeInvcd LockedUtilsContrToBeInvcd from

Associations (1)

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

Annotations (8)

NameValueLevelField
EndUserText.label Locked Contract to Be Invoiced view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CELCONTRTBINVCDO 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 (28)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_LockedUtilsContrToBeInvcd UtilitiesContract
KEY ScheduledUtilitiesBillingDate I_LockedUtilsContrToBeInvcd ScheduledUtilitiesBillingDate
KEY UtilitiesPortion I_LockedUtilsContrToBeInvcd UtilitiesPortion
KEY ScheduledMeterReadingDate I_LockedUtilsContrToBeInvcd ScheduledMeterReadingDate
BusinessPartner I_LockedUtilsContrToBeInvcd BusinessPartner Issuing Authority
ContractAccount I_LockedUtilsContrToBeInvcd ContractAccount Contract Acct
CompanyCode I_LockedUtilsContrToBeInvcd CompanyCode Receiver Company Code
Division I_LockedUtilsContrToBeInvcd Division Internal Division ID
UtilitiesInstallation I_LockedUtilsContrToBeInvcd UtilitiesInstallation
UtilitiesAccountDetnCode I_LockedUtilsContrToBeInvcd UtilitiesAccountDetnCode
UtilitiesRateCategory I_LockedUtilsContrToBeInvcd UtilitiesRateCategory
UtilitiesBillingClass I_LockedUtilsContrToBeInvcd UtilitiesBillingClass
AltvContractAcctForCollvBills I_LockedUtilsContrToBeInvcd AltvContractAcctForCollvBills Coll. Bill Acct
CABusinessLockReason I_LockedUtilsContrToBeInvcd CABusinessLockReason Lock Reason
CAInvcgLockReasonName
AuthorizationGroup I_LockedUtilsContrToBeInvcd AuthorizationGroup AuthorizGroup
NmbrOfUtilsContrLockedForInvcg I_LockedUtilsContrToBeInvcd NmbrOfUtilsContrLockedForInvcg
_UtilitiesPortion I_LockedUtilsContrToBeInvcd _UtilitiesPortion
_BusinessPartner I_LockedUtilsContrToBeInvcd _BusinessPartner
_CompanyCode I_LockedUtilsContrToBeInvcd _CompanyCode
_Division I_LockedUtilsContrToBeInvcd _Division
_UtilitiesInstallation I_LockedUtilsContrToBeInvcd _UtilitiesInstallation
_UtilsAccountDetnCode I_LockedUtilsContrToBeInvcd _UtilsAccountDetnCode
_UtilitiesRateCategory I_LockedUtilsContrToBeInvcd _UtilitiesRateCategory
_UtilsBillingClass I_LockedUtilsContrToBeInvcd _UtilsBillingClass
_AltvContrAcc I_LockedUtilsContrToBeInvcd _AltvContrAcc
_CAInvcgLockReason I_LockedUtilsContrToBeInvcd _CAInvcgLockReason
_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_LockedUtilsContrToBeInvcdOvw.
-- 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: CELCONTRTBINVCDO

CREATE VIEW C_LockedUtilsContrToBeInvcdOvw AS
SELECT
  LockedUtilsContrToBeInvcd.UtilitiesContract AS UtilitiesContract,
  LockedUtilsContrToBeInvcd.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  LockedUtilsContrToBeInvcd.UtilitiesPortion AS UtilitiesPortion,
  LockedUtilsContrToBeInvcd.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  LockedUtilsContrToBeInvcd.BusinessPartner AS BusinessPartner,
  LockedUtilsContrToBeInvcd.ContractAccount AS ContractAccount,
  LockedUtilsContrToBeInvcd.CompanyCode AS CompanyCode,
  LockedUtilsContrToBeInvcd.Division AS Division,
  LockedUtilsContrToBeInvcd.UtilitiesInstallation AS UtilitiesInstallation,
  LockedUtilsContrToBeInvcd.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  LockedUtilsContrToBeInvcd.UtilitiesRateCategory AS UtilitiesRateCategory,
  LockedUtilsContrToBeInvcd.UtilitiesBillingClass AS UtilitiesBillingClass,
  LockedUtilsContrToBeInvcd.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
  LockedUtilsContrToBeInvcd.CABusinessLockReason AS CABusinessLockReason,
  LockedUtilsContrToBeInvcd._CAInvcgLockReason._CAInvcgLockReasonText[1: Language = $session.system_language].CAInvcgLockReasonName AS CAInvcgLockReasonName,
  LockedUtilsContrToBeInvcd.AuthorizationGroup AS AuthorizationGroup,
  LockedUtilsContrToBeInvcd.NmbrOfUtilsContrLockedForInvcg AS NmbrOfUtilsContrLockedForInvcg,
  LockedUtilsContrToBeInvcd._UtilitiesPortion AS _UtilitiesPortion,
  LockedUtilsContrToBeInvcd._BusinessPartner AS _BusinessPartner,
  LockedUtilsContrToBeInvcd._CompanyCode AS _CompanyCode,
  LockedUtilsContrToBeInvcd._Division AS _Division,
  LockedUtilsContrToBeInvcd._UtilitiesInstallation AS _UtilitiesInstallation,
  LockedUtilsContrToBeInvcd._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  LockedUtilsContrToBeInvcd._UtilitiesRateCategory AS _UtilitiesRateCategory,
  LockedUtilsContrToBeInvcd._UtilsBillingClass AS _UtilsBillingClass,
  LockedUtilsContrToBeInvcd._AltvContrAcc AS _AltvContrAcc,
  LockedUtilsContrToBeInvcd._CAInvcgLockReason AS _CAInvcgLockReason
FROM I_LockedUtilsContrToBeInvcd AS LockedUtilsContrToBeInvcd
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [1..1]
;

Learn More