P_UserOrganization

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 P_UserOrganization.
-- 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 P_UserOrganization AS
SELECT
  UserID AS bname,
  UserGroup AS class,
  UserAddressPersonIdentifier AS persnumber,
  UserAddressIdentifier AS addrnumber,
  IdentityAddressType AS idadtype,
  case when IdentityAddressType = '00' then _Company.UserCompanyIdentifier when IdentityAddressType = '04' then _TemplateCompany.UserCompanyIdentifier else ' ' end as company AS UserCompanyIdentifierelseendascompany,
  BusinessPartnerUUID AS orgaddr_uuid,
  _Location.FormOfAddress AS title,
  _Location.OrganizationName1 AS name1,
  _Location.OrganizationName2 AS name2,
  _Location.OrganizationName3 AS name3,
  _Location.OrganizationName4 AS name4,
  _Organization.CareOfName AS name_co,
  _Organization.CityName AS city1,
  _Organization.DistrictName AS city2,
  _Organization.CityNumber AS city_code,
  _Location.DistrictNumber AS cityp_code,
  _Organization.VillageName AS home_city,
  _Location.Village AS cityh_code,
  _Organization.RegionalStructureCheckStatus AS chckstatus,
  _Organization.RegionalStructureGroup AS regiogroup,
  _Organization.PostalCode AS post_code1,
  _Organization.POBoxPostalCode AS post_code2,
  _Organization.CompanyPostalCode AS post_code3,
  _Organization.POBox AS po_box,
  _Organization.POBoxAddrNonDeliverableReason AS dont_use_p,
  _Organization.POBoxIsWithoutNumber AS po_box_num,
  _Organization.POBoxDeviatingCityName AS po_box_loc,
  _Organization.POBoxDeviatingCityCode AS city_code2,
  _Organization.POBoxDeviatingRegion AS po_box_reg,
  _Organization.POBoxDeviatingCountry AS po_box_cty,
  _Organization.TransportZone AS transpzone,
  _Organization.StreetName AS street,
  _Organization.StreetAddrNonDeliverableReason AS dont_use_s,
  _Organization.Street AS streetcode,
  _Organization.HouseNumber AS house_num1,
  _Organization.HouseNumberSupplementText AS house_num2,
  _Organization.StreetPrefixName1 AS str_suppl1,
  _Organization.StreetPrefixName2 AS str_suppl2,
  _Organization.StreetSuffixName1 AS str_suppl3,
  _Organization.StreetSuffixName2 AS location,
  _Organization.Building AS building,
  _Organization.Floor AS floor,
  _Organization.RoomNumber AS roomnumber,
  _Organization.Country AS country,
  _Organization.Region AS region,
  _Organization.AddressSearchTerm1 AS sort1,
  _Organization.AddressSearchTerm2 AS sort2,
  _Organization.AddressTimeZone AS time_zone,
  _Organization.TaxJurisdiction AS taxjurcode,
  _Organization.CorrespondenceLanguage AS langu,
  _Organization.POBoxLobbyName AS po_box_lobby,
  _Organization.SecondaryRegionName AS county,
  _Organization.TertiaryRegionName AS township,
  _Location._FormOfAddress AS _FormOfAddress,
  _Organization._Country AS _Country,
  _Organization._CorrespondenceLanguage AS _CorrespondenceLanguage
FROM I_UserAddress
LEFT OUTER JOIN I_AddressRemark AS _Remark ON addrnumber = _Remark.AddressID AND persnumber = _Remark.AddressPersonID AND _Remark.AddressRepresentationCode = ' ' AND _Remark.Language = $session.system_language  -- association [0..1]
;