C_SchedUtilsContrUrdyInvcgOvw

DDL: C_SCHEDUTILSCONTRURDYINVCGOVW SQL: CESCHCONTRNTRDYO Type: view CONSUMPTION
33 Fields 1 Data Sources 1 Associations

Scheduled Contract is not Ready for Invoicing

C_SchedUtilsContrUrdyInvcgOvw is a Consumption CDS View that provides data about "Scheduled Contract is not Ready for Invoicing" in SAP S/4HANA. It reads from 1 data source (I_SchedldUtilsContrUrdyInvcg) and exposes 33 fields with key fields UtilitiesContract, ScheduledUtilitiesBillingDate, UtilitiesPortion, ScheduledMeterReadingDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SchedldUtilsContrUrdyInvcg SchedldUtilsContrUrdyInvcg 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 is not Ready for Invoicing view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CESCHCONTRNTRDYO 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 (33)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_SchedldUtilsContrUrdyInvcg UtilitiesContract
KEY ScheduledUtilitiesBillingDate I_SchedldUtilsContrUrdyInvcg ScheduledUtilitiesBillingDate
KEY UtilitiesPortion I_SchedldUtilsContrUrdyInvcg UtilitiesPortion
KEY ScheduledMeterReadingDate I_SchedldUtilsContrUrdyInvcg ScheduledMeterReadingDate
BusinessPartner I_SchedldUtilsContrUrdyInvcg BusinessPartner Issuing Authority
ContractAccount I_SchedldUtilsContrUrdyInvcg ContractAccount Contract Acct
CompanyCode I_SchedldUtilsContrUrdyInvcg CompanyCode Receiver Company Code
Division I_SchedldUtilsContrUrdyInvcg Division Internal Division ID
UtilitiesInstallation I_SchedldUtilsContrUrdyInvcg UtilitiesInstallation
UtilitiesAccountDetnCode I_SchedldUtilsContrUrdyInvcg UtilitiesAccountDetnCode
UtilitiesRateCategory I_SchedldUtilsContrUrdyInvcg UtilitiesRateCategory
UtilitiesBillingClass I_SchedldUtilsContrUrdyInvcg UtilitiesBillingClass
AltvContractAcctForCollvBills I_SchedldUtilsContrUrdyInvcg AltvContractAcctForCollvBills Coll. Bill Acct
CABusinessLockReason I_SchedldUtilsContrUrdyInvcg CABusinessLockReason Lock Reason
UtilsContrToBeInvcdPrgrsSts I_SchedldUtilsContrUrdyInvcg UtilsContrToBeInvcdPrgrsSts
UtilsContrToBeInvcdPrgrsStsTxt
UtilsContrToBeBlldDetsType I_SchedldUtilsContrUrdyInvcg UtilsContrToBeBlldDetsType
UtilsContrToBeBlldDetsTypeName
AuthorizationGroup I_SchedldUtilsContrUrdyInvcg AuthorizationGroup AuthorizGroup
NmbrOfUtilsContrToBeInvoiced I_SchedldUtilsContrUrdyInvcg NmbrOfUtilsContrToBeInvoiced
_UtilitiesPortion I_SchedldUtilsContrUrdyInvcg _UtilitiesPortion
_BusinessPartner I_SchedldUtilsContrUrdyInvcg _BusinessPartner
_CompanyCode I_SchedldUtilsContrUrdyInvcg _CompanyCode
_Division I_SchedldUtilsContrUrdyInvcg _Division
_UtilitiesInstallation I_SchedldUtilsContrUrdyInvcg _UtilitiesInstallation
_UtilsAccountDetnCode I_SchedldUtilsContrUrdyInvcg _UtilsAccountDetnCode
_UtilitiesRateCategory I_SchedldUtilsContrUrdyInvcg _UtilitiesRateCategory
_UtilsBillingClass I_SchedldUtilsContrUrdyInvcg _UtilsBillingClass
_AltvContrAcc I_SchedldUtilsContrUrdyInvcg _AltvContrAcc
_CAInvcgLockReason I_SchedldUtilsContrUrdyInvcg _CAInvcgLockReason
_UtilsContrToBeInvcdPrgrsSts I_SchedldUtilsContrUrdyInvcg _UtilsContrToBeInvcdPrgrsSts
_UtilsContrToBeBlldDetsType I_SchedldUtilsContrUrdyInvcg _UtilsContrToBeBlldDetsType
_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_SchedUtilsContrUrdyInvcgOvw.
-- 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: CESCHCONTRNTRDYO

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

Learn More