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_MeterReadingDocumentTP.
-- 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_MeterReadingDocumentTP AS
SELECT
I_MeterReadingDocument.MeterReadingDocument AS MeterReadingDocument,
I_MeterReadingDocument.SerialNumber AS SerialNumber,
I_MeterReadingDocument.Equipment AS Equipment,
I_MeterReadingDocument.MeterReadingDate AS MeterReadingDate,
I_MeterReadingDocument.MeterReadingTime AS MeterReadingTime,
I_MeterReadingDocument.MeterReadingResultPreDecimals AS MeterReadingResultPreDecimals,
I_MeterReadingDocument.MeterReadingResultDecimals AS MeterReadingResultDecimals,
I_MeterReadingDocument.MeterReadingMeasurementUnit AS MeterReadingMeasurementUnit,
I_MeterReadingDocument.BlldMeterReadingResultPreDcmls AS BlldMeterReadingResultPreDcmls,
I_MeterReadingDocument.BlldMeterReadingResultDcmls AS BlldMeterReadingResultDcmls,
I_MeterReadingDocument.BillingMeasurementUnit AS BillingMeasurementUnit,
I_MeterReadingDocument.NmbrOfUtilsRegDigitsPreDcmls AS NmbrOfUtilsRegDigitsPreDcmls,
I_MeterReadingDocument.NmbrOfUtilsRegDigitsDcmls AS NmbrOfUtilsRegDigitsDcmls,
cast('' as e_actlcnsmpn_vdm) AS MeterReadingConsumptionActual,
cast('' as e_expdcnsmpn_vdm) AS MeterReadingConsumptionExpd,
cast(0 as e_mtrrdngresultdifference_vdm) AS MeterReadingResultDifference,
cast('' as e_mtrrdngdifference_vdm ) AS MeterReadingResultDiffVal,
$session.system_date AS MeterReadingSystemDate,
cast('' as e_originestn_vdm) AS MeterReadingOriginEstimation,
cast('' as e_estdvalue_vdm) AS MeterReadingEstimatedValue,
cast( cast( '' as abap.char(10) ) as /scdl/dl_partyno ) AS BusinessPartner,
cast( '' as e_mrbupaname_vdm ) AS BusinessPartnerName,
cast( '' as e_plausicheckt_vdm ) AS MtrRdngValdtnInfoChkRsltDesc,
cast( '' as e_actlcnsmpn_vdm ) AS MtrRdngValdtnInfoCnsmpnActl,
cast( '' as e_expdcnsmpn_vdm ) AS MtrRdngValdtnInfoCnsmpnExpd,
cast( '00000000' as einzdat ) AS UtilitiesMoveInDate,
cast( 0 as abrfakt ) AS UtilsBillingFactor,
_MeterReadingDocSingleAttrib.MeterReadingReason AS MeterReadingReason,
_MeterReadingDocSingleAttrib.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
_MeterReadingDocSingleAttrib.UtilitiesRegister AS UtilitiesRegister,
_MeterReadingDocSingleAttrib.UtilitiesRegisterTypeName AS UtilitiesRegisterTypeName,
_MeterReadingDocSingleAttrib.MeterReadingUnit AS MeterReadingUnit,
_MeterReadingDocSingleAttrib.UtilitiesPremise AS UtilitiesPremise,
_MeterReadingDocSingleAttrib.AddressID AS AddressID,
_MeterReadingDocSingleAttrib.UtilsPostalAddressFormatted AS UtilsPostalAddressFormatted,
_MeterReadingDocSingleAttrib.UtilitiesInstallation AS UtilitiesInstallation,
_MeterReadingDocSingleAttrib._MeterReadingUnit.UtilitiesPortion AS UtilitiesPortion,
_MeterReadingDocSingleAttrib.UtilitiesRateCategory AS UtilitiesRateCategory,
_MeterReadingDocSingleAttrib.MeterReadingRsnScheduledDate AS MeterReadingRsnScheduledDate,
_MeterReadingDocDvceInfoRecd.Division AS Division,
_MeterReadingDocDvceInfoRecd.UtilsDeviceCategoryDescription AS UtilsDeviceCategoryDescription,
_MeterReadingDocDvceInfoRecd.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
I_MeterReadingDocument.MeterReadingStatus AS MeterReadingStatus,
I_MeterReadingDocument.MeterReadingType AS MeterReadingType,
I_MeterReadingDocument.MeterReadingCategory AS MeterReadingCategory,
I_MeterReadingDocument.SchedldMtrReadingCategory AS SchedldMtrReadingCategory,
I_MeterReadingDocument.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
I_MeterReadingDocument.ActualMeterReadingDate AS ActualMeterReadingDate,
I_MeterReadingDocument.ActualMeterReadingTime AS ActualMeterReadingTime,
I_MeterReadingDocument.MaximumMeterReadingDate AS MaximumMeterReadingDate,
I_MeterReadingDocument.MaximumMeterReadingTime AS MaximumMeterReadingTime,
I_MeterReadingDocument.MeterReadingAllocationDate AS MeterReadingAllocationDate,
I_MeterReadingDocument.UtilitiesGasAllocationDate AS UtilitiesGasAllocationDate,
I_MeterReadingDocument.CtrlMtrReadingOrderSchedldDate AS CtrlMtrReadingOrderSchedldDate,
I_MeterReadingDocument.CtrlMtrReadingOrderSchedldTime AS CtrlMtrReadingOrderSchedldTime,
I_MeterReadingDocument.ControlMeterReadingIsPrinted AS ControlMeterReadingIsPrinted,
I_MeterReadingDocument.MtrRdngActiveStatus AS MtrRdngActiveStatus,
I_MeterReadingDocument.IndepMtrRdngValidationChk AS IndepMtrRdngValidationChk,
I_MeterReadingDocument.DepdntMtrRdngValidationChk AS DepdntMtrRdngValidationChk,
I_MeterReadingDocument.MeterReaderNoteCode AS MeterReaderNoteCode,
I_MeterReadingDocument.MeterReaderNoteFllwUpActn AS MeterReaderNoteFllwUpActn,
I_MeterReadingDocument.MeterReaderCode AS MeterReaderCode,
I_MeterReadingDocument.MeterReadingBasePeriodCat AS MeterReadingBasePeriodCat,
I_MeterReadingDocument.MeterReadingCreationDate AS MeterReadingCreationDate,
I_MeterReadingDocument.MeterReadingCreatedByUser AS MeterReadingCreatedByUser,
I_MeterReadingDocument.MeterReadingLastChangeDate AS MeterReadingLastChangeDate,
I_MeterReadingDocument.MeterReadingLastChangedByUser AS MeterReadingLastChangedByUser,
I_MeterReadingDocument.AdvancedMeteringSystem AS AdvancedMeteringSystem,
I_MeterReadingDocument.MeterReadingTransferStatus AS MeterReadingTransferStatus,
I_MeterReadingDocument.MeterReadingTransferDateTime AS MeterReadingTransferDateTime,
I_MeterReadingDocument.AdvncdMeteringDataOrignType AS AdvncdMeteringDataOrignType,
I_MeterReadingDocument.MobileMeterReadingEntrySystem AS MobileMeterReadingEntrySystem,
I_MeterReadingDocument.MeterReadingOrderIsOutputted AS MeterReadingOrderIsOutputted,
I_MeterReadingDocument.MeterReadingCheckDigit AS MeterReadingCheckDigit,
I_MeterReadingDocument.MeterReadingFastEntryNumber AS MeterReadingFastEntryNumber,
I_MeterReadingDocument.MeterReadingIsRecaptured AS MeterReadingIsRecaptured,
I_MeterReadingDocument.MeterReadingAutomMntrgStatus AS MeterReadingAutomMntrgStatus,
I_MeterReadingDocument.MtrRdngIsSchdlForMltplOrdCrtn AS MtrRdngIsSchdlForMltplOrdCrtn,
I_MeterReadingDocument.MltplMtrRdngOrdCrtnCntrlGroup AS MltplMtrRdngOrdCrtnCntrlGroup,
I_MeterReadingDocument.MltplMtrRdngRefSchedldDate AS MltplMtrRdngRefSchedldDate,
I_MeterReadingDocument.OrderType AS OrderType,
I_MeterReadingDocument.ServiceOrder AS ServiceOrder,
dats_days_between($session.system_date, I_MeterReadingDocument.ScheduledMeterReadingDate) AS MeterReadingDatesDifference,
fltp_to_dec(_ImplsblMtrRdngDocMaLrnRslt.UtilsMchnLrngRelConfidenceVal as e_rel_confidence_vdm) AS UtilsMchnLrngRelConfidenceVal,
cast('' as e_plausicheckv_vdm) AS MtrRdngValdtnInfoChkRsltValue,
cast(_LatestOpenBPEMCase._BPEMCase.BPEMCase as e_clarificationcase_vdm preserving type) AS BPEMCase,
_LatestOpenBPEMCase._BPEMCase.BPEMCaseCurrentProcessor AS BPEMCaseCurrentProcessor,
_LatestOpenBPEMCase._BPEMCase._User.UserDescription AS UserDescription,
cast(_LatestOpenBPEMCase._BPEMCase.BPEMCaseCategory as e_clarcasecategory_vdm preserving type) AS BPEMCaseCategory,
cast(_LatestOpenBPEMCase._BPEMCase.BPEMCasePreviousProcessor as e_clarcaseprevproc_vdm preserving type) AS BPEMCasePreviousProcessor,
_LatestOpenBPEMCase._BPEMCase._PreviousUser.UserDescription AS LastChangedByUserDescription,
_LatestOpenBPEMCase._BPEMCase.BPEMBusinessProcessCode AS BPEMBusinessProcessCode,
_LatestOpenBPEMCase._BPEMCase.BPEMCaseForwardingReason AS BPEMCaseForwardingReason,
cast(_LatestOpenBPEMCase._BPEMCase.BPEMCaseCreationDate as e_clarcasecreationdate_vdm preserving type) AS BPEMCaseCreationDate,
cast(_LatestOpenBPEMCase._BPEMCase.BPEMCaseDueDate as e_clarcaseduedate_vdm preserving type) AS BPEMCaseDueDate,
cast(_LatestOpenBPEMCase._BPEMCase.BPEMCaseOriginalDate as e_clarcaseorigdate_vdm preserving type) AS BPEMCaseOriginalDate,
cast(_LatestOpenBPEMCase._BPEMCase.BPEMCasePriority as e_clarcasepriority_vdm preserving type) AS BPEMCasePriority,
cast(_LatestOpenBPEMCase._BPEMCase.BPEMCaseStatus as e_bpemcasestatus_vdm preserving type ) AS BPEMCaseStatus,
I_MeterReadingDocument._AdvancedMeteringSystem AS _AdvancedMeteringSystem,
I_MeterReadingDocument._CreatedByUser AS _CreatedByUser,
I_MeterReadingDocument._DepdntMtrRdngValidationChk AS _DepdntMtrRdngValidationChk,
I_MeterReadingDocument._IndepMtrRdngValidationChk AS _IndepMtrRdngValidationChk,
I_MeterReadingDocument._LastChangedByUser AS _LastChangedByUser,
I_MeterReadingDocument._MeterReaderCode AS _MeterReaderCode,
I_MeterReadingDocument._MeterReaderNote AS _MeterReaderNote,
I_MeterReadingDocument._MeterReaderNoteFllwUpActn AS _MeterReaderNoteFllwUpActn,
I_MeterReadingDocument._MeterReadingBasePeriodCat AS _MeterReadingBasePeriodCat,
I_MeterReadingDocument._MeterReadingCategory AS _MeterReadingCategory,
I_MeterReadingDocument._MeterReadingDocumentReason AS _MeterReadingDocumentReason,
I_MeterReadingDocument._MeterReadingStatus AS _MeterReadingStatus,
I_MeterReadingDocument._MeterReadingType AS _MeterReadingType,
I_MeterReadingDocument._MtrRdngActiveStatus AS _MtrRdngActiveStatus,
I_MeterReadingDocument._SchedldMtrReadingCategory AS _SchedldMtrReadingCategory,
I_MeterReadingDocument._SystemStatus AS _SystemStatus,
I_MeterReadingDocument._UnitOfMeasure AS _UnitOfMeasure,
I_MeterReadingDocument._UnitOfMeasure_E AS _UnitOfMeasure_E,
I_MeterReadingDocument._MeterReadingValdtnInfo AS _MeterReadingValdtnInfo,
_LatestOpenBPEMCase._BPEMCase._BPEMBusinessProcessCode AS _BPEMBusinessProcessCode,
_LatestOpenBPEMCase._BPEMCase._BPEMCasePriority AS _BPEMCasePriority,
_LatestOpenBPEMCase._BPEMCase._User AS _User,
_LatestOpenBPEMCase._BPEMCase._PreviousUser AS _PreviousUser,
_LatestOpenBPEMCase._BPEMCase._BPEMCaseForwardReason AS _BPEMCaseForwardReason,
_LatestOpenBPEMCase._BPEMCase._BPEMCaseCategory AS _BPEMCaseCategory,
_MeterReadingDocSingleAttrib._Address AS _Address,
_MeterReadingDocDvceInfoRecd._Division AS _Division,
_MeterReadingDocSingleAttrib._MeterReadingUnit AS _MeterReadingUnit,
_MeterReadingDocSingleAttrib._MeterReadingReason AS _MeterReadingReason,
_MeterReadingDocSingleAttrib._UtilitiesPremise AS _UtilitiesPremise,
_MeterReadingDocSingleAttrib._UtilitiesInstallation AS _UtilitiesInstallation,
_MeterReadingDocSingleAttrib._UtilitiesRateCategory AS _UtilitiesRateCategory,
_MeterReadingDocSingleAttrib._MeterReadingUnit._UtilitiesPortion AS _UtilitiesPortion,
_MeterReadingDocSingleAttrib._UtilitiesInstallationHist AS _UtilitiesInstallationHist
FROM I_MeterReadingDocument
LEFT OUTER JOIN I_MeterReadingDocSingleAttrib AS _MeterReadingDocSingleAttrib ON MeterReadingDocument = _MeterReadingDocSingleAttrib.MeterReadingDocument -- association [0..*]
LEFT OUTER JOIN I_MeterReadingDocDvceInfoRecd AS _MeterReadingDocDvceInfoRecd ON Equipment = _MeterReadingDocDvceInfoRecd.Equipment AND ScheduledMeterReadingDate <= _MeterReadingDocDvceInfoRecd.UtilsDeviceValidityEndDate AND ScheduledMeterReadingDate >= _MeterReadingDocDvceInfoRecd.UtilsDeviceValidityStartDate -- association [0..*]
LEFT OUTER JOIN I_OpenBPEMCaseStatusVH AS _OpenBPEMCaseStatus ON BPEMCaseStatus = _OpenBPEMCaseStatus.BPEMCaseStatus -- association [0..1]
LEFT OUTER JOIN I_ImplsblMtrRdngDocMaLrnRslt AS _ImplsblMtrRdngDocMaLrnRslt ON MeterReadingDocument = _ImplsblMtrRdngDocMaLrnRslt.MeterReadingDocument -- association [0..1]
LEFT OUTER JOIN I_UtilitiesRegister AS _UtilitiesRegister ON Equipment = _UtilitiesRegister.Equipment AND utilitiesregister = _UtilitiesRegister.UtilitiesRegister AND ScheduledMeterReadingDate <= _UtilitiesRegister.UtilsRegisterValidityEndDate AND ScheduledMeterReadingDate >= _UtilitiesRegister.UtilsRegisterValidityStartDate -- association [0..*]
LEFT OUTER JOIN I_MeterReadingDocumentReasonTP AS _MeterReadingDocumentReasonTP ON /* condition not available in parsed metadata */ -- association [0..*]
;