What is I_EWA_WeighingProcessCube in SAP S/4HANA?

I_EWA_WeighingProcessCube is a composite CDS view in SAP S/4HANA. Weighing Process - Cube It contains 166 fields.

Which tables does I_EWA_WeighingProcessCube read from?

I_EWA_WeighingProcessCube reads data from: I_EWA_WeighingProcess.

What VDM layer is I_EWA_WeighingProcessCube?

I_EWA_WeighingProcessCube is classified as a Composite view that combines data from multiple basic views.

I_EWA_WeighingProcessCube

DDL: I_EWA_WEIGHINGPROCESSCUBE Type: view_entity COMPOSITE

166 Fields 1 Data Sources 8 Associations

Weighing Process - Cube

I_EWA_WeighingProcessCube (Composite)

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

Utilities

I_EWA_WeighingProcessCube is a Composite CDS View (Cube) that provides data about "Weighing Process - Cube" in SAP S/4HANA. It reads from 1 data source (I_EWA_WeighingProcess) and exposes 166 fields with key field EWAWeighingTransaction. It has 8 associations to related views.

SAP Help Documentation

Category	CDS Views for Weighing
Data Category	Cube

Purpose
This CDS view is used to fetch all fields relevant to the weighing process. Weighing details for transactions include weighing quantities such as gross weight, tare weight, and net weight. 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
Parameters The parameters of the CDS view are as follows: P_EWAWeightUnit : This parameter is used to display unit of weight. P_EWAVolumeUnit : This parameter is used to display unit of volume. P_Language : This parameter is used to display language. Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment EWAWeighingTransaction Weighing Transaction Attribute Weighing Transaction EWAWaste Waste Attribute Waste SalesContract Sales Contract Attribute Sales Contract SalesContractItem Sales Contract Item Attribute Sales Contract Item MaterialDocument Material Document Attribute Number of Material Document EWAWasteDisposalOrder Waste Disposal Order Attribute Internal Number for Identifying a Waste Disposal Order

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-WA
Capabilities	Data Provider for Analytical Queries, Data Source for Defining CDS Entities, Data Source in SQL Select
Package	Utilities for SAP S/4HANA
Description	<p>This CDS view is used to fetch all fields relevant to the weighing process. Weighing details for transactions include weighing quantities such as gross weight, tare weight, and net weight.</p> <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

Parameters (3)

Name	Type	Default
P_EWAWeightUnit	ewa_vdm_dispweightunit
P_EWAVolumeUnit	ewa_vdm_dispvolunit
P_Language	ewa_vdm_language

Associations (8)

Cardinality	Target	Alias	Condition
[0..1]	I_CalendarDate	_Cal	`EWA_WEIGH.EWAShiftDate = _Cal.CalendarDate`
[0..1]	I_EWA_MultipleWeighingProcess	_EWAMultipleWeighingProcess	`$projection.EWAWeighingTransaction = _EWAMultipleWeighingProcess.EWAWeighingTransaction`
[0..1]	I_EWA_WasteDisposalOrder	_EWAWasteDisposalOrder	`$projection.EWAWasteDisposalOrder = _EWAWasteDisposalOrder.EWAWasteDisposalOrder`
[0..1]	I_Customer	_Customer	`$projection.Customer = _Customer.Customer`
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[0..1]	I_Plant	_TargetPlant	`$projection.EWATargetPlant = _TargetPlant.Plant`
[0..1]	I_EWA_WeighingStatus	_EWAWeighingStatus	`$projection.EWAWeighingTransaction = _EWAWeighingStatus.EWAWeighingTransaction`
[0..1]	E_EWA_WasteItemWeigh	_ExtensionWeighProc	`$projection.EWAWeighingTransaction = _ExtensionWeighProc.EWAWeighingTransaction`

Annotations (12)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Weighing Process - Cube	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
Analytics.internalName	#LOCAL	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (166)

Key	Field	Source Table	Source Field	Description
KEY	EWAWeighingTransaction	I_EWA_WeighingProcess	EWAWeighingTransaction	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
	EWAWasteText			Material Description
	EWALicensePlateNumber	I_EWA_WeighingProcess	EWALicensePlateNumber	License Plate Number
	_Cal		_Cal
	_EWAMultipleWeighingProcess		_EWAMultipleWeighingProcess
	_EWAWeighingStatus		_EWAWeighingStatus
	_Customer		_Customer
	_Plant		_Plant
	_TargetPlant		_TargetPlant
	EWANmbrOfWeighingTransac			Number of Weighing Transaction
	EWAGrossWeighingNumber	I_EWA_WeighingProcess	EWAGrossWeighingNumber	Gross Weighing Number
	EWAGrossWeighingDate	I_EWA_WeighingProcess	EWAGrossWeighingDate	Weighing Date- Gross
	EWAGrossWeighingTime	I_EWA_WeighingProcess	EWAGrossWeighingTime	Gross Weighing Time
	EWAGrossWeighingInfoCode	I_EWA_WeighingProcess	EWAGrossWeighingInfoCode	Weighing Information Gross Weighing
	EWAGrossWeighInfoCodeDesc			Description Weighing Information
	EWAGrossWeight	I_EWA_WeighingProcess	EWAGrossWeight	Gross Weight
	EWAGrossWeightUnit	I_EWA_WeighingProcess	EWAGrossWeightUnit	Gross Weight Unit
	EWAGrossWeightDisplayUnit			Display Unit of Weight.
	EWATareWeighingNumber	I_EWA_WeighingProcess	EWATareWeighingNumber	Tare Weighing Number
	EWATareWeighingDate	I_EWA_WeighingProcess	EWATareWeighingDate	Tare Weighing Date
	EWATareWeighingTime	I_EWA_WeighingProcess	EWATareWeighingTime	Tare Weighing Time
	EWATareWeighingInfoCode	I_EWA_WeighingProcess	EWATareWeighingInfoCode	Weighing Information Tare Weight
	EWATareWeighInfoCodeDesc			Description Weighing Information
	EWATareWeight	I_EWA_WeighingProcess	EWATareWeight	Tare Weight
	EWATareWeightUnit	I_EWA_WeighingProcess	EWATareWeightUnit	Tare Weight Unit
	EWATareWeightDisplayUnit			Display Unit of Weight.
	EWANetWeighingInfoCode	I_EWA_WeighingProcess	EWANetWeighingInfoCode	Weighing Information Net
	EWANetWeighInfoCodeDesc			Description Weighing Information
	EWANetWeight	I_EWA_WeighingProcess	EWANetWeight	Net Weight
	EWANetWeightDisplayUnit			Display Unit of Weight.
	EWAEmptyWeight	I_EWA_WeighingProcess	EWAEmptyWeight	Weight of empty container
	EWAWeightUnit	I_EWA_WeighingProcess	EWAWeightUnit	Empty Container Weight Unit
	EWAEmptyWeightDisplayUnit			Display Empty Container Weight
	EWAWasteVolume	I_EWA_WeighingProcess	EWAWasteVolume	Waste Volume
	EWAVolumeUnit	I_EWA_WeighingProcess	EWAVolumeUnit	Waste Volume Unit
	EWAWasteVolumeDisplayUnit			Display Unit of Volume.
	EWAWasteDisposalFacility	I_EWA_WeighingProcess	EWAWasteDisposalFacility	Identification of Waste Disposal Facility
	EWAWasteDisposalFacilityDesc			Waste Disposal Facility Desc
	EWAIsExternalWasteDsplFacility			Waste Disposal Facility Type
	Plant	I_EWA_WeighingProcess	Plant	Plant
	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	Weighing 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 Bin
	EWATargetStorageType	I_EWA_WeighingProcess	EWATargetStorageType	Target Storage Location 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
	CustomerFullName			Customer Full Name
	EWALoadingFromTime	I_EWA_WeighingProcess	EWALoadingFromTime	Loading From Time
	EWALoadingToTime	I_EWA_WeighingProcess	EWALoadingToTime	Loading To Time
	EWAUnloadingFromTime	I_EWA_WeighingProcess	EWAUnloadingFromTime	Unloading From Time
	EWAUnloadingToTime	I_EWA_WeighingProcess	EWAUnloadingToTime	Unloading To Time
	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	Weighing Gross Weight
	EWAWeighGrossDisplayWgtUnit			Display Weighing Gross Weight Unit
	EWAWeighingTransacTareWeight	I_EWA_WeighingProcess	EWAWeighingTransacTareWeight	Weighing Tare Weight
	EWAWeighTareDisplayWgtUnit			Display Weighing Tare Weight Unit
	EWAWeighingTransacNetWeight	I_EWA_WeighingProcess	EWAWeighingTransacNetWeight	Weighing Net Weight
	EWAWeighNetDisplayWgtUnit			Display Weighing Net Weight Unit
	SalesContract	I_EWA_WeighingProcess	SalesContract	Sales Contract
	SalesContractItem	I_EWA_WeighingProcess	SalesContractItem	Sales Contract Item
	EWAWeighingType	I_EWA_WeighingProcess	EWAWeighingType	Weighing Data Type
	EWAWasteDsplFcltyTransacCat	I_EWA_WeighingProcess	EWAWasteDsplFcltyTransacCat	WD Facility 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	Address Number
	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	Weighing Transaction Object Number
	EWALeadingWeighingTransaction	I_EWA_WeighingProcess	EWALeadingWeighingTransaction	Leading Weighing Transaction
	EWAMatlSplittingIsInPercent	I_EWA_WeighingProcess	EWAMatlSplittingIsInPercent	Material Splitting Percentage
	EWAFcltyReltdWeighingTransac	I_EWA_WeighingProcess	EWAFcltyReltdWeighingTransac	Fcaility Related Weighing Transaction
	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 Splitting Type
	EWASplittingIsCancelled	I_EWA_WeighingProcess	EWASplittingIsCancelled	Spiltting Cancellation Flag
	EWAMaterialSplittingTypeDesc			Material Splitting Type Desc
	EWAMatlSplittingVolumeRatio	I_EWA_WeighingProcess	EWAMatlSplittingVolumeRatio	Percentage for Material Split in Multi Weighing
	EWAIsWeighingTransacCancelled	_EWAMultipleWeighingProcess	EWAIsWeighingTransacCancelled	Reverse Indicator for Weighing Data Record
	EWACopiedWeighingTransaction	_EWAMultipleWeighingProcess	EWACopiedWeighingTransaction	Copied Weighing Transaction
	EWASplittingMethod	_EWAMultipleWeighingProcess	EWASplittingMethod	Splitting Method of the Weighing Transaction
	UtilitiesPremise	I_EWA_WeighingProcess	UtilitiesPremise	Ultilies Premise
	ConsumptionBillingPaymentTerms	I_EWA_WeighingProcess	ConsumptionBillingPaymentTerms	Consumption Billing Payment Terms
	PaymentTermsValidityMonthDay	I_EWA_WeighingProcess	PaymentTermsValidityMonthDay	Payment Terms Validity Month Day
	CapacityInternalID	I_EWA_WeighingProcess	CapacityInternalID	Capacity Internal 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
	EWAShiftDateYear			Year of Creation
	EWAShiftDateYearQuarter			Year/Quarter of Creation
	EWAShiftDateYearMonth			Year/Month of Creation
	EWAShiftDateWeek			Week of Creation
	EWAWeighingTransacPostingDate	I_EWA_WeighingProcess	EWAWeighingTransacPostingDate	Posting Date
	RELocalSubDistrict	I_EWA_WeighingProcess	RELocalSubDistrict	Local Sub District
	REPropertyTractNumberText	I_EWA_WeighingProcess	REPropertyTractNumberText	Number of Tract of Land in Land Register
	REParcelOfLandText	I_EWA_WeighingProcess	REParcelOfLandText	Parcel of Land Text
	EWAWeighingTransacIsCancelled	I_EWA_WeighingProcess	EWAWeighingTransacIsCancelled	Reverse Indicator for Weighing Data Record
	EWATareIsMaintainedManually	I_EWA_WeighingProcess	EWATareIsMaintainedManually	Maintain Tare Weight Manually
	EWAControllingDocPostingDate	I_EWA_WeighingProcess	EWAControllingDocPostingDate	Date on Which CO Document Was Posted
	EWAWeighingFeeCode	I_EWA_WeighingProcess	EWAWeighingFeeCode	Weighing Fee Code
	EWAWeightIsMinimumNet	I_EWA_WeighingProcess	EWAWeightIsMinimumNet	Flag for minimun net weight
	EWADeviceGroup	I_EWA_WeighingProcess	EWADeviceGroup	Hardware Profile Group
	EWAWeighingStatusUnchecked	_EWAWeighingStatus	EWAWeighingStatusUnchecked	No. of Unchecked Weighing Transaction
	EWAWeighingStatusBooked	_EWAWeighingStatus	EWAWeighingStatusBooked	No. of Booked Weighing Transaction
	EWAWeighingStatusReversed	_EWAWeighingStatus	EWAWeighingStatusReversed	No. of Cancelled Weighing Transaction
	EWAYardCheckerStatusUnchecked	_EWAWeighingStatus	EWAYardCheckerStatusUnchecked	No. of Yardlist Status - Created
	EWAYardCheckerStatusProcessed	_EWAWeighingStatus	EWAYardCheckerStatusProcessed	No. of Yardlist Status - Completed
	EWAYardCheckerStatusRejected	_EWAWeighingStatus	EWAYardCheckerStatusRejected	No. of Yardlist Status - Cancelled
	_EWAContainerCategory	I_EWA_WeighingProcess	_EWAContainerCategory
	_EWAContainerLocation	I_EWA_WeighingProcess	_EWAContainerLocation
	_EWAFleetEquipment	I_EWA_WeighingProcess	_EWAFleetEquipment
	_EWAGrossWeighingInfoCode	I_EWA_WeighingProcess	_EWAGrossWeighingInfoCode
	_EWAGrossWeightUnit	I_EWA_WeighingProcess	_EWAGrossWeightUnit
	_EWALeadingWeighingTransaction	I_EWA_WeighingProcess	_EWALeadingWeighingTransaction
	_EWANetWeighingInfoCode	I_EWA_WeighingProcess	_EWANetWeighingInfoCode
	_EWATareWeighingInfoCode	I_EWA_WeighingProcess	_EWATareWeighingInfoCode
	_EWATareWeightUnit	I_EWA_WeighingProcess	_EWATareWeightUnit
	_EWATrailerContainerCategory	I_EWA_WeighingProcess	_EWATrailerContainerCategory
	_EWATrailerFleetEquipment	I_EWA_WeighingProcess	_EWATrailerFleetEquipment
	_EWAVehicleContainerCategory	I_EWA_WeighingProcess	_EWAVehicleContainerCategory
	_EWAVolumeUnit	I_EWA_WeighingProcess	_EWAVolumeUnit
	_EWAWaste	I_EWA_WeighingProcess	_EWAWaste
	_EWAWasteDisposalFacility	I_EWA_WeighingProcess	_EWAWasteDisposalFacility
	_EWAWasteDisposalOrder		_EWAWasteDisposalOrder
	_EWAWasteType	I_EWA_WeighingProcess	_EWAWasteType
	_EWAWeighingFeeCode	I_EWA_WeighingProcess	_EWAWeighingFeeCode
	_EWAWeighingType	I_EWA_WeighingProcess	_EWAWeighingType
	_EWAWeightUnit	I_EWA_WeighingProcess	_EWAWeightUnit
	_PaymentTermsValidityMonthDay	I_EWA_WeighingProcess	_PaymentTermsValidityMonthDay
	_RELocalSubDistrict	I_EWA_WeighingProcess	_RELocalSubDistrict
	_SalesContract	I_EWA_WeighingProcess	_SalesContract
	_SalesContractItem	I_EWA_WeighingProcess	_SalesContractItem
	_SalesDocument	I_EWA_WeighingProcess	_SalesDocument
	_UtilitiesPremise	I_EWA_WeighingProcess	_UtilitiesPremise
	_Warehouse	I_EWA_WeighingProcess	_Warehouse

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_WeighingProcessCube.
-- 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.
-- Parameters: P_EWAWeightUnit : ewa_vdm_dispweightunit, P_EWAVolumeUnit : ewa_vdm_dispvolunit, P_Language : ewa_vdm_language

CREATE VIEW I_EWA_WeighingProcessCube AS
SELECT
  EWA_WEIGH.EWAWeighingTransaction AS EWAWeighingTransaction,
  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._EWAWaste._Text[1: Language=$parameters.P_Language].MaterialName AS EWAWasteText,
  EWA_WEIGH.EWALicensePlateNumber AS EWALicensePlateNumber,
  cast (1 as abap.int4) AS EWANmbrOfWeighingTransac,
  EWA_WEIGH.EWAGrossWeighingNumber AS EWAGrossWeighingNumber,
  EWA_WEIGH.EWAGrossWeighingDate AS EWAGrossWeighingDate,
  EWA_WEIGH.EWAGrossWeighingTime AS EWAGrossWeighingTime,
  EWA_WEIGH.EWAGrossWeighingInfoCode AS EWAGrossWeighingInfoCode,
  EWA_WEIGH._EWAGrossWeighingInfoCode._EWAWeighingInformationText[1: Language=$parameters.P_Language].EWAWeighingInfoDescription AS EWAGrossWeighInfoCodeDesc,
  EWA_WEIGH.EWAGrossWeight AS EWAGrossWeight,
  EWA_WEIGH.EWAGrossWeightUnit AS EWAGrossWeightUnit,
  $parameters.P_EWAWeightUnit AS EWAGrossWeightDisplayUnit,
  EWA_WEIGH.EWATareWeighingNumber AS EWATareWeighingNumber,
  EWA_WEIGH.EWATareWeighingDate AS EWATareWeighingDate,
  EWA_WEIGH.EWATareWeighingTime AS EWATareWeighingTime,
  EWA_WEIGH.EWATareWeighingInfoCode AS EWATareWeighingInfoCode,
  EWA_WEIGH._EWATareWeighingInfoCode._EWAWeighingInformationText[1: Language=$parameters.P_Language].EWAWeighingInfoDescription AS EWATareWeighInfoCodeDesc,
  EWA_WEIGH.EWATareWeight AS EWATareWeight,
  EWA_WEIGH.EWATareWeightUnit AS EWATareWeightUnit,
  $parameters.P_EWAWeightUnit AS EWATareWeightDisplayUnit,
  EWA_WEIGH.EWANetWeighingInfoCode AS EWANetWeighingInfoCode,
  EWA_WEIGH._EWANetWeighingInfoCode._EWAWeighingInformationText[1: Language=$parameters.P_Language].EWAWeighingInfoDescription AS EWANetWeighInfoCodeDesc,
  EWA_WEIGH.EWANetWeight AS EWANetWeight,
  $parameters.P_EWAWeightUnit AS EWANetWeightDisplayUnit,
  EWA_WEIGH.EWAEmptyWeight AS EWAEmptyWeight,
  EWA_WEIGH.EWAWeightUnit AS EWAWeightUnit,
  $parameters.P_EWAWeightUnit AS EWAEmptyWeightDisplayUnit,
  EWA_WEIGH.EWAWasteVolume AS EWAWasteVolume,
  EWA_WEIGH.EWAVolumeUnit AS EWAVolumeUnit,
  $parameters.P_EWAVolumeUnit AS EWAWasteVolumeDisplayUnit,
  EWA_WEIGH.EWAWasteDisposalFacility AS EWAWasteDisposalFacility,
  EWA_WEIGH._EWAWasteDisposalFacility.EWAWasteDisposalFacilityDesc AS EWAWasteDisposalFacilityDesc,
  EWA_WEIGH._EWAWasteDisposalFacility.EWAIsExternalWasteDsplFacility AS EWAIsExternalWasteDsplFacility,
  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._Customer.CustomerFullName AS CustomerFullName,
  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,
  $parameters.P_EWAWeightUnit AS EWAWeighGrossDisplayWgtUnit,
  EWA_WEIGH.EWAWeighingTransacTareWeight AS EWAWeighingTransacTareWeight,
  $parameters.P_EWAWeightUnit AS EWAWeighTareDisplayWgtUnit,
  EWA_WEIGH.EWAWeighingTransacNetWeight AS EWAWeighingTransacNetWeight,
  $parameters.P_EWAWeightUnit AS EWAWeighNetDisplayWgtUnit,
  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.EWALeadingWeighingTransaction AS EWALeadingWeighingTransaction,
  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.EWASplittingIsCancelled AS EWASplittingIsCancelled,
  EWA_WEIGH._EWAWasteType._Text[1: Language=$parameters.P_Language].MaterialName AS EWAMaterialSplittingTypeDesc,
  EWA_WEIGH.EWAMatlSplittingVolumeRatio AS EWAMatlSplittingVolumeRatio,
  _EWAMultipleWeighingProcess.EWAIsWeighingTransacCancelled AS EWAIsWeighingTransacCancelled,
  _EWAMultipleWeighingProcess.EWACopiedWeighingTransaction AS EWACopiedWeighingTransaction,
  _EWAMultipleWeighingProcess.EWASplittingMethod AS EWASplittingMethod,
  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,
  cast(_Cal.CalendarYear as creation_date_year) AS EWAShiftDateYear,
  cast(_Cal.YearQuarter as creation_date_year_quarter) AS EWAShiftDateYearQuarter,
  cast(_Cal.YearMonth as creation_date_year_month) AS EWAShiftDateYearMonth,
  cast(_Cal.CalendarWeek as creation_date_week) AS EWAShiftDateWeek,
  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.EWAControllingDocPostingDate AS EWAControllingDocPostingDate,
  EWA_WEIGH.EWAWeighingFeeCode AS EWAWeighingFeeCode,
  EWA_WEIGH.EWAWeightIsMinimumNet AS EWAWeightIsMinimumNet,
  EWA_WEIGH.EWADeviceGroup AS EWADeviceGroup,
  _EWAWeighingStatus.EWAWeighingStatusUnchecked AS EWAWeighingStatusUnchecked,
  _EWAWeighingStatus.EWAWeighingStatusBooked AS EWAWeighingStatusBooked,
  _EWAWeighingStatus.EWAWeighingStatusReversed AS EWAWeighingStatusReversed,
  _EWAWeighingStatus.EWAYardCheckerStatusUnchecked AS EWAYardCheckerStatusUnchecked,
  _EWAWeighingStatus.EWAYardCheckerStatusProcessed AS EWAYardCheckerStatusProcessed,
  _EWAWeighingStatus.EWAYardCheckerStatusRejected AS EWAYardCheckerStatusRejected,
  EWA_WEIGH._EWAContainerCategory AS _EWAContainerCategory,
  EWA_WEIGH._EWAContainerLocation AS _EWAContainerLocation,
  EWA_WEIGH._EWAFleetEquipment AS _EWAFleetEquipment,
  EWA_WEIGH._EWAGrossWeighingInfoCode AS _EWAGrossWeighingInfoCode,
  EWA_WEIGH._EWAGrossWeightUnit AS _EWAGrossWeightUnit,
  EWA_WEIGH._EWALeadingWeighingTransaction AS _EWALeadingWeighingTransaction,
  EWA_WEIGH._EWANetWeighingInfoCode AS _EWANetWeighingInfoCode,
  EWA_WEIGH._EWATareWeighingInfoCode AS _EWATareWeighingInfoCode,
  EWA_WEIGH._EWATareWeightUnit AS _EWATareWeightUnit,
  EWA_WEIGH._EWATrailerContainerCategory AS _EWATrailerContainerCategory,
  EWA_WEIGH._EWATrailerFleetEquipment AS _EWATrailerFleetEquipment,
  EWA_WEIGH._EWAVehicleContainerCategory AS _EWAVehicleContainerCategory,
  EWA_WEIGH._EWAVolumeUnit AS _EWAVolumeUnit,
  EWA_WEIGH._EWAWaste AS _EWAWaste,
  EWA_WEIGH._EWAWasteDisposalFacility AS _EWAWasteDisposalFacility,
  EWA_WEIGH._EWAWasteType AS _EWAWasteType,
  EWA_WEIGH._EWAWeighingFeeCode AS _EWAWeighingFeeCode,
  EWA_WEIGH._EWAWeighingType AS _EWAWeighingType,
  EWA_WEIGH._EWAWeightUnit AS _EWAWeightUnit,
  EWA_WEIGH._PaymentTermsValidityMonthDay AS _PaymentTermsValidityMonthDay,
  EWA_WEIGH._RELocalSubDistrict AS _RELocalSubDistrict,
  EWA_WEIGH._SalesContract AS _SalesContract,
  EWA_WEIGH._SalesContractItem AS _SalesContractItem,
  EWA_WEIGH._SalesDocument AS _SalesDocument,
  EWA_WEIGH._UtilitiesPremise AS _UtilitiesPremise,
  EWA_WEIGH._Warehouse AS _Warehouse
FROM I_EWA_WeighingProcess AS EWA_WEIGH
LEFT OUTER JOIN I_CalendarDate AS _Cal ON EWA_WEIGH.EWAShiftDate = _Cal.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_EWA_MultipleWeighingProcess AS _EWAMultipleWeighingProcess ON EWAWeighingTransaction = _EWAMultipleWeighingProcess.EWAWeighingTransaction  -- association [0..1]
LEFT OUTER JOIN I_EWA_WasteDisposalOrder AS _EWAWasteDisposalOrder ON EWAWasteDisposalOrder = _EWAWasteDisposalOrder.EWAWasteDisposalOrder  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _TargetPlant ON EWATargetPlant = _TargetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_EWA_WeighingStatus AS _EWAWeighingStatus ON EWAWeighingTransaction = _EWAWeighingStatus.EWAWeighingTransaction  -- association [0..1]
LEFT OUTER JOIN E_EWA_WasteItemWeigh AS _ExtensionWeighProc ON EWAWeighingTransaction = _ExtensionWeighProc.EWAWeighingTransaction  -- association [0..1]
;

Depth:

I_EWA_WeighingProcessCube view_entity

I_EWA_WeighingProcess view_entity

C_EWA_WeighingProcessQuery view