R_SrcgProjItmDeliveryAddressTP

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 R_SrcgProjItmDeliveryAddressTP.
-- 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 R_SrcgProjItmDeliveryAddressTP AS
SELECT
  SrcgProjAddressUUID,
  SrcgProjAddressID,
  _Address.AddressID AS AddressID,
  SourcingProjectUUID,
  SourcingProjectItemUUID,
  SourcingOrigin,
  SourcingScenario,
  cast( _Address.AddresseeFullName as caaddr_fullname preserving type ) AS FullName,
  _Address.HouseNumber AS HouseNumber,
  _Address.StreetName AS StreetName,
  _Address.CityName AS CityName,
  _Address.Region AS Region,
  _Address.PostalCode AS PostalCode,
  cast( _Address.Country as caaddr_country preserving type ) AS Country,
  _Address.SecondaryRegionName AS County,
  _Address.DistrictName AS District,
  _Address.SecondaryRegionName AS SecondaryRegionName,
  _Address.DistrictName AS DistrictName,
  _Address.Building AS Building,
  _Address.RoomNumber AS RoomNumber,
  _Address.Floor AS Floor,
  cast ( _Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as caaddr_phonenr preserving type ) AS PhoneNumber,
  cast ( _Address._CurrentDfltEmailAddress.EmailAddress as caaddr_smtpadr preserving type ) AS EmailAddress,
  cast ( _Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber as telfx ) AS FaxNumber,
  _Address.POBox AS POBox,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _Address.FormOfAddress AS FormOfAddress,
  cast( '' as bu_adrkind ) AS AddressType,
  cast( '' as vdm_addressownerobjectid ) AS AddressOwnerObjectID,
  cast( '' as boolean ) AS AddressIsChangedManually,
  ActiveAddressIsManual,
  cast( '' as ad_appltab ) AS AddressOwnerTableName,
  cast( '' as ad_applfld ) AS AddressOwnerFieldName,
  cast( '' as vdm_referenceaddressid ) AS ReferenceAddressID,
  cast( '' as vdm_referenceobjectid ) AS ReferenceObjectID,
  cast( '' as vdm_referenceaddresstype ) AS ReferenceAddressType
FROM R_SrcgProjItmDeliveryAddress
LEFT OUTER JOIN R_SourcingProjectTP AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _Address ON SrcgProjAddressID = _Address.AddressID AND _Address.AddressPersonID = '' AND _Address.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjSourcingOriginText AS _SrcgProjSourcingOriginText ON SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjSourcingScenarioText AS _SrcgProjSourcingScenarioText ON SourcingScenario = _SrcgProjSourcingScenarioText.SourcingScenario  -- association [0..*]
;