I_EWA_PropertySalesContrAssgmt

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_PropertySalesContrAssgmt.
-- 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_PropertySalesContrAssgmt AS
SELECT
  obknr AS MaintenanceObjectList,
  obzae AS MaintenanceObjectListItem,
  bis AS EWAValidToDate,
  ab AS EWAValidFromDate,
  vbeln AS SalesContract,
  posnr AS EWASalesContractMainItem,
  matnr AS Material,
  iloan AS MaintObjectLocAcctAssgmtNmbr,
  prop AS EWAProperty,
  cast(tplnr as vdm_eam_tplnr) AS FunctionalLocation,
  kunnr AS Customer,
  servfreqnr AS EWAServiceNumber,
  propshare AS EWAPropertyPortionRatio
FROM ewapropsd
LEFT OUTER JOIN I_LocationAccountAssignment AS _MaintObjectLocAcctAssgmtNmbr ON MaintObjectLocAcctAssgmtNmbr = _MaintObjectLocAcctAssgmtNmbr.MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
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_EWA_CleaningProperty AS _EWAProperty ON EWAProperty = _EWAProperty.EWAProperty  -- 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]
;