CRMS4_IU_C_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_C_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: CRMS4IUVCPODADDR

CREATE VIEW CRMS4_IU_C_PODADDR AS
SELECT
  AddressID,
  PD_VALID_FROM,
  PD_VALID_TO,
  PD_AEDAT,
  PD_AENAM,
  PD_BEGRU,
  PD_ERDAT,
  PD_ERNAM,
  PD_EUIROLED,
  PD_EUIROLET,
  PD_EXT_UI,
  PD_INT_UI,
  PD_LOEVM,
  PD_SPARTE,
  PD_SPARTE_DESC,
  PD_UICAT,
  PD_UITYPE,
  PD_UITYPE_DESC,
  PD_GRID_LTYP,
  PD_GRID_LTYP_DESC,
  PD_GRID_LEVL,
  PD_GRID_LEVL_DESC,
  PD_GRID_ID,
  PD_GRID_ID_DESC,
  PD_OUTL_CONT,
  PD_INST_ALLOC_FROM,
  PD_INST_ALLOC_TO,
  PD_ANLAGE,
  NAME1,
  NAME2,
  CITY1,
  CITY2,
  POST_CODE1,
  POST_CODE2,
  POST_CODE3,
  PO_BOX_LOC,
  STREET,
  STR_SUPPL1,
  STR_SUPPL2,
  STR_SUPPL3,
  HOUSE_NUM1,
  HOUSE_NUM2,
  COUNTRY,
  REGION,
  SORT1,
  SORT2,
  ADDRNUMBER,
  PO_BOX_LOBBY,
  DELI_SERV_TYPE,
  DELI_SERV_NUMBER,
  COUNTY,
  TOWNSHIP,
  upper(CITY1) AS MC_CITY1,
  upper(CITY2) AS MC_CITY2,
  upper(COUNTY) AS MC_COUNTY,
  upper(HOUSE_NUM1) AS MC_HOUSE_NUM1,
  upper(HOUSE_NUM2) AS MC_HOUSE_NUM2,
  upper(NAME1) AS MC_NAME1,
  upper(STREET) AS MC_STREET,
  upper(STR_SUPPL1) AS MC_STR_SUPPL1,
  upper(STR_SUPPL2) AS MC_STR_SUPPL2,
  upper(STR_SUPPL3) AS MC_STR_SUPPL3,
  upper(TOWNSHIP) AS MC_TOWNSHIP,
  UtilsInternalPointOfDelivery
FROM CRMS4_IU_P_PODADDR
;