/BOFU/CV_BPCommon

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 /BOFU/CV_BPCommon.
-- 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: /BOFU/CV_BPCMN

CREATE VIEW /BOFU/CV_BPCommon AS
SELECT
  but000.partner AS partner,
  but000.partner_guid AS partner_guid,
  cast ('' as bu_central_valid_from ) AS valid_from,
  cast ('' as bu_central_valid_to ) AS valid_to,
  but000.bu_sort1 AS searchterm1,
  but000.bu_sort2 AS searchterm2,
  but000.name_first AS firstname,
  but000.name_last AS lastname,
  but000.name_org1 AS name1,
  but000.name_org2 AS name2,
  but000.name_org3 AS name3,
  but000.name_org4 AS name4,
  but000.name_grp1 AS namegroup1,
  but000.name_grp1 AS namegroup2,
  but000.partgrptyp AS grouptype,
  but000.augrp AS augrp,
  but000.xpcpt AS IsBusinessPurposeCompleted
FROM but000
LEFT OUTER JOIN /BOFU/CV_BPCurrentDefaultAddr AS _BPCurrentDefaultAddress ON partner = _BPCurrentDefaultAddress.BusinessPartner  -- association [0..1]
;