I_UtilsContractProductChanges

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_UtilsContractProductChanges.
-- 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: IECONTPRODCHGS
-- Parameters: P_StartDate : sydate, P_EndDate : sydate

CREATE VIEW I_UtilsContractProductChanges AS
SELECT
  UtilitiesContract.UtilitiesContract AS UtilitiesContract,
  cast(UtilitiesContractHistory.UtilsContractValidityEndDate as e_utilsprodcenddate_vdm preserving type ) AS UtilsProdAllocationEndDate,
  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.UtilitiesInstallation AS UtilitiesInstallation,
  UtilitiesContract.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  UtilitiesContract.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  UtilitiesContract.UtilsContractCreationDate AS UtilsContractCreationDate,
  UtilitiesContract.UtilsContractCreatedByUser AS UtilsContractCreatedByUser,
  UtilitiesContract.UtilsContractLastChangeDate AS UtilsContractLastChangeDate,
  UtilitiesContract.UtilsContractLastChangedByUser AS UtilsContractLastChangedByUser,
  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.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilitiesContract.UtilsContrSpcfcBdgtBillgCycle AS UtilsContrSpcfcBdgtBillgCycle,
  UtilitiesContract.UtilsBillgOutsortingReason AS UtilsBillgOutsortingReason,
  cast(UtilitiesMoveOutDocument.UtilsMoveOutDocCreationDate as e_utilscontrtermdate_vdm preserving type ) AS UtilsContractTerminationDate,
  cast(UtilitiesContractHistory.UtilsContractValidityStartDate as e_utilsprodcstartdate_vdm preserving type ) AS UtilsProdAllocationStartDate,
  cast(UtilitiesContractHistory.UtilitiesProduct as e_targetutilsproduct_vdm preserving type ) AS UtilitiesProduct,
  cast(UtilsContrNextValidityPeriod.UtilitiesProduct as e_oldutilsproduct_vdm preserving type ) AS UtilitiesPreviousProduct,
  cast(MoveInDate.YearMonth as e_moveinasyearmonth_vdm preserving type ) AS UtilsMoveInDateAsYearMonth,
  cast(MoveOutDate.YearMonth as e_moveoutasyearmonth_vdm preserving type ) AS UtilsMoveOutDateAsYearMonth,
  UtilitiesContract._Division AS _Division,
  UtilitiesContract._CompanyCode AS _CompanyCode,
  UtilitiesContract._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilitiesContract._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilitiesContract._CreatedByUser AS _CreatedByUser,
  UtilitiesContract._LastChangedByUser AS _LastChangedByUser,
  UtilitiesContract._UtilitiesPortion AS _UtilitiesPortion,
  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._UtilsContrProcessingStatus AS _UtilsContrProcessingStatus,
  UtilitiesContract._UtilsBillgOutsortingGroup AS _UtilsBillgOutsortingGroup,
  UtilitiesContract._UtilitiesServiceProvider AS _UtilitiesServiceProvider,
  UtilitiesContract._CADunningProcedure AS _CADunningProcedure,
  UtilitiesContract._UtilitiesContractHistory AS _UtilitiesContractHistory
FROM I_UtilitiesContract AS UtilitiesContract
LEFT OUTER JOIN I_UtilitiesContractHistory AS UtilitiesContractHistory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilitiesMoveOutDocument AS UtilitiesMoveOutDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsContrNextValidityPeriod AS UtilsContrNextValidityPeriod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS MoveOutDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS MoveInDate ON /* join condition not captured in parsed metadata */
;