I_UtilsContrToBeBlldInvcdAnlys

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_UtilsContrToBeBlldInvcdAnlys.
-- 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: IECONTRTBBILINV

CREATE VIEW I_UtilsContrToBeBlldInvcdAnlys 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.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilsContrToBeBlldData.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilsContrToBeBlldData.CompanyCode AS CompanyCode,
  UtilsContrToBeBlldData.Division AS Division,
  UtilsContrToBeBlldData.UtilitiesInstallation AS UtilitiesInstallation,
  cast(ContractAccountPartner.CAAccountDeterminationCode as e_kofiz_ca_vdm preserving type) AS CAAccountDeterminationCode,
  UtilsContrToBeBlldData.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilsContrToBeBlldData.MeterReadingUnit AS MeterReadingUnit,
  UtilsContrToBeBlldData.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilsContrToBeBlldData.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  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._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilsContrToBeBlldData._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilsContrToBeBlldData._CompanyCode AS _CompanyCode,
  UtilsContrToBeBlldData._Division AS _Division,
  UtilsContrToBeBlldData._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsContrToBeBlldData._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  ContractAccountPartner._AcctDetnCode AS _AcctDetnCode,
  UtilsContrToBeBlldData._MeterReadingUnit AS _MeterReadingUnit,
  UtilsContrToBeBlldData._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsContrToBeBlldData._UtilsBillingClass AS _UtilsBillingClass,
  ContractAccountPartner._AltvContrAcc AS _AltvContrAcc
FROM I_UtilsContrToBeBlldData AS UtilsContrToBeBlldData
INNER JOIN I_ContractAccountPartner AS ContractAccountPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesBillingOrder AS UtilitiesBillingOrder ON /* join condition not captured in parsed metadata */
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 */
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_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_UtilsContrToBeBlldType AS _UtilsContrToBeBlldType ON UtilsContrToBeBlldType = _UtilsContrToBeBlldType.UtilsContrToBeBlldType  -- association [1..1]
LEFT OUTER JOIN I_UtilsContrToBeBlldDetsType AS _UtilsContrToBeBlldDetsType ON UtilsContrToBeBlldDetsType = _UtilsContrToBeBlldDetsType.UtilsContrToBeBlldDetsType  -- association [1..1]
LEFT OUTER JOIN I_UtilsContrToBeInvcdPrgrs AS _UtilsContrToBeInvcdPrgrs ON UtilsContrToBeInvcdPrgrs = _UtilsContrToBeInvcdPrgrs.UtilsContrToBeInvcdPrgrs  -- association [1..1]
LEFT OUTER JOIN I_UtilsContrToBeInvcdPrgrsSts AS _UtilsContrToBeInvcdPrgrsSts ON UtilsContrToBeInvcdPrgrsSts = _UtilsContrToBeInvcdPrgrsSts.UtilsContrToBeInvcdPrgrsSts  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgLockReason AS _CAInvcgLockReason ON CABusinessLockReason = _CAInvcgLockReason.CAInvcgLockReason  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstIntAndExtPtOfDeliv AS _UtilsInstIntAndExtPtOfDeliv ON UtilitiesInstallation = _UtilsInstIntAndExtPtOfDeliv.UtilitiesInstallation AND _UtilsInstIntAndExtPtOfDeliv.UtilsPoDAllocValidityEndDate = '99991231' AND _UtilsInstIntAndExtPtOfDeliv.UtilsPoDAllocValidityEndTime = '235959'  -- association [0..*]
;