I_EWA_WeighingProcessDetail

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_WeighingProcessDetail.
-- 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_WeighingProcessDetail AS
SELECT
  weighingnr AS EWAWeighingTransaction,
  cast( car as ewael_equnr_car preserving type ) AS EWAFleetEquipment,
  treatment AS EWAWasteTreatment,
  cast( ordernr as eordernr preserving type ) AS EWAWasteDisposalOrder,
  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
FROM ewa_wa_weighproc
;