What is C_EWA_WasteItemWeighingDEX in SAP S/4HANA?

C_EWA_WasteItemWeighingDEX is a consumption CDS view in SAP S/4HANA. Data Extraction for Waste item Weighing It contains 108 fields.

Which tables does C_EWA_WasteItemWeighingDEX read from?

C_EWA_WasteItemWeighingDEX reads data from: I_EWA_WeighingProcess.

What VDM layer is C_EWA_WasteItemWeighingDEX?

C_EWA_WasteItemWeighingDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_EWA_WasteItemWeighingDEX

DDL: C_EWA_WASTEITEMWEIGHINGDEX Type: view_entity CONSUMPTION

108 Fields 1 Data Sources 2 Associations

Data Extraction for Waste item Weighing

C_EWA_WasteItemWeighingDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Multi Item Waste Weighing · Utilities

C_EWA_WasteItemWeighingDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Waste item Weighing" in SAP S/4HANA. It reads from 1 data source (I_EWA_WeighingProcess) and exposes 108 fields with key field EWAWeighingTransaction. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Weighing
Data Category	Fact

Purpose
This CDS view is used to extract waste item weighing data to SAP Business Warehouse (SAP BW) or other external systems. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: B_BUP_PCPT (Business Partner: Purpose Completed) E_WEIGHPRO (Authorization Object for Weighing Procedure)

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment EWAWeighingTransaction Weighing Transaction Attribute Weighing Transaction

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-WA
Capabilities	Data Source for Data Extraction
Package	Utilities for SAP S/4HANA
Description	This CDS view is used to extract waste item weighing data to SAP Business Warehouse (SAP BW) or other external systems. <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA, onpremise edition — Explore SAP S/4HANA Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_EWA_WeighingProcess	EWA_Weigh	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_Customer	_Customer	`$projection.Customer = _Customer.Customer`
[0..1]	E_EWA_WasteItemWeigh	_ExtensionWeighProc	`$projection.EWAWeighingTransaction = _ExtensionWeighProc.EWAWeighingTransaction`

Annotations (12)

Name	Value	Level
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Data Extraction for Waste item Weighing	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.sapObjectNodeType.name	EWA_WasteItemWeigh	view
ObjectModel.modelingPattern	#NONE	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view

Fields (108)

Key	Field	Source Table	Source Field	Description
KEY	EWAWeighingTransaction	I_EWA_WeighingProcess	EWAWeighingTransaction	Weighing Transaction
	EWALeadingWeighingTransaction	I_EWA_WeighingProcess	EWALeadingWeighingTransaction	Leading Weighing Transaction
	EWAFleetEquipment	I_EWA_WeighingProcess	EWAFleetEquipment	Equipment Number: Vehicle
	EWATrailerFleetEquipment	I_EWA_WeighingProcess	EWATrailerFleetEquipment	Equipment Number: Trailer
	EWAWasteTreatment	I_EWA_WeighingProcess	EWAWasteTreatment	Type of Waste Treatment
	EWAWasteDisposalOrder	I_EWA_WeighingProcess	EWAWasteDisposalOrder	Internal Number for Identifying a Waste Disposal Order
	EWAWeighingNoteSequence	I_EWA_WeighingProcess	EWAWeighingNoteSequence	Consecutive Number of Weighing Data Record
	EWAWeighingRecordExtNumber	I_EWA_WeighingProcess	EWAWeighingRecordExtNumber	External Number of Weighing Data Record
	EWAWaste	I_EWA_WeighingProcess	EWAWaste	Waste
	EWALicensePlateNumber	I_EWA_WeighingProcess	EWALicensePlateNumber	License plate number
	EWAGrossWeighingNumber	I_EWA_WeighingProcess	EWAGrossWeighingNumber	Gross Weighing Number
	EWAGrossWeighingDate	I_EWA_WeighingProcess	EWAGrossWeighingDate	Weighing Date- Gross
	EWAGrossWeighingTime	I_EWA_WeighingProcess	EWAGrossWeighingTime	Weighing Time Gross
	EWAGrossWeighingInfoCode	I_EWA_WeighingProcess	EWAGrossWeighingInfoCode	Weighing Information Gross Weighing
	EWATareWeighingInfoCode	I_EWA_WeighingProcess	EWATareWeighingInfoCode	Weighing Information Tare Weight
	EWANetWeighingInfoCode	I_EWA_WeighingProcess	EWANetWeighingInfoCode	Weighing Information Net
	EWAGrossWeight	I_EWA_WeighingProcess	EWAGrossWeight	Gross Weight
	EWAGrossWeightUnit	I_EWA_WeighingProcess	EWAGrossWeightUnit	Unit of weight
	EWATareWeighingNumber	I_EWA_WeighingProcess	EWATareWeighingNumber	Weight No.- Empty
	EWATareWeighingDate	I_EWA_WeighingProcess	EWATareWeighingDate	Weighing Date Tare
	EWATareWeighingTime	I_EWA_WeighingProcess	EWATareWeighingTime	Weighing Time Tare
	EWATareWeight	I_EWA_WeighingProcess	EWATareWeight	Tare Weight
	EWATareWeightUnit	I_EWA_WeighingProcess	EWATareWeightUnit	Unit of weight
	EWAEmptyWeight	I_EWA_WeighingProcess	EWAEmptyWeight	Weight of empty container
	EWAWeightUnit	I_EWA_WeighingProcess	EWAWeightUnit	Unit of weight
	EWANetWeight	I_EWA_WeighingProcess	EWANetWeight	Net Weight
	EWAWasteVolume	I_EWA_WeighingProcess	EWAWasteVolume	Waste volume
	EWAVolumeUnit	I_EWA_WeighingProcess	EWAVolumeUnit	Volume unit
	EWAWasteDisposalFacility	I_EWA_WeighingProcess	EWAWasteDisposalFacility	Identification of Waste Disposal Facility
	EWAWasteDsplFacilityOrderType	I_EWA_WeighingProcess	EWAWasteDsplFacilityOrderType	Order Type for Waste Disposal Facility
	Plant	I_EWA_WeighingProcess	Plant	Valuation Area
	StorageLocation	I_EWA_WeighingProcess	StorageLocation	Storage Location
	EWAStockType	I_EWA_WeighingProcess	EWAStockType	Stock Type
	EWAWasteDsplOrdItmObjectNumber	I_EWA_WeighingProcess	EWAWasteDsplOrdItmObjectNumber	Object Number of Order Item
	EWAWeighingTransactionType	I_EWA_WeighingProcess	EWAWeighingTransactionType	Transaction Type
	EWAIsGoodsMovementRelevant	I_EWA_WeighingProcess	EWAIsGoodsMovementRelevant	Indicator for Goods Movement
	EWAIsBillingRelevant	I_EWA_WeighingProcess	EWAIsBillingRelevant	Indicator: Relevant for Billing
	EWAWeighingQuantity	I_EWA_WeighingProcess	EWAWeighingQuantity	Quantity/ Piece Goods Of Weighing Transaction
	EWAWeighingQuantityUnit	I_EWA_WeighingProcess	EWAWeighingQuantityUnit	Unit/Type For Quantity in Weighing Transaction
	EWATargetWasteDisposalFacility	I_EWA_WeighingProcess	EWATargetWasteDisposalFacility	Identification of Target Waste Disposal Facility
	EWATargetPlant	I_EWA_WeighingProcess	EWATargetPlant	Plant of Target Facility
	EWATargetStorageLocation	I_EWA_WeighingProcess	EWATargetStorageLocation	Target Storage Location
	EWATargetStorageBin	I_EWA_WeighingProcess	EWATargetStorageBin	Target Storage Location
	EWATargetStorageType	I_EWA_WeighingProcess	EWATargetStorageType	Targ.Stor.Type
	EWAWasteType	I_EWA_WeighingProcess	EWAWasteType	Waste: Redeclaration
	EWAContainerLocation	I_EWA_WeighingProcess	EWAContainerLocation	Functional Location
	EWAContainerCategory	I_EWA_WeighingProcess	EWAContainerCategory	Container category
	Customer	I_EWA_WeighingProcess	Customer	Customer Number
	EWALoadingFromTime	I_EWA_WeighingProcess	EWALoadingFromTime	Loading Time From
	EWALoadingToTime	I_EWA_WeighingProcess	EWALoadingToTime	Loading Time To
	EWAUnloadingFromTime	I_EWA_WeighingProcess	EWAUnloadingFromTime	Unloading Time From
	EWAUnloadingToTime	I_EWA_WeighingProcess	EWAUnloadingToTime	Unloading Time To
	EWAVehicleContainerCategory	I_EWA_WeighingProcess	EWAVehicleContainerCategory	Vehicle Container Material Number
	EWATrailerContainerCategory	I_EWA_WeighingProcess	EWATrailerContainerCategory	Trailer Container Material Number
	MaterialDocument	I_EWA_WeighingProcess	MaterialDocument	Number of Material Document
	MaterialDocumentYear	I_EWA_WeighingProcess	MaterialDocumentYear	Material Document Year
	SalesDocument	I_EWA_WeighingProcess	SalesDocument	Sales and Distribution Document Number
	EWAWeighingTransacGrossWeight	I_EWA_WeighingProcess	EWAWeighingTransacGrossWeight	Gross Weight
	EWAWeighingTransacTareWeight	I_EWA_WeighingProcess	EWAWeighingTransacTareWeight	Tare Weight
	EWAWeighingTransacNetWeight	I_EWA_WeighingProcess	EWAWeighingTransacNetWeight	Net Weight
	SalesContract	I_EWA_WeighingProcess	SalesContract	Sales Document
	SalesContractItem	I_EWA_WeighingProcess	SalesContractItem	Sales Document Item
	EWAWeighingType	I_EWA_WeighingProcess	EWAWeighingType	Weighing Data Type
	EWAWasteDsplFcltyTransacCat	I_EWA_WeighingProcess	EWAWasteDsplFcltyTransacCat	Key for Transaction Category
	EWAWasteDsplFcltyTransaction	I_EWA_WeighingProcess	EWAWasteDsplFcltyTransaction	Transaction Within Facility
	Batch	I_EWA_WeighingProcess	Batch	Batch Number
	Warehouse	I_EWA_WeighingProcess	Warehouse	Warehouse Number / Warehouse Complex
	StorageType	I_EWA_WeighingProcess	StorageType	Storage Type
	StorageBin	I_EWA_WeighingProcess	StorageBin	Storage Bin
	EWATrailerLicensePlateNumber	I_EWA_WeighingProcess	EWATrailerLicensePlateNumber	Lincense Plate Number: Trailer
	AddressID	I_EWA_WeighingProcess	AddressID	Ship-to address
	EWATareDeviceGroup	I_EWA_WeighingProcess	EWATareDeviceGroup	Hareware Profile Group: Tare
	EWAGrossDeviceGroup	I_EWA_WeighingProcess	EWAGrossDeviceGroup	Hareware Profile Group: Gross
	EWABillingType	I_EWA_WeighingProcess	EWABillingType	Flag For Payment Transaction
	EWAWeighingTransacDeliveryType	I_EWA_WeighingProcess	EWAWeighingTransacDeliveryType	Weighing Transaction: Internal/External Transaction
	EWAWeighingTransacObjectNumber	I_EWA_WeighingProcess	EWAWeighingTransacObjectNumber	Object number
	EWAMatlSplittingIsInPercent	I_EWA_WeighingProcess	EWAMatlSplittingIsInPercent	Percentage Flag
	EWAFcltyReltdWeighingTransac	I_EWA_WeighingProcess	EWAFcltyReltdWeighingTransac	Facility-Related Weighing Number
	EWASplittingWeighingTransac	I_EWA_WeighingProcess	EWASplittingWeighingTransac	Weighing Transaction (Splitting)
	EWAMaterialSplittingSequence	I_EWA_WeighingProcess	EWAMaterialSplittingSequence	Serial Number per Material Split in Weighing Transaction
	EWAMaterialSplittingRatio	I_EWA_WeighingProcess	EWAMaterialSplittingRatio	Percentage for Material Split in Multi Weighing
	EWAMaterialSplittingType	I_EWA_WeighingProcess	EWAMaterialSplittingType	Material Split Type
	EWAMatlSplittingVolumeRatio	I_EWA_WeighingProcess	EWAMatlSplittingVolumeRatio	Percentage for Material Split in Multi Weighing
	UtilitiesPremise	I_EWA_WeighingProcess	UtilitiesPremise	Premise
	ConsumptionBillingPaymentTerms	I_EWA_WeighingProcess	ConsumptionBillingPaymentTerms	Terms of Payment Key
	PaymentTermsValidityMonthDay	I_EWA_WeighingProcess	PaymentTermsValidityMonthDay	Day Limit
	CapacityInternalID	I_EWA_WeighingProcess	CapacityInternalID	Capacity ID
	EWACapacityVersion	I_EWA_WeighingProcess	EWACapacityVersion	Available capacity version
	EWAEndDate	I_EWA_WeighingProcess	EWAEndDate	End Date
	EWACapacityCycleCurrentWeekDay	I_EWA_WeighingProcess	EWACapacityCycleCurrentWeekDay	Current weekday number within the available capacity cycle
	AvailableCapacityShift	I_EWA_WeighingProcess	AvailableCapacityShift	Shift Number of an Available Capacity
	EWAShiftDate	I_EWA_WeighingProcess	EWAShiftDate	Shift Date
	EWAShiftTime	I_EWA_WeighingProcess	EWAShiftTime	Time of Acceptance
	EWAWeighingTransacPostingDate	I_EWA_WeighingProcess	EWAWeighingTransacPostingDate	Posting Date
	RELocalSubDistrict	I_EWA_WeighingProcess	RELocalSubDistrict	Local Subdistrict
	REPropertyTractNumberText	I_EWA_WeighingProcess	REPropertyTractNumberText	Number of Tract of Land in Land Register
	REParcelOfLandText	I_EWA_WeighingProcess	REParcelOfLandText	Parcel of Land
	EWAWeighingTransacIsCancelled	I_EWA_WeighingProcess	EWAWeighingTransacIsCancelled	Reverse Indicator for Weighing Data Record
	EWATareIsMaintainedManually	I_EWA_WeighingProcess	EWATareIsMaintainedManually	Maintain Tare Weight Manually
	EWASplittingIsCancelled	I_EWA_WeighingProcess	EWASplittingIsCancelled	Material Splitting Canceled
	EWAControllingDocPostingDate	I_EWA_WeighingProcess	EWAControllingDocPostingDate	Date on Which CO Document Was Posted
	EWAWeighingFeeCode	I_EWA_WeighingProcess	EWAWeighingFeeCode	Weighing Fee
	EWAWeightIsMinimumNet	I_EWA_WeighingProcess	EWAWeightIsMinimumNet	Flag for minimun net weight
	EWADeviceGroup	I_EWA_WeighingProcess	EWADeviceGroup	Hardware Profile Group
	EWAIsWeighingTransacCancelled	EWAMultipleWeighProc	EWAIsWeighingTransacCancelled	Reverse Indicator for Weighing Data Record
	EWASplittingMethod	EWAMultipleWeighProc	EWASplittingMethod	Splitting Method of the Weighing Transaction
	EWAYardCheckerStatus	EWAMultipleWeighProc	EWAYardCheckerStatus
	_Customer		_Customer

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_EWA_WasteItemWeighingDEX.
-- 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_EWA_WasteItemWeighingDEX AS
SELECT
  EWA_Weigh.EWAWeighingTransaction AS EWAWeighingTransaction,
  EWA_Weigh.EWALeadingWeighingTransaction AS EWALeadingWeighingTransaction,
  EWA_Weigh.EWAFleetEquipment AS EWAFleetEquipment,
  EWA_Weigh.EWATrailerFleetEquipment AS EWATrailerFleetEquipment,
  EWA_Weigh.EWAWasteTreatment AS EWAWasteTreatment,
  EWA_Weigh.EWAWasteDisposalOrder AS EWAWasteDisposalOrder,
  EWA_Weigh.EWAWeighingNoteSequence AS EWAWeighingNoteSequence,
  EWA_Weigh.EWAWeighingRecordExtNumber AS EWAWeighingRecordExtNumber,
  EWA_Weigh.EWAWaste AS EWAWaste,
  EWA_Weigh.EWALicensePlateNumber AS EWALicensePlateNumber,
  EWA_Weigh.EWAGrossWeighingNumber AS EWAGrossWeighingNumber,
  EWA_Weigh.EWAGrossWeighingDate AS EWAGrossWeighingDate,
  EWA_Weigh.EWAGrossWeighingTime AS EWAGrossWeighingTime,
  EWA_Weigh.EWAGrossWeighingInfoCode AS EWAGrossWeighingInfoCode,
  EWA_Weigh.EWATareWeighingInfoCode AS EWATareWeighingInfoCode,
  EWA_Weigh.EWANetWeighingInfoCode AS EWANetWeighingInfoCode,
  EWA_Weigh.EWAGrossWeight AS EWAGrossWeight,
  EWA_Weigh.EWAGrossWeightUnit AS EWAGrossWeightUnit,
  EWA_Weigh.EWATareWeighingNumber AS EWATareWeighingNumber,
  EWA_Weigh.EWATareWeighingDate AS EWATareWeighingDate,
  EWA_Weigh.EWATareWeighingTime AS EWATareWeighingTime,
  EWA_Weigh.EWATareWeight AS EWATareWeight,
  EWA_Weigh.EWATareWeightUnit AS EWATareWeightUnit,
  EWA_Weigh.EWAEmptyWeight AS EWAEmptyWeight,
  EWA_Weigh.EWAWeightUnit AS EWAWeightUnit,
  EWA_Weigh.EWANetWeight AS EWANetWeight,
  EWA_Weigh.EWAWasteVolume AS EWAWasteVolume,
  EWA_Weigh.EWAVolumeUnit AS EWAVolumeUnit,
  EWA_Weigh.EWAWasteDisposalFacility AS EWAWasteDisposalFacility,
  EWA_Weigh.EWAWasteDsplFacilityOrderType AS EWAWasteDsplFacilityOrderType,
  EWA_Weigh.Plant AS Plant,
  EWA_Weigh.StorageLocation AS StorageLocation,
  EWA_Weigh.EWAStockType AS EWAStockType,
  EWA_Weigh.EWAWasteDsplOrdItmObjectNumber AS EWAWasteDsplOrdItmObjectNumber,
  EWA_Weigh.EWAWeighingTransactionType AS EWAWeighingTransactionType,
  EWA_Weigh.EWAIsGoodsMovementRelevant AS EWAIsGoodsMovementRelevant,
  EWA_Weigh.EWAIsBillingRelevant AS EWAIsBillingRelevant,
  EWA_Weigh.EWAWeighingQuantity AS EWAWeighingQuantity,
  EWA_Weigh.EWAWeighingQuantityUnit AS EWAWeighingQuantityUnit,
  EWA_Weigh.EWATargetWasteDisposalFacility AS EWATargetWasteDisposalFacility,
  EWA_Weigh.EWATargetPlant AS EWATargetPlant,
  EWA_Weigh.EWATargetStorageLocation AS EWATargetStorageLocation,
  EWA_Weigh.EWATargetStorageBin AS EWATargetStorageBin,
  EWA_Weigh.EWATargetStorageType AS EWATargetStorageType,
  EWA_Weigh.EWAWasteType AS EWAWasteType,
  EWA_Weigh.EWAContainerLocation AS EWAContainerLocation,
  EWA_Weigh.EWAContainerCategory AS EWAContainerCategory,
  EWA_Weigh.Customer AS Customer,
  EWA_Weigh.EWALoadingFromTime AS EWALoadingFromTime,
  EWA_Weigh.EWALoadingToTime AS EWALoadingToTime,
  EWA_Weigh.EWAUnloadingFromTime AS EWAUnloadingFromTime,
  EWA_Weigh.EWAUnloadingToTime AS EWAUnloadingToTime,
  EWA_Weigh.EWAVehicleContainerCategory AS EWAVehicleContainerCategory,
  EWA_Weigh.EWATrailerContainerCategory AS EWATrailerContainerCategory,
  EWA_Weigh.MaterialDocument AS MaterialDocument,
  EWA_Weigh.MaterialDocumentYear AS MaterialDocumentYear,
  EWA_Weigh.SalesDocument AS SalesDocument,
  EWA_Weigh.EWAWeighingTransacGrossWeight AS EWAWeighingTransacGrossWeight,
  EWA_Weigh.EWAWeighingTransacTareWeight AS EWAWeighingTransacTareWeight,
  EWA_Weigh.EWAWeighingTransacNetWeight AS EWAWeighingTransacNetWeight,
  EWA_Weigh.SalesContract AS SalesContract,
  EWA_Weigh.SalesContractItem AS SalesContractItem,
  EWA_Weigh.EWAWeighingType AS EWAWeighingType,
  EWA_Weigh.EWAWasteDsplFcltyTransacCat AS EWAWasteDsplFcltyTransacCat,
  EWA_Weigh.EWAWasteDsplFcltyTransaction AS EWAWasteDsplFcltyTransaction,
  EWA_Weigh.Batch AS Batch,
  EWA_Weigh.Warehouse AS Warehouse,
  EWA_Weigh.StorageType AS StorageType,
  EWA_Weigh.StorageBin AS StorageBin,
  EWA_Weigh.EWATrailerLicensePlateNumber AS EWATrailerLicensePlateNumber,
  EWA_Weigh.AddressID AS AddressID,
  EWA_Weigh.EWATareDeviceGroup AS EWATareDeviceGroup,
  EWA_Weigh.EWAGrossDeviceGroup AS EWAGrossDeviceGroup,
  EWA_Weigh.EWABillingType AS EWABillingType,
  EWA_Weigh.EWAWeighingTransacDeliveryType AS EWAWeighingTransacDeliveryType,
  EWA_Weigh.EWAWeighingTransacObjectNumber AS EWAWeighingTransacObjectNumber,
  EWA_Weigh.EWAMatlSplittingIsInPercent AS EWAMatlSplittingIsInPercent,
  EWA_Weigh.EWAFcltyReltdWeighingTransac AS EWAFcltyReltdWeighingTransac,
  EWA_Weigh.EWASplittingWeighingTransac AS EWASplittingWeighingTransac,
  EWA_Weigh.EWAMaterialSplittingSequence AS EWAMaterialSplittingSequence,
  EWA_Weigh.EWAMaterialSplittingRatio AS EWAMaterialSplittingRatio,
  EWA_Weigh.EWAMaterialSplittingType AS EWAMaterialSplittingType,
  EWA_Weigh.EWAMatlSplittingVolumeRatio AS EWAMatlSplittingVolumeRatio,
  EWA_Weigh.UtilitiesPremise AS UtilitiesPremise,
  EWA_Weigh.ConsumptionBillingPaymentTerms AS ConsumptionBillingPaymentTerms,
  EWA_Weigh.PaymentTermsValidityMonthDay AS PaymentTermsValidityMonthDay,
  EWA_Weigh.CapacityInternalID AS CapacityInternalID,
  EWA_Weigh.EWACapacityVersion AS EWACapacityVersion,
  EWA_Weigh.EWAEndDate AS EWAEndDate,
  EWA_Weigh.EWACapacityCycleCurrentWeekDay AS EWACapacityCycleCurrentWeekDay,
  EWA_Weigh.AvailableCapacityShift AS AvailableCapacityShift,
  EWA_Weigh.EWAShiftDate AS EWAShiftDate,
  EWA_Weigh.EWAShiftTime AS EWAShiftTime,
  EWA_Weigh.EWAWeighingTransacPostingDate AS EWAWeighingTransacPostingDate,
  EWA_Weigh.RELocalSubDistrict AS RELocalSubDistrict,
  EWA_Weigh.REPropertyTractNumberText AS REPropertyTractNumberText,
  EWA_Weigh.REParcelOfLandText AS REParcelOfLandText,
  EWA_Weigh.EWAWeighingTransacIsCancelled AS EWAWeighingTransacIsCancelled,
  EWA_Weigh.EWATareIsMaintainedManually AS EWATareIsMaintainedManually,
  EWA_Weigh.EWASplittingIsCancelled AS EWASplittingIsCancelled,
  EWA_Weigh.EWAControllingDocPostingDate AS EWAControllingDocPostingDate,
  EWA_Weigh.EWAWeighingFeeCode AS EWAWeighingFeeCode,
  EWA_Weigh.EWAWeightIsMinimumNet AS EWAWeightIsMinimumNet,
  EWA_Weigh.EWADeviceGroup AS EWADeviceGroup,
  EWAMultipleWeighProc.EWAIsWeighingTransacCancelled AS EWAIsWeighingTransacCancelled,
  EWAMultipleWeighProc.EWASplittingMethod AS EWASplittingMethod,
  EWAMultipleWeighProc.EWAYardCheckerStatus AS EWAYardCheckerStatus
FROM I_EWA_WeighingProcess AS EWA_Weigh
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN E_EWA_WasteItemWeigh AS _ExtensionWeighProc ON EWAWeighingTransaction = _ExtensionWeighProc.EWAWeighingTransaction  -- association [0..1]
;

Depth:

C_EWA_WasteItemWeighingDEX view_entity

I_EWA_WeighingProcess view_entity