I_EWA_IntAndExtWeighingRecords

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_EWA_IntAndExtWeighingRecords.
-- 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_EWA_IntAndExtWeighingRecords AS
SELECT
  WeighProc.EWALeadingWeighingTransaction AS EWALeadingWeighingTransaction,
  WeighProc.EWAWasteDisposalOrder AS EWAWasteDisposalOrder,
  WeighProc.EWAWeighingNoteSequence AS EWAWeighingNoteSequence,
  WeighProc.EWAWeighingTransaction AS EWAWeighingTransaction,
  WeighProc.EWAWeighingTransacDeliveryType AS EWAWeighingTransacDeliveryType,
  WeighProc.EWAWaste AS EWAWaste,
  WeighProc._EWAWaste._Text[1: Language=$session.system_language].MaterialName AS EWAWasteText,
  WeighProc.EWAGrossWeighingNumber AS EWAGrossWeighingNumber,
  WeighProc.EWAGrossWeighingDate AS EWAGrossWeighingDate,
  WeighProc.EWAGrossWeighingTime AS EWAGrossWeighingTime,
  WeighProc.EWAWeighingTransacGrossWeight AS EWAWeighingTransacGrossWeight,
  WeighProc.EWAGrossWeightUnit AS EWAGrossWeightUnit,
  WeighProc.EWATareWeighingNumber AS EWATareWeighingNumber,
  WeighProc.EWATareWeighingDate AS EWATareWeighingDate,
  WeighProc.EWATareWeighingTime AS EWATareWeighingTime,
  WeighProc.EWAWeighingTransacTareWeight AS EWAWeighingTransacTareWeight,
  WeighProc.EWATareWeightUnit AS EWATareWeightUnit,
  WeighProc.EWAEmptyWeight AS EWAEmptyWeight,
  WeighProc.EWAWeightUnit AS EWAWeightUnit,
  WeighProc.EWAWeighingTransacNetWeight AS EWAWeighingTransacNetWeight,
  WeighProc.EWAWasteVolume AS EWAWasteVolume,
  WeighProc.EWAVolumeUnit AS EWAVolumeUnit,
  WeighProc.EWAWasteDisposalFacility AS EWAWasteDisposalFacility,
  WeighProc.Plant AS Plant,
  WeighProc.StorageLocation AS StorageLocation,
  WeighProc.StorageType AS StorageType,
  WeighProc.EWAStockType AS EWAStockType,
  WeighProc.StorageBin AS StorageBin,
  WeighProc.EWAWasteDsplOrdItmObjectNumber AS EWAWasteDsplOrdItmObjectNumber,
  WeighProc.MaterialDocument AS MaterialDocument,
  WeighProc.MaterialDocumentYear AS MaterialDocumentYear,
  WeighProc.SalesDocument AS SalesDocument,
  WeighProc.SalesContract AS SalesContract,
  WeighProc.SalesContractItem AS SalesContractItem,
  WeighProc.EWATargetPlant AS EWATargetPlant,
  WeighProc.EWATargetStorageLocation AS EWATargetStorageLocation,
  WeighProc.EWATargetStorageBin AS EWATargetStorageBin,
  WeighProc.EWATargetStorageType AS EWATargetStorageType,
  WeighProc.EWAWeighingTransactionType AS EWAWeighingTransactionType,
  WeighProc.EWAIsGoodsMovementRelevant AS EWAIsGoodsMovementRelevant,
  WeighProc.EWAIsBillingRelevant AS EWAIsBillingRelevant,
  WeighProc.EWAWeighingQuantity AS EWAWeighingQuantity,
  WeighProc.EWAWeighingQuantityUnit AS EWAWeighingQuantityUnit,
  WeighProc.EWATargetWasteDisposalFacility AS EWATargetWasteDisposalFacility,
  WeighProc.EWAMaterialSplittingType AS EWAMaterialSplittingType,
  WeighProc.EWALicensePlateNumber AS EWALicensePlateNumber,
  WeighProc.EWAWeighingTransacPostingDate AS EWAWeighingTransacPostingDate,
  WeighProc.EWAWeighingRecordExtNumber AS EWAWeighingRecordExtNumber,
  WeighProc.EWAWeighingTransacIsCancelled AS EWAWeighingTransacIsCancelled,
  WeighProc.EWAControllingDocPostingDate AS EWAControllingDocPostingDate,
  WeighProc.EWAFleetEquipment AS EWAFleetEquipment,
  WeighProc.EWATrailerFleetEquipment AS EWATrailerFleetEquipment,
  WeighProc.EWAWasteTreatment AS EWAWasteTreatment,
  WeighProc.EWAWasteType AS EWAWasteType,
  WeighProc.UtilitiesPremise AS UtilitiesPremise,
  WeighProc.EWAContainerLocation AS EWAContainerLocation,
  WeighProc.ConsumptionBillingPaymentTerms AS ConsumptionBillingPaymentTerms,
  WeighProc.Customer AS Customer,
  WeighProc.EWALoadingFromTime AS EWALoadingFromTime,
  WeighProc.EWALoadingToTime AS EWALoadingToTime,
  WeighProc.EWAUnloadingFromTime AS EWAUnloadingFromTime,
  WeighProc.EWAUnloadingToTime AS EWAUnloadingToTime,
  WeighProc.EWAEndDate AS EWAEndDate,
  WeighProc.AvailableCapacityShift AS AvailableCapacityShift,
  WeighProc.EWAShiftDate AS EWAShiftDate,
  WeighProc.EWAShiftTime AS EWAShiftTime,
  WeighProc.EWAVehicleContainerCategory AS EWAVehicleContainerCategory,
  WeighProc.EWATrailerContainerCategory AS EWATrailerContainerCategory,
  WeighProc.RELocalSubDistrict AS RELocalSubDistrict,
  WeighProc.REPropertyTractNumberText AS REPropertyTractNumberText,
  WeighProc.REParcelOfLandText AS REParcelOfLandText,
  WeighProc.EWAWeighingType AS EWAWeighingType,
  WeighProc.EWAWasteDsplFcltyTransacCat AS EWAWasteDsplFcltyTransacCat,
  WeighProc.EWAWasteDsplFcltyTransaction AS EWAWasteDsplFcltyTransaction,
  WeighProc.Batch AS Batch,
  WeighProc.EWATareIsMaintainedManually AS EWATareIsMaintainedManually,
  WeighProc.Warehouse AS Warehouse,
  WeighProc.EWAWasteDsplFacilityOrderType AS EWAWasteDsplFacilityOrderType,
  WeighProc.EWATrailerLicensePlateNumber AS EWATrailerLicensePlateNumber,
  WeighProc.EWASplittingIsCancelled AS EWASplittingIsCancelled,
  WeighProc.EWAWasteDisposalFacilityDesc AS EWAWasteDisposalFacilityDesc,
  WeighProc.EWAWeighingFeeCode AS EWAWeighingFeeCode,
  WeighProc.AddressID AS AddressID,
  WeighProc.EWATareDeviceGroup AS EWATareDeviceGroup,
  WeighProc.EWAGrossDeviceGroup AS EWAGrossDeviceGroup,
  WeighProc.EWAGrossWeighingInfoCode AS EWAGrossWeighingInfoCode,
  WeighProc.EWATareWeighingInfoCode AS EWATareWeighingInfoCode,
  WeighProc.EWABillingType AS EWABillingType,
  WeighProc.EWAWeighingTransacObjectNumber AS EWAWeighingTransacObjectNumber,
  WeighProc.EWAFcltyReltdWeighingTransac AS EWAFcltyReltdWeighingTransac,
  WeighProc.EWASplittingWeighingTransac AS EWASplittingWeighingTransac,
  WeighProc.EWAMaterialSplittingSequence AS EWAMaterialSplittingSequence,
  WeighProc.EWAMatlSplittingIsInPercent AS EWAMatlSplittingIsInPercent,
  WeighProc.EWANetWeighingInfoCode AS EWANetWeighingInfoCode,
  WeighProc.EWAContainerCategory AS EWAContainerCategory,
  WeighProc.EWAWeightIsMinimumNet AS EWAWeightIsMinimumNet,
  WeighProc.EWADeviceGroup AS EWADeviceGroup,
  WeighProc.EWAManualTareWeighIsChecked AS EWAManualTareWeighIsChecked,
  cast('I' as ewadwa_weighprocintext) AS EWAWeighingSource,
  WeighProc._WeighingStatus.EWAWeighingStatusUnchecked AS EWAWeighingStatusUnchecked,
  WeighProc._WeighingStatus.EWAWeighingStatusBooked AS EWAWeighingStatusBooked,
  WeighProc._WeighingStatus.EWAWeighingStatusReversed AS EWAWeighingStatusReversed,
  cast('01' as ewa_weighingheader) AS EWAWeighingHeader1,
  cast('02' as ewa_weighingheader) AS EWAWeighingHeader2,
  cast('03' as ewa_weighingheader) AS EWAWeighingHeader3
FROM I_EWA_WeighingProcess AS WeighProc
LEFT OUTER JOIN I_EWA_WeighingSourceVH AS _EWAWeighingSource ON EWAWeighingSource = _EWAWeighingSource.EWAWeighingSource  -- association [0..*]
LEFT OUTER JOIN I_EWA_WeighingHeader AS _WeighHead1 ON EWAWeighingHeader1 =_WeighHead1.EWAWeighingHeaderValue  -- association [0..*]
LEFT OUTER JOIN I_EWA_WeighingHeader AS _WeighHead2 ON EWAWeighingHeader2 =_WeighHead2.EWAWeighingHeaderValue  -- association [0..*]
LEFT OUTER JOIN I_EWA_WeighingHeader AS _WeighHead3 ON EWAWeighingHeader3 =_WeighHead3.EWAWeighingHeaderValue  -- association [0..*]
LEFT OUTER JOIN I_EWA_WeighingStatusText AS _EWAStatusText ON EWAWeighingStatus = _EWAStatusText.EWAWeighingStatus  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON EWAContainerLocation = _FunctionalLocationText.FunctionalLocation AND _FunctionalLocationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON ( EWAFleetEquipment = _EquipmentText.Equipment OR EWATrailerFleetEquipment = _EquipmentText.Equipment) AND _EquipmentText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN E_EWA_WasteItemWeigh AS _ExtensionWeighProc ON EWAWeighingTransaction = _ExtensionWeighProc.EWAWeighingTransaction  -- association [0..1]
LEFT OUTER JOIN E_EWA_WasteDisposalOrderWeigh AS _ExtensionOrderWeigh ON EWAWasteDisposalOrder = _ExtensionOrderWeigh.EWAWasteDisposalOrder  -- association [0..1]
-- UNION ALL with additional select branch(es): I_EWA_WasteOrderWeighingNote
;