I_UserAddress

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_UserAddress.
-- 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_UserAddress AS
SELECT
  _UserBasic.UserID AS UserID,
  _UserBasic.UserGroup AS UserGroup,
  _AddressLink.UserAddressPersonIdentifier AS UserAddressPersonIdentifier,
  _AddressLink.UserAddressIdentifier AS UserAddressIdentifier,
  _AddressLink.BusinessPartnerUUID AS BusinessPartnerUUID,
  _AddressLink.IdentityAddressType AS IdentityAddressType,
  _AddressLink.UserTemplateAddressIdentifier AS UserTemplateAddressIdentifier,
  _AddressLink.UserTemplateOrgType AS UserTemplateOrgType,
  _AddressLink.ResponsibleUser AS ResponsibleUser,
  _AddressLink.UserDescription AS UserDescription
FROM I_UserAddressLink AS _AddressLink
INNER JOIN I_UserBasic AS _UserBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddressPersonName AS _PersonName ON _PersonName.AddressPersonID = UserAddressPersonIdentifier AND _PersonName.AddressRepresentationCode = ''  -- association [1..1]
LEFT OUTER JOIN I_AddressWorkplaceDetails AS _PersonWorkplace ON _PersonWorkplace.AddressPersonID = UserAddressPersonIdentifier AND _PersonWorkplace.AddressID = UserAddressIdentifier AND _PersonWorkplace.AddressRepresentationCode = ''  -- association [1..1]
LEFT OUTER JOIN I_OrganizationAddress AS _Organization ON _Organization.AddressPersonID = '' AND _Organization.AddressID = UserAddressIdentifier AND _Organization.AddressRepresentationCode = ''  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _Location ON _Location.AddressID = UserAddressIdentifier AND _Location.AddressRepresentationCode = ''  -- association [1..1]
LEFT OUTER JOIN I_UserCompany AS _Company ON _Company.UserAddressIdentifier = UserAddressIdentifier  -- association [0..1]
LEFT OUTER JOIN I_UserCompany AS _TemplateCompany ON _TemplateCompany.UserAddressIdentifier = UserTemplateAddressIdentifier AND UserTemplateOrgType = 'C'  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultEmailAddress AS _DefaultEmail ON _DefaultEmail.AddressPersonID = UserAddressPersonIdentifier AND _DefaultEmail.AddressID = UserAddressIdentifier  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _DefaultPhone ON _DefaultPhone.AddressPersonID = UserAddressPersonIdentifier AND _DefaultPhone.AddressID = UserAddressIdentifier  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _DefaultFax ON _DefaultFax.AddressPersonID = UserAddressPersonIdentifier AND _DefaultFax.AddressID = UserAddressIdentifier  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _DefaultMobile ON _DefaultMobile.AddressPersonID = UserAddressPersonIdentifier AND _DefaultMobile.AddressID = UserAddressIdentifier  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _Phone ON _Phone.AddressPersonID = UserAddressPersonIdentifier AND _Phone.AddressID = UserAddressIdentifier  -- association [0..*]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _Fax ON _Fax.AddressPersonID = UserAddressPersonIdentifier AND _Fax.AddressID = UserAddressIdentifier  -- association [0..*]
LEFT OUTER JOIN I_AddressEmailAddress_2 AS _EMail ON _EMail.AddressPersonID = UserAddressPersonIdentifier AND _EMail.AddressID = UserAddressIdentifier  -- association [0..*]
;