I_EWA_WeighingProcess

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_WeighingProcess.
-- 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_WeighingProcess AS
SELECT
  cast( weighingnr as ewawa_weighingnr preserving type ) AS EWAWeighingTransaction,
  cast( car as ewael_equnr_car preserving type ) AS EWAFleetEquipment,
  trailer AS EWATrailerFleetEquipment,
  treatment AS EWAWasteTreatment,
  cast( ordernr as eordernr preserving type ) AS EWAWasteDisposalOrder,
  wcnt AS EWAWeighingNoteSequence,
  ext_id AS EWAWeighingRecordExtNumber,
  cast( waste as waste_type preserving type ) AS EWAWaste,
  cast( license_num as license_num preserving type ) AS EWALicensePlateNumber,
  gross_id AS EWAGrossWeighingNumber,
  gross_wdate AS EWAGrossWeighingDate,
  gross_wtime AS EWAGrossWeighingTime,
  gross_weight AS EWAGrossWeight,
  tare_id AS EWATareWeighingNumber,
  tare_wdate AS EWATareWeighingDate,
  tare_wtime AS EWATareWeighingTime,
  tare_weight AS EWATareWeight,
  tare_scale AS EWAEmptyWeight,
  weight_unit AS EWAWeightUnit,
  net_weight AS EWANetWeight,
  volume AS EWAWasteVolume,
  vol_unit AS EWAVolumeUnit,
  cast( wdplant as ewael_wdplantnr preserving type ) AS EWAWasteDisposalFacility,
  werks AS Plant,
  lgort AS StorageLocation,
  stock_type AS EWAStockType,
  pobjnr AS EWAWasteDsplOrdItmObjectNumber,
  processtype AS EWAWeighingTransactionType,
  gm_flag AS EWAIsGoodsMovementRelevant,
  billing_flag AS EWAIsBillingRelevant,
  quantity AS EWAWeighingQuantity,
  cast( quantity_unit as ewadelwghquantityunit preserving type ) AS EWAWeighingQuantityUnit,
  wdplant_dst AS EWATargetWasteDisposalFacility,
  werks_dst AS EWATargetPlant,
  lgort_dst AS EWATargetStorageLocation,
  lgpla_dst AS EWATargetStorageBin,
  lgtyp_dst AS EWATargetStorageType,
  cast( waste_redeclared as waste_type_redeclared preserving type ) AS EWAWasteType,
  vstelle AS UtilitiesPremise,
  cast( servloc as vdm_eam_tplnr preserving type ) AS EWAContainerLocation,
  zterm AS ConsumptionBillingPaymentTerms,
  ztagg AS PaymentTermsValidityMonthDay,
  cast( kunnr as kunnr preserving type ) AS Customer,
  load_time_begin AS EWALoadingFromTime,
  load_time_end AS EWALoadingToTime,
  unload_time_begi AS EWAUnloadingFromTime,
  unload_time_end AS EWAUnloadingToTime,
  kapid AS CapacityInternalID,
  versn AS EWACapacityVersion,
  datub AS EWAEndDate,
  tagnr AS EWACapacityCycleCurrentWeekDay,
  schnr AS AvailableCapacityShift,
  schdatum AS EWAShiftDate,
  schuzeit AS EWAShiftTime,
  buchdatum AS EWAWeighingTransacPostingDate,
  cast( car_cont_nr as ewael_matnr_car preserving type ) AS EWAVehicleContainerCategory,
  cast( trlr_cont_nr as ewael_matnr_trlr preserving type ) AS EWATrailerContainerCategory,
  mblnr AS MaterialDocument,
  mjahr AS MaterialDocumentYear,
  vbeln AS SalesDocument,
  brutto_weight AS EWAWeighingTransacGrossWeight,
  cast( brutto_unit as weight_unit preserving type ) AS EWAGrossWeightUnit,
  tara_weight AS EWAWeighingTransacTareWeight,
  cast( tara_unit as weight_unit preserving type ) AS EWATareWeightUnit,
  netto_weight AS EWAWeighingTransacNetWeight,
  cast( contract_vbeln as vbeln_va preserving type ) AS SalesContract,
  cast( contract_posnr as posnr_va preserving type ) AS SalesContractItem,
  gemark AS RELocalSubDistrict,
  nflurnr AS REPropertyTractNumberText,
  xflurst AS REParcelOfLandText,
  weighing_type AS EWAWeighingType,
  storno AS EWAWeighingTransacIsCancelled,
  wdpprotynr AS EWAWasteDsplFcltyTransacCat,
  wdpprocnr AS EWAWasteDsplFcltyTransaction,
  cast( charg as charg_d preserving type ) AS Batch,
  flag_tara AS EWATareIsMaintainedManually,
  cast( lgnum as lgnum preserving type ) AS Warehouse,
  cast( lgtyp as lgtyp preserving type ) AS StorageType,
  cast( lgpla as lgpla preserving type ) AS StorageBin,
  wdplantordertype AS EWAWasteDsplFacilityOrderType,
  tr_license_num AS EWATrailerLicensePlateNumber,
  splitt_canceled AS EWASplittingIsCancelled,
  note AS EWAWasteDisposalFacilityDesc,
  cobeldat AS EWAControllingDocPostingDate,
  fee AS EWAWeighingFeeCode,
  custaddrnum AS AddressID,
  devgrpnr_tare AS EWATareDeviceGroup,
  devgrpnr_gross AS EWAGrossDeviceGroup,
  cast( grossinfoid as ewadwa_grossinfoid preserving type ) AS EWAGrossWeighingInfoCode,
  cast( tareinfoid as ewadwa_tareinfoid preserving type ) AS EWATareWeighingInfoCode,
  billing_type AS EWABillingType,
  deliverytype AS EWAWeighingTransacDeliveryType,
  objnr AS EWAWeighingTransacObjectNumber,
  weighingnr_lead AS EWALeadingWeighingTransaction,
  weighingnr_ext AS EWAFcltyReltdWeighingTransac,
  weighingnr_split AS EWASplittingWeighingTransac,
  matsplit_laufnr AS EWAMaterialSplittingSequence,
  matsplit_prz_flag AS EWAMatlSplittingIsInPercent,
  matsplit_procent AS EWAMaterialSplittingRatio,
  matsplit_type AS EWAMaterialSplittingType,
  netinfoid AS EWANetWeighingInfoCode,
  cast( beh_type_deduct as beh_type preserving type ) AS EWAContainerCategory,
  minnetweight_flag AS EWAWeightIsMinimumNet,
  devgroupnr_manual AS EWADeviceGroup,
  volsplit_procent AS EWAMatlSplittingVolumeRatio,
  dats_is_valid(buchdatum) AS EWAValidPosting,
  tare_checkbox AS EWAManualTareWeighIsChecked,
  createdat AS EWACreatedOnDateTime,
  createdby AS EWACreatedByName,
  lastchangedat AS EWALastChangedOnDateTime,
  lastchangedby AS EWAChangedByName
FROM ewa_wa_weighproc
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTermsValidityMonthDay ON PaymentTermsValidityMonthDay = _PaymentTermsValidityMonthDay.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_SalesContractItem AS _SalesContractItem ON SalesContractItem = _SalesContractItem.SalesContract AND SalesContractItem = _SalesContractItem.SalesContractItem  -- association [0..1]
LEFT OUTER JOIN I_SalesContract AS _SalesContract ON SalesContract = _SalesContract.SalesContract  -- association [0..1]
LEFT OUTER JOIN I_EWA_WasteDsplFcltyOrderType AS _EWAWasteDsplFacilityOrderType ON EWAWasteDsplFacilityOrderType = _EWAWasteDsplFacilityOrderType.EWAWasteDsplFacilityOrderType  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _EWAContainerLocation ON EWAContainerLocation = _EWAContainerLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Material AS _EWAWaste ON EWAWaste = _EWAWaste.Material  -- association [0..1]
LEFT OUTER JOIN I_Warehouse AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWAWeightUnit ON EWAWeightUnit = _EWAWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPremise AS _UtilitiesPremise ON UtilitiesPremise = _UtilitiesPremise.UtilitiesPremise  -- association [0..1]
LEFT OUTER JOIN I_EWA_WasteDisposalFacility AS _EWAWasteDisposalFacility ON EWAWasteDisposalFacility = _EWAWasteDisposalFacility.EWAWasteDisposalFacility  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWATareWeightUnit ON EWATareWeightUnit = _EWATareWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_EWA_WeighingInformation AS _EWATareWeighingInfoCode ON EWATareWeighingInfoCode = _EWATareWeighingInfoCode.EWAWeighingInfoCode  -- association [0..1]
LEFT OUTER JOIN I_EWA_WeighingInformation AS _EWAGrossWeighingInfoCode ON EWAGrossWeighingInfoCode = _EWAGrossWeighingInfoCode.EWAWeighingInfoCode  -- association [0..1]
LEFT OUTER JOIN I_EWA_WeighingInformation AS _EWANetWeighingInfoCode ON EWANetWeighingInfoCode = _EWANetWeighingInfoCode.EWAWeighingInfoCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_EWA_WeighingFee AS _EWAWeighingFeeCode ON EWAWeighingFeeCode = _EWAWeighingFeeCode.EWAWeighingFeeCode  -- association [0..1]
LEFT OUTER JOIN I_EWA_WeighingType AS _EWAWeighingType ON EWAWeighingType = _EWAWeighingType.EWAWeighingType  -- association [0..1]
LEFT OUTER JOIN I_EWA_WeighingProcess AS _EWALeadingWeighingTransaction ON EWALeadingWeighingTransaction = _EWALeadingWeighingTransaction.EWAWeighingTransaction  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWAVolumeUnit ON EWAVolumeUnit = _EWAVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_EWA_WasteDisposalOrder AS _EWAWasteDisposalOrder ON EWAWasteDisposalOrder = _EWAWasteDisposalOrder.EWAWasteDisposalOrder  -- association [0..1]
LEFT OUTER JOIN I_Material AS _EWAWasteType ON EWAWasteType = _EWAWasteType.Material  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWAGrossWeightUnit ON EWAGrossWeightUnit = _EWAGrossWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _EWAFleetEquipment ON EWAFleetEquipment = _EWAFleetEquipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_Material AS _EWAContainerCategory ON EWAContainerCategory = _EWAContainerCategory.Material  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _EWATrailerFleetEquipment ON EWATrailerFleetEquipment = _EWATrailerFleetEquipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_RELocalSubDistrict AS _RELocalSubDistrict ON RELocalSubDistrict = _RELocalSubDistrict.RELocalSubDistrict  -- association [0..1]
LEFT OUTER JOIN I_Material AS _EWAVehicleContainerCategory ON EWAVehicleContainerCategory = _EWAVehicleContainerCategory.Material  -- association [0..1]
LEFT OUTER JOIN I_Material AS _EWATrailerContainerCategory ON EWATrailerContainerCategory = _EWATrailerContainerCategory.Material  -- association [0..1]
LEFT OUTER JOIN I_EWA_WeighingStatus AS _WeighingStatus ON EWAWeighingTransaction = _WeighingStatus.EWAWeighingTransaction  -- association [0..1]
LEFT OUTER JOIN E_EWA_WasteItemWeigh AS _ExtensionWeighProc ON EWAWeighingTransaction = _ExtensionWeighProc.EWAWeighingTransaction  -- association [0..1]
;