I_EWA_ContLocSalesContrAssgmt

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_ContLocSalesContrAssgmt.
-- 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_ContLocSalesContrAssgmt AS
SELECT
  obknr AS MaintenanceObjectList,
  obzae AS MaintenanceObjectListItem,
  bis AS EWAValidToDate,
  timto AS EWAEndTime,
  ab AS EWAValidFromDate,
  vbeln AS SalesContract,
  posnr AS EWASalesContractMainItem,
  equnr AS EWAContainer,
  matnr AS Material,
  iloan AS MaintObjectLocAcctAssgmtNmbr,
  cast(servloc as vdm_eam_tplnr) AS EWAContainerLocation,
  ibase AS EWAInstalledBase,
  kunnr AS Customer,
  cont_count AS EWANumberOfContainers,
  servfreqnr AS EWAServiceNumber,
  contshare AS EWAContainerPortionRatio,
  logiknr AS UtilitiesLogicalDeviceNumber
FROM ewaelocsd_new
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _EWAContainer ON EWAContainer = _EWAContainer.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _EWAContainerLocation ON EWAContainerLocation = _EWAContainerLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_LocationAccountAssignment AS _MaintObjectLocAcctAssgmt ON MaintObjectLocAcctAssgmtNmbr = _MaintObjectLocAcctAssgmt.MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_SalesContract AS _SalesContract ON SalesContract = _SalesContract.SalesContract  -- association [0..1]
LEFT OUTER JOIN I_SalesContractItem AS _SalesContractItem ON SalesContract = _SalesContractItem.SalesContract AND EWASalesContractMainItem = _SalesContractItem.SalesContractItem  -- association [0..1]
;