I_EWA_WASTEORDERWEIGHINGNOTE

CDS View

Waste disposal order weighing notes

I_EWA_WASTEORDERWEIGHINGNOTE is a CDS View in S/4HANA. Waste disposal order weighing notes. It contains 69 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_EWA_WasteDsplOrdWeighDEX view_entity from CONSUMPTION Data Ext for Waste Dspl Order Weighing
I_EWA_IntAndExtWeighingRecords view_entity union_all COMPOSITE Internal and External Weighing Records
I_EWA_OrderWeighingStatus view_entity from COMPOSITE Waste Order Weighing Status
I_EWA_WasteOrderWeighCube view_entity from COMPOSITE Waste Order Weigh - Cube
I_EWA_WeighRecord view_entity union_all COMPOSITE Weighing Records
R_EWAOrderWeighTP view_entity from TRANSACTIONAL Order Weighing - TP

Fields (69)

KeyField CDS FieldsUsed in Views
KEY EWAWasteDisposalOrder EWAWasteDisposalOrder 4
KEY EWAWeighingNoteSequence EWAWeighingNoteSequence 4
KEY EWAWeighingTransaction EWAWeighingTransaction 3
_EWAAltPurchaseContract _EWAAltPurchaseContract 2
_EWAAltPurchaseContractItem _EWAAltPurchaseContractItem 2
_EWAPurchaseContract _EWAPurchaseContract 2
_EWAPurchaseContractItem _EWAPurchaseContractItem 2
_EWAPurchaseOrderUnit _EWAPurchaseOrderUnit 2
_EWASubcontrgPurchaseOrder _EWASubcontrgPurchaseOrder 2
_EWASubcontrgPurchaseOrderItem _EWASubcontrgPurchaseOrderItem 2
_EWAVolumeUnit _EWAVolumeUnit 2
_EWAWaste _EWAWaste 2
_EWAWasteDisposalFacility _EWAWasteDisposalFacility 2
_EWAWasteDisposalOrder _EWAWasteDisposalOrder 1
_EWAWeightUnit _EWAWeightUnit 2
_Plant _Plant 2
_StorageLocation _StorageLocation 2
EWAAltPurchaseContract EWAAltPurchaseContract 2
EWAAltPurchaseContractItem EWAAltPurchaseContractItem 2
EWAControllingDocPostingDate EWAControllingDocPostingDate 3
EWAEmptyWeight EWAEmptyWeight 3
EWAGrossOrderWeight EWAGrossOrderWeight 2
EWAGrossWeighingDate EWAGrossWeighingDate 3
EWAGrossWeighingNumber EWAGrossWeighingNumber 3
EWAGrossWeighingTime EWAGrossWeighingTime 3
EWAGrossWeight EWAGrossWeight,EWAWeighingTransacGrossWeight 3
EWAIsBillingRelevant EWAIsBillingRelevant 3
EWAIsGoodsMovementRelevant EWAIsGoodsMovementRelevant 3
EWAIsWeighingNoteCancelled EWAIsWeighingNoteCancelled,EWAWeighingTransacIsCancelled 3
EWALicensePlateNumber EWALicensePlateNumber 3
EWAMaterialSplitType EWAMaterialSplittingType,EWAMaterialSplitType 3
EWANetWeight EWANetWeight,EWAWeighingTransacNetWeight 3
EWAPurchaseContract EWAPurchaseContract 2
EWAPurchaseContractItem EWAPurchaseContractItem 2
EWAPurchaseOrderQuantity EWAPurchaseOrderQuantity 2
EWAPurchaseOrderUnit EWAPurchaseOrderUnit 2
EWAStockType EWAStockType 3
EWASubcontrgMaterialDocument EWASubcontrgMaterialDocument 2
EWASubcontrgMaterialDocYear EWASubcontrgMaterialDocYear 2
EWASubcontrgPurchaseOrder EWASubcontrgPurchaseOrder 2
EWASubcontrgPurchaseOrderItem EWASubcontrgPurchaseOrderItem 2
EWASubcontrgSalesOrder EWASubcontrgSalesOrder 2
EWASubcontrgSalesOrderItem EWASubcontrgSalesOrderItem 2
EWATareWeighingDate EWATareWeighingDate 3
EWATareWeighingNumber EWATareWeighingNumber 3
EWATareWeighingTime EWATareWeighingTime 3
EWATareWeight EWATareWeight,EWAWeighingTransacTareWeight 3
EWATargetPlant EWATargetPlant 3
EWATargetStorageBin EWATargetStorageBin 3
EWATargetStorageLocation EWATargetStorageLocation 3
EWATargetStorageType EWATargetStorageType 3
EWATargetWasteDisposalFacility EWATargetWasteDisposalFacility 3
EWAVolumeUnit EWAVolumeUnit 3
EWAWaste EWAWaste 3
EWAWasteDisposalFacility EWAWasteDisposalFacility 3
EWAWasteDsplOrdItmObjectNumber EWAWasteDsplOrdItmObjectNumber 3
EWAWasteVolume EWAWasteVolume 3
EWAWeighingQuantity EWAWeighingQuantity 3
EWAWeighingQuantityUnit EWAWeighingQuantityUnit 3
EWAWeighingRecordExtNumber EWAWeighingRecordExtNumber 3
EWAWeighingTransactionType EWAWeighingTransactionType 3
EWAWeightUnit EWAGrossWeightUnit,EWATareWeightUnit,EWAWeightUnit 3
MaterialDocument MaterialDocument 3
MaterialDocumentYear MaterialDocumentYear 3
Plant Plant 3
PostingDate EWAWeighingTransacPostingDate,PostingDate 3
StorageBin StorageBin 3
StorageLocation StorageLocation 3
StorageType StorageType 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Waste disposal order weighing notes
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWA_WASTEORDERWEIGHINGNOTE (
    EWAWASTEDISPOSALORDER,
    EWAWEIGHINGNOTESEQUENCE,
    EWAWEIGHINGTRANSACTION,
    _EWAALTPURCHASECONTRACT,
    _EWAALTPURCHASECONTRACTITEM,
    _EWAPURCHASECONTRACT,
    _EWAPURCHASECONTRACTITEM,
    _EWAPURCHASEORDERUNIT,
    _EWASUBCONTRGPURCHASEORDER,
    _EWASUBCONTRGPURCHASEORDERITEM,
    _EWAVOLUMEUNIT,
    _EWAWASTE,
    _EWAWASTEDISPOSALFACILITY,
    _EWAWASTEDISPOSALORDER,
    _EWAWEIGHTUNIT,
    _PLANT,
    _STORAGELOCATION,
    EWAALTPURCHASECONTRACT,
    EWAALTPURCHASECONTRACTITEM,
    EWACONTROLLINGDOCPOSTINGDATE,
    EWAEMPTYWEIGHT,
    EWAGROSSORDERWEIGHT,
    EWAGROSSWEIGHINGDATE,
    EWAGROSSWEIGHINGNUMBER,
    EWAGROSSWEIGHINGTIME,
    EWAGROSSWEIGHT,
    EWAISBILLINGRELEVANT,
    EWAISGOODSMOVEMENTRELEVANT,
    EWAISWEIGHINGNOTECANCELLED,
    EWALICENSEPLATENUMBER,
    EWAMATERIALSPLITTYPE,
    EWANETWEIGHT,
    EWAPURCHASECONTRACT,
    EWAPURCHASECONTRACTITEM,
    EWAPURCHASEORDERQUANTITY,
    EWAPURCHASEORDERUNIT,
    EWASTOCKTYPE,
    EWASUBCONTRGMATERIALDOCUMENT,
    EWASUBCONTRGMATERIALDOCYEAR,
    EWASUBCONTRGPURCHASEORDER,
    EWASUBCONTRGPURCHASEORDERITEM,
    EWASUBCONTRGSALESORDER,
    EWASUBCONTRGSALESORDERITEM,
    EWATAREWEIGHINGDATE,
    EWATAREWEIGHINGNUMBER,
    EWATAREWEIGHINGTIME,
    EWATAREWEIGHT,
    EWATARGETPLANT,
    EWATARGETSTORAGEBIN,
    EWATARGETSTORAGELOCATION,
    EWATARGETSTORAGETYPE,
    EWATARGETWASTEDISPOSALFACILITY,
    EWAVOLUMEUNIT,
    EWAWASTE,
    EWAWASTEDISPOSALFACILITY,
    EWAWASTEDSPLORDITMOBJECTNUMBER,
    EWAWASTEVOLUME,
    EWAWEIGHINGQUANTITY,
    EWAWEIGHINGQUANTITYUNIT,
    EWAWEIGHINGRECORDEXTNUMBER,
    EWAWEIGHINGTRANSACTIONTYPE,
    EWAWEIGHTUNIT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTYEAR,
    PLANT,
    POSTINGDATE,
    STORAGEBIN,
    STORAGELOCATION,
    STORAGETYPE,
    PRIMARY KEY (EWAWASTEDISPOSALORDER, EWAWEIGHINGNOTESEQUENCE, EWAWEIGHINGTRANSACTION)
);