P_HP_UT_BP

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 P_HP_UT_BP.
-- 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: PHPUTBP

CREATE VIEW P_HP_UT_BP AS
SELECT
  node_id AS BP,
  auth_group AS AuthorizationGroup,
  _CompanyCode.CompanyCode AS CompanyCode
FROM hpnode
LEFT OUTER JOIN P_HP_UT_BP_ACompanyCode AS _CompanyCode ON BP = _CompanyCode.BP  -- association [0..1]
LEFT OUTER JOIN P_HP_UT_BP_AStatus AS _Status ON BP = _Status.BP  -- association [0..1]
LEFT OUTER JOIN P_HP_UT_BP_ACountry AS _Country ON BP = _Country.BP  -- association [0..1]
LEFT OUTER JOIN P_HP_UT_BP_AState AS _State ON BP = _State.BP  -- association [0..1]
LEFT OUTER JOIN P_HP_UT_BP_ACity AS _City ON BP = _City.BP  -- association [0..1]
LEFT OUTER JOIN P_HP_UT_BP_AZIPCode AS _ZIPCode ON BP = _ZIPCode.BP  -- association [0..1]
LEFT OUTER JOIN P_HP_UT_BPText AS _Text ON BP = _Text.BP  -- association [0..*]
;