I_UtilitiesContractTP

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_UtilitiesContractTP.
-- 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.

CREATE VIEW I_UtilitiesContractTP AS
SELECT
  UtilitiesContract.UtilitiesContract AS UtilitiesContract,
  UtilitiesContract.UtilitiesInstallation AS UtilitiesInstallation,
  ContractAccountPartner.BusinessPartner AS BusinessPartner,
  UtilitiesInstallationHist.UtilsInstHistValidityEndDate AS UtilsInstHistValidityEndDate,
  _UtilsInstIntAndExtPtOfDeliv.UtilsInternalPointOfDelivery AS UtilsInternalPointOfDelivery,
  UtilitiesContract.CompanyCode AS CompanyCode,
  UtilitiesContract.UtilitiesDivision AS UtilitiesDivision,
  UtilitiesContract.AlternativeUtilitiesPortion AS AlternativeUtilitiesPortion,
  UtilitiesContract.UtilsContrIsBilledManually AS UtilsContrIsBilledManually,
  UtilitiesContract.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilitiesContract.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilitiesContract.ContractAccount AS ContractAccount,
  UtilitiesContract.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilitiesContract.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilitiesContract.UtilsContrIsFinallyBilled AS UtilsContrIsFinallyBilled,
  UtilitiesContract.UtilsPlantOrCompanyConsumption AS UtilsPlantOrCompanyConsumption,
  UtilitiesContract.UtilsContrJointInvcType AS UtilsContrJointInvcType,
  UtilitiesContract.UtilitiesContractCanclnDate AS UtilitiesContractCanclnDate,
  UtilitiesContract.UtilitiesContractRenewalDate AS UtilitiesContractRenewalDate,
  UtilitiesContract.CADunningProcedure AS CADunningProcedure,
  UtilitiesContract.UtilitiesServiceProvider AS UtilitiesServiceProvider,
  UtilitiesContract.UtilsContractProcessingSts AS UtilsContractProcessingSts,
  UtilitiesContract.AuthorizationGroup AS AuthorizationGroup,
  UtilitiesContract.DeletionIndicator AS DeletionIndicator,
  UtilitiesContract.UtilsOutsrtgCheckGrpForBillg AS UtilsOutsrtgCheckGrpForBillg,
  UtilitiesContract.UtilitiesContractDescription AS UtilitiesContractDescription,
  UtilitiesContract.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilitiesContract.UtilsContrSpcfcBdgtBillgCycle AS UtilsContrSpcfcBdgtBillgCycle,
  UtilitiesContract.UtilsBillgOutsortingReason AS UtilsBillgOutsortingReason,
  UtilitiesInstallationHist._MeterReadingUnit.UtilitiesPortion AS UtilitiesPortion,
  UtilitiesInstallationHist.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilitiesInstallationHist.MeterReadingUnit AS MeterReadingUnit,
  UtilitiesInstallationHist.UtilitiesRateCategory AS UtilitiesRateCategory,
  cast(ContractAccountPartner._ContrAcc.ContractAccountCategory as e_vktyp_vdm preserving type) AS ContractAccountCategory,
  ContractAccountPartner._ContrAcc.CAApplicationArea AS CAApplicationArea,
  cast(ContractAccountPartner.CAAlternativeInvoiceRecipient as e_altinvrec_vdm preserving type ) AS CAAlternativeInvoiceRecipient,
  ContractAccountPartner._RelshpOfBP.CABPIsAccountHolder AS CABPIsAccountHolder,
  ContractAccountPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  UtilitiesContract.LastUtilitiesPortion AS LastUtilitiesPortion,
  _LtstUtilsContrBillgBlkRsnChg._UtilsContrBillgBlkRsnChgs.CreatedByUser AS CreatedByUser,
  _LtstUtilsContrBillgBlkRsnChg._UtilsContrBillgBlkRsnChgs._User.UserDescription AS UserDescription,
  _LtstUtilsContrBillgBlkRsnChg._UtilsContrBillgBlkRsnChgs.CreationDate AS CreationDate,
  _LtstUtilsBillgDateForContr._UtilsBillgDocForContract.UtilitiesBillingDocument AS UtilitiesBillingDocument,
  _LtstUtilsBillgDateForContr.UtilsBillgPeriodEndDate AS UtilsBillgPeriodEndDate,
  _LtstUtilsBillgDateForContr._UtilsBillgDocForContract.UtilsBillgPeriodStartDate AS UtilsBillgPeriodStartDate,
  _LtstUtilsBillgDateForContr._UtilsBillgDocForContract.UtilsBillgDocCreationDate AS UtilsBillgDocCreationDate,
  _UtilsInstIntAndExtPtOfDeliv.UtilsExternalPointOfDelivery AS UtilsExternalPointOfDelivery,
  UtilitiesContract._UtilitiesInstallation.UtilitiesPremise AS UtilitiesPremise,
  UtilitiesContract._Division AS _Division,
  UtilitiesContract._CompanyCode AS _CompanyCode,
  UtilitiesContract._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilitiesContract._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilitiesContract._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilitiesContract._UtilsOutsrtgChkGrpBillg AS _UtilsOutsrtgChkGrpBillg,
  UtilitiesContract._UtilsContrSpcfcBdgtBillgCyc AS _UtilsContrSpcfcBdgtBillgCyc,
  UtilitiesContract._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  UtilitiesContract._UtilsPlantOrCompanyCnsmpn AS _UtilsPlantOrCompanyCnsmpn,
  UtilitiesContract._InvcUtilsContractsJointly AS _InvcUtilsContractsJointly,
  UtilitiesContract._CADunningProcedure AS _CADunningProcedure,
  UtilitiesContract._UtilsContrProcessingStatus AS _UtilsContrProcessingStatus,
  UtilitiesContract._UtilitiesServiceProvider AS _UtilitiesServiceProvider,
  UtilitiesContract._UtilsBillgOutsortingGroup AS _UtilsBillgOutsortingGroup,
  ContractAccountPartner._ContrAcc._ApplArea AS _ApplArea,
  UtilitiesContract._UtilitiesInstallation._UtilitiesPremise AS _UtilitiesPremise,
  UtilitiesInstallationHist._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilitiesInstallationHist._UtilsBillingClass AS _UtilsBillingClass,
  UtilitiesInstallationHist._MeterReadingUnit AS _MeterReadingUnit,
  ContractAccountPartner._BusinessPartner AS _BusinessPartner,
  ContractAccountPartner._ContrAcc._Category AS _ContractAccountCategory,
  ContractAccountPartner._AltvInvoiceRecipient AS _AltvInvoiceRecipient,
  _LtstUtilsContrBillgBlkRsnChg._UtilsContrBillgBlkRsnChgs._User AS _User
FROM I_UtilitiesContract AS UtilitiesContract
INNER JOIN I_UtilitiesInstallationHist AS UtilitiesInstallationHist 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_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CABusinessLock AS _CABusinessLock ON UtilitiesContract = _CABusinessLock.CABusinessLockObject AND _CABusinessLock.CABusinessLockValidFrom <= UtilitiesMoveInDate AND _CABusinessLock.CABusinessLockValidTo >= UtilitiesMoveInDate AND _CABusinessLock.CABusinessLockObjectCategory = '41'  -- association [0..1]
LEFT OUTER JOIN I_UtilsInstIntAndExtPtOfDeliv AS _UtilsInstIntAndExtPtOfDeliv ON UtilitiesInstallation = _UtilsInstIntAndExtPtOfDeliv.UtilitiesInstallation AND _UtilsInstIntAndExtPtOfDeliv.UtilsPoDAllocValidityEndDate = '99991231' AND _UtilsInstIntAndExtPtOfDeliv.UtilsPoDAllocValidityEndTime = '235959'  -- association [0..*]
LEFT OUTER JOIN I_LatestUtilsBillgOrdForContr AS _LatestUtilsBillgOrdForContr ON UtilitiesContract = _LatestUtilsBillgOrdForContr.UtilitiesContract  -- association [0..1]
LEFT OUTER JOIN I_LtstUtilsContrBillgBlkRsnChg AS _LtstUtilsContrBillgBlkRsnChg ON UtilitiesContract = _LtstUtilsContrBillgBlkRsnChg.ChangeDocObject  -- association [0..1]
LEFT OUTER JOIN I_LtstUtilsBillgDateForContr AS _LtstUtilsBillgDateForContr ON UtilitiesContract = _LtstUtilsBillgDateForContr.UtilitiesContract  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPortion AS _UtilitiesPortion ON utilitiesportion = _UtilitiesPortion.UtilitiesPortion  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPortion AS _AlternativeUtilitiesPortion ON AlternativeUtilitiesPortion = _AlternativeUtilitiesPortion.UtilitiesPortion  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPortion AS _LastUtilitiesPortion ON LastUtilitiesPortion = _LastUtilitiesPortion.UtilitiesPortion  -- association [0..1]
;