A_EWAWeighTP

DDL: A_EWAWEIGHTP Type: view_entity CONSUMPTION
105 Fields 1 Data Sources 1 Associations

Multi Weighing

A_EWAWeighTP is a Consumption CDS View that provides data about "Multi Weighing" in SAP S/4HANA. It reads from 1 data source (R_EWAWeighTP) and exposes 105 fields with key field EWAWeighingTransaction. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_EWAWeighTP R_EWAWeighTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_EWA_WasteItemWeigh _ExtensionWeighProc $projection.EWAWeighingTransaction = _ExtensionWeighProc.EWAWeighingTransaction

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Multi Weighing view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name EWA_WasteItemWeigh view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.personalData.blocking #REQUIRED view

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY EWAWeighingTransaction EWAWeighingTransaction Weighing Trans.
EWAFleetEquipment EWAFleetEquipment Equ. Nr. Vehicle
EWATrailerFleetEquipment EWATrailerFleetEquipment Equ. Nr. Trailer
EWAWasteTreatment EWAWasteTreatment Waste Treatment
EWAWasteDisposalOrder EWAWasteDisposalOrder WD Order
EWAWeighingNoteSequence EWAWeighingNoteSequence Cons.No.WghData
EWAWeighingRecordExtNumber EWAWeighingRecordExtNumber Ext. No. WDR
EWAWaste EWAWaste Waste
EWALicensePlateNumber EWALicensePlateNumber License Plate
EWAGrossWeighingNumber EWAGrossWeighingNumber Gross Weigh.No.
EWAGrossWeighingDate EWAGrossWeighingDate Date Gross
EWAGrossWeighingTime EWAGrossWeighingTime Time Gross
EWAGrossWeight EWAGrossWeight Gross Weight
EWAGrossWeightUnit EWAGrossWeightUnit Unit of weight
EWAWeighingTransacGrossWeight EWAWeighingTransacGrossWeight Gross Weight
EWAWeighingTransacTareWeight EWAWeighingTransacTareWeight Tare Weight
EWAWeighingTransacNetWeight EWAWeighingTransacNetWeight Net Weight
EWATareWeighingNumber EWATareWeighingNumber Wt No. Empty
EWATareWeighingDate EWATareWeighingDate Date Tare
EWATareWeighingTime EWATareWeighingTime Time Tare
EWATareWeight EWATareWeight Tare Weight
EWATareWeightUnit EWATareWeightUnit Unit of weight
EWAWeightUnit EWAWeightUnit Unit of weight
EWANetWeight EWANetWeight Net Weight
EWAWasteVolume EWAWasteVolume Waste volume
EWAVolumeUnit EWAVolumeUnit Volume unit
EWAWasteDisposalFacility EWAWasteDisposalFacility WD Facility
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
EWAStockType EWAStockType Stock Type
EWAWasteDsplOrdItmObjectNumber EWAWasteDsplOrdItmObjectNumber Object Number
EWAWeighingTransactionType EWAWeighingTransactionType Transact. Type
EWAIsGoodsMovementRelevant EWAIsGoodsMovementRelevant Goods Mvmt Ind.
EWAIsBillingRelevant EWAIsBillingRelevant Bill. Indicator
EWAWeighingQuantity EWAWeighingQuantity Quantity
EWAWeighingQuantityUnit EWAWeighingQuantityUnit Unit
EWATargetWasteDisposalFacility EWATargetWasteDisposalFacility Target Facility
EWATargetPlant EWATargetPlant Target Plant
EWATargetStorageLocation EWATargetStorageLocation Target Stor Loc
EWATargetStorageBin EWATargetStorageBin TargetStor.Loc.
EWATargetStorageType EWATargetStorageType Targ.Stor.Type
EWAWasteType EWAWasteType Waste: Redeclaration
UtilitiesPremise UtilitiesPremise Premise
EWAContainerLocation EWAContainerLocation Functional Location
ConsumptionBillingPaymentTerms ConsumptionBillingPaymentTerms Pyt Terms
PaymentTermsValidityMonthDay PaymentTermsValidityMonthDay Day Limit
Customer Customer Sold-to Party
EWALoadingFromTime EWALoadingFromTime Load. Time From
EWALoadingToTime EWALoadingToTime Loading Time To
EWAUnloadingFromTime EWAUnloadingFromTime Unload.Tme.From
EWAUnloadingToTime EWAUnloadingToTime Unload.Time To
CapacityInternalID CapacityInternalID Capacity ID
EWACapacityVersion EWACapacityVersion Version
EWAEndDate EWAEndDate End Date
EWACapacityCycleCurrentWeekDay EWACapacityCycleCurrentWeekDay Weekday number
AvailableCapacityShift AvailableCapacityShift Capacity Shift
EWAShiftDate EWAShiftDate Shift Date
EWAShiftTime EWAShiftTime Time
EWAWeighingTransacPostingDate EWAWeighingTransacPostingDate Posting Date
EWAVehicleContainerCategory EWAVehicleContainerCategory Vh. Con. Mat. Nr.
EWATrailerContainerCategory EWATrailerContainerCategory Tra. Con. Mat. Nr.
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentYear MaterialDocumentYear Material Document Year
SalesDocument SalesDocument SD Document
SalesContract SalesContract Sales Document
SalesContractItem SalesContractItem Item
RELocalSubDistrict RELocalSubDistrict Loc Subdistrict
REPropertyTractNumberText REPropertyTractNumberText Tract of Land
REParcelOfLandText REParcelOfLandText Parcel of Land
EWAWeighingType EWAWeighingType Weigh.Data Type
EWAWeighingTransacIsCancelled EWAWeighingTransacIsCancelled Reversal
EWAWasteDsplFcltyTransacCat EWAWasteDsplFcltyTransacCat Transact. Cat.
EWAWasteDsplFcltyTransaction EWAWasteDsplFcltyTransaction Number
Batch Batch Lot No.
EWATareIsMaintainedManually EWATareIsMaintainedManually Maint.Tare Man.
Warehouse Warehouse Warehouse No.
StorageType StorageType Storage Type
StorageBin StorageBin Storage Bin
EWAWasteDsplFacilityOrderType EWAWasteDsplFacilityOrderType OrdTyp.WstDspFa
EWATrailerLicensePlateNumber EWATrailerLicensePlateNumber Lic.Pl.Nr.:Trailer
EWASplittingIsCancelled EWASplittingIsCancelled Split. Canceled
EWAWasteDisposalFacilityDesc EWAWasteDisposalFacilityDesc Description
EWAControllingDocPostingDate EWAControllingDocPostingDate CO Posting Date
EWAWeighingFeeCode EWAWeighingFeeCode Weighing Fee
AddressID AddressID Ship-to address
EWATareDeviceGroup EWATareDeviceGroup Profile Group: Tare
EWAGrossDeviceGroup EWAGrossDeviceGroup Profile Group:Gross
EWAGrossWeighingInfoCode EWAGrossWeighingInfoCode Wgh. Data Gross
EWATareWeighingInfoCode EWATareWeighingInfoCode Wghng Data Tare
EWABillingType EWABillingType Flag Payment Transa.
EWAWeighingTransacDeliveryType EWAWeighingTransacDeliveryType intern./extern.
EWAWeighingTransacObjectNumber EWAWeighingTransacObjectNumber Object number
EWALeadingWeighingTransaction EWALeadingWeighingTransaction Leading Weigh.Trans.
EWAFcltyReltdWeighingTransac EWAFcltyReltdWeighingTransac Fac-Rel.Weigh.Number
EWASplittingWeighingTransac EWASplittingWeighingTransac Wei.Tran.(Splitting)
EWAMaterialSplittingSequence EWAMaterialSplittingSequence Serial Split No
EWAMatlSplittingIsInPercent EWAMatlSplittingIsInPercent Percentage Flag
EWAMaterialSplittingRatio EWAMaterialSplittingRatio Percentage
EWAMaterialSplittingType EWAMaterialSplittingType MatSplitTyp
EWANetWeighingInfoCode EWANetWeighingInfoCode Weighing Info Net
EWAContainerCategory EWAContainerCategory Container cat.
EWAWeightIsMinimumNet EWAWeightIsMinimumNet MinimunNetWeightFlag
EWADeviceGroup EWADeviceGroup Hardware Prof. Group
EWAMatlSplittingVolumeRatio EWAMatlSplittingVolumeRatio Percentage
EWAManualTareWeighIsChecked EWAManualTareWeighIsChecked

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

Learn More