R_EWA_WeighProcessMasterDraft

DDL: R_EWA_WEIGHPROCESSMASTERDRAFT Type: view_entity BASIC
117 Fields 1 Data Sources

Master Root - Draft

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

Data Sources (1)

SourceAliasJoin Type
ewa_weighproc_dt WeighProcMasterD from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Master 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 (117)

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

Learn More