CRMS4_IU_C_CONCA

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_CONCA.
-- 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: CRMS4IUVCCONCA

CREATE VIEW CRMS4_IU_C_CONCA AS
SELECT
  BUAG_NUMBER,
  CRMS4_IU_C_CONBP.HAUS AS HAUS,
  _ConnectionObjectData.CO_FLTYP AS CO_FLTYP,
  _ConnectionObjectData.CO_BEGRU AS CO_BEGRU,
  _ConnectionObjectData.CO_SWERK AS CO_SWERK,
  _ConnectionObjectData.AddressID AS AddressID,
  _ConnectionObjectData.CO_SHTXT AS CO_SHTXT,
  _ConnectionObjectData.CO_ERNAM AS CO_ERNAM,
  _ConnectionObjectData.CO_ERDAT AS CO_ERDAT,
  _ConnectionObjectData.CO_AENAM AS CO_AENAM,
  _ConnectionObjectData.CO_AEDAT AS CO_AEDAT,
  _ConnectionObjectData.TITLE AS TITLE,
  _ConnectionObjectData.NAME1 AS NAME1,
  _ConnectionObjectData.NAME2 AS NAME2,
  _ConnectionObjectData.NAME3 AS NAME3,
  _ConnectionObjectData.NAME4 AS NAME4,
  _ConnectionObjectData.NAME_CO AS NAME_CO,
  _ConnectionObjectData.CITY1 AS CITY1,
  _ConnectionObjectData.CITY2 AS CITY2,
  _ConnectionObjectData.CITY_CODE AS CITY_CODE,
  _ConnectionObjectData.HOME_CITY AS HOME_CITY,
  _ConnectionObjectData.POST_CODE1 AS POST_CODE1,
  _ConnectionObjectData.POST_CODE2 AS POST_CODE2,
  _ConnectionObjectData.POST_CODE3 AS POST_CODE3,
  _ConnectionObjectData.PO_BOX AS PO_BOX,
  _ConnectionObjectData.PO_BOX_NUM AS PO_BOX_NUM,
  _ConnectionObjectData.PO_BOX_LOC AS PO_BOX_LOC,
  _ConnectionObjectData.PO_BOX_REG AS PO_BOX_REG,
  _ConnectionObjectData.PO_BOX_CTY AS PO_BOX_CTY,
  _ConnectionObjectData.TRANSPZONE AS TRANSPZONE,
  _ConnectionObjectData.STREET AS STREET,
  _ConnectionObjectData.HOUSE_NUM1 AS HOUSE_NUM1,
  _ConnectionObjectData.HOUSE_NUM2 AS HOUSE_NUM2,
  _ConnectionObjectData.STR_SUPPL1 AS STR_SUPPL1,
  _ConnectionObjectData.STR_SUPPL2 AS STR_SUPPL2,
  _ConnectionObjectData.STR_SUPPL3 AS STR_SUPPL3,
  _ConnectionObjectData.LOCATION AS LOCATION,
  _ConnectionObjectData.BUILDING AS BUILDING,
  _ConnectionObjectData.FLOOR AS FLOOR,
  _ConnectionObjectData.ROOMNUMBER AS ROOMNUMBER,
  _ConnectionObjectData.COUNTRY AS COUNTRY,
  _ConnectionObjectData.LANGU AS LANGU,
  _ConnectionObjectData.REGION AS REGION,
  _ConnectionObjectData.SORT1 AS SORT1,
  _ConnectionObjectData.SORT2 AS SORT2,
  _ConnectionObjectData.TIME_ZONE AS TIME_ZONE,
  _ConnectionObjectData.TAXJURCODE AS TAXJURCODE,
  _ConnectionObjectData.PO_BOX_LOBBY AS PO_BOX_LOBBY,
  _ConnectionObjectData.DELI_SERV_TYPE AS DELI_SERV_TYPE,
  _ConnectionObjectData.DELI_SERV_NUMBER AS DELI_SERV_NUMBER,
  _ConnectionObjectData.COUNTY_CODE AS COUNTY_CODE,
  _ConnectionObjectData.COUNTY AS COUNTY,
  _ConnectionObjectData.DEFLT_COMM AS DEFLT_COMM,
  _ConnectionObjectData.MC_CITY1 AS MC_CITY1,
  _ConnectionObjectData.MC_STREET AS MC_STREET,
  _ConnectionObjectData.MC_NAME1 AS MC_NAME1,
  _ConnectionObjectData.MC_COUNTY AS MC_COUNTY,
  _ConnectionObjectData.MC_TOWNSHIP AS MC_TOWNSHIP,
  _ConnectionObjectData.NUMBER_PRM AS NUMBER_PRM
FROM CRMS4_IU_C_CONBP
INNER JOIN CRMS4_IU_C_CON AS _ConnectionObjectData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CRMS4_IU_C_CON AS _ConnectionObject ON _ConnectionObject.HAUS = HAUS  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON _ContractAccountPartner.ContractAccount = BUAG_NUMBER  -- association [1..*]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON _ContractAccountHeader.ContractAccount = BUAG_NUMBER  -- association [1..1]
;