What is C_EWA_WeighingProcessQuery in SAP S/4HANA?

C_EWA_WeighingProcessQuery is a consumption CDS view in SAP S/4HANA. Weighing Process - Query It contains 126 fields.

Which tables does C_EWA_WeighingProcessQuery read from?

C_EWA_WeighingProcessQuery reads data from: I_EWA_WeighingProcessCube.

What VDM layer is C_EWA_WeighingProcessQuery?

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

C_EWA_WeighingProcessQuery

DDL: C_EWA_WEIGHINGPROCESSQUERY SQL: CEWAWEIGHPROCQ Type: view CONSUMPTION

126 Fields 1 Data Sources 1 Associations

Weighing Process - Query

C_EWA_WeighingProcessQuery (Consumption)

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

Utilities

C_EWA_WeighingProcessQuery is a Consumption CDS View that provides data about "Weighing Process - Query" in SAP S/4HANA. It reads from 1 data source (I_EWA_WeighingProcessCube) and exposes 126 fields with key field EWAWeighingTransaction. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Weighing
Data Category	Query

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, as well as the associated resources. 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: Users who want to use this CDS view need to access it via another CDS view (privileged mode).

Structure
Parameters The parameters of the CDS view are as follows: P_EWAVolumeUnit : This parameter is used to display unit of volume. P_EWAWeightUnit : This parameter is used to display unit of weight. 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	Analytical Query
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, as well as the associated resources.</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_WeighingProcessCube	I_EWA_WeighingProcessCube	from

Parameters (3)

Name	Type	Default
P_EWAWeightUnit	ewa_vdm_dispweightunit
P_EWAVolumeUnit	ewa_vdm_dispvolunit
P_Language	ewa_vdm_language

Associations (1)

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

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CEWAWEIGHPROCQ	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Weighing Process - Query	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
ObjectModel.modelingPattern	#ANALYTICAL_QUERY	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (126)

Key	Field	Source Table	Source Field	Description
KEY	EWAWeighingTransaction		EWAWeighingTransaction	Weighing Transaction
	EWAFleetEquipment		EWAFleetEquipment	Equipment Number: Vehicle
	EWATrailerFleetEquipment		EWATrailerFleetEquipment	Equipment Number: Trailer
	EWAWasteTreatment		EWAWasteTreatment	Type of Waste Treatment
	EWAWasteDisposalOrder		EWAWasteDisposalOrder	Internal Number for Identifying a Waste Disposal Order
	EWAWeighingNoteSequence		EWAWeighingNoteSequence	Consecutive Number of Weighing Data Record
	EWAWeighingRecordExtNumber		EWAWeighingRecordExtNumber	External Number of Weighing Data Record
	EWAWaste		EWAWaste	Waste
	EWAWasteText		EWAWasteText	Material Description
	EWALicensePlateNumber		EWALicensePlateNumber	License Plate Number
	EWAShiftDate		EWAShiftDate	Shift Date
	EWAShiftTime		EWAShiftTime	Time of Acceptance
	EWAShiftDateWeek		EWAShiftDateWeek	Week of Creation
	EWAShiftDateYearMonth		EWAShiftDateYearMonth	Year/Month of Creation
	EWAShiftDateYearQuarter		EWAShiftDateYearQuarter	Year/Quarter of Creation
	EWAShiftDateYear		EWAShiftDateYear	Year of Creation
	EWAWeighingTransacPostingDate		EWAWeighingTransacPostingDate	Posting Date
	MaterialDocument		MaterialDocument	Number of Material Document
	MaterialDocumentYear		MaterialDocumentYear	Material Document Year
	SalesDocument		SalesDocument	Sales and Distribution Document Number
	SalesContract		SalesContract	Sales Contract
	SalesContractItem		SalesContractItem	Sales Contract Item
	EWAWeighingType		EWAWeighingType	Weighing Data Type
	Customer		Customer	Customer Number
	CustomerFullName		CustomerFullName	Customer Full Name
	EWANmbrOfWeighingTransac		EWANmbrOfWeighingTransac	Total number of Weighing Transaction
	EWAGrossWeighingNumber		EWAGrossWeighingNumber	Gross Weighing Number
	EWAGrossWeighingDate		EWAGrossWeighingDate	Weighing Date- Gross
	EWAGrossWeighingTime		EWAGrossWeighingTime	Gross Weighing Time
	EWAGrossWeighingInfoCode		EWAGrossWeighingInfoCode	Weighing Information Gross Weighing
	EWAGrossWeighInfoCodeDesc		EWAGrossWeighInfoCodeDesc	Description Weighing Information
	EWAGrossWeight		EWAGrossWeight	Gross Weight
	EWAGrossWeightUnit		EWAGrossWeightUnit	Gross Weight Unit
	EWAGrossDisplayWeight		EWAGrossDisplayWeight	Display Gross Weight
	EWAGrossWeightDisplayUnit		EWAGrossWeightDisplayUnit	Gross Weight Display Unit
	EWAWeighGrossDisplayWgtUnit		EWAWeighGrossDisplayWgtUnit	Display Weighing Gross Weight Unit
	EWAWeighingTransacGrossWeight		EWAWeighingTransacGrossWeight	Weighing Gross Weight
	EWAWeighTransDisplayGrossWgt		EWAWeighTransDisplayGrossWgt	Display Weighing Gross Weight
	EWATareWeighingNumber		EWATareWeighingNumber	Tare Weighing Number
	EWATareWeighingDate		EWATareWeighingDate	Tare Weighing Date
	EWATareWeighingTime		EWATareWeighingTime	Tare Weighing Time
	EWATareWeighingInfoCode		EWATareWeighingInfoCode	Weighing Information Tare Weight
	EWATareWeighInfoCodeDesc		EWATareWeighInfoCodeDesc	Description Weighing Information
	EWATareWeight		EWATareWeight	Tare Weight
	EWATareWeightUnit		EWATareWeightUnit	Tare Weight Unit
	EWATareDisplayWeight		EWATareDisplayWeight	Display Tare Weight
	EWATareWeightDisplayUnit		EWATareWeightDisplayUnit	Tare Weight Display Unit
	EWAWeighTareDisplayWgtUnit		EWAWeighTareDisplayWgtUnit	Display Weighing Tare Weight Unit
	EWAWeighingTransacTareWeight		EWAWeighingTransacTareWeight	Weighing Tare Weight
	EWAWeighTransDisplayTareWgt		EWAWeighTransDisplayTareWgt	Display Weighing Tare Weight
	EWANetWeighingInfoCode		EWANetWeighingInfoCode	Weighing Information Net
	EWANetWeighInfoCodeDesc		EWANetWeighInfoCodeDesc	Description Weighing Information
	EWANetWeight		EWANetWeight	Net Weight
	EWANetDisplayWeight		EWANetDisplayWeight	Display Net Weight
	EWANetWeightDisplayUnit		EWANetWeightDisplayUnit	Net Weight Display Unit
	EWAWeighNetDisplayWgtUnit		EWAWeighNetDisplayWgtUnit	Display Weighing Net Weight Unit
	EWAWeighingTransacNetWeight		EWAWeighingTransacNetWeight	Weighing Net Weight
	EWAWeighTransDisplayNetWgt		EWAWeighTransDisplayNetWgt	Display Weighing Net Weight
	EWAEmptyWeight		EWAEmptyWeight	Weight of empty container
	EWAWeightUnit		EWAWeightUnit	Empty Container Weight Unit
	EWAEmptyDisplayWeight		EWAEmptyDisplayWeight	Display Empty Container Weight
	EWAEmptyWeightDisplayUnit		EWAEmptyWeightDisplayUnit	Empty Container Weight Display Unit
	EWAWasteVolume		EWAWasteVolume	Weighing Volume
	EWAVolumeUnit		EWAVolumeUnit	Weighing Volume Unit
	EWAWasteVolumeDisplayQuantity		EWAWasteVolumeDisplayQuantity	Display Weighing Volume
	EWAWasteVolumeDisplayUnit		EWAWasteVolumeDisplayUnit	Weighing Volume Display Unit
	EWAWasteDisposalFacility		EWAWasteDisposalFacility	Identification of Waste Disposal Facility
	EWAWasteDisposalFacilityDesc		EWAWasteDisposalFacilityDesc	WDO Facility Name
	EWAIsExternalWasteDsplFacility		EWAIsExternalWasteDsplFacility	WDO Facility Type
	EWAWasteDsplFacilityTypeDesc		EWAWasteDsplFacilityTypeDesc	WDO Facility Type Name
	Plant		Plant	Plant
	PlantName	_Plant	PlantName	Plant Name
	StorageLocation		StorageLocation	Storage Location
	EWAStockType		EWAStockType	Stock Type
	EWAWasteDsplOrdItmObjectNumber		EWAWasteDsplOrdItmObjectNumber	Object Number of Order Item
	EWAWeighingTransactionType		EWAWeighingTransactionType	Weighing Transaction Type
	EWAIsGoodsMovementRelevant		EWAIsGoodsMovementRelevant	Indicator for Goods Movement
	EWAIsBillingRelevant		EWAIsBillingRelevant	Indicator: Relevant for Billing
	EWATargetWasteDisposalFacility		EWATargetWasteDisposalFacility	Identification of Target Waste Disposal Facility
	EWATargetPlant		EWATargetPlant	Plant of Target Facility
	EWATargetStorageLocation		EWATargetStorageLocation	Target Storage Location
	EWATargetStorageBin		EWATargetStorageBin	Target Storage Location Bin
	EWATargetStorageType		EWATargetStorageType	Target Storage Location Type
	EWAWasteType		EWAWasteType	Waste: Redeclaration
	EWAContainerLocation		EWAContainerLocation	Functional Location
	EWAContainerCategory		EWAContainerCategory	Container Category
	EWALoadingFromTime		EWALoadingFromTime	Loading From Time
	EWALoadingToTime		EWALoadingToTime	Loading To Time
	EWAUnloadingFromTime		EWAUnloadingFromTime	Unloading From Time
	EWAUnloadingToTime		EWAUnloadingToTime	Unloading To Time
	Batch		Batch	Batch Number
	Warehouse		Warehouse	Warehouse Number / Warehouse Complex
	StorageType		StorageType	Storage Type
	StorageBin		StorageBin	Storage Bin
	EWATrailerLicensePlateNumber		EWATrailerLicensePlateNumber	Lincense Plate Number: Trailer
	AddressID		AddressID	Address Number
	EWABillingType		EWABillingType	Flag For Payment Transaction
	EWAWeighingTransacDeliveryType		EWAWeighingTransacDeliveryType	Weighing Transaction: Internal/External Transaction
	EWAWeighingTransacObjectNumber		EWAWeighingTransacObjectNumber	Weighing Transaction Object Number
	EWADeviceGroup		EWADeviceGroup	Hardware Profile Group
	EWATareDeviceGroup		EWATareDeviceGroup	Hareware Profile Group: Tare
	EWAGrossDeviceGroup		EWAGrossDeviceGroup	Hareware Profile Group: Gross
	EWALeadingWeighingTransaction		EWALeadingWeighingTransaction	Leading Weighing Transaction
	EWAMatlSplittingIsInPercent		EWAMatlSplittingIsInPercent	Material Splitting Percentage
	EWAFcltyReltdWeighingTransac		EWAFcltyReltdWeighingTransac	Fcaility Related Weighing Transaction
	EWASplittingWeighingTransac		EWASplittingWeighingTransac	Weighing Transaction (Splitting)
	EWAMaterialSplittingSequence		EWAMaterialSplittingSequence	Serial Number per Material Split in Weighing Transaction
	EWAMaterialSplittingRatio		EWAMaterialSplittingRatio	Percentage for Material Split in Multi Weighing
	EWAMaterialSplittingType		EWAMaterialSplittingType	Material Splitting Type
	EWAMaterialSplittingTypeDesc		EWAMaterialSplittingTypeDesc	Material Splitting Type Desc
	EWAMatlSplittingVolumeRatio		EWAMatlSplittingVolumeRatio	Percentage for Material Split in Multi Weighing
	EWAIsWeighingTransacCancelled		EWAIsWeighingTransacCancelled	Reverse Indicator for Weighing Data Record
	EWACopiedWeighingTransaction		EWACopiedWeighingTransaction	Copied Weighing Transaction
	EWASplittingMethod		EWASplittingMethod	Splitting Method of the Weighing Transaction
	EWASplittingIsCancelled		EWASplittingIsCancelled	Spiltting Cancellation Flag
	ConsumptionBillingPaymentTerms		ConsumptionBillingPaymentTerms	Consumption Billing Payment Terms
	PaymentTermsValidityMonthDay		PaymentTermsValidityMonthDay	Payment Terms Validity Month Day
	EWAWeighingTransacIsCancelled		EWAWeighingTransacIsCancelled	Reverse Indicator for Weighing Data Record
	EWAWeighingTransacTypeName		EWAWeighingTransacTypeName	Weighing Transaction Type Name
	EWAWeighingTransacStatusDesc		EWAWeighingTransacStatusDesc	Weighing Transaction Status
	EWAWeighingStatusUnchecked		EWAWeighingStatusUnchecked	No. of Unchecked Weighing Transaction
	EWAWeighingStatusBooked		EWAWeighingStatusBooked	No. of Booked Weighing Transaction
	EWAWeighingStatusReversed		EWAWeighingStatusReversed	No. of Cancelled Weighing Transaction
	EWAYardCheckerStatusUnchecked		EWAYardCheckerStatusUnchecked	No. of Yardlist Status - Created
	EWAYardCheckerStatusProcessed		EWAYardCheckerStatusProcessed	No. of Yardlist Status - Completed
	EWAYardCheckerStatusRejected		EWAYardCheckerStatusRejected	No. of Yardlist Status - Cancelled

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_WeighingProcessQuery.
-- 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.
-- SQL view name: CEWAWEIGHPROCQ
-- Parameters: P_EWAWeightUnit : ewa_vdm_dispweightunit, P_EWAVolumeUnit : ewa_vdm_dispvolunit, P_Language : ewa_vdm_language

CREATE VIEW C_EWA_WeighingProcessQuery AS
SELECT
  EWAWeighingTransaction,
  EWAFleetEquipment,
  EWATrailerFleetEquipment,
  EWAWasteTreatment,
  EWAWasteDisposalOrder,
  EWAWeighingNoteSequence,
  EWAWeighingRecordExtNumber,
  EWAWaste,
  EWAWasteText,
  EWALicensePlateNumber,
  EWAShiftDate,
  EWAShiftTime,
  EWAShiftDateWeek,
  EWAShiftDateYearMonth,
  EWAShiftDateYearQuarter,
  EWAShiftDateYear,
  EWAWeighingTransacPostingDate,
  MaterialDocument,
  MaterialDocumentYear,
  SalesDocument,
  SalesContract,
  SalesContractItem,
  EWAWeighingType,
  Customer,
  CustomerFullName,
  EWANmbrOfWeighingTransac,
  EWAGrossWeighingNumber,
  EWAGrossWeighingDate,
  EWAGrossWeighingTime,
  EWAGrossWeighingInfoCode,
  EWAGrossWeighInfoCodeDesc,
  EWAGrossWeight,
  EWAGrossWeightUnit,
  EWAGrossDisplayWeight,
  EWAGrossWeightDisplayUnit,
  EWAWeighGrossDisplayWgtUnit,
  EWAWeighingTransacGrossWeight,
  EWAWeighTransDisplayGrossWgt,
  EWATareWeighingNumber,
  EWATareWeighingDate,
  EWATareWeighingTime,
  EWATareWeighingInfoCode,
  EWATareWeighInfoCodeDesc,
  EWATareWeight,
  EWATareWeightUnit,
  EWATareDisplayWeight,
  EWATareWeightDisplayUnit,
  EWAWeighTareDisplayWgtUnit,
  EWAWeighingTransacTareWeight,
  EWAWeighTransDisplayTareWgt,
  EWANetWeighingInfoCode,
  EWANetWeighInfoCodeDesc,
  EWANetWeight,
  EWANetDisplayWeight,
  EWANetWeightDisplayUnit,
  EWAWeighNetDisplayWgtUnit,
  EWAWeighingTransacNetWeight,
  EWAWeighTransDisplayNetWgt,
  EWAEmptyWeight,
  EWAWeightUnit,
  EWAEmptyDisplayWeight,
  EWAEmptyWeightDisplayUnit,
  EWAWasteVolume,
  EWAVolumeUnit,
  EWAWasteVolumeDisplayQuantity,
  EWAWasteVolumeDisplayUnit,
  EWAWasteDisposalFacility,
  EWAWasteDisposalFacilityDesc,
  EWAIsExternalWasteDsplFacility,
  EWAWasteDsplFacilityTypeDesc,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  EWAStockType,
  EWAWasteDsplOrdItmObjectNumber,
  EWAWeighingTransactionType,
  EWAIsGoodsMovementRelevant,
  EWAIsBillingRelevant,
  EWATargetWasteDisposalFacility,
  EWATargetPlant,
  EWATargetStorageLocation,
  EWATargetStorageBin,
  EWATargetStorageType,
  EWAWasteType,
  EWAContainerLocation,
  EWAContainerCategory,
  EWALoadingFromTime,
  EWALoadingToTime,
  EWAUnloadingFromTime,
  EWAUnloadingToTime,
  Batch,
  Warehouse,
  StorageType,
  StorageBin,
  EWATrailerLicensePlateNumber,
  AddressID,
  EWABillingType,
  EWAWeighingTransacDeliveryType,
  EWAWeighingTransacObjectNumber,
  EWADeviceGroup,
  EWATareDeviceGroup,
  EWAGrossDeviceGroup,
  EWALeadingWeighingTransaction,
  EWAMatlSplittingIsInPercent,
  EWAFcltyReltdWeighingTransac,
  EWASplittingWeighingTransac,
  EWAMaterialSplittingSequence,
  EWAMaterialSplittingRatio,
  EWAMaterialSplittingType,
  EWAMaterialSplittingTypeDesc,
  EWAMatlSplittingVolumeRatio,
  EWAIsWeighingTransacCancelled,
  EWACopiedWeighingTransaction,
  EWASplittingMethod,
  EWASplittingIsCancelled,
  ConsumptionBillingPaymentTerms,
  PaymentTermsValidityMonthDay,
  EWAWeighingTransacIsCancelled,
  EWAWeighingTransacTypeName,
  EWAWeighingTransacStatusDesc,
  EWAWeighingStatusUnchecked,
  EWAWeighingStatusBooked,
  EWAWeighingStatusReversed,
  EWAYardCheckerStatusUnchecked,
  EWAYardCheckerStatusProcessed,
  EWAYardCheckerStatusRejected
FROM I_EWA_WeighingProcessCube
LEFT OUTER JOIN E_EWA_WasteItemWeigh AS _ExtensionWeighProc ON EWAWeighingTransaction = _ExtensionWeighProc.EWAWeighingTransaction  -- association [0..1]
;

Depth:

C_EWA_WeighingProcessQuery view

I_EWA_WeighingProcessCube view_entity