R_EWA_WeighProcessDetailDraft

DDL: R_EWA_WEIGHPROCESSDETAILDRAFT Type: view_entity BASIC
118 Fields 1 Data Sources

Detail Root - Draft

R_EWA_WeighProcessDetailDraft is a Basic CDS View that provides data about "Detail Root - Draft" in SAP S/4HANA. It reads from 1 data source (ewa_weighdet_dt) and exposes 118 fields with key fields EWAWeighingTransaction, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
ewa_weighdet_dt WeighProcDetailD from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Detail Root - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.personalData.blocking #REQUIRED view

Fields (118)

KeyFieldSource TableSource FieldDescription
KEY EWAWeighingTransaction ewa_weighdet_dt ewaweighingtransaction Weighing Trans.
KEY DraftUUID ewa_weighdet_dt draftuuid UUID
ParentDraftUUID ewa_weighdet_dt parentdraftuuid NodeID
EWALeadingWeighingTransaction ewa_weighdet_dt ewaleadingweighingtransaction Leading Weigh.Trans.
EWAFleetEquipment ewa_weighdet_dt ewafleetequipment Equ. Nr. Vehicle
EWATrailerFleetEquipment ewa_weighdet_dt ewatrailerfleetequipment Equ. Nr. Trailer
EWAWasteTreatment ewa_weighdet_dt ewawastetreatment Waste Treatment
EWAWasteDisposalOrder ewa_weighdet_dt ewawastedisposalorder WD Order
EWAWeighingNoteSequence ewa_weighdet_dt ewaweighingnotesequence Cons.No.WghData
EWAWeighingRecordExtNumber ewa_weighdet_dt ewaweighingrecordextnumber Ext. No. WDR
EWAWaste ewa_weighdet_dt ewawaste Waste
EWALicensePlateNumber ewa_weighdet_dt ewalicenseplatenumber License Plate
EWAGrossWeighingNumber ewa_weighdet_dt ewagrossweighingnumber Gross Weigh.No.
EWAGrossWeighingDate ewa_weighdet_dt ewagrossweighingdate Date Gross
EWAGrossWeighingTime ewa_weighdet_dt ewagrossweighingtime Time Gross
EWAGrossWeight ewa_weighdet_dt ewagrossweight Gross Weight
EWATareWeighingNumber ewa_weighdet_dt ewatareweighingnumber Wt No. Empty
EWATareWeighingDate ewa_weighdet_dt ewatareweighingdate Date Tare
EWATareWeighingTime ewa_weighdet_dt ewatareweighingtime Time Tare
EWATareWeight ewa_weighdet_dt ewatareweight Tare Weight
EWAEmptyWeight ewa_weighdet_dt ewaemptyweight Empty-weight
EWAWeightUnit ewa_weighdet_dt ewaweightunit Unit of weight
EWANetWeight ewa_weighdet_dt ewanetweight Net Weight
EWAWasteVolume ewa_weighdet_dt ewawastevolume Waste volume
EWAVolumeUnit ewa_weighdet_dt ewavolumeunit Volume unit
EWAWasteDisposalFacility ewa_weighdet_dt ewawastedisposalfacility WD Facility
Plant ewa_weighdet_dt plant Valuation Area
StorageLocation ewa_weighdet_dt storagelocation StorageLocation
EWAStockType ewa_weighdet_dt ewastocktype Stock Type
EWAWasteDsplOrdItmObjectNumber ewa_weighdet_dt ewawastedsplorditmobjectnumber Object Number
EWAWeighingTransactionType ewa_weighdet_dt ewaweighingtransactiontype Transact. Type
EWAIsGoodsMovementRelevant ewa_weighdet_dt ewaisgoodsmovementrelevant Goods Mvmt Ind.
EWAIsBillingRelevant ewa_weighdet_dt ewaisbillingrelevant Bill. Indicator
EWAWeighingQuantity ewa_weighdet_dt ewaweighingquantity Quantity
EWAWeighingQuantityUnit ewa_weighdet_dt ewaweighingquantityunit Unit
EWATargetWasteDisposalFacility ewa_weighdet_dt ewatargetwastedisposalfacility Target Facility
EWATargetPlant ewa_weighdet_dt ewatargetplant Target Plant
EWATargetStorageLocation ewa_weighdet_dt ewatargetstoragelocation Target Stor Loc
EWATargetStorageBin ewa_weighdet_dt ewatargetstoragebin TargetStor.Loc.
EWATargetStorageType ewa_weighdet_dt ewatargetstoragetype Targ.Stor.Type
EWAWasteType ewa_weighdet_dt ewawastetype Waste: Redeclaration
UtilitiesPremise ewa_weighdet_dt utilitiespremise Premise
EWAContainerLocation ewa_weighdet_dt ewacontainerlocation Functional Location
ConsumptionBillingPaymentTerms ewa_weighdet_dt consumptionbillingpaymentterms Pyt Terms
PaymentTermsValidityMonthDay ewa_weighdet_dt paymenttermsvaliditymonthday Day Limit
Customer ewa_weighdet_dt customer Sold-to Party
EWALoadingFromTime ewa_weighdet_dt ewaloadingfromtime Load. Time From
EWALoadingToTime ewa_weighdet_dt ewaloadingtotime Loading Time To
EWAUnloadingFromTime ewa_weighdet_dt ewaunloadingfromtime Unload.Tme.From
EWAUnloadingToTime ewa_weighdet_dt ewaunloadingtotime Unload.Time To
CapacityInternalID ewa_weighdet_dt capacityinternalid Capacity ID
EWACapacityVersion ewa_weighdet_dt ewacapacityversion Version
EWAEndDate ewa_weighdet_dt ewaenddate End Date
EWACapacityCycleCurrentWeekDay ewa_weighdet_dt ewacapacitycyclecurrentweekday Weekday number
AvailableCapacityShift ewa_weighdet_dt availablecapacityshift Capacity Shift
EWAShiftDate ewa_weighdet_dt ewashiftdate Shift Date
EWAShiftTime ewa_weighdet_dt ewashifttime Time
EWAWeighingTransacPostingDate ewa_weighdet_dt ewaweighingtransacpostingdate Posting Date
EWAVehicleContainerCategory ewa_weighdet_dt ewavehiclecontainercategory Vh. Con. Mat. Nr.
EWATrailerContainerCategory ewa_weighdet_dt ewatrailercontainercategory Tra. Con. Mat. Nr.
MaterialDocument ewa_weighdet_dt materialdocument Material Doc.
MaterialDocumentYear ewa_weighdet_dt materialdocumentyear Material Document Year
SalesDocument ewa_weighdet_dt salesdocument SD Document
EWAWeighingTransacGrossWeight ewa_weighdet_dt ewaweighingtransacgrossweight Gross Weight
EWAGrossWeightUnit ewa_weighdet_dt ewagrossweightunit Unit of weight
EWAWeighingTransacTareWeight ewa_weighdet_dt ewaweighingtransactareweight Tare Weight
EWATareWeightUnit ewa_weighdet_dt ewatareweightunit Unit of weight
EWAWeighingTransacNetWeight ewa_weighdet_dt ewaweighingtransacnetweight Net Weight
SalesContract ewa_weighdet_dt salescontract Sales Document
SalesContractItem ewa_weighdet_dt salescontractitem Item
RELocalSubDistrict ewa_weighdet_dt relocalsubdistrict Loc Subdistrict
REPropertyTractNumberText ewa_weighdet_dt repropertytractnumbertext Tract of Land
REParcelOfLandText ewa_weighdet_dt reparceloflandtext Parcel of Land
EWAWeighingType ewa_weighdet_dt ewaweighingtype Weigh.Data Type
EWAWeighingTransacIsCancelled ewa_weighdet_dt ewaweighingtransaciscancelled Reversal
EWAWasteDsplFcltyTransacCat ewa_weighdet_dt ewawastedsplfcltytransaccat Transact. Cat.
EWAWasteDsplFcltyTransaction ewa_weighdet_dt ewawastedsplfcltytransaction Number
Batch ewa_weighdet_dt batch Lot No.
EWATareIsMaintainedManually ewa_weighdet_dt ewatareismaintainedmanually Maint.Tare Man.
Warehouse ewa_weighdet_dt warehouse Warehouse No.
StorageType ewa_weighdet_dt storagetype Storage Type
StorageBin ewa_weighdet_dt storagebin Storage Bin
EWAWasteDsplFacilityOrderType ewa_weighdet_dt ewawastedsplfacilityordertype OrdTyp.WstDspFa
EWATrailerLicensePlateNumber ewa_weighdet_dt ewatrailerlicenseplatenumber Lic.Pl.Nr.:Trailer
EWASplittingIsCancelled ewa_weighdet_dt ewasplittingiscancelled Split. Canceled
EWAWasteDisposalFacilityDesc ewa_weighdet_dt ewawastedisposalfacilitydesc Description
EWAControllingDocPostingDate ewa_weighdet_dt ewacontrollingdocpostingdate CO Posting Date
EWAWeighingFeeCode ewa_weighdet_dt ewaweighingfeecode Weighing Fee
AddressID ewa_weighdet_dt addressid Ship-to address
EWATareDeviceGroup ewa_weighdet_dt ewataredevicegroup Profile Group: Tare
EWAGrossDeviceGroup ewa_weighdet_dt ewagrossdevicegroup Profile Group:Gross
EWAGrossWeighingInfoCode ewa_weighdet_dt ewagrossweighinginfocode Wgh. Data Gross
EWATareWeighingInfoCode ewa_weighdet_dt ewatareweighinginfocode Wghng Data Tare
EWABillingType ewa_weighdet_dt ewabillingtype Flag Payment Transa.
EWAWeighingTransacDeliveryType ewa_weighdet_dt ewaweighingtransacdeliverytype intern./extern.
EWAWeighingTransacObjectNumber ewa_weighdet_dt ewaweighingtransacobjectnumber Object number
EWAFcltyReltdWeighingTransac ewa_weighdet_dt ewafcltyreltdweighingtransac Fac-Rel.Weigh.Number
EWASplittingWeighingTransac ewa_weighdet_dt ewasplittingweighingtransac Wei.Tran.(Splitting)
EWAMaterialSplittingSequence ewa_weighdet_dt ewamaterialsplittingsequence Serial Split No
EWAMatlSplittingIsInPercent ewa_weighdet_dt ewamatlsplittingisinpercent Percentage Flag
EWAMaterialSplittingRatio ewa_weighdet_dt ewamaterialsplittingratio Percentage
EWAMaterialSplittingType ewa_weighdet_dt ewamaterialsplittingtype MatSplitTyp
EWANetWeighingInfoCode ewa_weighdet_dt ewanetweighinginfocode Weighing Info Net
EWAContainerCategory ewa_weighdet_dt ewacontainercategory Container cat.
EWAWeightIsMinimumNet ewa_weighdet_dt ewaweightisminimumnet MinimunNetWeightFlag
EWADeviceGroup ewa_weighdet_dt ewadevicegroup Hardware Prof. Group
EWAMatlSplittingVolumeRatio ewa_weighdet_dt ewamatlsplittingvolumeratio Percentage
EWAManualTareWeighIsChecked ewa_weighdet_dt ewamanualtareweighischecked
EWACreatedOnDateTime ewa_weighdet_dt ewacreatedondatetime Created On
EWACreatedByName ewa_weighdet_dt ewacreatedbyname Created By
EWALastChangedOnDateTime ewa_weighdet_dt ewalastchangedondatetime Changed On
EWAChangedByName ewa_weighdet_dt ewachangedbyname Changed By
DraftEntityCreationDateTime ewa_weighdet_dt draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime ewa_weighdet_dt draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID ewa_weighdet_dt draftadministrativedatauuid UUID
DraftEntityOperationCode ewa_weighdet_dt draftentityoperationcode Draft - Operation Code
HasActiveEntity ewa_weighdet_dt hasactiveentity TRUE
DraftFieldChanges ewa_weighdet_dt draftfieldchanges Field Changes

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 R_EWA_WeighProcessDetailDraft.
-- 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 R_EWA_WeighProcessDetailDraft AS
SELECT
  WeighProcDetailD.ewaweighingtransaction AS EWAWeighingTransaction,
  WeighProcDetailD.draftuuid AS DraftUUID,
  WeighProcDetailD.parentdraftuuid AS ParentDraftUUID,
  WeighProcDetailD.ewaleadingweighingtransaction AS EWALeadingWeighingTransaction,
  WeighProcDetailD.ewafleetequipment AS EWAFleetEquipment,
  WeighProcDetailD.ewatrailerfleetequipment AS EWATrailerFleetEquipment,
  WeighProcDetailD.ewawastetreatment AS EWAWasteTreatment,
  WeighProcDetailD.ewawastedisposalorder AS EWAWasteDisposalOrder,
  WeighProcDetailD.ewaweighingnotesequence AS EWAWeighingNoteSequence,
  WeighProcDetailD.ewaweighingrecordextnumber AS EWAWeighingRecordExtNumber,
  WeighProcDetailD.ewawaste AS EWAWaste,
  WeighProcDetailD.ewalicenseplatenumber AS EWALicensePlateNumber,
  WeighProcDetailD.ewagrossweighingnumber AS EWAGrossWeighingNumber,
  WeighProcDetailD.ewagrossweighingdate AS EWAGrossWeighingDate,
  WeighProcDetailD.ewagrossweighingtime AS EWAGrossWeighingTime,
  WeighProcDetailD.ewagrossweight AS EWAGrossWeight,
  WeighProcDetailD.ewatareweighingnumber AS EWATareWeighingNumber,
  WeighProcDetailD.ewatareweighingdate AS EWATareWeighingDate,
  WeighProcDetailD.ewatareweighingtime AS EWATareWeighingTime,
  WeighProcDetailD.ewatareweight AS EWATareWeight,
  WeighProcDetailD.ewaemptyweight AS EWAEmptyWeight,
  WeighProcDetailD.ewaweightunit AS EWAWeightUnit,
  WeighProcDetailD.ewanetweight AS EWANetWeight,
  WeighProcDetailD.ewawastevolume AS EWAWasteVolume,
  WeighProcDetailD.ewavolumeunit AS EWAVolumeUnit,
  WeighProcDetailD.ewawastedisposalfacility AS EWAWasteDisposalFacility,
  WeighProcDetailD.plant AS Plant,
  WeighProcDetailD.storagelocation AS StorageLocation,
  WeighProcDetailD.ewastocktype AS EWAStockType,
  WeighProcDetailD.ewawastedsplorditmobjectnumber AS EWAWasteDsplOrdItmObjectNumber,
  WeighProcDetailD.ewaweighingtransactiontype AS EWAWeighingTransactionType,
  WeighProcDetailD.ewaisgoodsmovementrelevant AS EWAIsGoodsMovementRelevant,
  WeighProcDetailD.ewaisbillingrelevant AS EWAIsBillingRelevant,
  WeighProcDetailD.ewaweighingquantity AS EWAWeighingQuantity,
  WeighProcDetailD.ewaweighingquantityunit AS EWAWeighingQuantityUnit,
  WeighProcDetailD.ewatargetwastedisposalfacility AS EWATargetWasteDisposalFacility,
  WeighProcDetailD.ewatargetplant AS EWATargetPlant,
  WeighProcDetailD.ewatargetstoragelocation AS EWATargetStorageLocation,
  WeighProcDetailD.ewatargetstoragebin AS EWATargetStorageBin,
  WeighProcDetailD.ewatargetstoragetype AS EWATargetStorageType,
  WeighProcDetailD.ewawastetype AS EWAWasteType,
  WeighProcDetailD.utilitiespremise AS UtilitiesPremise,
  WeighProcDetailD.ewacontainerlocation AS EWAContainerLocation,
  WeighProcDetailD.consumptionbillingpaymentterms AS ConsumptionBillingPaymentTerms,
  WeighProcDetailD.paymenttermsvaliditymonthday AS PaymentTermsValidityMonthDay,
  WeighProcDetailD.customer AS Customer,
  WeighProcDetailD.ewaloadingfromtime AS EWALoadingFromTime,
  WeighProcDetailD.ewaloadingtotime AS EWALoadingToTime,
  WeighProcDetailD.ewaunloadingfromtime AS EWAUnloadingFromTime,
  WeighProcDetailD.ewaunloadingtotime AS EWAUnloadingToTime,
  WeighProcDetailD.capacityinternalid AS CapacityInternalID,
  WeighProcDetailD.ewacapacityversion AS EWACapacityVersion,
  WeighProcDetailD.ewaenddate AS EWAEndDate,
  WeighProcDetailD.ewacapacitycyclecurrentweekday AS EWACapacityCycleCurrentWeekDay,
  WeighProcDetailD.availablecapacityshift AS AvailableCapacityShift,
  WeighProcDetailD.ewashiftdate AS EWAShiftDate,
  WeighProcDetailD.ewashifttime AS EWAShiftTime,
  WeighProcDetailD.ewaweighingtransacpostingdate AS EWAWeighingTransacPostingDate,
  WeighProcDetailD.ewavehiclecontainercategory AS EWAVehicleContainerCategory,
  WeighProcDetailD.ewatrailercontainercategory AS EWATrailerContainerCategory,
  WeighProcDetailD.materialdocument AS MaterialDocument,
  WeighProcDetailD.materialdocumentyear AS MaterialDocumentYear,
  WeighProcDetailD.salesdocument AS SalesDocument,
  WeighProcDetailD.ewaweighingtransacgrossweight AS EWAWeighingTransacGrossWeight,
  WeighProcDetailD.ewagrossweightunit AS EWAGrossWeightUnit,
  WeighProcDetailD.ewaweighingtransactareweight AS EWAWeighingTransacTareWeight,
  WeighProcDetailD.ewatareweightunit AS EWATareWeightUnit,
  WeighProcDetailD.ewaweighingtransacnetweight AS EWAWeighingTransacNetWeight,
  WeighProcDetailD.salescontract AS SalesContract,
  WeighProcDetailD.salescontractitem AS SalesContractItem,
  WeighProcDetailD.relocalsubdistrict AS RELocalSubDistrict,
  WeighProcDetailD.repropertytractnumbertext AS REPropertyTractNumberText,
  WeighProcDetailD.reparceloflandtext AS REParcelOfLandText,
  WeighProcDetailD.ewaweighingtype AS EWAWeighingType,
  WeighProcDetailD.ewaweighingtransaciscancelled AS EWAWeighingTransacIsCancelled,
  WeighProcDetailD.ewawastedsplfcltytransaccat AS EWAWasteDsplFcltyTransacCat,
  WeighProcDetailD.ewawastedsplfcltytransaction AS EWAWasteDsplFcltyTransaction,
  WeighProcDetailD.batch AS Batch,
  WeighProcDetailD.ewatareismaintainedmanually AS EWATareIsMaintainedManually,
  WeighProcDetailD.warehouse AS Warehouse,
  WeighProcDetailD.storagetype AS StorageType,
  WeighProcDetailD.storagebin AS StorageBin,
  WeighProcDetailD.ewawastedsplfacilityordertype AS EWAWasteDsplFacilityOrderType,
  WeighProcDetailD.ewatrailerlicenseplatenumber AS EWATrailerLicensePlateNumber,
  WeighProcDetailD.ewasplittingiscancelled AS EWASplittingIsCancelled,
  WeighProcDetailD.ewawastedisposalfacilitydesc AS EWAWasteDisposalFacilityDesc,
  WeighProcDetailD.ewacontrollingdocpostingdate AS EWAControllingDocPostingDate,
  WeighProcDetailD.ewaweighingfeecode AS EWAWeighingFeeCode,
  WeighProcDetailD.addressid AS AddressID,
  WeighProcDetailD.ewataredevicegroup AS EWATareDeviceGroup,
  WeighProcDetailD.ewagrossdevicegroup AS EWAGrossDeviceGroup,
  WeighProcDetailD.ewagrossweighinginfocode AS EWAGrossWeighingInfoCode,
  WeighProcDetailD.ewatareweighinginfocode AS EWATareWeighingInfoCode,
  WeighProcDetailD.ewabillingtype AS EWABillingType,
  WeighProcDetailD.ewaweighingtransacdeliverytype AS EWAWeighingTransacDeliveryType,
  WeighProcDetailD.ewaweighingtransacobjectnumber AS EWAWeighingTransacObjectNumber,
  WeighProcDetailD.ewafcltyreltdweighingtransac AS EWAFcltyReltdWeighingTransac,
  WeighProcDetailD.ewasplittingweighingtransac AS EWASplittingWeighingTransac,
  WeighProcDetailD.ewamaterialsplittingsequence AS EWAMaterialSplittingSequence,
  WeighProcDetailD.ewamatlsplittingisinpercent AS EWAMatlSplittingIsInPercent,
  WeighProcDetailD.ewamaterialsplittingratio AS EWAMaterialSplittingRatio,
  WeighProcDetailD.ewamaterialsplittingtype AS EWAMaterialSplittingType,
  WeighProcDetailD.ewanetweighinginfocode AS EWANetWeighingInfoCode,
  WeighProcDetailD.ewacontainercategory AS EWAContainerCategory,
  WeighProcDetailD.ewaweightisminimumnet AS EWAWeightIsMinimumNet,
  WeighProcDetailD.ewadevicegroup AS EWADeviceGroup,
  WeighProcDetailD.ewamatlsplittingvolumeratio AS EWAMatlSplittingVolumeRatio,
  WeighProcDetailD.ewamanualtareweighischecked AS EWAManualTareWeighIsChecked,
  WeighProcDetailD.ewacreatedondatetime AS EWACreatedOnDateTime,
  WeighProcDetailD.ewacreatedbyname AS EWACreatedByName,
  WeighProcDetailD.ewalastchangedondatetime AS EWALastChangedOnDateTime,
  WeighProcDetailD.ewachangedbyname AS EWAChangedByName,
  WeighProcDetailD.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  WeighProcDetailD.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  WeighProcDetailD.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  WeighProcDetailD.draftentityoperationcode AS DraftEntityOperationCode,
  WeighProcDetailD.hasactiveentity AS HasActiveEntity,
  WeighProcDetailD.draftfieldchanges AS DraftFieldChanges
FROM ewa_weighdet_dt AS WeighProcDetailD
;

Learn More