I_EWA_BulkRefuseOrdC

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 I_EWA_BulkRefuseOrdC.
-- 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: IEWABULKREFORDC
-- Parameters: P_DisplayVolumeUnit : ewa_vdm_dispvolunit, P_DisplayCurrency : vdm_v_display_currency, P_Language : ewa_vdm_language

CREATE VIEW I_EWA_BulkRefuseOrdC AS
SELECT
  EWA_BULKREF.EWAWasteDisposalOrder AS EWAWasteDisposalOrder,
  EWA_BULKREF.EWAWasteDisposalOrderItem AS EWAWasteDisposalOrderItem,
  EWA_BULKREF.EWAWasteDsplOrdItmObjectNumber AS EWAWasteDsplOrdItmObjectNumber,
  EWA_BULKREF.SalesDocument AS SalesDocument,
  EWA_BULKREF.SalesDocumentItem AS SalesDocumentItem,
  EWA_WDO.EWAWasteDsplOrderObjectNumber AS EWAWasteDsplOrderObjectNumber,
  EWA_BULKREF.EWABulkySoldToParty AS EWABulkySoldToParty,
  EWA_BULKREF.EWAWaste AS EWAWaste,
  EWA_BULKREF.EWAAltInvoiceRecipient AS EWAAltInvoiceRecipient,
  EWA_BULKREF.EWAWasteGeneratorPartner AS EWAWasteGeneratorPartner,
  EWA_BULKREF.EWAWasteRemovalAddress AS EWAWasteRemovalAddress,
  EWA_BULKREF.EWAMaterialStandardPrice AS EWAMaterialStandardPrice,
  EWA_BULKREF.EWAMaterialPrice AS EWAMaterialPrice,
  EWA_BULKREF.EWAConditionAmount AS EWAConditionAmount,
  $parameters.P_DisplayCurrency AS EWADisplayCurrency,
  EWA_BULKREF.EWABulkVolume AS EWABulkVolume,
  EWA_BULKREF.EWAVolumeUnit AS EWAVolumeUnit,
  EWA_BULKREF.EWABulkHasExcessVolume AS EWABulkHasExcessVolume,
  EWA_BULKREF.EWAWasteManagementNote AS EWAWasteManagementNote,
  EWA_BULKREF.EWAWasteManagementNote01 AS EWAWasteManagementNote01,
  EWA_BULKREF.EWAWasteManagementNote02 AS EWAWasteManagementNote02,
  EWA_BULKREF.EWAWasteManagementNote03 AS EWAWasteManagementNote03,
  EWA_BULKREF.EWAWasteManagementNote04 AS EWAWasteManagementNote04,
  EWA_BULKREF.EWAFourthConditionType AS EWAFourthConditionType,
  EWA_BULKREF.EWAFourthConditionAmount AS EWAFourthConditionAmount,
  EWA_BULKREF.EWAWasteManagementNote05 AS EWAWasteManagementNote05,
  EWA_BULKREF.EWAFifthConditionType AS EWAFifthConditionType,
  EWA_BULKREF.EWAFifthConditionAmount AS EWAFifthConditionAmount,
  EWA_BULKREF.EWAWasteManagementNote06 AS EWAWasteManagementNote06,
  EWA_BULKREF.EWASixthConditionType AS EWASixthConditionType,
  EWA_BULKREF.EWASixthConditionAmount AS EWASixthConditionAmount,
  EWA_BULKREF.EWAWasteManagementNote07 AS EWAWasteManagementNote07,
  EWA_BULKREF.EWASeventhConditionType AS EWASeventhConditionType,
  EWA_BULKREF.EWASeventhConditionAmount AS EWASeventhConditionAmount,
  EWA_BULKREF.EWAWasteManagementNote08 AS EWAWasteManagementNote08,
  EWA_BULKREF.EWAEighthConditionType AS EWAEighthConditionType,
  EWA_BULKREF.EWAEighthConditionAmount AS EWAEighthConditionAmount,
  EWA_BULKREF.EWAWasteManagementNote09 AS EWAWasteManagementNote09,
  EWA_BULKREF.EWANinthConditionType AS EWANinthConditionType,
  EWA_BULKREF.EWANinthConditionAmount AS EWANinthConditionAmount,
  EWA_BULKREF.EWAIsCashPaymentRequired AS EWAIsCashPaymentRequired,
  EWA_BULKREF.EWAAdvancePayIsRequired AS EWAAdvancePayIsRequired,
  EWA_BULKREF.EWAPaymentIsLater AS EWAPaymentIsLater,
  EWA_BULKREF.EWANoticeOfCharge AS EWANoticeOfCharge,
  EWA_BULKREF.EWAIsFreeOfCharge AS EWAIsFreeOfCharge,
  EWA_BULKREF.EWAExpressSurcharge AS EWAExpressSurcharge,
  EWA_BULKREF.EWAServiceWindow AS EWAServiceWindow,
  EWA_BULKREF.EWAServiceWindowStartTime AS EWAServiceWindowStartTime,
  EWA_BULKREF.EWAServiceWindowEndTime AS EWAServiceWindowEndTime,
  EWA_BULKREF.EWAServiceArea AS EWAServiceArea,
  EWA_BULKREF.EWABulkRefuseOrderType AS EWABulkRefuseOrderType,
  EWA_BULKREF.Currency AS Currency,
  EWA_BULKREF.NetAmount AS NetAmount,
  EWA_BULKREF.OpenTotalTaxAmount AS TaxAmount,
  EWA_BULKREF.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  _HeadStatus.UtilitiesSystemStatus AS EWAWasteDsplOrderHeadStatus,
  _HeadStatus._SystemStatus._SystemStatusText[1: Language=$parameters.P_Language].SystemStatusName AS EWAWasteDsplOrderStatusText,
  _ItemStatus.UtilitiesSystemStatus AS EWAWasteDsplOrderItemStatus,
  _ItemStatus._SystemStatus._SystemStatusText[1: Language=$parameters.P_Language].SystemStatusName AS EWAWasteDsplOrdItemStatusText,
  $parameters.P_DisplayVolumeUnit AS EWABulkVolDisplayUnit
FROM I_EWA_BulkRefuseOrder AS EWA_BULKREF
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Product AS _BulkMaterial ON EWAWaste = _BulkMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_EWA_WasteObjectCurrentStatus AS _HeadStatus ON EWA_WDO.EWAWasteDsplOrderObjectNumber = _HeadStatus.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_EWA_WasteObjectCurrentStatus AS _ItemStatus ON EWA_BULKREF.EWAWasteDsplOrdItmObjectNumber = _ItemStatus.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON EWABulkySoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
;