I_SchedldUtilsContrNotInvcd

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 I_SchedldUtilsContrNotInvcd.
-- 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: IESCHCONTRNTINV

CREATE VIEW I_SchedldUtilsContrNotInvcd AS
SELECT
  UtilsContrToBeBlldData.UtilitiesContract AS UtilitiesContract,
  UtilsContrToBeBlldData.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsContrToBeBlldData.UtilitiesPortion AS UtilitiesPortion,
  UtilsContrToBeBlldData.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  ContractAccountPartner.BusinessPartner AS BusinessPartner,
  UtilsContrToBeBlldData.ContractAccount AS ContractAccount,
  UtilsContrToBeBlldData.CompanyCode AS CompanyCode,
  UtilsContrToBeBlldData.Division AS Division,
  UtilsContrToBeBlldData.UtilitiesInstallation AS UtilitiesInstallation,
  UtilsContrToBeBlldData.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  cast(ContractAccountPartner.CAAccountDeterminationCode as e_kofiz_ca_vdm preserving type) AS CAAccountDeterminationCode,
  UtilsContrToBeBlldData.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilsContrToBeBlldData.UtilitiesBillingClass AS UtilitiesBillingClass,
  cast(ContractAccountPartner.AltvContractAcctForCollvBills as e_collvbillacct_vdm preserving type) AS AltvContractAcctForCollvBills,
  UtilsContrToBeBlldData.AuthorizationGroup AS AuthorizationGroup,
  cast(1 as e_nrofutilscontr_vdm) AS NmbrOfUtilsContrToBeInvoiced,
  UtilsContrToBeBlldData._UtilitiesPortion AS _UtilitiesPortion,
  ContractAccountPartner._BusinessPartner AS _BusinessPartner,
  UtilsContrToBeBlldData._CompanyCode AS _CompanyCode,
  UtilsContrToBeBlldData._Division AS _Division,
  UtilsContrToBeBlldData._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsContrToBeBlldData._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  ContractAccountPartner._AcctDetnCode AS _AcctDetnCode,
  UtilsContrToBeBlldData._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsContrToBeBlldData._UtilsBillingClass AS _UtilsBillingClass,
  ContractAccountPartner._AltvContrAcc AS _AltvContrAcc
FROM I_UtilsContrToBeBlldData AS UtilsContrToBeBlldData
LEFT OUTER JOIN P_SuppressedUtilsBillingOrder AS SuppressedUtilsBillingOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesBillingDocument AS UtilitiesBillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsBillgDocInvcgHistory AS UtilsBillgDocInvcgHistory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesInvoicingDocument AS UtilitiesInvoicingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesInvoicingOrder AS UtilitiesInvoicingOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsContrAcctBlkdByJntInvcg AS UtilsContrAcctBlkdByJntInvcg ON /* join condition not captured in parsed metadata */
INNER JOIN I_ContractAccountPartner AS ContractAccountPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ActvUtilsCAInvcgLockRsn AS ActvUtilsCAInvcgLockRsn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ActvUtilsContrInvcgLockRsn AS ActvUtilsContrInvcgLockRsn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsContrToBeInvcdPrgrsSts AS _UtilsContrToBeInvcdPrgrsSts ON UtilsContrToBeInvcdPrgrsSts = _UtilsContrToBeInvcdPrgrsSts.UtilsContrToBeInvcdPrgrsSts  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgLockReason AS _CAInvcgLockReason ON CABusinessLockReason = _CAInvcgLockReason.CAInvcgLockReason  -- association [0..1]
;