CRMS4_IU_P_PODADDR

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_P_PODADDR.
-- 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: CRMS4IUVPPODADDR

CREATE VIEW CRMS4_IU_P_PODADDR AS
SELECT
  PointOfDelivery.UtilsInternalPointOfDelivery AS UtilsInternalPointOfDelivery,
  ConnectionObject.AddressID AS AddressID,
  PointOfDelivery.UtilsPtOfDeliveryValidFrom AS PD_VALID_FROM,
  PointOfDelivery.UtilsPtOfDeliveryValidTo AS PD_VALID_TO,
  PointOfDelivery.UtilsPoDLastChangeDate AS PD_AEDAT,
  PointOfDelivery.UtilsPoDLastChangedByUser AS PD_AENAM,
  PointOfDelivery.AuthorizationGroup AS PD_BEGRU,
  PointOfDelivery.UtilsPtOfDeliveryCreationDate AS PD_ERDAT,
  PointOfDelivery.UtilsPtOfDeliveryCreatedByUser AS PD_ERNAM,
  PointOfDelivery.UtilsPtOfDeliveryIsDeregulated AS PD_EUIROLED,
  PointOfDelivery.UtilsPtOfDeliveryIsTechnical AS PD_EUIROLET,
  PointOfDelivery.UtilsExternalPointOfDelivery AS PD_EXT_UI,
  PointOfDelivery.UtilsInternalPointOfDelivery AS PD_INT_UI,
  PointOfDelivery.DeletionIndicator AS PD_LOEVM,
  PointOfDelivery.Division AS PD_SPARTE,
  PointOfDelivery.DivisionName AS PD_SPARTE_DESC,
  PointOfDelivery.UtilsPointOfDeliveryCategory AS PD_UICAT,
  PointOfDelivery.UtilitiesPointOfDeliveryType AS PD_UITYPE,
  PointOfDelivery.UtilitiesPtOfDeliveryTypeName AS PD_UITYPE_DESC,
  PointOfDelivery.UtilitiesGridLevelType AS PD_GRID_LTYP,
  PointOfDelivery.UtilitiesGridLevelTypeName AS PD_GRID_LTYP_DESC,
  PointOfDelivery.UtilitiesGridLevel AS PD_GRID_LEVL,
  PointOfDelivery.UtilitiesVoltageLevelName AS PD_GRID_LEVL_DESC,
  PointOfDelivery.UtilitiesGrid AS PD_GRID_ID,
  PointOfDelivery.UtilitiesGridName AS PD_GRID_ID_DESC,
  PointOfDelivery.UtilitiesIsOutlineContract AS PD_OUTL_CONT,
  PointOfDelivery.UtilsInstToPoDAllocFromDteTme AS PD_INST_ALLOC_FROM,
  PointOfDelivery.UtilsInstToPoDAllocToDteTme AS PD_INST_ALLOC_TO,
  PointOfDelivery.UtilitiesInstallation AS PD_ANLAGE,
  PointOfDelivery.UtilitiesPremise AS VSTELLE,
  ConnectionObject.OrganizationName1 AS NAME1,
  ConnectionObject.OrganizationName2 AS NAME2,
  ConnectionObject.CityName AS CITY1,
  ConnectionObject.DistrictName AS CITY2,
  ConnectionObject.PostalCode AS POST_CODE1,
  ConnectionObject.POBoxPostalCode AS POST_CODE2,
  ConnectionObject.CompanyPostalCode AS POST_CODE3,
  ConnectionObject.POBoxDeviatingCityName AS PO_BOX_LOC,
  ConnectionObject.StreetName AS STREET,
  ConnectionObject.StreetPrefixName1 AS STR_SUPPL1,
  ConnectionObject.StreetPrefixName2 AS STR_SUPPL2,
  ConnectionObject.StreetSuffixName1 AS STR_SUPPL3,
  ConnectionObject.HouseNumber AS HOUSE_NUM1,
  ConnectionObject.HouseNumberSupplementText AS HOUSE_NUM2,
  ConnectionObject.Country AS COUNTRY,
  ConnectionObject.Region AS REGION,
  ConnectionObject.AddressSearchTerm1 AS SORT1,
  ConnectionObject.AddressSearchTerm2 AS SORT2,
  ConnectionObject.AddressID AS ADDRNUMBER,
  ConnectionObject.POBoxLobbyName AS PO_BOX_LOBBY,
  ConnectionObject.DeliveryServiceNumber AS DELI_SERV_TYPE,
  ConnectionObject.DeliveryServiceTypeCode AS DELI_SERV_NUMBER,
  ConnectionObject.SecondaryRegionName AS COUNTY,
  ConnectionObject.TertiaryRegionName AS TOWNSHIP,
  ConnectionObject._Address2 AS _Address2
FROM CRMS4_IU_I_POD AS PointOfDelivery
INNER JOIN CRMS4_IU_I_PRM 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 */
;