SADL_V_EXP_BusinessPartner

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 SADL_V_EXP_BusinessPartner.
-- 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: SADL_V_E_BUPA

CREATE VIEW SADL_V_EXP_BusinessPartner AS
SELECT
  node_key AS businessPartnerKey,
  bp_id AS businessPartnerId,
  company_name,
  bp_role,
  phone_number,
  fax_number,
  web_address,
  legal_form,
  created_by,
  created_at,
  changed_by,
  changed_at,
  'X' AS isPrimaryContact,
  cast(changed_at as abap.dec(15,0)) AS ChangeAtInDec,
  cast( bp_id as abap.char( 32 ) ) AS SemanticsUUID,
  cast( bp_id as abap.char( 22 ) ) AS SemanticsUUID2,
  address_guid,
  address
FROM snwd_bpa
;