I_EWA_ContainerAllocationC

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_ContainerAllocationC.
-- 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 I_EWA_ContainerAllocationC AS
SELECT
  Equipment.Equipment AS Equipment,
  Container.EWAServiceNumber AS EWAServiceNumber,
  EWAService.EWAServiceNumberItem AS EWAServiceNumberItem,
  Assignment.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  Container.EWAContainerLocation AS EWAContainerLocation,
  Container.Material AS Material,
  Container.EWAContainer AS EWAContainer,
  Container.EWAServiceArea AS EWAServiceArea,
  Container.EWAWaste AS EWAWaste,
  Container.EWAContainerCategory AS EWAContainerCategory,
  Container.MaintenanceObjectList AS MaintenanceObjectList,
  Container.MaintenanceObjectListItem AS MaintenanceObjectListItem,
  Container.UtilitiesInstallation AS UtilitiesInstallation,
  Container.UtilsBillingOperand AS UtilsBillingOperand,
  Container.EWABillingOperandSequence AS EWABillingOperandSequence,
  Container.AddressID AS AddressID,
  Container.EWARouteNumber AS EWARouteNumber,
  Container.UtilitiesLogicalDeviceNumber AS UtilitiesLogicalDeviceNumber,
  Container.EWAContainerGroup AS EWAContainerGroup,
  Container.EWABillingFactor AS EWABillingFactor,
  Container.EWACleaningObject AS EWACleaningObject,
  Container.EWAWinterMaintenanceLevel AS EWAWinterMaintenanceLevel,
  Container.EWAPoliticalStrucElem AS EWAPoliticalStrucElem,
  Container.Country AS Country,
  Container.EWAWasteDisposalFacility AS EWAWasteDisposalFacility,
  Container.Plant AS Plant,
  Container.EWATargetStorageLocation AS EWATargetStorageLocation,
  Container.EWAInstalledBase AS EWAInstalledBase,
  Container.StorageLocation AS StorageLocation,
  Container.EWAAuthorizationGroup AS EWAAuthorizationGroup,
  Container.EWAIsMarkedForDeletion AS EWAIsMarkedForDeletion,
  Equipment.ValidityStartDate AS ValidityStartDate,
  Equipment.ValidityEndDate AS ValidityEndDate,
  cast(_CAL.CalendarYear as creation_date_year) AS EWAServiceValidFromYear,
  cast(_CAL.YearQuarter as creation_date_year_quarter) AS EWAServiceValidFromYearQuarter,
  cast(_CAL.YearMonth as creation_date_year_month) AS EWAServiceValidFromYearMonth,
  cast(_CAL.CalendarWeek as creation_date_week) AS EWAOrderDateWeek,
  Equipment.ConstructionMaterial AS ConstructionMaterial,
  _ContLocSalesContrAssgmt.SalesContract AS SalesContract,
  _ContLocSalesContrAssgmt.EWAContainerPortionRatio AS EWAContainerPortionRatio,
  UtilsDeviceCategory.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  cast (1 as abap.int4) AS EWANmbrOfContCat,
  cast (1 as abap.int4) AS EWANmbrOfService,
  cast (1 as abap.int4) AS EWANmbrOfServiceItem,
  cast (1 as abap.int4) AS EWANmbrOfContainer,
  Container._Address AS _Address,
  Container._Equipment AS _Equipment,
  Container._EWATargetStorageLocation AS _EWATargetStorageLocation,
  Container._EWAWasteDisposalFacility AS _EWAWasteDisposalFacility,
  Container._Material AS _Material,
  Container._Plant AS _Plant
FROM I_EquipmentTimeSeg AS Equipment
LEFT OUTER JOIN I_EWA_ContLocSalesContrAssgmt AS _ContLocSalesContrAssgmt ON EWAContainer = _ContLocSalesContrAssgmt.EWAContainer  -- association [1..*]
LEFT OUTER JOIN I_CalendarDate AS _CAL ON Equipment.ValidityStartDate = _CAL.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_EWA_ServiceFrequency AS _EWAServiceNumber ON EWAServiceNumber = _EWAServiceNumber.EWAServiceNumber  -- association [0..1]
;