C_MtrRdngDocumentTP

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_MtrRdngDocumentTP.
-- 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_MtrRdngDocumentTP AS
SELECT
  I_MeterReadingDocumentTP.MeterReadingDocument AS MeterReadingDocument,
  I_MeterReadingDocumentTP.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  cast( I_MeterReadingDocumentTP.SerialNumber as geraet preserving type ) AS UtilitiesDevice,
  I_MeterReadingDocumentTP.MeterReadingReason AS MeterReadingReason,
  I_MeterReadingDocumentTP.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  I_MeterReadingDocumentTP.Division AS Division,
  I_MeterReadingDocumentTP.UtilsDeviceCategoryDescription AS UtilsDeviceCategoryDescription,
  I_MeterReadingDocumentTP.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  I_MeterReadingDocumentTP.UtilitiesRegister AS UtilitiesRegister,
  I_MeterReadingDocumentTP.UtilitiesRegisterTypeName AS UtilitiesRegisterTypeName,
  I_MeterReadingDocumentTP.MeterReadingUnit AS MeterReadingUnit,
  I_MeterReadingDocumentTP.UtilitiesPremise AS UtilitiesPremise,
  I_MeterReadingDocumentTP._UtilitiesPremise AS _UtilitiesPremise,
  I_MeterReadingDocumentTP.AddressID AS AddressID,
  I_MeterReadingDocumentTP.UtilsPostalAddressFormatted AS UtilsPostalAddressFormatted,
  I_MeterReadingDocumentTP.UtilitiesInstallation AS UtilitiesInstallation,
  I_MeterReadingDocumentTP.MeterReadingStatus AS MeterReadingStatus,
  I_MeterReadingDocumentTP.MeterReadingDate AS MeterReadingDate,
  I_MeterReadingDocumentTP.MeterReadingTime AS MeterReadingTime,
  I_MeterReadingDocumentTP.MeterReadingResultPreDecimals AS MeterReadingResultPreDecimals,
  I_MeterReadingDocumentTP.MeterReadingResultDecimals AS MeterReadingResultDecimals,
  I_MeterReadingDocumentTP.MeterReadingResultDifference AS MeterReadingResultDifference,
  I_MeterReadingDocumentTP.MeterReadingResultDiffVal AS MeterReadingResultDiffVal,
  I_MeterReadingDocumentTP.MeterReadingMeasurementUnit AS MeterReadingMeasurementUnit,
  I_MeterReadingDocumentTP.UtilsBillingFactor AS UtilsBillingFactor,
  I_MeterReadingDocumentTP.MeterReadingConsumptionActual AS MeterReadingConsumptionActual,
  I_MeterReadingDocumentTP.MeterReadingConsumptionExpd AS MeterReadingConsumptionExpd,
  I_MeterReadingDocumentTP.MeterReadingOriginEstimation AS MeterReadingOriginEstimation,
  I_MeterReadingDocumentTP.MeterReadingEstimatedValue AS MeterReadingEstimatedValue,
  I_MeterReadingDocumentTP.MeterReadingType AS MeterReadingType,
  I_MeterReadingDocumentTP._MeterReaderCode.MeterReader AS MeterReader,
  I_MeterReadingDocumentTP.MeterReaderNoteCode AS MeterReaderNoteCode,
  I_MeterReadingDocumentTP.UtilitiesPortion AS UtilitiesPortion,
  I_MeterReadingDocumentTP.IndepMtrRdngValidationChk AS IndepMtrRdngValidationChk,
  I_MeterReadingDocumentTP.DepdntMtrRdngValidationChk AS DepdntMtrRdngValidationChk,
  I_MeterReadingDocumentTP.UtilitiesRateCategory AS UtilitiesRateCategory,
  I_MeterReadingDocumentTP.MeterReadingRsnScheduledDate AS MeterReadingRsnScheduledDate,
  I_MeterReadingDocumentTP.BusinessPartnerName AS BusinessPartnerName,
  I_MeterReadingDocumentTP.BusinessPartner AS BusinessPartner,
  I_MeterReadingDocumentTP.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  I_MeterReadingDocumentTP.MeterReadingDatesDifference AS MeterReadingDatesDifference,
  I_MeterReadingDocumentTP.MtrRdngDocHasMltplRsn AS MtrRdngDocHasMltplRsn,
  I_MeterReadingDocumentTP.MtrRdngDocHasMltplInst AS MtrRdngDocHasMltplInst,
  I_MeterReadingDocumentTP.MtrRdngDocHasMltplMtrRdngUnit AS MtrRdngDocHasMltplMtrRdngUnit,
  I_MeterReadingDocumentTP.Equipment AS Equipment,
  _MeterReadingValdtnInfo.MeterReadingConsumption AS MeterReadingConsumption,
  _MeterReadingValdtnInfo.MtrRdngValdtnInfoCnsmpnValExpd AS MtrRdngValdtnInfoCnsmpnValExpd,
  I_MeterReadingDocumentTP.UtilsMchnLrngRelConfidenceVal AS UtilsMchnLrngRelConfidenceVal,
  I_MeterReadingDocumentTP.MtrRdngValdtnInfoCnsmpnActl AS MtrRdngValdtnInfoCnsmpnActl,
  I_MeterReadingDocumentTP.MtrRdngValdtnInfoCnsmpnExpd AS MtrRdngValdtnInfoCnsmpnExpd,
  _MeterReadingValdtnInfo.MtrReadingValdtnInfoDcmls AS MtrReadingValdtnInfoDcmls,
  _MeterReadingValdtnInfo.MeterRdngOriginEstimationValue AS MeterRdngOriginEstimationValue,
  _MeterReadingValdtnInfo.MeterRdngValidationCurrentVal AS MeterRdngValidationCurrentVal,
  _MeterReadingValdtnInfo.MtrRdngValidationExpectedValue AS MtrRdngValidationExpectedValue,
  _MeterReadingValdtnInfo.MeterRdngValidationLowerLimit AS MeterRdngValidationLowerLimit,
  _MeterReadingValdtnInfo.MeterRdngValidationUpperLimit AS MeterRdngValidationUpperLimit,
  I_MeterReadingDocumentTP.MtrRdngValdtnInfoChkRsltValue AS MtrRdngValdtnInfoChkRsltValue,
  I_MeterReadingDocumentTP.MtrRdngValdtnInfoChkRsltDesc AS MtrRdngValdtnInfoChkRsltDesc,
  I_MeterReadingDocumentTP.NmbrOfUtilsRegDigitsPreDcmls AS NmbrOfUtilsRegDigitsPreDcmls,
  I_MeterReadingDocumentTP.NmbrOfUtilsRegDigitsDcmls AS NmbrOfUtilsRegDigitsDcmls,
  I_MeterReadingDocumentTP.MeterReadingDateCriticality AS MeterReadingDateCriticality,
  MeterReadingCategory,
  I_MeterReadingDocumentTP.BPEMCase AS BPEMCase,
  I_MeterReadingDocumentTP.BPEMCaseCurrentProcessor AS BPEMCaseCurrentProcessor,
  I_MeterReadingDocumentTP.UserDescription AS UserDescription,
  I_MeterReadingDocumentTP.BPEMCaseCategory AS BPEMCaseCategory,
  I_MeterReadingDocumentTP.BPEMCasePreviousProcessor AS BPEMCasePreviousProcessor,
  I_MeterReadingDocumentTP.LastChangedByUserDescription AS LastChangedByUserDescription,
  I_MeterReadingDocumentTP.BPEMBusinessProcessCode AS BPEMBusinessProcessCode,
  I_MeterReadingDocumentTP.BPEMCaseForwardingReason AS BPEMCaseForwardingReason,
  I_MeterReadingDocumentTP.BPEMCaseCreationDate AS BPEMCaseCreationDate,
  I_MeterReadingDocumentTP.BPEMCaseDueDate AS BPEMCaseDueDate,
  I_MeterReadingDocumentTP.BPEMCaseOriginalDate AS BPEMCaseOriginalDate,
  I_MeterReadingDocumentTP.BPEMCasePriority AS BPEMCasePriority,
  I_MeterReadingDocumentTP.BPEMCaseStatus AS BPEMCaseStatus,
  I_MeterReadingDocumentTP.BPEMCaseIsExisting AS BPEMCaseIsExisting,
  I_MeterReadingDocumentTP._MeterReadingDocDvceInfoRecd AS _MeterReadingDocDvceInfoRecd,
  I_MeterReadingDocumentTP._MeterReadingDocSingleAttrib AS _MeterReadingDocSingleAttrib,
  I_MeterReadingDocumentTP._MeterReadingUnit AS _MeterReadingUnit,
  I_MeterReadingDocumentTP._MeterReadingReason AS _MeterReadingReason,
  I_MeterReadingDocumentTP._Address AS _Address,
  I_MeterReadingDocumentTP._UtilitiesPortion AS _UtilitiesPortion,
  I_MeterReadingDocumentTP._MeterReadingType AS _MeterReadingType,
  I_MeterReadingDocumentTP._MeterReaderNote AS _MeterReaderNote,
  I_MeterReadingDocumentTP._MeterReadingStatus AS _MeterReadingStatus,
  I_MeterReadingDocumentTP._Division AS _Division,
  I_MeterReadingDocumentTP._IndepMtrRdngValidationChk AS _IndepMtrRdngValidationChk,
  I_MeterReadingDocumentTP._DepdntMtrRdngValidationChk AS _DepdntMtrRdngValidationChk,
  I_MeterReadingDocumentTP._UtilitiesInstallationHist AS _UtilitiesInstallationHist,
  I_MeterReadingDocumentTP._UtilitiesRateCategory AS _UtilitiesRateCategory,
  I_MeterReadingDocumentTP._BPEMBusinessProcessCode AS _BPEMBusinessProcessCode,
  I_MeterReadingDocumentTP._BPEMCaseCategory AS _BPEMCaseCategory,
  I_MeterReadingDocumentTP._BPEMCasePriority AS _BPEMCasePriority,
  I_MeterReadingDocumentTP._OpenBPEMCaseStatus AS _OpenBPEMCaseStatus,
  I_MeterReadingDocumentTP._User AS _User,
  I_MeterReadingDocumentTP._PreviousUser AS _PreviousUser,
  I_MeterReadingDocumentTP._BPEMCaseForwardReason AS _BPEMCaseForwardReason
FROM I_MeterReadingDocumentTP
LEFT OUTER JOIN C_BPEMCaseTP AS _BPEMCaseTP ON MeterReadingDocument = _BPEMCaseTP.BPEMCaseMainObject AND _BPEMCaseTP.BPEMCaseMainObjectType = 'MTRREADDOC' AND _BPEMCaseTP.BPEMBusinessProcessCode = 'EMR00002'  -- association [0..*]
LEFT OUTER JOIN C_MeterReadingDocumentValdtn AS _MeterReadingDocumentValdtn ON IndepMtrRdngValidationChk = _MeterReadingDocumentValdtn.IndepMtrRdngValidationChk  -- association [0..*]
LEFT OUTER JOIN C_MeterReadingDocumentHistory AS _MeterReadingDocumentHistory ON UtilitiesInstallation = _MeterReadingDocumentHistory.UtilitiesInstallation  -- association [0..*]
LEFT OUTER JOIN I_ImplsblMtrRdngDocMaLrnRslt AS _ImplsblMtrRdngDocMaLrnRslt ON MeterReadingDocument = _ImplsblMtrRdngDocMaLrnRslt.MeterReadingDocument  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MeterReadingMeasurementUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;