C_OutsrtdUtilsBillgDoc

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_OutsrtdUtilsBillgDoc.
-- 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 C_OutsrtdUtilsBillgDoc AS
SELECT
  UtilitiesBillingDocumentTP._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  UtilitiesBillingDocumentTP._ContractAccountPartner.ContractAccountName AS ContractAccountName,
  UtilitiesBillingDocumentTP._UtilitiesContract.UtilitiesContractDescription AS UtilitiesContractDescription,
  UtilitiesBillingDocumentTP._UtilitiesContract.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  _UtilitiesPremise._UtilsTechObjLocationAddr.AddressID AS AddressID,
  UtilitiesBillingDocumentTP._UtilitiesInstallationHist.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilitiesBillingDocumentTP._UtilitiesInstallationHist.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilitiesBillingDocumentTP._UtilitiesInstallationHist.IndustrySector AS IndustrySector,
  UtilitiesBillingDocumentTP._UtilsBillgDocIntAndExtPoD.UtilsExternalPointOfDelivery AS UtilsExternalPointOfDelivery,
  UtilitiesBillingDocumentTP._UtilitiesPortionScheduleRecd.SchedldUtilsInvcgPrintoutDate AS SchedldUtilsInvcgPrintoutDate,
  _CalendarDate._CalendarMonth._Text.CalendarMonthName : localized AS CalendarMonthNamelocalized,
  UtilitiesBillingDocumentTP.UtilitiesBillingDocument AS UtilitiesBillingDocument,
  UtilitiesBillingDocumentTP.UtilsBillgDocTotalNetAmt AS UtilsBillgDocTotalNetAmt,
  UtilitiesBillingDocumentTP.UtilsBillgDocTransactionCrcy AS UtilsBillgDocTransactionCrcy,
  UtilitiesBillingDocumentTP.CompanyCode AS CompanyCode,
  UtilitiesBillingDocumentTP.BusinessPartner AS BusinessPartner,
  UtilitiesBillingDocumentTP.ContractAccount AS ContractAccount,
  UtilitiesBillingDocumentTP.UtilitiesContract AS UtilitiesContract,
  UtilitiesBillingDocumentTP.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilitiesBillingDocumentTP.UtilsBillgPeriodStartDate AS UtilsBillgPeriodStartDate,
  UtilitiesBillingDocumentTP.UtilsBillgPeriodEndDate AS UtilsBillgPeriodEndDate,
  UtilitiesBillingDocumentTP.Division AS Division,
  UtilitiesBillingDocumentTP.UtilitiesPortion AS UtilitiesPortion,
  UtilitiesBillingDocumentTP.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilitiesBillingDocumentTP.MeterReadingUnit AS MeterReadingUnit,
  UtilitiesBillingDocumentTP.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilitiesBillingDocumentTP.UtilsBillgDocCreationDate AS UtilsBillgDocCreationDate,
  UtilitiesBillingDocumentTP.UtilitiesAccountClass AS UtilitiesAccountClass,
  UtilitiesBillingDocumentTP.AltvContractAcctForCollvBills AS AltvContractAcctForCollvBills,
  UtilitiesBillingDocumentTP.UtilitiesInstallation AS UtilitiesInstallation,
  UtilitiesBillingDocumentTP.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilitiesBillingDocumentTP.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilitiesBillingDocumentTP.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilitiesBillingDocumentTP.UtilsContrSpcfcBdgtBillgCycle AS UtilsContrSpcfcBdgtBillgCycle,
  UtilitiesBillingDocumentTP.UtilitiesPremise AS UtilitiesPremise,
  UtilitiesBillingDocumentTP.UtilsOutsrtgCheckGrpForBillg AS UtilsOutsrtgCheckGrpForBillg,
  UtilitiesBillingDocumentTP.UtilitiesBillingCheck AS UtilitiesBillingCheck,
  UtilitiesBillingDocumentTP.UtilsOutsrtdBillgDocDvtgValue AS UtilsOutsrtdBillgDocDvtgValue,
  UtilitiesBillingDocumentTP.UtilsSequenceNumberOutsrtg AS UtilsSequenceNumberOutsrtg,
  UtilitiesBillingDocumentTP.NmbrOfBillgDocOutsrtgDataRecd AS NmbrOfBillgDocOutsrtgDataRecd,
  UtilitiesBillingDocumentTP.UtilsBillgOutsortingReason AS UtilsBillgOutsortingReason,
  UtilitiesBillingDocumentTP.UtilsDefaultBdgtBillgCycle AS UtilsDefaultBdgtBillgCycle,
  UtilitiesBillingDocumentTP.AuthorizationGroup AS AuthorizationGroup,
  UtilitiesBillingDocumentTP.UtilsPostalAddressFormatted AS UtilsPostalAddressFormatted,
  UtilitiesBillingDocumentTP.UtilsBillgDocIsNotReleased AS UtilsBillgDocIsNotReleased,
  UtilitiesBillingDocumentTP.CalendarMonth AS CalendarMonth,
  UtilitiesBillingDocumentTP.CalendarYear AS CalendarYear,
  UtilitiesBillingDocumentTP.UtilsMchnLrngRelConfidenceVal AS UtilsMchnLrngRelConfidenceVal,
  UtilitiesBillingDocumentTP.BPEMCase AS BPEMCase,
  UtilitiesBillingDocumentTP.BPEMCaseCurrentProcessor AS BPEMCaseCurrentProcessor,
  UtilitiesBillingDocumentTP.UserDescription AS UserDescription,
  UtilitiesBillingDocumentTP.BPEMCaseCategory AS BPEMCaseCategory,
  UtilitiesBillingDocumentTP.BPEMCasePreviousProcessor AS BPEMCasePreviousProcessor,
  UtilitiesBillingDocumentTP.LastChangedByUserDescription AS LastChangedByUserDescription,
  UtilitiesBillingDocumentTP.BPEMBusinessProcessCode AS BPEMBusinessProcessCode,
  UtilitiesBillingDocumentTP.BPEMCaseForwardingReason AS BPEMCaseForwardingReason,
  UtilitiesBillingDocumentTP.BPEMCaseCreationDate AS BPEMCaseCreationDate,
  UtilitiesBillingDocumentTP.BPEMCaseDueDate AS BPEMCaseDueDate,
  UtilitiesBillingDocumentTP.BPEMCaseOriginalDate AS BPEMCaseOriginalDate,
  UtilitiesBillingDocumentTP.BPEMCasePriority AS BPEMCasePriority,
  UtilitiesBillingDocumentTP.BPEMCaseStatus AS BPEMCaseStatus,
  UtilitiesBillingDocumentTP.BPEMCaseIsExisting AS BPEMCaseIsExisting,
  UtilitiesBillingDocumentTP._BusinessPartner AS _BusinessPartner,
  UtilitiesBillingDocumentTP._CompanyCode AS _CompanyCode,
  UtilitiesBillingDocumentTP._ContractAccountPartner AS _ContractAccountPartner,
  UtilitiesBillingDocumentTP._Division AS _Division,
  UtilitiesBillingDocumentTP._MeterReadingUnit AS _MeterReadingUnit,
  UtilitiesBillingDocumentTP._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilitiesBillingDocumentTP._UtilitiesContract AS _UtilitiesContract,
  UtilitiesBillingDocumentTP._UtilitiesInstallationHist AS _UtilitiesInstallationHist,
  UtilitiesBillingDocumentTP._UtilitiesPortion AS _UtilitiesPortion,
  UtilitiesBillingDocumentTP._UtilitiesPortionScheduleRecd AS _UtilitiesPortionScheduleRecd,
  UtilitiesBillingDocumentTP._UtilitiesPremise AS _UtilitiesPremise,
  UtilitiesBillingDocumentTP._UtilsAccountClass AS _UtilsAccountClass,
  UtilitiesBillingDocumentTP._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilitiesBillingDocumentTP._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilitiesBillingDocumentTP._UtilsBillgDocDvceLineItem AS _UtilsBillgDocDvceLineItem,
  UtilitiesBillingDocumentTP._UtilsBillgDocTotalNetAmt AS _UtilsBillgDocTotalNetAmt,
  UtilitiesBillingDocumentTP._UtilsContrSpcfcBdgtBillgCyc AS _UtilsContrSpcfcBdgtBillgCyc,
  UtilitiesBillingDocumentTP._UtilitiesBdgtBillgCyc AS _UtilitiesBdgtBillgCyc,
  UtilitiesBillingDocumentTP._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  UtilitiesBillingDocumentTP._UtilsBillgDocIntAndExtPoD AS _UtilsBillgDocIntAndExtPoD,
  UtilitiesBillingDocumentTP._UtilsOutsrtgChkGrpBillg AS _UtilsOutsrtgChkGrpBillg,
  UtilitiesBillingDocumentTP._UtilsBillgOutsortingGroup AS _UtilsBillgOutsortingGroup,
  UtilitiesBillingDocumentTP._OutsrtdUtilsBillgDocTotAmt AS _OutsrtdUtilsBillgDocTotAmt,
  UtilitiesBillingDocumentTP._UtilsBillgDocOutsrtgDataCntr AS _UtilsBillgDocOutsrtgDataCntr,
  UtilitiesBillingDocumentTP._UtilsBillgDocOutsrtgDataRsn AS _UtilsBillgDocOutsrtgDataRsn,
  UtilitiesBillingDocumentTP._CalendarDate AS _CalendarDate,
  UtilitiesBillingDocumentTP._CalendarMonth AS _CalendarMonth,
  UtilitiesBillingDocumentTP._CalendarYear AS _CalendarYear,
  UtilitiesBillingDocumentTP._OutsrtdUtilsBillgDocMaLeRslt AS _OutsrtdUtilsBillgDocMaLeRslt,
  UtilitiesBillingDocumentTP._BPEMBusinessProcessCode AS _BPEMBusinessProcessCode,
  UtilitiesBillingDocumentTP._BPEMCaseCategory AS _BPEMCaseCategory,
  UtilitiesBillingDocumentTP._BPEMCasePriority AS _BPEMCasePriority,
  UtilitiesBillingDocumentTP._User AS _User,
  UtilitiesBillingDocumentTP._PreviousUser AS _PreviousUser,
  UtilitiesBillingDocumentTP._BPEMCaseForwardReason AS _BPEMCaseForwardReason
FROM I_UtilitiesBillingDocumentTP
LEFT OUTER JOIN C_BPEMCaseTP AS _BPEMCaseTP ON UtilitiesInstallation = _BPEMCaseTP.BPEMCaseMainObject AND _BPEMCaseTP.BPEMCaseMainObjectType = 'INSTLN' AND _BPEMCaseTP.BPEMBusinessProcessCode = 'EBI00001'  -- association [0..*]
LEFT OUTER JOIN C_UtilsBillgDocMeteringData AS _UtilsBillgDocMeteringData ON UtilitiesBillingDocument = _UtilsBillgDocMeteringData.UtilitiesBillingDocument  -- association [0..*]
LEFT OUTER JOIN C_UtilsBillgDocOutsrtgData AS _UtilsBillgDocOutsrtgData ON UtilitiesBillingDocument = _UtilsBillgDocOutsrtgData.UtilitiesBillingDocument  -- association [1..*]
LEFT OUTER JOIN I_UtilsBillgDocPrevYrInvcgDoc AS _UtilsBillgDocPrevYrInvcgDoc ON UtilitiesBillingDocument = _UtilsBillgDocPrevYrInvcgDoc.UtilitiesBillingDocument  -- association [0..1]
LEFT OUTER JOIN C_UtilitiesBPContactData AS _UtilitiesBPContactData ON BusinessPartner = _UtilitiesBPContactData.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_OpenBPEMCaseStatusVH AS _OpenBPEMCaseStatus ON BPEMCaseStatus = _OpenBPEMCaseStatus.BPEMCaseStatus  -- association [0..1]
LEFT OUTER JOIN I_UtilsBillingClass AS _UtilsBillingClass ON utilitiesbillingclass = _UtilsBillingClass.UtilitiesBillingClass  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesRateCategory AS _UtilitiesRateCategory ON utilitiesratecategory = _UtilitiesRateCategory.UtilitiesRateCategory  -- association [1]
;