CRMS4_IU_C_CONPOD

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 CRMS4_IU_C_CONPOD.
-- 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.
-- SQL view name: CRMS4IUVCCONPOD

CREATE VIEW CRMS4_IU_C_CONPOD AS
SELECT
  CRMS4_IU_P_PODPRM.UtilsInternalPointOfDelivery AS INT_UI,
  ConnectionObject.FunctionalLocation AS HAUS,
  ConnectionObject.FunctionalLocation AS CO_TPLNR,
  ConnectionObject.FunctionalLocationCategory AS CO_FLTYP,
  ConnectionObject.AuthorizationGroup AS CO_BEGRU,
  ConnectionObject.MaintenancePlant AS CO_SWERK,
  ConnectionObject.FunctionalLocationName AS CO_SHTXT,
  ConnectionObject.CreatedByUser AS CO_ERNAM,
  ConnectionObject.CreationDate AS CO_ERDAT,
  ConnectionObject.LastChangedByUser AS CO_AENAM,
  ConnectionObject.LastChangeDate AS CO_AEDAT,
  ConnectionObject.FormOfAddress AS TITLE,
  ConnectionObject.OrganizationName1 AS NAME1,
  ConnectionObject.OrganizationName2 AS NAME2,
  ConnectionObject.OrganizationName3 AS NAME3,
  ConnectionObject.OrganizationName4 AS NAME4,
  ConnectionObject.CareOfName AS NAME_CO,
  ConnectionObject.CityName AS CITY1,
  ConnectionObject.DistrictName AS CITY2,
  ConnectionObject.CityNumber AS CITY_CODE,
  ConnectionObject.VillageName AS HOME_CITY,
  ConnectionObject.PostalCode AS POST_CODE1,
  ConnectionObject.POBoxPostalCode AS POST_CODE2,
  ConnectionObject.CompanyPostalCode AS POST_CODE3,
  ConnectionObject.POBox AS PO_BOX,
  ConnectionObject.POBoxIsWithoutNumber AS PO_BOX_NUM,
  ConnectionObject.POBoxDeviatingCityName AS PO_BOX_LOC,
  ConnectionObject.POBoxDeviatingRegion AS PO_BOX_REG,
  ConnectionObject.POBoxDeviatingCountry AS PO_BOX_CTY,
  ConnectionObject.TransportZone AS TRANSPZONE,
  ConnectionObject.StreetName AS STREET,
  ConnectionObject.HouseNumber AS HOUSE_NUM1,
  ConnectionObject.HouseNumberSupplementText AS HOUSE_NUM2,
  ConnectionObject.StreetPrefixName1 AS STR_SUPPL1,
  ConnectionObject.StreetPrefixName2 AS STR_SUPPL2,
  ConnectionObject.StreetSuffixName1 AS STR_SUPPL3,
  ConnectionObject.StreetSuffixName2 AS LOCATION,
  ConnectionObject.Building AS BUILDING,
  ConnectionObject.Floor AS FLOOR,
  ConnectionObject.RoomNumber AS ROOMNUMBER,
  ConnectionObject.Country AS COUNTRY,
  ConnectionObject.CorrespondenceLanguage AS LANGU,
  ConnectionObject.Region AS REGION,
  ConnectionObject.AddressSearchTerm1 AS SORT1,
  ConnectionObject.AddressSearchTerm2 AS SORT2,
  ConnectionObject.AddressTimeZone AS TIME_ZONE,
  ConnectionObject.TaxJurisdiction AS TAXJURCODE,
  ConnectionObject.POBoxLobbyName AS PO_BOX_LOBBY,
  ConnectionObject.DeliveryServiceNumber AS DELI_SERV_TYPE,
  ConnectionObject.DeliveryServiceTypeCode AS DELI_SERV_NUMBER,
  ConnectionObject.SecondaryRegion AS COUNTY_CODE,
  ConnectionObject.SecondaryRegionName AS COUNTY,
  ConnectionObject.PrfrdCommMediumType AS DEFLT_COMM,
  ConnectionObject.StreetSearch AS MC_STREET,
  ConnectionObject.mc_name1 AS MC_NAME1,
  ConnectionObject.mc_county AS MC_COUNTY,
  ConnectionObject.mc_township AS MC_TOWNSHIP
INNER JOIN evbs AS _Premise ON /* join condition not captured in parsed metadata */
INNER JOIN CRMS4_IU_I_CON AS ConnectionObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CRMS4_IU_I_CON AS _ConnectionObject ON _ConnectionObject.FunctionalLocation = ConnectionObject.FunctionalLocation  -- association [1..1]
LEFT OUTER JOIN CRMS4_IU_I_POD AS _PointOfDelivery ON _PointOfDelivery.UtilsInternalPointOfDelivery = INT_UI  -- association [1..1]
;